Java database connection pooling and database connection example _java

Copy Code code as follows:

Import java.sql.Connection;
Import java.sql.SQLException;

Import Javax.sql.DataSource;

Import Com.mchange.v2.c3p0.ComboPooledDataSource;

/**
* Tool class provides database connection pool and database connection
*
* @author Seawind
*
*/
public class Jdbcutils {
private static DataSource DataSource = new Combopooleddatasource ();

public static DataSource Getdatasource () {
return dataSource;
}

/**
* Call this method to obtain a connection when the dbutils needs to manually control the transaction
*
* @return
* @throws SQLException
*/
public static Connection getconnection () throws SQLException {
return Datasource.getconnection ();
}
}