public static List<Dict> selectByFzddms(String... fzddm) {
QueryBuilder queryBuilder = APP.getDaoInstant().getDictDao().queryBuilder();
QueryBuilder.LOG_SQL = true;
QueryBuilder.LOG_VALUES = true;
List<WhereCondition> whereConditions = new ArrayList<>();
for (int i = 0; i < fzddm.length; i++) {
whereConditions.add(DictDao.Properties.Fzddm.eq(fzddm[i]));
}
WhereCondition[] conditionsArray = new WhereCondition[whereConditions.size()];
conditionsArray = whereConditions.toArray(conditionsArray);
//
QueryBuilder queryBuilder1 = whereOr(queryBuilder, conditionsArray);
return queryBuilder1.list();
}
/**
* 针对于或多条件查询
*
* @param queryBuilder
* @param whereConditions
* @return
*/
public static QueryBuilder whereOr(QueryBuilder queryBuilder, WhereCondition[] whereConditions) {
if (whereConditions == null) return queryBuilder.where(null);
else if (whereConditions.length == 1) return queryBuilder.where(whereConditions[0]);
else
return queryBuilder.whereOr(whereConditions[0], whereConditions[1], Arrays.copyOfRange(whereConditions, 2, whereConditions.length));
}
借鉴:GreenDao where或条件加入循环 - VoidCC