c3p0的配置和使用(包含所需的c3p0 jar包)

野性酷女 2023-06-12 08:49 19阅读 0赞

c3p0连接池jar包地址： **链接：https://pan.baidu.com/s/1pDskeTNxb7r-Kbnfw6gPhg  
提取码：wckq**

![20191111151348334.PNG][]

1.  **在项目中新建一个模块，并且在模块中建立libs文件夹**

![20191111152041516.PNG][]

1.  **将以下jar包复制到libs文件夹下，然后分别单机右键->点击Add as library(将jar包添加为库)**  
    ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MzIyMzU3_size_16_color_FFFFFF_t_70][]
2.  **将xml文件复制到src目录下**  
    ![2019111115292240.PNG][]
3.  **修改XML文件中的数据库名称，用户名，密码，每个人设置的可能不一样**  
    ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MzIyMzU3_size_16_color_FFFFFF_t_70 1][]

#### 配置结束，接下来说下c3p0的具体使用步骤 ####

1.  获取datasource对象
2.  通过datasource对象获取连接对象
3.  定义sql语句
4.  执行sql语句
5.  归还连接对象

package c3p0;
    /* * 使用数据库连接池c3p0的步骤 * */
    import com.mchange.v2.c3p0.ComboPooledDataSource;
    import javax.sql.DataSource;
    import java.sql.Connection;
    import java.sql.PreparedStatement;
    import java.sql.SQLException;
    
    public class c3p0Demo01 { 
        public static void main(String[] args) { 
            Connection conn = null;
            PreparedStatement pstmt = null;
            //获取datasource
            DataSource ds = new ComboPooledDataSource();
            try { 
                /*获取连接*/
                conn = ds.getConnection();
                //定义sql语句
                String sql = "update acccount set balance = 100 where id = 1";
                //执行sql语句
                pstmt = conn.prepareStatement(sql);
                pstmt.executeUpdate();
            } catch (SQLException e) { 
                e.printStackTrace();
            }finally { 
                try { 
                    //归还连接
                    conn.close();
                } catch (SQLException e) { 
                    e.printStackTrace();
                }
            }
    
        }
    }

[20191111151348334.PNG]: https://img-blog.csdnimg.cn/20191111151348334.PNG
[20191111152041516.PNG]: https://img-blog.csdnimg.cn/20191111152041516.PNG
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MzIyMzU3_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20191111152321548.PNG?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MzIyMzU3,size_16,color_FFFFFF,t_70
[2019111115292240.PNG]: https://img-blog.csdnimg.cn/2019111115292240.PNG
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MzIyMzU3_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20191111154329964.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MzIyMzU3,size_16,color_FFFFFF,t_70