Example of a connection pool (description)

The connection pool was removed directly from the jive and modified to allow the connection parameters to be read directly in the program rather than in the subordinate file.

Usage:
First set your own connection parameters, in the Dbconnectiondefaultpool.java file Loadproperties method. Note that you also need to set the location of the log file for the connection pool.

String driver= "Org.gjt.mm.mysql.Driver";//This is the JDBC driver used
String server= "Jdbc:mysql://192.100.100.1/qingtuo";/the URL used
String server= "Jdbc:mysql://192.168.0.1/qingtuo";
String username= "Qingtuo";
String password= "Qingtuo";
String minconnections= "3";//minimum number of connections
String maxconnections= "20";//maximum number of connections
String logpath= "C:\\temp\\qingtuodblog.log";//log file location
String logpath= "/tmp/qingtuodblog.log";
String connectiontimeout= "0.5";//timed purge unwanted connection interval (in days)

and then
In your program you just need to import the package Com.qingtuo.db.pool, and then use the following.

Connection con = null;
PreparedStatement pstmt = null;
ResultSet Rs=null;
try {
con = dbconnectionmanager.getconnection ();
Here to write your SQL statement
}
catch (SQLException Sqle) {
Throw Sqle;
}
finally {
try {
Pstmt.close ();
}
catch (Exception e) {
E.printstacktrace ();
}
try {
Con.close ();
}
catch (Exception e) {
E.printstacktrace ();
}
}

Advantages
Although many application servers also have connection pooling, the benefit of doing so is more generic.