| | |
| | | baseVo.setPageNum(1); |
| | | } |
| | | |
| | | if(baseVo.getPageSize() == null || baseVo.getPageSize() <= 0 || baseVo.getPageSize() >= 100) |
| | | if(baseVo.getPageSize() == null || baseVo.getPageSize() <= 0 || baseVo.getPageSize() > 100) |
| | | { |
| | | baseVo.setPageSize(20); |
| | | } |
| | |
| | | map.put("isDel", BaseEntity.NO); |
| | | |
| | | StringBuilder stringBuilder = new StringBuilder(); |
| | | stringBuilder.append("select createTime from query_record where isDel = #{m.isDel}"); |
| | | stringBuilder.append("select * from query_record where isDel = #{m.isDel}"); |
| | | |
| | | if(!StringUtils.isEmpty(baseVo.getKeyWord())) |
| | | { |
| | |
| | | } |
| | | |
| | | sqlSentence.setSqlSentence(stringBuilder.toString()); |
| | | PageHelper.startPage(1, 1, " createTime desc "); |
| | | PageHelper.startPage(baseVo.getPageNum(), baseVo.getPageSize(), " createTime desc "); |
| | | List<QueryRecord> list = queryRecordService.selectList(sqlSentence); |
| | | PageInfo<QueryRecord> pageInfo = new PageInfo<>(list); |
| | | |