GreenDao的like模糊查询

mac2024-07-06  52

模糊查询like中value前后需要根据需要拼接%
like("%" + value+ "%")
QueryBuilder<People> queryBuilder = PeopleSession.queryBuilder(); //对输入参数非空判断进行where拼写 if (!TextUtils.isEmpty(cardId)) { queryBuilder.where(PeopleDao.Properties.CardId.like("%" + cardId + "%")); } if (!TextUtils.isEmpty(nameStr)) { queryBuilder.where(PeopleDao.Properties.Name.like("%" + nameStr + "%")); } if (!TextUtils.isEmpty(phoneStr)) { queryBuilder.where(PeopleDao.Properties.Phone.like("%" + phoneStr + "%")); } queryBuilder.orderAsc(PeopleDao.Properties.CardId, PeopleDao.Properties.Name).build(); //pageNum * Constants.PAGE_SIZE 页码 * 每页条数 return queryBuilder.offset(pageNum * Constants.PAGE_SIZE).limit(Constants.PAGE_SIZE).list();
最新回复(0)