C3P0 is a common data connection pooling technology (provided by third parties)
is also based on the core class datasource.
Dbcputils.java
Package Com.itheima.b_dbcp;import Java.sql.connection;import Java.sql.sqlexception;import Org.apache.commons.dbcp.basicdatasource;public class Dbcputils {private static basicdatasource DataSource; static{try {//Manually create connection Pool DataSource = new Basicdatasource ();//Set parameters//* Basic Datasource.setdriverclassname ("Com.mysql.jdbc.Driver"); Datasource.seturl ("Jdbc:mysql://localhost:3306/day17");d atasource.setusername ("root");d Atasource.setpassword (" 1234 ");//* function datasource.setinitialsize (20); Number of initialization datasource.setmaxactive (50); Maximum number of connections Datasource.setmaxidle (30);//MAX idle number Datasource.setminidle (10)////* * * connection pool, use idle time to maintain link creation and destruction in connection pool} catch ( Exception e) {throw new RuntimeException (e);}} public static Connection getconnection () throws sqlexception{//get connection from Connection pool return datasource.getconnection ();}}
You can write a test class, test it yourself.