Tomcat 5.5.x + mysql 5.0.x 配置连接池
一、在tomcat\conf\server.xml
1.<GlobalNamingResources></GlobalNamingResources>之间添加
<Resource
name="jdbc/mysql" //这个名字可以随便取,连接时用到的,
type="javax.sql.DataSource"
password="mysql的登录用户密码"
driverClassName="com.mysql.jdbc.Driver"
maxIdle="10"
maxWait="1000"
username="mysql的登录用户"
url="jdbc:mysql://localhost:3306/test"
maxActive="20"/>
2.在</Host>这之前添加
<Context
docBase="你的服务目录"
path="/虚拟路径"
reloadable="true">
<ResourceLink
global="jdbc/mysql"
name="jdbc/msyql"
type="javax.sql.DataSourcer"/>
</Context>
二、在tomcat\conf\context.xml，<Context></Context>之间添加
<Resource
name="jdbc/mysql"
type="javax.sql.DataSource"
password="mysql的登录用户密码"
driverClassName="com.mysql.jdbc.Driver"
maxIdle="10"
maxWait="1000"
username="mysql的登录用户"
url="jdbc:mysql://localhost:3306/test"
maxActive="20"/>
<ResourceLink
global="jdbc/mysql"
name="jdbc/msyql"
type="javax.sql.DataSourcer"/>
注意: 这一步重要,要不然后,报错javax.naming.NameNotFoundException: Name is not bound in this Context 错误
三、下面是测试文件
testDataSource.jsp
<%@ page language="java" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<%@ page import="javax.sql.*" %>
<%@ page import="javax.naming.*" %>
<%
Connection con = null;
Statement sm = null;
ResultSet rs = null;
try {
InitialContext ctx = new InitialContext();
Context envctx = (Context)ctx.lookup("java:comp/env");
DataSource ds = (DataSource)envctx.lookup("jdbc/mysql");
con = ds.getConnection();
sm = con.createStatement();
rs = sm.executeQuery("select * from person"); //对应改
while(rs.next()) {
out.println(rs.getString(1)+",");
}
}catch(Exception e) {
e.printStackTrace();
}finally {
if(rs !=null) {
try {
rs.close();
} catch(SQLException e) {}
rs = null;
}
if(sm != null) {
try {
sm.close();
} catch(SQLException e) {}
sm = null;
}
if(con != null) {
try {
con.close();
} catch(SQLException e) {}
con = null;
}
}
%>
说明: JDBC确保放在Tomcat\common\lib目录下.
