UC知道proxool netbeans
来源：百度知道 编辑：UC知道 时间：2024/07/02 20:47:07
在netbeans6.5中建一个java桌面应用程序工程，文件夹如图所示，下了一个proxool-0.9.1 建了一个proxool.xm文件，内容如下：
<?xml version="1.0" encoding="ISO-8859-1"?>
<!-- the proxool configuration can be embedded within your own application's.
Anything outside the "proxool" tag is ignored. -->
<something-else-entirely>
<proxool>
<alias>myedit</alias>
<driver-url>jdbc:mysql://localhost:3306/versionedit</driver-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<driver-properties>
<property name="user" value="root"/>
<property name="password" value="1234"/>
</driver-properties>
<maximum-connection-count>20</maximum-connection-count>
<house-keeping-test-sql>select CURRENT_DATE</house-keeping-te
<?xml version="1.0" encoding="ISO-8859-1"?>
<!-- the proxool configuration can be embedded within your own application's.
Anything outside the "proxool" tag is ignored. -->
<something-else-entirely>
<proxool>
<alias>myedit</alias>
<driver-url>jdbc:mysql://localhost:3306/versionedit</driver-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<driver-properties>
<property name="user" value="root"/>
<property name="password" value="1234"/>
</driver-properties>
<maximum-connection-count>20</maximum-connection-count>
<house-keeping-test-sql>select CURRENT_DATE</house-keeping-te
try {
Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");
info = new Properties();
info.setProperty("proxool.maximum-connection-count", "10");
info.setProperty("proxool.house-keeping-test-sql", "select CURRENT_DATE");
info.setProperty("user", "root");
info.setProperty("password", "1234");
String alias = "test";
String driverClass = "com.mysql.jdbc.Driver";
String driverUrl = "jdbc:mysql://localhost:3306/versionedit";
url = "proxool." + alias + ":" + driverClass + ":" + driverUrl;
try {
ProxoolFacade.registerConnectionPool(url, info);
} catch (ProxoolException ex) {
Logger.getLogger(ConnectionPool.class.getName()).log(Level.SEVERE, null, ex);
}
} catch (ClassNotFoundException ex) {
Logger.getLogger(ConnectionPool.class.getN