proxool配置

proxool配置文件proxool.xml
[code]<?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>bookshop</alias>
<driver-url>
jdbc:oracle:thin:@system-xuby:1521:java
</driver-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<driver-properties>
<property name="user" value="java" />
<property name="password" value="java1234" />
</driver-properties>

<maximum-connection-count>500</maximum-connection-count>
<house-keeping-test-sql>
select sysdate from DUAL
</house-keeping-test-sql>
</proxool>

</something-else-entirely>
[/code]

web.xml
[code] <servlet>
<servlet-name>ServletConfigurator</servlet-name>
<servlet-class>
org.logicalcobwebs.proxool.configuration.ServletConfigurator
</servlet-class>

<init-param>
<param-name>xmlFile</param-name>
<param-value>
WEB-INF/classes/config/Proxool.xml
</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet>
<servlet-name>Admin</servlet-name>
<servlet-class>
org.logicalcobwebs.proxool.admin.servlet.AdminServlet
</servlet-class>
</servlet>

<servlet-mapping>
<servlet-name>Admin</servlet-name>
<url-pattern>/admin</url-pattern>
</servlet-mapping>
[/code]

得到数据库连接.比较简单
[code]
public Connection getConnection() {
try {
return DriverManager.getConnection("proxool.bookshop");
} catch (Exception e) {
e.printStackTrace();
return null;
}
}[/code]

[color=red]注意下面的[/color]
proxool.xml里面的
[code]<alias>bookshop</alias>[/code]
和[code]DriverManager.getConnection("proxool.bookshop");[/code]对应!