db utility in java
public class DB_Utility {
// adding static field so we can access in all static methods
private static Connection conn;
private static Statement stmnt;
private static ResultSet rs ;
/*
* a static method to create connection
* with valid url and username password
* */
public static void createConnection() {
String connectionStr = ConfigurationReader.getProperty("database.url");
String username = ConfigurationReader.getProperty("database.username");
String password = ConfigurationReader.getProperty("database.password");
try {
conn = DriverManager.getConnection(connectionStr, username, password);
System.out.println("CONNECTION SUCCESSFUL");
} catch (SQLException e) {
System.out.println("CONNECTION HAS FAILED!");
e.printStackTrace();
}
// createConnection(connectionStr,username,password);
}