Exemplo n.º 1
0
 private String generateSelectSQL(SisSettings sisSettings) {
   String activeField =
       isNotEmpty(sisSettings.activeFieldName()) ? ", " + sisSettings.activeFieldName() : "";
   String nameFields =
       isNotEmpty(sisSettings.getLastNameField())
           ? ", " + sisSettings.getFirstNameField() + ", " + sisSettings.getLastNameField() + " "
           : "";
   return "select "
       + sisSettings.studentIDFieldName()
       + ","
       + sisSettings.freeFieldName()
       + ", "
       + sisSettings.reducedFieldName()
       + activeField
       + nameFields
       + " from "
       + sisSettings.getStudentsTable();
 }
Exemplo n.º 2
0
 private String generateInsertSQL(SisSettings sisSettings) {
   return "insert into "
       + sisSettings.getStudentsTable()
       + " ("
       + sisSettings.studentIDFieldName()
       + ", "
       + sisSettings.freeFieldName()
       + ", "
       + sisSettings.reducedFieldName()
       + (isNotEmpty(sisSettings.activeFieldName()) ? "," + sisSettings.activeFieldName() : "")
       + (isNotEmpty(sisSettings.getFirstNameField()) ? "," + sisSettings.getFirstNameField() : "")
       + (isNotEmpty(sisSettings.getLastNameField()) ? "," + sisSettings.getLastNameField() : "")
       + ") values ( ?, ?, ?"
       + (isNotEmpty(sisSettings.activeFieldName()) ? ", ?" : "")
       + (isNotEmpty(sisSettings.getFirstNameField()) ? ", ?" : "")
       + (isNotEmpty(sisSettings.getLastNameField()) ? ", ?" : "")
       + ")";
 }