c3p0-config.xml

     
         
              
       
        root
               
       
        root
               
       
        com.mysql.jdbc.Driver
               
       
        jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=UTF8
               
               
       
        2
               
       
        5
               
       
        5
               
       
        10
               
       
        20
               
       
        5
           
      
     

JdbcUtils

package Utils;import java.sql.Connection;import java.sql.SQLException;import javax.sql.DataSource;import com.mchange.v2.c3p0.ComboPooledDataSource;public class JdbcUtil {        public static void reaseConnection(Connection connection) {        try {            if(connection!=null){                connection.close();            }        } catch (SQLException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }    }    private static DataSource dataSource = null;    static{        dataSource = new ComboPooledDataSource("mvc");    }        public static DataSource getDataSource(){        return dataSource;    }        public static Connection getConnection(){        try {            return dataSource.getConnection();        } catch (SQLException e) {            // TODO Auto-generated catch block            //e.printStackTrace();            System.out.println("连接失败");        }        return null;            }}