先在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>
<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();
}
%>