コード例 #1
0
  public JwSqlInsert _checkAndComposeInsert(JwList<AcDomesticCandidateRouteTmp> v) {
    for (AcDomesticCandidateRouteTmp e : v) {
      defaultUpdateCount(e);
      e.validate();
      verifyNoMatching(e);
    }

    JwSqlInsert st = createInsert();
    st.setTable(TABLE);
    populateInsertColumns(st);

    for (AcDomesticCandidateRouteTmp e : v) {
      st.startNewRow();
      st.addStringValue(e.getLogin());
      st.addTimestampValue(e.getCreatedUtcTs());
      st.addDateValue(e.getBlockBeginUtcDt());
      st.addDateValue(e.getBlockEndUtcDt());
      st.addDateValue(e.getRouteBeginUtcDt());
      st.addDateValue(e.getRouteEndUtcDt());
      st.addIntegerValue(e.hasError() ? e.getError().getCode() : null);
    }
    return st;
  }
コード例 #2
0
 public void update(AcDomesticCandidateRouteTmp e) {
   e.validate();
   JwSqlUpdate st = composeUpdate(e);
   int i = execute(st);
   if (i != 1) error("Unable to update AcDomesticCandidateRouteTmp.  Rows updated: %s.", i);
 }