ProxoolÀ´Á¬½Ómysql½éÉÜ

±¾ÎÄÖ÷Òª½éÉÜÁ˲ÉÓÃProxoolÀ´Á¬½ÓmysqlµÄ·½·¨£¬Í¨¹ýjava  application·½Ê½¿ÉÒÔÑéÖ¤Êý¾Ý¿âµÄÁ¬½Ó¼°»ñÈ¡±íÖеÄÊý¾Ý¡£ÎªÁËÄܹ»Ó봫ͳµÄJDBC·½Ê½µÄÁ¬½Ó½øÐбȽϣ¬±¾ÎIJÉÈ¡ÁËÁ½ÖÖ·½Ê½½øÐÐÊý¾Ý¿âµÄÁ¬½Ó£¬´úÂëÈçÏ¡£
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import org.logicalcobwebs.proxool.configuration.JAXPConfigurator;
public class TestProxool {
public static String dburl = "jdbc:mysql://localhost:3306/dma";
public static String user = "root";
public static String password = "888888";

public static void test1() throws Exception {
String testsql = "select * from user where userID = 13";
//1£º×¢²áÇý¶¯Àà
Class.forName("com.mysql.jdbc.Driver");
//2£º´´½¨Êý¾Ý¿âÁ¬½Ó
Connection conn = DriverManager.getConnection(dburl, user, password);
//3£º´´½¨Ö´ÐÐSQLµÄ¶ÔÏó
Statement stmt = conn.createStatement();
//4£ºÖ´ÐÐSQL£¬²¢»ñÈ¡·µ»Ø½á¹û
ResultSet rs = stmt.executeQuery(testsql);
//5£º´¦Àí·µ»Ø½á¹û£¬´Ë´¦´òÓ¡²éѯ½á¹û
while (rs.next()) {
System.out.print(rs.getInt("userID") + "\t");
System.out.print(rs.getString("sourceIP") + "\t");
System.out.println();
}
//6£º¹Ø±ÕÊý¾Ý¿âÁ¬½Ó
conn.close();
}

/**
* proxool·½Ê½²âÊÔ
*
* @throws Exception
*/
public static void test2() throws Exception {
//¼ÓÔØÅäÖÃÎļþ,ÅäÖÃÎļþ¿ÉÒÔÊÇÏà¶Ô·¾¶£¬Ò²¿ÉÒÔÊǾø¶Ô·¾¶
JAXPConfigurator.configure("proxool.xml", false);
// System.out.println("You have already load the xml file");
String testsql = "select * from user where userID = 13";
//1£º×¢²áÇý¶¯À࣬ÊÇProxoolרÓõÄÇý¶¯
Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");
//2£º´´½¨Êý¾Ý¿âÁ¬½Ó£¬Õâ¸ö²ÎÊýÊÇÒ»¸ö×Ö·û´®£¬ÊÇÊý¾ÝÔ´µÄ±ðÃû£¬ÔÚÅäÖÃÎļþÖÐÅäÖõÄdma£¬²ÎÊý¸ñʽΪ£ºproxool.Êý¾ÝÔ´µÄ±ðÃû
Connection conn = DriverManage