com.qf.util工具类里边的C3P0Util.java

代码如下：

package com.qf.util;import java.beans.PropertyVetoException;import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import com.mchange.v2.c3p0.ComboPooledDataSource;public class C3P0Util {    private static ComboPooledDataSource dataSource = new ComboPooledDataSource();    public static ComboPooledDataSource getDataSource() {        return dataSource;    }    // static {    //    // try {    // dataSource.setDriverClass( "com.mysql.jdbc.Driver" ); //loads the jdbc    // driver    // dataSource.setJdbcUrl( "jdbc:mysql://localhost:3306/day_14" );    // dataSource.setUser("root");    // dataSource.setPassword("123456");    // dataSource.setInitialPoolSize(10);    // } catch (PropertyVetoException e) {    // e.printStackTrace();    // throw new ExceptionInInitializerError("配置文件出错啦");    // }    // }    // 获取连接    public static Connection getConnection() {        try {            return dataSource.getConnection();        } catch (SQLException e) {            e.printStackTrace();            throw new RuntimeException("服务器繁忙");        }    }    // 释放资源    public static void release(ResultSet rs, Statement stmt, Connection conn) {        if (rs != null) {            try {                rs.close();            } catch (SQLException e) {                // TODO Auto-generated catch block                e.printStackTrace();            }            rs = null;        }        if (stmt != null) {            try {                stmt.close();            } catch (SQLException e) {                // TODO Auto-generated catch block                e.printStackTrace();            }            stmt = null;        }        if (conn != null) {            try {                conn.close();// 运行的时候检查调用自己重写的 close() 连接还回取            } catch (SQLException e) {                // TODO Auto-generated catch block                e.printStackTrace();            }            conn = null;        }    }}

记得导jar包
包名： c3p0-0.9.1.2.jar