public long count(AdminAccountQuery query) { AdminAccountExample example = new AdminAccountExample(); Criteria criteria = example.createCriteria(); criteria.andStatEqualTo(DataStatus.ENABLED); if (StringUtils.isNotEmpty(query.getAccountCode())) { criteria.andUserNameEqualTo(query.getAccountCode()); } if (StringUtils.isNotEmpty(query.getRoleId())) { criteria.andRoleIdEqualTo(query.getRoleId()); } return mapper.countByExample(example); }
public List<AdminAccount> find(AdminAccountQuery query, PageQuery page) { AdminAccountExample example = new AdminAccountExample(); Criteria criteria = example.createCriteria(); criteria.andStatEqualTo(DataStatus.ENABLED); if (StringUtils.isNotEmpty(query.getAccountCode())) { criteria.andUserNameEqualTo(query.getAccountCode()); } if (StringUtils.isNotEmpty(query.getRoleId())) { criteria.andRoleIdEqualTo(query.getRoleId()); } example.setOrderByClause( " create_time asc limit " + page.getStartNum() + ", " + page.getPageSize()); return mapper.selectByExample(example); }