public class c3p0demo{
/*
Code configuration
*/
public void Fun1 () {
To create a connection pool object
Combopooleddatasource DataSource = new Combopooleddatasource ();
Four-parameter configuration for connection pooling
Datasource.setdriverclass ("Com.mysql.jdbc.Driver");
Datasource.setjdbcurl ("Jdbc:mysql://loaclhost:3306/mydb");
Datasource.setuser ("root");
Datasource.setpassword ("root");
Pool Configuration
Datasource.setacquireincrement (5);
Datasource.setinitialpoolsize (20);
Datasource.setminpoolsize (2);
Datasource.setmaxpoolsize (50);
Connection con = datasource.getconnection ();
System.out.println (con);
Con.close ();
}
/*
Default configuration for configuration files
*/
public void fun2 () {
When you create a connection pool object, the object automatically loads the configuration file.
Combopooleddatasource DataSource =
New Combopooleddatasource ();
Connection con = datasource.getconnection ();
System.out.println (con);
Con.close ();
}
/*
Using Named configuration information
*/
public void Fun3 () {
Constructor's parameter specifies the name of the named configuration element!
Combopooleddatasource DataSource =
New Combopooleddatasorce ("Oracle-config");
Connection con = datasource.getconnection ();
System.out.println (con);
Con.close ();
}
}
C3P0 Connection Pool