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 ){}
??}
%>