Tomcat4.1.30数据池测试
第一步
修改E:\tomcat4\conf\server.xml中的
<!-- Tomcat Root Context -->
下的东东
<Context path="" docBase="ROOT" debug="0">
<Resource name="jdbc/OracleDB" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/OracleDB">
<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:dxm</value>
</parameter>
<parameter>
<name>username</name>
<value>system</value>
</parameter>
<parameter>
<name>password</name>
<value>manager</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
</ResourceParams>
</Context>
第二步
添加
<resource-ref>
<description>Oracle Datasource example</description>
<res-ref-name>jdbc/OracleDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
在E:\tomcat4\webapps\ROOT\WEB-INF\web.xml中。
第三步
jdbc加在common\lib下
第四步测试
<%@ page contentType="text/html;charset=GBK"%>
<%@ page import= "java.sql.* "%>
<%@ page import= "javax.naming.* "%>
<html>
<head><title>Tomcat4.1.30数据池测试</title></head>
<body>
<% try{
Context initCtx = new InitialContext();
Context ctx = (Context) initCtx.lookup("java:comp/env");
//获取连接池对象
Object obj = (Object) ctx.lookup("jdbc/OracleDB");
//类型转换
javax.sql.DataSource ds = (javax.sql.DataSource)obj;
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
String strSql = " select * from test_jndi ";
ResultSet rs = stmt.executeQuery(strSql);
if(rs.next())
{ out.println(rs.getString(1));
out.println("Tomcat4.1.30数据池测试成功!");
}
}catch(Exception ex)
{ ex.printStackTrace();
throw new SQLException(ex.toString());
}%>
</body>
</html>
(全文完)
浙公网安备 33010602011771号