public void getNewNotification(Properties prop, List<JSONObject> newNotification)
throws SQLException, JSONException {
Statement st = null;
ResultSet rs = null;
DBCon.getInstance().setProperties(prop);
Connection connection = null;
try {
connection = DBCon.getInstance().getConnection();
String querry = "CALL getNewNotification();";
st = connection.createStatement();
rs = st.executeQuery(querry);
log.debug("==NewNotificationChecker :" + querry.toString());
parseResultSet(prop, rs, newNotification);
} catch (Exception ex) {
System.out.println("Exception Occured==" + ex);
log.debug("Exception occured ==", ex);
} finally {
rs.close();
st.close();
connection.close();
}
}
private void invalidate_record(String notiID, Properties prop) throws SQLException {
Statement st = null;
DBCon.getInstance().setProperties(prop);
Connection connection = null;
try {
connection = DBCon.getInstance().getConnection();
String querry = "call invalidateRecord(" + notiID + ")";
st = connection.createStatement();
st.executeUpdate(querry);
log.debug("Invalidate Record :" + querry.toString());
} catch (Exception ex) {
System.out.println("Exception Occured==" + ex);
log.debug("Exception occured ==", ex);
} finally {
st.close();
connection.close();
}
}
@Override
protected void finalize() throws Throwable {
// TODO Auto-generated method stub
super.finalize();
DBCon.closeAllMethod(connection, preparedStatement, rs);
}
public Health_UserTable_Ctr() {
// TODO Auto-generated constructor stub
connection = DBCon.getCon();
}