JDBC学习笔记（6）之数据库连接池实现

来源：互联网发布：ci框架怎么连接数据库编辑：程序博客网时间：2024/04/30 00:38

package DatabaseConnectionPool;import java.beans.PropertyVetoException;import java.io.FileInputStream;import java.io.IOException;import java.sql.Connection;import java.sql.SQLException;import java.sql.Statement;import java.util.Properties;import com.mchange.v2.c3p0.ComboPooledDataSource;public class DatabaseConnectionPool {private static Properties pro=new Properties();private static ComboPooledDataSource databasesource=new ComboPooledDataSource();/*************初始化数据库连接池*************/private static void initPool(){try {pro.load(new FileInputStream("jdbc.properties"));databasesource.setDriverClass(pro.getProperty("jdbc.driver"));databasesource.setJdbcUrl(pro.getProperty("jdbc.url"));databasesource.setUser(pro.getProperty("jdbc.usrName"));databasesource.setPassword(pro.getProperty("jdbc.passwd"));databasesource.setInitialPoolSize(15);databasesource.setMinPoolSize(5);databasesource.setMaxPoolSize(30);databasesource.setMaxIdleTime(60);databasesource.setIdleConnectionTestPeriod(60);} catch (PropertyVetoException | IOException e) {// TODO Auto-generated catch blocke.printStackTrace();}}/*************建立连接、创建Statement*************/public static Statement getConnction(){initPool();Connection conn=null;Statement st=null;try { conn=databasesource.getConnection(); st=conn.createStatement();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}return st;}}

0 0