Notes

package ohc.rev.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DBManager {

static Connection connection = null;

public static Connection doConnect(String dbName) {

try {

Class.forName("org.postgresql.Driver");

} catch (ClassNotFoundException e) {

System.out.println("Where is your PostgreSQL JDBC Driver? " + "Include in your library path!");
e.printStackTrace();
return null;

}

try {

connection = DriverManager.getConnection("jdbc:postgresql://10.184.240.220/"+dbName, "postgres", "");

} catch (SQLException e) {

System.out.println("Connection Failed! Check output console");
e.printStackTrace();
return null;

}
return connection;
}

public static ResultSet executePSQLFetch(String query) {

ResultSet res = null;
try {
Statement st = connection.createStatement();
res = st.executeQuery(query);

} catch (Exception e) {
e.printStackTrace();
}finally{
System.out.println(" Data fetch block executed");
}
return res;

}

public static int executePSQLUpdate(String query) {

int count = 0;
try {
Statement st = connection.createStatement();
count = st.executeUpdate(query);

} catch (Exception e) {
e.printStackTrace();
}finally{
System.out.println(count+" records Insert/Update query executed..");
}
return count;

}

public static void doDisconnect(){
try{
connection.close();
}catch(Exception e){
e.printStackTrace();
}finally{
System.out.println("Connection Closed.");
}

}
}