MYSQL使用连接池功能 代码如下: package com.jdbc.proxool;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Properties;import org.logicalcobwebs.proxool.ProxoolDriver;
import org.logicalcobwebs.proxool.ProxoolFacade;
public class proxool { /**
* @param args
*/
public static void main(String[] args) {
try{
Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");
Properties info =new Properties();
info.setProperty("proxool.maximum-connection-count","10");
info.setProperty("proxool.house-keep-test-sql","select CURRENT_DATE");
info.setProperty("user","test");
info.setProperty("password","test");
String alias="test";
String driverClass="com.mysql.jdbc.Driver";
String driverUrl="jdbc.mysql://localhost/proxool?user=test&password=test";
String url="proxool."+alias+":"+driverClass+":"+driverUrl;
ProxoolFacade.registerConnectionPool(url,info);
Connection con=DriverManager.getConnection("proxool.test");
Statement stat =con.createStatement();
ResultSet rs=stat.executeQuery("select * from student");
System.out.println(" 客户 年龄 性别 ");
while(rs.next()){
int id =rs.getInt(1);
String age=rs.getString(2);
String sex=rs.getString(3);
System.out.println(id+" "+age+" "+sex);
}
}
catch(Exception e){
System.out.println(e.getMessage());
}
}}
所需的驱动类已经加载:COMMONS-LOGGIN.JAR;PROXOOL.JAR;MYSQL-CONNECTOR-JAVA.JAR
报错如下:
2009-11-2 18:16:10 org.logicalcobwebs.proxool.ProxoolFacade registerConnectionPool
信息: Proxool 0.9.0RC3 (10-Jan-2007 01:38)
No suitable driver found for jdbc.mysql://localhost/proxool?user=test&password=test
2009-11-2 18:16:11 org.logicalcobwebs.proxool.ConnectionPool shutdown
信息: Shutting down 'test' pool immediately [Shutdown Hook]
2009-11-2 18:16:11 org.logicalcobwebs.proxool.PrototyperController shutdown
信息: Stopping Prototyper thread
2009-11-2 18:16:11 org.logicalcobwebs.proxool.HouseKeeperController shutdown
信息: Stopping HouseKeeper thread
请问DRIVERCLASS 应如何配置 需要加newInstance()吗 ?
谢谢!
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Properties;import org.logicalcobwebs.proxool.ProxoolDriver;
import org.logicalcobwebs.proxool.ProxoolFacade;
public class proxool { /**
* @param args
*/
public static void main(String[] args) {
try{
Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");
Properties info =new Properties();
info.setProperty("proxool.maximum-connection-count","10");
info.setProperty("proxool.house-keep-test-sql","select CURRENT_DATE");
info.setProperty("user","test");
info.setProperty("password","test");
String alias="test";
String driverClass="com.mysql.jdbc.Driver";
String driverUrl="jdbc.mysql://localhost/proxool?user=test&password=test";
String url="proxool."+alias+":"+driverClass+":"+driverUrl;
ProxoolFacade.registerConnectionPool(url,info);
Connection con=DriverManager.getConnection("proxool.test");
Statement stat =con.createStatement();
ResultSet rs=stat.executeQuery("select * from student");
System.out.println(" 客户 年龄 性别 ");
while(rs.next()){
int id =rs.getInt(1);
String age=rs.getString(2);
String sex=rs.getString(3);
System.out.println(id+" "+age+" "+sex);
}
}
catch(Exception e){
System.out.println(e.getMessage());
}
}}
所需的驱动类已经加载:COMMONS-LOGGIN.JAR;PROXOOL.JAR;MYSQL-CONNECTOR-JAVA.JAR
报错如下:
2009-11-2 18:16:10 org.logicalcobwebs.proxool.ProxoolFacade registerConnectionPool
信息: Proxool 0.9.0RC3 (10-Jan-2007 01:38)
No suitable driver found for jdbc.mysql://localhost/proxool?user=test&password=test
2009-11-2 18:16:11 org.logicalcobwebs.proxool.ConnectionPool shutdown
信息: Shutting down 'test' pool immediately [Shutdown Hook]
2009-11-2 18:16:11 org.logicalcobwebs.proxool.PrototyperController shutdown
信息: Stopping Prototyper thread
2009-11-2 18:16:11 org.logicalcobwebs.proxool.HouseKeeperController shutdown
信息: Stopping HouseKeeper thread
请问DRIVERCLASS 应如何配置 需要加newInstance()吗 ?
谢谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货