tomcat60连接池的配置及实例.docx

Tomcat6.0 连接池的配置及实例 1． 配置 Tomcat 目录文件夹 conf 下的 context.xml 文件添加如下节点： SqlServer 为 : Resource name=jdbc/testDB auth=Container type=javax.sql.DataSource maxActive=100 maxIdle=30 maxWait=10000 username=sa password= driverClassName=com.microsoft.jdbc.sqlserver.SQLServerDriver url=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs/ MySql 为： Resource name=jdbc/testDB auth=Container type=javax.sql.DataSource maxActive=100 maxIdle=30 maxWait=10000 username=root password=root driverClassName=com.mysql.jdbc.Driver url=jdbc:mysql://localhost/class/ 2． 找到 WEB-INF/web.xml 在 web-app../web-app 中添加如下节点 resource-ref description TestDB / description res-ref-name jdbc/testDB / res-ref-name res-type javax.sql.DataSource / res-type res-auth Container / res-auth / resource-ref 3． 编写测试程序代码如下 : package com.szkp; import java.sql.*; import javax .namin g.*; import javax.sql.DataSource; import java.util.*; public class Conn { public Connection getC on(){ Conn ecti on con=n ull; try { Con text ic=new In itialC on text(); DataSource data=(DataSource)ic」o okup(java:comp/e nv/jdbc/testDB); con=data.getC onnection(); } catch (Nam in gExcepti on e) { e.pri ntStackTrace(); }catch (SQLException e) { e.pri ntStackTrace(); } return con; } public List getData(C onnection con){ ListStri ng n ame=n ull; String sql=select au_lname from authors; try { Stateme nt s=c on .createStateme nt(); ResultSet rs=s.executeQuery(sql); n ame=new ArrayListStri ng(); while(rs. next()){ String ss=rs.getString(1); n ame.add(ss); } } catch (SQLException e) { e.pri ntStackTrace(); }fin ally{ try { con. close(); } catch (SQLException e) { e.pri ntStackTrace(); } } return n ame; } } 4.编写测试Jsp页面 %@ page Ian guage =javaimport =java.util.*pageE ncod ing =gbk %@ page Ian guage =java import =java.util.* pageE ncod ing =gbk % %@ page import =com.szkp.* % %@ page import =java.sql.* % % gbk);request.setCharacterE ncod ing( gbk); resp on se.setC onten tType(text/html; charset=gb2312); resp on se.setC onten tType( text