From 7201205af85508421037119ba66b3a6a48de61ec Mon Sep 17 00:00:00 2001 From: guang <guang@guang.com> Date: 星期六, 06 五月 2023 11:58:57 +0800 Subject: [PATCH] 分布及druid --- src/main/java/com/hx/other/service/controller/admin/AdminQueryRecordController.java | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) diff --git a/src/main/java/com/hx/other/service/controller/admin/AdminQueryRecordController.java b/src/main/java/com/hx/other/service/controller/admin/AdminQueryRecordController.java index 90b71e6..30a46fd 100644 --- a/src/main/java/com/hx/other/service/controller/admin/AdminQueryRecordController.java +++ b/src/main/java/com/hx/other/service/controller/admin/AdminQueryRecordController.java @@ -50,7 +50,7 @@ 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); } @@ -61,7 +61,7 @@ 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())) { @@ -76,7 +76,7 @@ } 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); -- Gitblit v1.8.0