Answers for "db utility in java"

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);

    }