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"   //test 是你的JSP文件.
      maxActive="20"/>
2.在</Host>这之前添加
复制内容到剪贴板代码:
<Context
            docBase="你的服务目录"
            path="/虚拟路径"
            reloadable="true">
            <ResourceLink
                global="jdbc/mysql"
                name="jdbc/mysql"
                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/mysql"
                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目录下