Oracle数据库连接池

先在Tomcat服务器中配置好数据库连接池：

<Context path="/Test_datasource" reloadable="true" docBase="Test_datasource">

  < Resource name =" dbconnection " auth =" Container " type =" javax.sql.DataSource " maxActive =" 10 " maxIdle =" 10 " maxWait =" 10000 " username =" study-205 " password =" study " driverClassName =" oracle.jdbc.driver.OracleDriver " url =" jdbc:oracle:thin:@10.10.12.1:1521:edudb " />

  </ Context >

这是主要的配置部分

这个jdbc驱动包存放在<ORACLE_HOME>/ora92/jdbc/lib/目录下有，一个为classes12.jar，另一个为classes12.zip。

Oracle的jdbc数据库驱动包一定要拷贝到<CATALINA_HOME>/common/lib 目录下：classes12.jar

这是web.xml的主要配置：

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.4"
 xmlns="http://java.sun.com/xml/ns/j2ee"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
 http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
<resource-ref>
<res-ref-name>dbconnection</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>

这是测试页面：

<%
  try {
   Context ctx = new InitialContext();
   DataSource ds = (DataSource) ctx
     .lookup("java:comp/env/dbconnection");
   Connection conn = ds.getConnection();
   String sql = "select * from ejb_test_user ";
   Statement stm = conn.createStatement();
   ResultSet rs = stm.executeQuery(sql);
   while (rs.next()) {
    out.println(rs.getString("username"));
   }
   out.println("success");
  } catch (Exception e) {
   e.printStackTrace();
  }
 %>