1.利用tomcat的amdin管理界面配置连接池
2.将conf/server.xml文件中生存的连接池部分
剪切到conf/context.xml文件中
3。JNDI访问连接池
2.将conf/server.xml文件中生存的连接池部分
<Resource
name="jdbc/drp"
type="javax.sql.DataSource"
maxActive="4"
maxIdle="2"
username="drp1"
maxWait="5000"
driverClassName="oracle.jdbc.driver.OracleDriver"
password="drp1"
url="jdbc:oracle:thin:@localhost:1521:HUGUI"/>
剪切到conf/context.xml文件中
3。JNDI访问连接池
<%@ page language="java" contentType="text/html; charset=GB18030"
pageEncoding="GB18030"%>
<%@page import="javax.naming.*" %>
<%@page import="javax.sql.*" %>
<%@page import="java.sql.*" %>
<%
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try{
Context ctx = new InitialContext();
//通过JNDI查找DataSource
DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/drp");
conn = ds.getConnection();
pstmt = conn.prepareStatement("select * from t_user");
rs = pstmt.executeQuery();
System.out.println("ffff");
while(rs.next()){
out.println(rs.getString("user_id") + ", " + rs.getString("user_name"));
}
}catch(Exception e){
e.printStackTrace();
}finally{
if(rs != null){
rs.close();
}
if(pstmt != null){
pstmt.close();
}
if(conn != null){
//将Connecting放到连接池
conn.close();
}
}
%>