Connection Pool Core class DataSource
Based on this core class, there are several ways to create a connection pool, and here's how to create a connection pool for the database by reading the configuration file.
Dbcputils.java
Package Com.itheima.a_dbcp;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; public class Dbcputils {private static DataSource DataSource; static{try {//* provides parameters, content from config file properties props = new Propertie S ();//*** load InputStream is = DBCPUtils.class.getClassLoader (). getResourceAsStream ("dbcpconfig.properties"); Props.load (IS);//* Create a connection pool, just create one time DataSource = Basicdatasourcefactory.createdatasource (props);} catch (Exception e) {throw new RuntimeException (e);}} public static Connection getconnection () throws sqlexception{//get connection from Connection pool return datasource.getconnection ();}}
Testdbcppool.java
Package Com.itheima.a_dbcp;import Java.sql.connection;import Java.sql.sqlexception;public class TestDBCPPool {public static void Main (string[] args) throws SQLException {Connection conn = dbcputils.getconnection (); SYSTEM.OUT.PRINTLN (conn); Conn.close ();}}
Todo