proxool java_java proxool系统设置

1.在maven配置文件pom.xml中增加dependencies

com.cloudhopper.proxool

proxool

0.9.1

2.等待自动安装完毕后，修改WEB-INF目录下的proxool.xml文件

DBPool

jdbc:mysql://localhost:3306/test

com.mysql.jdbc.Driver

60000

10

2

0

20

select CURRENT_DATE

15s,10m,1d

INFO

3.创建一个单例DBManager来管理连接池

package com.newlysoft.controller;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import org.logicalcobwebs.proxool.configuration.JAXPConfigurator;

public class DBManager {

private String poolPath;

private DBManager() {

try {

this.poolPath = "D:\\javaprogram\\oasys\\target\\wxoa\\WEB-INF\\proxool.xml";

JAXPConfigurator.configure(this.poolPath, false);

Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");

} catch (Exception var2) {

System.out.println("error ");

}

}

public Connection getConnection(String poolname) throws SQLException {

return DriverManager.getConnection(poolname);

}

public static DBManager getDBManager() {

return DBManager.DBManagerDAO.dbManager;

}

private static class DBManagerDAO {

private static final DBManager dbManager = new DBManager();

private DBManagerDAO() {

}

}

}

4.在程序中获取conn

DBManager man=DBManager.getDBManager();

Connection conn=man.getConnection("proxool.DBPool");