先在Tomcat服务器中配置好数据库连接池:
<Context path="/Test_datasource" reloadable="true" docBase="Test_datasource">
<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();
}
%>