コード例 #1
0
  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();
    }
  }
コード例 #2
0
  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();
    }
  }