c3p0连接池

@Test

//原始的链接方法
public class C3POPoolDemo {
    public static void main(String[] args) throws PropertyVetoException, SQLException {
        ComboPooledDataSource cpds = new ComboPooledDataSource();
        cpds.setDriverClass("com.mysql.jdbc.Driver");
        cpds.setJdbcUrl("jdbc:mysql://localhost:3306/jdbc");
        cpds.setUser("root");
        cpds.setPassword("root");
        Connection connection = cpds.getConnection();
        String sql = "select * from users";
        PreparedStatement prepareStatement = connection.prepareStatement(sql);
        ResultSet resultSet = prepareStatement.executeQuery();
        while(resultSet.next()){
            System.out.println(resultSet.getString("name"));
        }
    }

}

//查询

    public void testC3p0() throws SQLException, PropertyVetoException{
        ComboPooledDataSource source = new ComboPooledDataSource();
        source.setDriverClass("com.mysql.jdbc.Driver");
        source.setJdbcUrl("jdbc:mysql://localhost:3306/jdbc");
        source.setUser("root");
        source.setPassword("root");
        Connection connection = source.getConnection();
        String sql ="select * from users";
        PreparedStatement statement = connection.prepareStatement(sql);
        ResultSet resultSet = statement.executeQuery();
        while (resultSet.next()) {
            int id = resultSet.getInt(1);
            String name = resultSet.getString(2);
            String pwd = resultSet.getString(3);
            String email = resultSet.getString(4);
            System.out.println("id是："+id+"名字是："+name+"密码是"+pwd+"email:"+email);
        }
        
    }
    @Test//增加和查询
    public void testC3POByProperties() throws SQLException{
        ComboPooledDataSource dataSource = new ComboPooledDataSource();
        Connection connection = dataSource.getConnection();
        String sql = "insert into users values(?,?,?,?)";
        PreparedStatement statement = connection.prepareStatement(sql);
        statement.setInt(1, 6);
        statement.setString(2, "yy");
        statement.setString(3, "333333");
        statement.setString(4, "ee@com.123");
        int executeUpdate = statement.executeUpdate();
        System.out.println(executeUpdate);
        ResultSet resultSet = statement.executeQuery("select * from users");
        while (resultSet.next()) {
            int id = resultSet.getInt(1);
            String name = resultSet.getString(2);
            String pwd = resultSet.getString(3);
            String email = resultSet.getString(4);
            System.out.println("id是："+id+"名字是："+name+"密码是"+pwd+"email:"+email);
        }
    }
    @Test//改
    public void testC3PODemo() throws SQLException{
        ComboPooledDataSource dataSource = new ComboPooledDataSource();
        Connection connection = dataSource.getConnection();
        String sql = "update users set id=3 where name ='ff'";
        PreparedStatement statement = connection.prepareStatement(sql);
        statement.executeUpdate();
        ResultSet resultSet = statement.executeQuery("select * from users");
        while (resultSet.next()) {
            int id = resultSet.getInt(1);
            String name = resultSet.getString(2);
            String pwd = resultSet.getString(3);
            String email = resultSet.getString(4);
            System.out.println("id是："+id+"名字是："+name+"密码是"+pwd+"email:"+email);
        }
    }
    @Test//删
    public void testC3P0Delete() throws SQLException{
        ComboPooledDataSource dataSource = new ComboPooledDataSource();
        Connection connection = dataSource.getConnection();
        String sql ="delete from users where id=2";
        PreparedStatement statement = connection.prepareStatement(sql);
        statement.executeUpdate();
        ResultSet resultSet = statement.executeQuery("select * from users");
        while (resultSet.next()) {
            int id = resultSet.getInt(1);
            String name = resultSet.getString(2);
            long pwd = resultSet.getLong(3);
            String email = resultSet.getString(4);
            System.out.println("id是："+id+"名字是"+name+"密码是"+pwd+"email"+email);
        }
    }