tomcat连接池默认连接池的配置
1、在conf/server.xml的GlobalNamingResources
标签下添加：
<Resource name="jdbc/connPool" auth="Container" type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
maxIdle="20"
maxWait="5000"
username="root"
password=""
url="jdbc:mysql://192.168.16.12:3306/edo"
maxActive="100"
removeAbandoned="true"
removeAbandonedTimeout="60"
logAbandoned="true"/>
2、针对每个不同的项目添加连接池
\conf\catalina\localhost 连接池配置文件 文件名为项目名称：
<?xml version="1.0" encoding="UTF-8"?>
<Context>
<Resource name="jdbc/connPool"
auth="Container" type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
maxIdle="20"
maxWait="5000"
username="root"
password=""
url="jdbc:mysql://192.168.16.12:3306/edo"
maxActive="100"
removeAbandoned="true"
removeAbandonedTimeout="60"
logAbandoned="true"/>
</Context>
3、conf/content.xml中<content>标签中添加：
<ResourceLink name=" jdbc/connPool " global=" jdbc/connPool " type="javax.sql.DataSource"/>
4、在web jsp访问方式：
<%@page import="java.lang.*"%>
<%@page import="java.sql.*"%>
<%@page import="java.util.*"%>
<%@page import="javax.naming.*"%>
<%@page import="javax.sql.*"%>
<%
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
// 找到DataSource
DataSource ds = (DataSource)envContext.lookup("jdbc/connPool");
Connection conn=null;
PreparedStatement pstm = null;
ResultSet rs = null;
try {
conn=ds.getConnection();
String sql = "select id,name from userinfo";
pstm = conn.prepareStatement(sql);
rs = pstm.executeQuery();
if(rs.next()){
System.out.println(rs.getInt(1)+" "+rs.getString(2));
}
} catch (Exception e) {
e.printStackTrace();
}finally{
try{
if( rs != null ) rs.close();
if( pstm != null ) pstm.close();
if( conn != null )conn.close();
}catch( Exception e ){}
}
%>
页:
[1]