import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class dataBaseConnManager {
static Connection conn = null;
static Statement stmt = null;
constant cnst = new constant();
public dataBaseConnManager() {
try {
if(conn==null || stmt == null || stmt.isClosed() == true)
{
conn = null;
stmt = null;
constant cnst = new constant();
// JDBC driver name and database URL
final String JDBC_DRIVER = “com.mysql.jdbc.Driver”; //FOR MYSQL
//final String JDBC_DRIVER = “oracle.jdbc.driver.OracleDriver”; //FOR ORACLE
final String DB_URL = “jdbc:mysql://localhost/”+cnst.dataBaseName; //FOR MYSQL
//final String DB_URL = “jdbc:oracle:thin:@129.146.79.106:1521:orcl”; //FOR ORACLE
final String USER = cnst.dataBaseUserName;
final String PASS = cnst.dataBasePassword;
try{
//STEP 2: Register JDBC driver
Class.forName(“com.mysql.jdbc.Driver”); //FOR MYSQL
//Class.forName(“oracle.jdbc.driver.OracleDriver”); //FOR ORACLE
//STEP 3: Open a connection
conn = DriverManager.getConnection(DB_URL,USER,PASS);
//STEP 4: Execute a query
stmt = conn.createStatement();
}catch(SQLException se){
se.printStackTrace();
}catch(Exception e){
e.printStackTrace();
}
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}