예제 #1
0
 public void populateSelectColumnsToCompose(JwSqlSelect st, String alias) {
   st.selectInteger(alias, ID);
   st.selectTimestamp(alias, MODIFIED_UTC_TS);
   st.selectString(alias, USER);
   st.selectInteger(alias, TYPE);
   st.selectString(alias, TYPE_NAME);
   st.selectString(alias, SUBJECT_1);
   st.selectString(alias, SUBJECT_2);
   st.selectString(alias, SUBJECT_3);
   st.selectString(alias, OLD_VALUE);
   st.selectString(alias, NEW_VALUE);
 }
 public void populateSelectColumnsToCompose(JwSqlSelect st, String alias) {
   st.selectInteger(alias, ID);
   st.selectString(alias, PATH);
   st.selectString(alias, FILE_NAME);
   st.selectString(alias, DESCRIPTION);
   st.selectTimestamp(alias, CREATED_UTC_TS);
 }
 public void populateSelectColumnsToCompose(JwSqlSelect st, String alias) {
   st.selectString(alias, LOGIN);
   st.selectTimestamp(alias, CREATED_UTC_TS);
   st.selectDate(alias, BLOCK_BEGIN_UTC_DT);
   st.selectDate(alias, BLOCK_END_UTC_DT);
   st.selectDate(alias, ROUTE_BEGIN_UTC_DT);
   st.selectDate(alias, ROUTE_END_UTC_DT);
   st.selectInteger(alias, ERROR);
 }
 public void populateSelectColumnsToCompose(JwSqlSelect st, String alias) {
   st.selectInteger(alias, ID);
   st.selectString(alias, OPERATOR_CARRIER_CODE);
   st.selectString(alias, OPERATOR_NUMBER);
   st.selectString(alias, RELATIONSHIP);
   st.selectString(alias, ORIGIN_AIRPORT_CODE);
   st.selectString(alias, DESTINATION_AIRPORT_CODE);
   st.selectTime(alias, DEPARTURE_LOCAL_TM);
   st.selectTime(alias, ARRIVAL_LOCAL_TM);
   st.selectInteger(alias, DAY_OFFSET);
   st.selectDate(alias, BOUNDING_START_LOCAL_DT);
   st.selectDate(alias, BOUNDING_END_LOCAL_DT);
   st.selectDayFrequency(alias, FREQUENCY);
   st.selectString(alias, EQUIPMENT_CODE);
   st.selectString(alias, SOURCE);
   st.selectString(alias, ABSOLUTE_SOURCE);
   st.selectBoolean(alias, CANCEL);
   st.selectTimestamp(alias, CREATED_UTC_TS);
   st.selectInteger(alias, SEQUENCE);
 }
 public JwList<Integer> getAllIds() {
   JwSqlSelect st = createSelect();
   st.selectInteger(ALIAS, ID);
   st.from(TABLE, ALIAS);
   return composeIntegerList(st);
 }