Reading data from the configuration file get connection

Configuration file

db.driver=com.mysql.jdbc.Driverdb.url=jdbc\:mysql\://localhost\:3306/mybasedb.user=  ROOTDB.PSWD=[email protected]#--connection Pool Initialize number of connections--datasource.initialsize=10#--Maximum idle connection-- Datasource.maxidle=20#--Minimum idle connection--datasource.minidle=5 #--Maximum Connections--datasource.maxactive=50 #--Timeout Wait time in milliseconds of 6000 milliseconds/1000 equals 60 seconds--datasource.wait=500

Link a database using normal methods

 PackageCom.globalroam.util;Importjava.io.IOException;Importjava.util.Properties; Public classDbutil {Private StaticProperties Properties =NewProperties ();  Public StaticString Driver =NULL;  Public StaticString URL =NULL;  Public StaticString user =NULL;  Public StaticString pswd =NULL; Static{        Try{properties.load (dbutil).class. getClassLoader (). getResourceAsStream ("Resource/db.properties")); Driver= Properties.getproperty ("Db.driver"); URL= Properties.getproperty ("Db.url"); User= Properties.getproperty ("Db.user"); PSWD= Properties.getproperty ("db.pswd"); } Catch(IOException e) {e.printstacktrace (); }    }}

Get connection Using connection pooling

 PackageCom.globalroam.util;Importjava.io.IOException;Importjava.sql.Connection;Importjava.sql.SQLException;Importjava.util.Properties;ImportOrg.apache.commons.dbcp.BasicDataSource; Public classDbconnectionpool {Private StaticBasicdatasource DataSource =NULL; Private StaticProperties Properties =NewProperties (); //private static Logger Logger = Logger.;     Public Static voidInitDataSource () {Try{properties.load (dbconnectionpool).class. GetClass (). getResourceAsStream ("Resource/db.properties")); DataSource=NewBasicdatasource (); Datasource.setdriverclassname (Properties.getproperty ("Db.driver")); Datasource.seturl (Properties.getproperty ("Db.url")); Datasource.setusername (Properties.getproperty ("Db.user")); Datasource.setpassword (Properties.getproperty ("DB.PSWD")); if(Properties.getproperty ("datasource.initialsize")! =NULL) {datasource.setinitialsize (Integer.parseint (Properties.getproperty ("Datasource.initialsize"))); }                        if(Properties.getproperty ("Datasource.maxidle")! =NULL) {Datasource.setmaxidle (Integer.parseint (Properties.getproperty ("Datasource.maxidle"))); }                        if(Properties.getproperty ("Datasource.minidle")! =NULL) {Datasource.setminidle (Integer.parseint (Properties.getproperty ("Datasource.minidle"))); }                        if(Properties.getproperty ("datasource.maxactive")! =NULL&& "0". Equals (Properties.getproperty ("Datasource.maxactive")) {datasource.setmaxactive (Integer.parseint (Properties.getproperty ("Datasource.maxactive"))); }                        if(Properties.getproperty ("datasource.wait")! =NULL) {datasource.setmaxwait (Integer.parseint (Properties.getproperty ("Datasource.wait"))); }        } Catch(IOException e) {e.printstacktrace (); }    }          Public StaticConnection getconnection ()throwsSQLException {Connection conn=NULL; if(DataSource = =NULL) {InitDataSource (); }        if(DataSource! =NULL) {Conn=datasource.getconnection (); }        returnConn; }}

Reading data from the configuration file get connection