Import Java.io.InputStream;
Import java.sql.Connection;
Import java.util.Properties;
Import Org.apache.commons.dbcp.BasicDataSource;
public class Dbutils {
private static String driver;
private static String URL;
private static String user;
private static String password;
private static int initsize;
private static int maxactive;
private static Basicdatasource DS;
static{
Ds=new Basicdatasource ();
Properties Cfg=new properties ();
try {
InputStream In=dbutils.class.getclassloader ().
getResourceAsStream ("Db.properties");
Cfg.load (in);
Initialize parameters
Driver=cfg.getproperty ("Jdbc.driver");
Url=cfg.getproperty ("Jdbc.url");
User=cfg.getproperty ("Jdbc.user");
Password=cfg.getproperty ("Jdbc.password");
Initsize=integer.parseint (Cfg.getproperty ("initsize"));
Maxactive=integer.parseint (Cfg.getproperty ("maxactive"));
In.close ();
Initializing the connection pool
Ds.setdriverclassname (driver);
Ds.seturl (URL);
Ds.setusername (user);
Ds.setpassword (password);
Ds.setinitialsize (initsize);
Ds.setmaxactive (maxactive);
} catch (Exception e) {
E.printstacktrace ();
throw new RuntimeException ();
}
}
public static Connection getconnection () {
try {
Connection conn=ds.getconnection ();
Return conn;
} catch (Exception e) {
E.printstacktrace ();
throw new RuntimeException ();
}
}
public static void Close (Connection conn) {
if (conn!=null) {
try {
Conn.close ();
} catch (Exception e) {
}
}
}
public static void rollback (Connection conn) {
if (conn!=null) {
try {
Conn.rollback ();
} catch (Exception e) {
E.printstacktrace ();
}
}
}
}
JDBC Connection Pool