java+tomcat5.5.20/6.0+mysql6.0配置连接池

mysql的驱动包要放到tomcat5.5.20\common\lib目录下，如是是tomcat6.x直接放到Tomcat6\lib目录下

在tomcat5.5.20\conf\Catalina\localhost目录下新建一文件，文件名为：你的项目名称.xml

如果你用的是tomcat6.x conf没有下没有Catalina\localhost这个目录，那就直接创建这个目录再加这个文件就可以了

文件内容如下:

<!--

??? Context configuration file for the Tomcat Manager Web App

??? $Id: manager.xml 303123 2004-08-26 17:03:35Z remm $

-->

<Context docBase="D:\janson\workspace\tomcat5.5.20\webapps\rolcoe"
???????? privileged="true" antiResourceLocking="false" antiJARLocking="false">

? <!-- Link to the user database we will get roles from -->
? <ResourceLink name="users" global="UserDatabase"
??????????????? type="org.apache.catalina.UserDatabase"/>

?<Resource
? name="jdbc/MysqlPool"
? type="javax.sql.DataSource"
? maxActive="4"
? maxIdle="2"
? username="root"
? maxWait="5000"
? driverClassName="com.mysql.jdbc.Driver"
? password="1111"
? url="jdbc:mysql://localhost:3306/rolcoe"/>
</Context>

?

获取连接类如下:

package com.rolcoe.daoFactory;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;

public class ConnectionManage {
?public final static String DBJNDI = "java:comp/env/jdbc/MysqlPool";//MysqlPool是连接池名称，要和上面的配置文件 name="jdbc/MysqlPool"中的MysqlPool一致

?private static Context Actx = null;

?private static DataSource Ads = null;

?public static void CloseConn(Connection conn){
??try {
???conn.close();
??} catch (SQLException ex) {

??}??
?}
?public static Connection getDBConn() {
??Connection Aconn = null;

??if (Actx == null) {
???try {
????Actx = new InitialContext();
???} catch (NamingException ex) {
????Actx = null;
????System.out.print("初始化连接池错误！No Context!!" + ex.getMessage());
???}
??}
??if (Actx != null) {
???try {
????Ads = (DataSource) Actx.lookup(DBJNDI);
???} catch (NamingException ex) {
????System.out.print("查找数据库连接池错误！!" + ex.getMessage());
???}
???if (Ads != null) {
????try {
?????Aconn = Ads.getConnection();
????} catch (SQLException ex) {
?????System.out.print("创建数据库连接错误!!" + ex.getMessage());
????}
???}
??}
??return Aconn;
?}

/*?public void close() {
??if (cn != null)
???try {
????cn.close();
???} catch (SQLException e) {
????// TODO 自动生成 catch 块
????e.printStackTrace();
???}
?}*/

?public static void close_p(Connection con, PreparedStatement pstm) {
??try {
???if (con != null)
????con.close();

???if (pstm != null)
????pstm.close();
??} catch (Exception e) {
???e.printStackTrace();
??}
?}

?public static void close_s(Connection con, Statement pstm) {
??try {
???if (con != null)
????con.close();

???if (pstm != null)
????pstm.close();
??} catch (Exception e) {
???e.printStackTrace();
??}
?}

?public static void close_s(Connection con, Statement pstm, ResultSet rs) {
??try {
???if (rs != null)
????rs.close();
???if (pstm != null)
????pstm.close();
???if (con != null)
????con.close();

??} catch (Exception e) {
???e.printStackTrace();
??}
?}

?public static void close_p(Connection con, PreparedStatement pstm,
???ResultSet rs) {
??try {
???if (rs != null)
????rs.close();
???if (pstm != null)
????pstm.close();
???if (con != null)
????con.close();

??} catch (Exception e) {
???e.printStackTrace();
??}
?}

?public static void main(String args[]) {
??new ConnectionManage();

?}
}

?