From 4bb3a9bdcc86953d3fba04a7be9abd8b3bfb6a15 Mon Sep 17 00:00:00 2001
From: chenjiahe <763432473@qq.com>
Date: 星期三, 07 八月 2024 17:31:04 +0800
Subject: [PATCH] 新增-查询分页优化
---
src/main/java/com/hx/mybatisTool/SqlSentence.java | 7 ++++---
1 files changed, 4 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/hx/mybatisTool/SqlSentence.java b/src/main/java/com/hx/mybatisTool/SqlSentence.java
index 0aa85e3..882a2a9 100644
--- a/src/main/java/com/hx/mybatisTool/SqlSentence.java
+++ b/src/main/java/com/hx/mybatisTool/SqlSentence.java
@@ -109,14 +109,15 @@
if(pageNum < 1){
pageNum = 1;
}
+ if(pageSize < 1){
+ pageSize = 1;
+ }
this.pageNum = pageNum;
this.pageSize = pageSize;
//绠楄捣鐐�
int pageStart = (pageNum-1)*pageSize;
- //绠楃粨鏉熺偣
- int pageEnd = pageNum*pageSize;
- sql = sql+" LIMIT "+pageStart+","+pageEnd;
+ sql = sql+" LIMIT "+pageStart+","+pageSize;
sqlSentence = sql;
m = values;
}
--
Gitblit v1.8.0