//1:将Oracle的class12.jar拷贝到E:/Tomcat/common/lib下。
//然后打开Server.xml文件
//1:配置局部连接池
//在<host></host>之间加入这段话即可配置好局部连接池
<Context path="/TestPool" docBase="F:/WookRoot/NBRoot/TestPool/WebRoot" reloadable="true">
<Resource name="jdbc/oracle" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/oracle">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@localhost:1521:oradb</value>
</parameter>
<parameter>
<name>username</name>
<value>jn0710</value>
</parameter>
<parameter>
<name>password</name>
<value>jn0710</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>5</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
</ResourceParams>
</Context>
//2:配置全局连接池
//先在GlobalNamingResources配置局部的连接池
<GlobalNamingResources>
<Resource name="jdbc/oracle" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/oracle">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@localhost:1521:oradb</value>
</parameter>
<parameter>
<name>username</name>
<value>jn0710</value>
</parameter>
<parameter>
<name>password</name>
<value>jn0710</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>5</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
</ResourceParams>
</GlobalNamingResources>
//然后在<host></host>之间调用全局的连接池
//调用时 DataSource dataSource = (DataSource) context.lookup("java:comp/env/jdbc/callGlobal");
<Context path="/TestPool" docBase="F:/WookRoot/NBRoot/TestPool/WebRoot" reloadable="true">
<ResourceLink name="jdbc/callGlobal" global="jdbc/oracle" type="javax.sql.DataSource"/>
</Context>
//调用连接池
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("GBK");
response.setCharacterEncoding("GBK");
response.setContentType("text/html");
PrintWriter out = response.getWriter();
try {
Context context = new javax.naming.InitialContext();
javax.sql.DataSource dataSource = (javax.sql.DataSource) context
.lookup("java:comp/env/jdbc/oracle");
Connection conn = dataSource.getConnection();
Statement stmt = conn.createStatement();
String sql = "Select * from classinfo";
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
System.out.println(rs.getString("classid"));
System.out.println(rs.getString("classname"));
}
} catch (Exception e) {
e.printStackTrace();
}
out.flush();
out.close();
}