Example #1
0
 public ISelecter where(String sql) {
   Rule r = new Rule();
   r.setColumn(sql);
   r.setOpStart("");
   r.setTag("");
   r.setOpEnd("");
   wheres.add(r);
   return this;
 }
Example #2
0
 public IExecuter whereSql(String sql, Object[] values) {
   Rule r = new Rule();
   r.setColumn(sql);
   r.setOpStart("");
   r.setTag("");
   r.setOpEnd("");
   wheres.add(r);
   for (Object v : values) {
     paramWheres.add(v);
   }
   return this;
 }
Example #3
0
 protected IExecuter whereNotIn(String column, Object... value) {
   Rule r = new Rule();
   r.setColumn(column);
   r.setOpStart(" not in (");
   r.setOpEnd(")");
   StringBuilder tag = new StringBuilder();
   List<Object> l = objectsToList(value);
   for (Object o : l) {
     tag.append(",?");
     paramWheres.add(o);
   }
   r.setTag(l.size() > 0 ? tag.toString().substring(1) : "");
   wheres.add(r);
   return this;
 }