话不多说,直接上代码:
public <T> List<T> getQueryByWhereBetween(Class<T> cla, String field,
String[] novalue) {
QueryBuilder<T> qb = new QueryBuilder<T>(cla);
qb.whereGreaterThan(field, novalue[0]);
qb.whereAppendAnd();
qb.whereLessThan(field, novalue[1]);
qb.whereAppendOr();
qb.whereEquals(field, novalue[0]);
qb.whereAppendOr();
qb.whereEquals(field, novalue[1]);
return liteOrm.<T> query(qb);
}
调到
DatabaseManager.getInstance().getQueryByWhereBetween(class,field,new String[]{"2019-12-01","2019-12-04"});
注意:数据库中的字段也必须是2019-01-01的格式。 若为2019-1-1是查不到数据的。