From 2e0ac4bee4366055254a12d932db8d5347e11ddb Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 26 九月 2022 17:13:46 +0800
Subject: [PATCH] 1
---
src/main/resources/mapper/data/StyleMapper.xml | 6 +-
src/main/java/com/lf/server/controller/data/StyleController.java | 17 ++++++++
src/main/java/com/lf/server/mapper/data/StyleMapper.java | 27 +++++++++++++
src/main/java/com/lf/server/service/data/StyleService.java | 19 +++++++++
4 files changed, 65 insertions(+), 4 deletions(-)
diff --git a/src/main/java/com/lf/server/controller/data/StyleController.java b/src/main/java/com/lf/server/controller/data/StyleController.java
index 25c5b5c..e8fec4d 100644
--- a/src/main/java/com/lf/server/controller/data/StyleController.java
+++ b/src/main/java/com/lf/server/controller/data/StyleController.java
@@ -1,5 +1,6 @@
package com.lf.server.controller.data;
+import com.lf.server.entity.data.DictEntity;
import com.lf.server.entity.data.StyleEntity;
import com.lf.server.service.data.StyleService;
import org.springframework.beans.factory.annotation.Autowired;
@@ -18,6 +19,20 @@
public class StyleController {
@Autowired
StyleService styleService;
+
+ @GetMapping({"/selectCount"})
+ public Integer selectCount(String name) {
+ return styleService.selectCount(name);
+ }
+
+ @GetMapping(value = "/selectByPage")
+ public List<StyleEntity> selectByPage(String name, Integer pageSize, Integer pageIndex) {
+ if (pageSize < 1 || pageIndex < 0) {
+ return null;
+ }
+
+ return styleService.selectByPage(name, pageSize, pageSize * pageIndex);
+ }
@RequestMapping(value = "/insertStyle", method = RequestMethod.POST, produces = "application/json; charset=UTF-8")
public Integer insertStyle(StyleEntity styleEntity) {
@@ -62,4 +77,4 @@
public List<StyleEntity> selectStyleAll() {
return styleService.selectStyleAll();
}
-}
+}
\ No newline at end of file
diff --git a/src/main/java/com/lf/server/mapper/data/StyleMapper.java b/src/main/java/com/lf/server/mapper/data/StyleMapper.java
index 395ef2b..5da6d30 100644
--- a/src/main/java/com/lf/server/mapper/data/StyleMapper.java
+++ b/src/main/java/com/lf/server/mapper/data/StyleMapper.java
@@ -1,5 +1,6 @@
package com.lf.server.mapper.data;
+import com.lf.server.entity.data.DictEntity;
import com.lf.server.entity.data.StyleEntity;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.web.bind.annotation.ResponseBody;
@@ -15,7 +16,26 @@
@ResponseBody
public interface StyleMapper {
/**
+ * 鏍规嵁琛ㄥ悕鏌ヨ璁板綍鏁�
+ *
+ * @param name 鏍峰紡鍚�
+ * @return 璁板綍鏁�
+ */
+ public Integer selectCount(String name);
+
+ /**
+ * 鏍规嵁琛ㄥ悕鍒嗛〉鏌ヨ
+ *
+ * @param name 鏍峰紡鍚�
+ * @param limit 璁板綍琛�
+ * @param offset 鍋忕Щ閲�
+ * @return 鍒楄〃
+ */
+ public List<StyleEntity> selectByPage(String name, Integer limit, Integer offset);
+
+ /**
* 娣诲姞鏁版嵁
+ *
* @param styleEntity
* @return
*/
@@ -23,12 +43,15 @@
/**
* 鎵归噺娣诲姞
+ *
* @param styleEntity
* @return
*/
public Integer insertStyles(List<StyleEntity> styleEntity);
+
/**
* 鍒櫎鏁版嵁
+ *
* @param id
* @return
*/
@@ -36,6 +59,7 @@
/**
* 鎵归噺鍒犻櫎
+ *
* @param ids
* @return
*/
@@ -43,6 +67,7 @@
/**
* 淇敼鏁版嵁
+ *
* @param styleEntity
* @return
*/
@@ -50,6 +75,7 @@
/**
* 鏌ヨ鍗曟潯鏁版嵁
+ *
* @param id
* @return
*/
@@ -57,6 +83,7 @@
/**
* 鏌ヨ鍏ㄩ儴鏁版嵁
+ *
* @return
*/
public List<StyleEntity> selectStyleAll();
diff --git a/src/main/java/com/lf/server/service/data/StyleService.java b/src/main/java/com/lf/server/service/data/StyleService.java
index 7cec962..090c0f0 100644
--- a/src/main/java/com/lf/server/service/data/StyleService.java
+++ b/src/main/java/com/lf/server/service/data/StyleService.java
@@ -1,5 +1,6 @@
package com.lf.server.service.data;
+import com.lf.server.entity.data.DictEntity;
import com.lf.server.entity.data.StyleEntity;
import com.lf.server.mapper.data.StyleMapper;
import org.springframework.beans.factory.annotation.Autowired;
@@ -19,6 +20,24 @@
StyleMapper styleMapper;
@Override
+ public Integer selectCount(String name) {
+ if (name != null && name.length() > 0) {
+ name = "%" + name + "%";
+ }
+
+ return styleMapper.selectCount(name);
+ }
+
+ @Override
+ public List<StyleEntity> selectByPage(String name, Integer limit, Integer offset) {
+ if (name != null && name.length() > 0) {
+ name = "%" + name + "%";
+ }
+
+ return styleMapper.selectByPage(name, limit, offset);
+ }
+
+ @Override
public Integer insertStyle(StyleEntity styleEntity) {
return styleMapper.insertStyle(styleEntity);
}
diff --git a/src/main/resources/mapper/data/StyleMapper.xml b/src/main/resources/mapper/data/StyleMapper.xml
index 753677a..3102f80 100644
--- a/src/main/resources/mapper/data/StyleMapper.xml
+++ b/src/main/resources/mapper/data/StyleMapper.xml
@@ -16,7 +16,7 @@
select count(*) from lf.sys_style
<where>
<if test="name != null">
- tab like #{tab}
+ name like #{name}
</if>
</where>
</select>
@@ -26,10 +26,10 @@
select * from lf.sys_style
<where>
<if test="name != null">
- tab like #{tab}
+ name like #{name}
</if>
</where>
- order by ns,tab,order_num
+ order by id
limit #{limit} offset #{offset}
</select>
--
Gitblit v1.9.3