JDBCUtil源码

package com.imooc.utils;

import java.beans.PropertyVetoException;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import com.mchange.v2.c3p0.ComboPooledDataSource;

import com.mchange.v2.c3p0.DataSources;

public class JDBCUtils {

    private static String url = "jdbc:mysql://localhost:3306/regist_web";

    private static String user = "root";

    private static String passwd = "20142266";

    private static String driver = "com.mysql.jdbc.Driver";

     public static ComboPooledDataSource getDataSource() throws Exception{

     ComboPooledDataSource cpds = new ComboPooledDataSource();

     cpds.setDriverClass( driver);

            cpds.setJdbcUrl( url );

            cpds.setUser(user);                                  

            cpds.setPassword(passwd);  

            cpds.setMinPoolSize(5);                                     

            cpds.setAcquireIncrement(5);

            cpds.setMaxPoolSize(30);

            cpds.setMaxIdleTime(60);

             return cpds;

}

}