c3p0数据库连接池问题
由于以前做的项目没用mysql是用自己的连接池. 新启一个工程用到mysql,mysql对于连接超过8小时,就会断开连接. 在网上查了下,说c3p0可以解决该问题. 找了点资料,配置后写代码测试,发觉c3p0也并没有提高效率,难道是我代码写错了. 因为c3p0每次都得释放连接,感觉用不用作用不太大.

import java.beans.PropertyVetoException;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;

import javax.sql.rowset.CachedRowSet;

import com.mchange.v2.c3p0.ComboPooledDataSource;
import com.sun.rowset.CachedRowSetImpl;
import com.zhongwei.connectionpool.ConnectionPool;


public class ConnectionManager
{
    private static ConnectionManager instance;
    
    private static ComboPooledDataSource dataSource;
    
    private ConnectionManager() throws IOException, SQLException,
            PropertyVetoException
    {
        
        Properties p = new Properties();
        
        p.load(this.getClass().getResourceAsStream("c3p0.properties"));
        
        dataSource = new ComboPooledDataSource();
        
        dataSource.setProperties(p);
        
        System.out.println(p.getProperty("password"));
        
        dataSource.setUser(p.getProperty("user"));
        dataSource.setPassword(p.getProperty("password"));
        dataSource.setJdbcUrl(p.getProperty("jdbcUrl"));
        dataSource.setDriverClass(p.getProperty("driverClass"));
        dataSource.setInitialPoolSize(Integer.valueOf(p.getProperty("initialPoolSize")));
        dataSource.setMinPoolSize(Integer.valueOf(p.getProperty("minPoolSize")));
        dataSource.setMaxPoolSize(Integer.valueOf(p.getProperty("maxPoolSize")));
        dataSource.setMaxStatements(Integer.valueOf(p.getProperty("maxStatements")));
        dataSource.setMaxIdleTime(Integer.valueOf(p.getProperty("maxIdleTime")));
        dataSource.setPreferredTestQuery(p.getProperty("preferredTestQuery"));
        dataSource.setIdleConnectionTestPeriod(Integer.valueOf(p.getProperty("idleConnectionTestPeriod")));
        dataSource.setTestConnectionOnCheckout(Boolean.valueOf(p.getProperty("testConnectionOnCheckout")));
        dataSource.setTestConnectionOnCheckin(Boolean.valueOf(p.getProperty("testConnectionOnCheckin")));
        dataSource.setAcquireIncrement(Integer.valueOf(p.getProperty("acquireIncrement")));
        dataSource.setAcquireRetryAttempts(Integer.valueOf(p.getProperty("acquireRetryAttempts")));
        dataSource.setAcquireRetryDelay(Integer.valueOf(p.getProperty("acquireRetryDelay")));
        dataSource.setAutomaticTestTable(p.getProperty("automaticTestTable"));
        dataSource.setCheckoutTimeout(Integer.valueOf(p.getProperty("checkoutTimeout")));
        dataSource.setAutoCommitOnClose(Boolean.valueOf(p.getProperty("autoCommitOnClose")));
        
    }
    
    public static final ConnectionManager getInstance()
    {
        if (instance == null)
        {
            try
            {
                instance = new ConnectionManager();
            }
            catch (Exception e)
            {
                e.printStackTrace();
            }
        }
        return instance;
    }
    
    public synchronized final Connection getConnection()
    {
        Connection connection = null;
        
        try
        {
            connection = dataSource.getConnection();
            
        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
        return connection;
    }
    
 
    public static void main(String[] args) throws Exception
    {
         System.out.println("开始使用连接池...");
      
         PreparedStatement pst = null;
         
         for(int i=0;i<10;i++)
         {
             long beginTime = System.currentTimeMillis();
             
             ConnectionManager inManager = ConnectionManager.getInstance();
             
             Connection conn = inManager.getConnection(); 
             
             try