请教c3p0的使用demo

Question

一定要在类路径下，你如果用IDE的话就在src根目录下就可以了

Answer 1

是在src下，读取的代码是上面的那样吗，如何把c3p0.properties的配置放到ComboPooledDataSource？

Answer 2

ComboPooledDataSource cpds = new ComboPooledDataSource("c3p0.properties");
这就可以了

Answer 3

Connection conn = null;
        Statement stsm = null;
        ComboPooledDataSource cds = null;
        cds = new ComboPooledDataSource(); //这里无需指定配置文件
 
        try {
 
            conn = cds.getConnection();
            stsm = conn.createStatement();
 
            ResultSet rs = stsm.executeQuery("select * from tbwebtest");
            while (rs.next()) {
                // do something
             }
 
            conn.close();
            stsm.close();
 
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }以下配置自己酌情修改
c3p0.jdbcUrl=jdbc:mysql://localhost:3306/test
c3p0.driverClass=com.mysql.jdbc.Driver  
c3p0.user=myuser
c3p0.password=mypassword
  
c3p0.acquireIncrement=3   
c3p0.idleConnectionTestPeriod=60      
c3p0.initialPoolSize=3 
c3p0.maxIdleTime=60   
c3p0.maxPoolSize=5   
c3p0.maxStatements=100    
c3p0.minPoolSize=2