(1) 将poolman.jar(jdbc2_0-stdext.jar,jmxri.jar,jta.jar,xerces.jar)加入classpath;
(2) 配置poolman.xml,这个xml文件声明池的各种信息。
package net.ijsp.connectbroker;
import com.codestudio.util.ObjectPool;
import com.codestudio.util.SQLManager;
public class PoolmanConnectBroker {
private static SQLManager sqlManager ;
public PoolmanConnectBroker()
{
System.out.println("2222222222222222222222");
File f = new File("c:/dbi.xml");
String s = f.getAbsolutePath();
System.out.println(s);
if(sqlManager == null)
sqlManager = SQLManager.getInstance(s);
System.out.println(sqlManager);
}
public Connection getConnection()
{
Connection c = null;
try{
c = sqlManager.requestConnection();
}catch(Exception e) {
System.out.println(e);
}
System.out.println(c);
return c;
}
..........
}