Exemple #1
0
 public QuerySet whereNotIn(String column, String value, String type) throws SQLException {
   hasRan();
   if (whereSet == null) {
     whereSet = "\nWHERE ";
   } else {
     whereSet += "\n" + type + " ";
   }
   checkSqlInValue(value);
   whereSet += column + " " + LogicOperands.NOT_IN + " (" + value + ")";
   return this;
 }
Exemple #2
0
 private String renderArrayListWithIds(ArrayList<String> values) throws SQLException {
   hasRan();
   String result = "";
   StringBuilder sb = new StringBuilder();
   for (String value : values) {
     sb.append(value).append(",");
   }
   if (sb.length() > 0) {
     sb.setLength(sb.length() - 1);
   }
   result = sb.toString();
   // Additional check to verify that String in list are integers throws exception if not
   checkSqlInValue(result);
   return result;
 }