Package Com.mysql.demo;import Java.io.inputstream;import Java.sql.connection;import java.sql.sqlexception;import Java.util.properties;import Javax.sql.datasource;import org.apache.commons.dbcp.basicdatasourcefactory;// Use the Open source database connection pool dbcp//reference Dbcp.jar and Pool.jar to read the DBCP configuration file. Refer directly to Getconnection or Getdatasourcepublic class Sqlpooling {private static DataSource ds=null;static{try{properties p= New Properties (); InputStream In=sqlpooling.class.getclassloader (). getResourceAsStream ("dbcpconfig.properties"); P.load (in); Basicdatasourcefactory factory=new basicdatasourcefactory ();d S=factory.createdatasource (p);//}catch (Exception e) { E.printstacktrace ();}} public static DataSource Getdatasource () {return DS;} public static Connection getconnection () throws Sqlexception{return ds.getconnection ();//dbcp connction ()}}
How to use open source framework database connection pool DBCP