DBCP连接池操作mysql数据库

最新推荐文章于 2022-08-18 14:01:18 发布

weixin_30611509

最新推荐文章于 2022-08-18 14:01:18 发布

阅读量227

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/zsj03180204/p/11118651.html

本文详细介绍了如何在Java中使用DBCP连接池进行数据库操作，包括导入必要的jar包、配置文件dbcpconfig.properties的使用、DBCPUtils工具类的编写及具体应用案例，如插入数据和查询数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1 导入jar包：commons-dbcp-1.4.jar， commons-pool-1.5.6.jar，mysql-connector-java-5.1.37-bin.jar

2 导入配置文件：dbcpconfig.properties

3 编写工具类DBCPUtils

public class DBCPUtils {
    private static DataSource ds;
    static{
        try {
            Properties ps = new Properties();
            ps.load(new FileInputStream("dbcpconfig.properties"));
            ds = BasicDataSourceFactory.createDataSource(ps);
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } 
    }
    
    public static Connection getConnection() {
        try {
            return ds.getConnection();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            throw new RuntimeException();
        }
    }
    public static void closeAll(Connection conn, PreparedStatement pst, ResultSet rs) {
        if(rs != null){
            try {
                rs.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
        
        if(pst != null){
            try {
                pst.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
        
        if(conn != null){
            try {
                conn.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
    }
}

4 使用工具类操作mysq

public class DBCPUtilsDemo {
    public static void main(String[] args) throws SQLException {
        insert();
        query();
    }

    public static void insert() throws SQLException {
            Connection conn = DBCPUtils.getConnection();
            String sql = "insert into practice (cid, cname) values (?, ?)";
            PreparedStatement pst = conn.prepareStatement(sql);
            pst.setObject(1, 1);
            pst.setObject(2, "abc123");
            int rows = pst.executeUpdate();
            System.out.println(rows);
            DBCPUtils.closeAll(conn, pst, null);
    }
    
    public static void query() throws SQLException{
        Connection conn = DBCPUtils.getConnection();
        Statement st = conn.createStatement();
        String sql = "select * from users";
        ResultSet rs = st.executeQuery(sql);
        while(rs.next()){
            System.out.println(rs.getObject("uid") + "\t" + rs.getObject("username") + "\t" + rs.getObject("password") + "\t");
        }
    }
}