public Page<AreaInfoVO> listForPage(int pageCurrent, int pageSize, AreaInfoQO qo) { AreaInfoExample example = new AreaInfoExample(); Criteria c = example.createCriteria(); example.setOrderByClause(" id desc "); Page<AreaInfo> page = dao.listForPage(pageCurrent, pageSize, example); return PageUtil.transform(page, AreaInfoVO.class); }
public Criteria or() { Criteria criteria = createCriteriaInternal(); oredCriteria.add(criteria); return criteria; }
@Override public AreaInfo getByProvinceCode(String provinceCode) { AreaInfoExample example = new AreaInfoExample(); example.createCriteria().andProvinceCodeEqualTo(provinceCode); List<AreaInfo> list = this.areaInfoMapper.selectByExample(example); if (list.isEmpty()) { return null; } return list.get(0); }
@Override public Page<AreaInfo> listForPage(int pageCurrent, int pageSize, AreaInfoExample example) { int count = this.areaInfoMapper.countByExample(example); pageSize = PageUtil.checkPageSize(pageSize); pageCurrent = PageUtil.checkPageCurrent(count, pageSize, pageCurrent); int totalPage = PageUtil.countTotalPage(count, pageSize); example.setLimitStart(PageUtil.countOffset(pageCurrent, pageSize)); example.setPageSize(pageSize); return new Page<AreaInfo>(count, totalPage, pageCurrent, pageSize, this.areaInfoMapper.selectByExample(example)); }
@Override public List<AreaInfo> listByAreaType(int areaType) { AreaInfoExample example = new AreaInfoExample(); example.createCriteria().andAreaTypeEqualTo(areaType); return this.areaInfoMapper.selectByExample(example); } }
@Override public AreaInfo getByProvinceAndCity(String provinceName, String cityName) { AreaInfoExample example = new AreaInfoExample(); example.createCriteria().andProvinceNameLike(PageUtil.likeRight(provinceName)).andCityNameLike(PageUtil.likeRight(cityName)); List<AreaInfo> list = this.areaInfoMapper.selectByExample(example); if (list.isEmpty()) { return null; } return list.get(0); }
public Criteria createCriteria() { Criteria criteria = createCriteriaInternal(); if (oredCriteria.size() == 0) { oredCriteria.add(criteria); } return criteria; }