JDBC连接池

在项目中创建Bean目录，里面放入Java类，类中的属性要与数据表中对应。
（1）导入相应的jar包
（2）加载、注册sql驱动
（3）获取Connection连接对象

编写jdbc.properties文件

user=root
password=123456
url=jdbc:mysql://localhost:3306/test?rewriteBatchedStatements=true
driverClass=com.mysql.jdbc.Driver

连接方式

public static Connection getConnection() throws Exception{
        //读取配置文件中的4个基本信息
        InputStream is= ClassLoader.getSystemClassLoader().getResourceAsStream("jdbc.properties");

        Properties pro=new Properties();
        pro.load(is);
        String user = pro.getProperty("user");
        String password = pro.getProperty("password");
        String url = pro.getProperty("url");
        String driverClass = pro.getProperty("driverClass");

        //加载驱动
        Class.forName(driverClass);

        //获取连接
        Connection conn = DriverManager.getConnection(url, user, password);
        return conn;
    }

德鲁伊连接池

配置druid文件

url=jdbc:mysql://localhost:3306/test?rewriteBatchedStatements=true
username=root
password=123456
driverClassName=com.mysql.jdbc.Driver

initialSize=10
maxActive=20
maxWait=1000
filters=wall

 public static Connection getConnection3() throws Exception{
        Properties pros=new Properties();
        InputStream is = ClassLoader.getSystemClassLoader().getResourceAsStream("druid.properties");
        pros.load(is);
        DataSource source= DruidDataSourceFactory.createDataSource(pros);
        Connection conn=source.getConnection();
        return conn;
    }

DBCP连接池

driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/test
username=root
password=123456

Properties pro=new Properties();
        InputStream is = ClassLoader.getSystemClassLoader().getResourceAsStream("dbcp.properties");

        pro.load(is);
        //创建DBCP连接池
        DataSource source = BasicDataSourceFactory.createDataSource(pro);
        Connection conn=source.getConnection();
        return conn;

数据库关闭

  /*
    查询关闭资源操作
     */
    public static void closeResource(Connection conn, PreparedStatement ps, ResultSet rs) {
        try {
            if (ps != null)
                ps.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        try {
            if (conn != null) {
                conn.close();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        try {
            if (rs != null) {
                rs.close();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public static void closeResource1(Connection conn, PreparedStatement ps, ResultSet rs) {
        try {
            DbUtils.close(conn);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        try {
            DbUtils.close(ps);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        try {
            DbUtils.close(rs);
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }