数据库连接池c3p0——连接步骤详解代码&jar包下载

下载链接：提取码为gkmm

步骤总结

1.导入jar包和c3p0-config.xml

2.配置文件（如下顺序操作）

3.创建链接

保证有li这个数据库，和student表

package c3p0;

import com.mchange.v2.c3p0.ComboPooledDataSource;

import javax.activation.DataSource;
import java.io.IOException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

public class JDBCUtils {

    public static void main(String[] args) throws SQLException {
        ComboPooledDataSource ds = new ComboPooledDataSource();
        Connection connection = ds.getConnection();
        System.out.println(connection);
        Statement statement = connection.createStatement();
        String sql = "select * from student";
        ResultSet set = statement.executeQuery(sql);

        System.out.println("姓名"+"\t"+"密码"+"\t"+"分数");
        while(set.next()){
            System.out.println(set.getString("name")+"\t"+set.getString("password")+"\t"+set.getString("score"));
        }
    }

}

4.测试结果