From 2a1ed8816d8ce5d1fe093e15a4e7ee7e7219570a Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期四, 24 十一月 2022 14:06:03 +0800
Subject: [PATCH] 1
---
src/main/resources/mapper/sys/OperateMapper.xml | 2
src/main/resources/mapper/data/DownloadMapper.xml | 4
src/main/resources/mapper/data/StyleMapper.xml | 2
src/main/resources/mapper/sys/ResMapper.xml | 4
src/main/resources/mapper/sys/RoleMenuAuthMapper.xml | 4
src/main/resources/mapper/show/MarkMapper.xml | 2
src/main/resources/mapper/sys/ResOpMapper.xml | 2
src/main/resources/mapper/sys/RoleMapper.xml | 2
src/main/resources/mapper/sys/ArgsMapper.xml | 2
src/main/resources/mapper/sys/UserMapper.xml | 4
src/main/resources/mapper/sys/AuthMapper.xml | 4
src/main/java/com/lf/server/mapper/data/MetaMapper.java | 8 +-
src/main/java/com/lf/server/controller/data/MetaController.java | 45 +-------------
src/main/java/com/lf/server/service/data/MetaService.java | 8 +-
src/main/resources/mapper/data/DictMapper.xml | 2
src/main/resources/mapper/sys/BlacklistMapper.xml | 2
src/main/resources/mapper/data/MetaMapper.xml | 14 +++-
src/main/resources/mapper/sys/TokenMapper.xml | 2
src/main/resources/mapper/sys/MenuAuthMapper.xml | 4
src/main/resources/mapper/sys/RoleUserMapper.xml | 2
src/main/resources/mapper/sys/AttachMapper.xml | 2
src/main/resources/mapper/data/MetaFileMapper.xml | 2
src/main/resources/mapper/data/VerMapper.xml | 3
src/main/resources/mapper/sys/LoginMapper.xml | 2
src/main/resources/mapper/sys/RoleResMapper.xml | 2
25 files changed, 51 insertions(+), 79 deletions(-)
diff --git a/src/main/java/com/lf/server/controller/data/MetaController.java b/src/main/java/com/lf/server/controller/data/MetaController.java
index a693ada..1076f54 100644
--- a/src/main/java/com/lf/server/controller/data/MetaController.java
+++ b/src/main/java/com/lf/server/controller/data/MetaController.java
@@ -39,63 +39,26 @@
DownloadService downloadService;
@SysLog()
- @ApiOperation(value = "鏌ヨ璁板綍鏁�")
- @ApiImplicitParams({
- @ApiImplicitParam(name = "name", value = "鍚嶇О", dataType = "String", paramType = "query", required = false, example = "")
- })
- @GetMapping({"/selectCount"})
- public ResponseMsg<Integer> selectCount(String name) {
- try {
- int count = metaService.selectCount(name);
-
- return success(count);
- } catch (Exception ex) {
- return fail(ex.getMessage(), -1);
- }
- }
-
- @SysLog()
- @ApiOperation(value = "鍒嗛〉鏌ヨ")
- @ApiImplicitParams({
- @ApiImplicitParam(name = "name", value = "鍚嶇О", dataType = "String", paramType = "query", example = ""),
- @ApiImplicitParam(name = "pageSize", value = "姣忛〉鏉℃暟", dataType = "Integer", paramType = "query", example = "10"),
- @ApiImplicitParam(name = "pageIndex", value = "鍒嗛〉鏁帮紙浠�1寮�濮嬶級", dataType = "Integer", paramType = "query", example = "1")
- })
- @GetMapping(value = "/selectByPage")
- public ResponseMsg<List<MetaEntity>> selectByPage(String name, Integer pageSize, Integer pageIndex) {
- try {
- if (pageSize < 1 || pageIndex < 1) {
- return fail("姣忛〉椤垫暟鎴栧垎椤垫暟灏忎簬1", null);
- }
-
- List<MetaEntity> rs = metaService.selectByPage(name, pageSize, pageSize * (pageIndex - 1));
-
- return success(rs);
- } catch (Exception ex) {
- return fail(ex.getMessage(), null);
- }
- }
-
- @SysLog()
@ApiOperation(value = "鍒嗛〉鏌ヨ骞惰繑鍥炶褰曟暟")
@ApiImplicitParams({
+ @ApiImplicitParam(name = "dirid", value = "鐩綍ID", dataType = "Integer", paramType = "query", example = "10"),
@ApiImplicitParam(name = "name", value = "鍚嶇О", dataType = "String", paramType = "query", example = ""),
@ApiImplicitParam(name = "pageSize", value = "姣忛〉鏉℃暟", dataType = "Integer", paramType = "query", example = "10"),
@ApiImplicitParam(name = "pageIndex", value = "鍒嗛〉鏁帮紙浠�1寮�濮嬶級", dataType = "Integer", paramType = "query", example = "1")
})
@GetMapping(value = "/selectByPageAndCount")
- public ResponseMsg<List<MetaEntity>> selectByPageAndCount(String name, Integer pageSize, Integer pageIndex) {
+ public ResponseMsg<List<MetaEntity>> selectByPageAndCount(Integer dirid, String name, Integer pageSize, Integer pageIndex) {
try {
if (pageSize < 1 || pageIndex < 1) {
return fail("姣忛〉椤垫暟鎴栧垎椤垫暟灏忎簬1", null);
}
- int count = metaService.selectCount(name);
+ int count = metaService.selectCount(dirid, name);
if (count == 0) {
return success(0, null);
}
- List<MetaEntity> rs = metaService.selectByPage(name, pageSize, pageSize * (pageIndex - 1));
+ List<MetaEntity> rs = metaService.selectByPage(dirid, name, pageSize, pageSize * (pageIndex - 1));
return success(count, rs);
} catch (Exception ex) {
diff --git a/src/main/java/com/lf/server/mapper/data/MetaMapper.java b/src/main/java/com/lf/server/mapper/data/MetaMapper.java
index fb6ee76..1277de2 100644
--- a/src/main/java/com/lf/server/mapper/data/MetaMapper.java
+++ b/src/main/java/com/lf/server/mapper/data/MetaMapper.java
@@ -16,20 +16,22 @@
/**
* 鏌ヨ璁板綍鏁�
*
- * @param name 鍚嶇О
+ * @param dirid 鐩綍ID
+ * @param name 鍚嶇О
* @return 璁板綍鏁�
*/
- public Integer selectCount(String name);
+ public Integer selectCount(Integer dirid, String name);
/**
* 鍒嗛〉鏌ヨ
*
+ * @param dirid 鐩綍ID
* @param name 鍚嶇О
* @param limit 璁板綍琛�
* @param offset 鍋忕Щ閲�
* @return 鍒楄〃
*/
- public List<MetaEntity> selectByPage(String name, Integer limit, Integer offset);
+ public List<MetaEntity> selectByPage(Integer dirid, String name, Integer limit, Integer offset);
/**
* 鏌ヨ涓婁紶璁板綍鏁�
diff --git a/src/main/java/com/lf/server/service/data/MetaService.java b/src/main/java/com/lf/server/service/data/MetaService.java
index 2efc911..f5b193c 100644
--- a/src/main/java/com/lf/server/service/data/MetaService.java
+++ b/src/main/java/com/lf/server/service/data/MetaService.java
@@ -18,17 +18,17 @@
MetaMapper metaMapper;
@Override
- public Integer selectCount(String name) {
+ public Integer selectCount(Integer dirid, String name) {
name = StringHelper.getLikeStr(name);
- return metaMapper.selectCount(name);
+ return metaMapper.selectCount(dirid, name);
}
@Override
- public List<MetaEntity> selectByPage(String name, Integer limit, Integer offset) {
+ public List<MetaEntity> selectByPage(Integer dirid, String name, Integer limit, Integer offset) {
name = StringHelper.getLikeStr(name);
- return metaMapper.selectByPage(name, limit, offset);
+ return metaMapper.selectByPage(dirid, name, limit, offset);
}
@Override
diff --git a/src/main/resources/mapper/data/DictMapper.xml b/src/main/resources/mapper/data/DictMapper.xml
index f5bddf2..8d070c3 100644
--- a/src/main/resources/mapper/data/DictMapper.xml
+++ b/src/main/resources/mapper/data/DictMapper.xml
@@ -1,7 +1,7 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lf.server.mapper.data.DictMapper">
- <select id="selectCount" resultType="java.lang.Integer" parameterType="java.lang.String">
+ <select id="selectCount" resultType="java.lang.Integer">
select count(*) from lf.sys_dict
<where>
ns = #{ns}
diff --git a/src/main/resources/mapper/data/DownloadMapper.xml b/src/main/resources/mapper/data/DownloadMapper.xml
index 64bf7c7..e9c3b4f 100644
--- a/src/main/resources/mapper/data/DownloadMapper.xml
+++ b/src/main/resources/mapper/data/DownloadMapper.xml
@@ -1,7 +1,7 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lf.server.mapper.data.DownloadMapper">
- <select id="selectCount" resultType="java.lang.Integer" parameterType="java.lang.String">
+ <select id="selectCount" resultType="java.lang.Integer">
select count(*) from lf.sys_download
<where>
<if test="name != null">
@@ -21,7 +21,7 @@
limit #{limit} offset #{offset}
</select>
- <select id="selectCountForExport" resultType="java.lang.Integer" parameterType="java.lang.String">
+ <select id="selectCountForExport" resultType="java.lang.Integer">
select count(*) from lf.sys_download
<where>
create_user = #{createUser} and type = 2
diff --git a/src/main/resources/mapper/data/MetaFileMapper.xml b/src/main/resources/mapper/data/MetaFileMapper.xml
index 7ac8a7b..a00647d 100644
--- a/src/main/resources/mapper/data/MetaFileMapper.xml
+++ b/src/main/resources/mapper/data/MetaFileMapper.xml
@@ -1,7 +1,7 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lf.server.mapper.data.MetaFileMapper">
- <select id="selectCount" resultType="java.lang.Integer" parameterType="java.lang.String">
+ <select id="selectCount" resultType="java.lang.Integer">
select count(*) from lf.sys_meta_file
<where>
<if test="name != null">
diff --git a/src/main/resources/mapper/data/MetaMapper.xml b/src/main/resources/mapper/data/MetaMapper.xml
index a03104c..aeb5af2 100644
--- a/src/main/resources/mapper/data/MetaMapper.xml
+++ b/src/main/resources/mapper/data/MetaMapper.xml
@@ -1,11 +1,15 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lf.server.mapper.data.MetaMapper">
- <select id="selectCount" resultType="java.lang.Integer" parameterType="java.lang.String">
+ <select id="selectCount" resultType="java.lang.Integer">
select count(*) from lf.sys_meta
<where>
+ 1 = 1
+ <if test="dirid != null">
+ and dirid = #{dirid}
+ </if>
<if test="name != null">
- name like #{name}
+ and name like #{name}
</if>
</where>
</select>
@@ -14,8 +18,12 @@
select a.*,fn_uname(a.create_user) uname,fn_rec_query(a.depid, 'dep') depName,fn_ver(a.verid) verName,fn_rec_query(a.dirid, 'dir') dirName
from lf.sys_meta a
<where>
+ 1 = 1
+ <if test="dirid != null">
+ and dirid = #{dirid}
+ </if>
<if test="name != null">
- name like #{name}
+ and name like #{name}
</if>
</where>
order by id
diff --git a/src/main/resources/mapper/data/StyleMapper.xml b/src/main/resources/mapper/data/StyleMapper.xml
index c2f7f36..85dcf79 100644
--- a/src/main/resources/mapper/data/StyleMapper.xml
+++ b/src/main/resources/mapper/data/StyleMapper.xml
@@ -1,7 +1,7 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lf.server.mapper.data.StyleMapper">
- <select id="selectCount" resultType="java.lang.Integer" parameterType="java.lang.String">
+ <select id="selectCount" resultType="java.lang.Integer">
select count(*) from lf.sys_style
<where>
<if test="name != null">
diff --git a/src/main/resources/mapper/data/VerMapper.xml b/src/main/resources/mapper/data/VerMapper.xml
index 94f2eef..05ba067 100644
--- a/src/main/resources/mapper/data/VerMapper.xml
+++ b/src/main/resources/mapper/data/VerMapper.xml
@@ -1,9 +1,8 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lf.server.mapper.data.VerMapper">
-
<!-- 缁熻琛屾暟 -->
- <select id="selectCount" resultType="java.lang.Integer" parameterType="java.lang.String">
+ <select id="selectCount" resultType="java.lang.Integer">
select count(*) from lf.sys_ver a inner join lf.sys_dir b
on a.dirid = b.id
<where>
diff --git a/src/main/resources/mapper/show/MarkMapper.xml b/src/main/resources/mapper/show/MarkMapper.xml
index 3931395..a0bee5e 100644
--- a/src/main/resources/mapper/show/MarkMapper.xml
+++ b/src/main/resources/mapper/show/MarkMapper.xml
@@ -1,7 +1,7 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lf.server.mapper.show.MarkMapper">
- <select id="selectCount" resultType="java.lang.Integer" parameterType="java.lang.String">
+ <select id="selectCount" resultType="java.lang.Integer">
select count(*) from lf.sys_mark
<where>
<if test="userid != null">
diff --git a/src/main/resources/mapper/sys/ArgsMapper.xml b/src/main/resources/mapper/sys/ArgsMapper.xml
index 5da9b80..3fda786 100644
--- a/src/main/resources/mapper/sys/ArgsMapper.xml
+++ b/src/main/resources/mapper/sys/ArgsMapper.xml
@@ -1,7 +1,7 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lf.server.mapper.sys.ArgsMapper">
- <select id="selectCount" resultType="java.lang.Integer" parameterType="java.lang.String">
+ <select id="selectCount" resultType="java.lang.Integer">
select count(*) from lf.sys_args
<where>
<if test="name != null">
diff --git a/src/main/resources/mapper/sys/AttachMapper.xml b/src/main/resources/mapper/sys/AttachMapper.xml
index 0c79010..1dd6348 100644
--- a/src/main/resources/mapper/sys/AttachMapper.xml
+++ b/src/main/resources/mapper/sys/AttachMapper.xml
@@ -1,7 +1,7 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lf.server.mapper.sys.AttachMapper">
- <select id="selectCount" resultType="java.lang.Integer" parameterType="java.lang.String">
+ <select id="selectCount" resultType="java.lang.Integer">
select count(*) from lf.sys_attach
<where>
<if test="name != null">
diff --git a/src/main/resources/mapper/sys/AuthMapper.xml b/src/main/resources/mapper/sys/AuthMapper.xml
index cea865a..149b024 100644
--- a/src/main/resources/mapper/sys/AuthMapper.xml
+++ b/src/main/resources/mapper/sys/AuthMapper.xml
@@ -1,7 +1,7 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lf.server.mapper.sys.AuthMapper">
- <select id="selectCount" resultType="java.lang.Integer" parameterType="java.lang.String">
+ <select id="selectCount" resultType="java.lang.Integer">
select count(*) from lf.sys_auth
<where>
<if test="name != null">
@@ -21,7 +21,7 @@
limit #{limit} offset #{offset}
</select>
- <select id="selectCountForMenu" resultType="java.lang.Integer" parameterType="java.lang.String">
+ <select id="selectCountForMenu" resultType="java.lang.Integer">
select count(a.*) from lf.sys_auth a where not exists (select b.id from lf.sys_menu_auth b
<where>
b.authid = a.id
diff --git a/src/main/resources/mapper/sys/BlacklistMapper.xml b/src/main/resources/mapper/sys/BlacklistMapper.xml
index 83dac15..fe7b62a 100644
--- a/src/main/resources/mapper/sys/BlacklistMapper.xml
+++ b/src/main/resources/mapper/sys/BlacklistMapper.xml
@@ -1,7 +1,7 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lf.server.mapper.sys.BlacklistMapper">
- <select id="selectCount" resultType="java.lang.Integer" parameterType="java.lang.String">
+ <select id="selectCount" resultType="java.lang.Integer">
select count(*) from lf.sys_blacklist
<where>
1 = 1
diff --git a/src/main/resources/mapper/sys/LoginMapper.xml b/src/main/resources/mapper/sys/LoginMapper.xml
index c13c328..5b0b67b 100644
--- a/src/main/resources/mapper/sys/LoginMapper.xml
+++ b/src/main/resources/mapper/sys/LoginMapper.xml
@@ -1,7 +1,7 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lf.server.mapper.sys.LoginMapper">
- <select id="selectCount" resultType="java.lang.Integer" parameterType="java.lang.String">
+ <select id="selectCount" resultType="java.lang.Integer">
select count(*) from lf.sys_login a inner join lf.sys_user b on a.userid = b.id
<where>
1 = 1
diff --git a/src/main/resources/mapper/sys/MenuAuthMapper.xml b/src/main/resources/mapper/sys/MenuAuthMapper.xml
index 83cbfd0..f08a442 100644
--- a/src/main/resources/mapper/sys/MenuAuthMapper.xml
+++ b/src/main/resources/mapper/sys/MenuAuthMapper.xml
@@ -1,7 +1,7 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lf.server.mapper.sys.MenuAuthMapper">
- <select id="selectCount" resultType="java.lang.Integer" parameterType="java.lang.String">
+ <select id="selectCount" resultType="java.lang.Integer">
select count(*) from lf.sys_menu_auth
<where>
<if test="menuid != null">
@@ -22,7 +22,7 @@
limit #{limit} offset #{offset}
</select>
- <select id="selectCountForRole" resultType="java.lang.Integer" parameterType="java.lang.String">
+ <select id="selectCountForRole" resultType="java.lang.Integer">
select count(a.id) from lf.sys_menu_auth a inner join lf.sys_auth c on a.authid = c.id
where not exists (select b.id from lf.sys_role_menu_auth b where b.menu_auth_id = a.id
<if test="roleid != null">
diff --git a/src/main/resources/mapper/sys/OperateMapper.xml b/src/main/resources/mapper/sys/OperateMapper.xml
index 01866f3..b321c41 100644
--- a/src/main/resources/mapper/sys/OperateMapper.xml
+++ b/src/main/resources/mapper/sys/OperateMapper.xml
@@ -1,7 +1,7 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lf.server.mapper.sys.OperateMapper">
- <select id="selectCount" resultType="java.lang.Integer" parameterType="java.lang.String">
+ <select id="selectCount" resultType="java.lang.Integer">
select count(*) from lf.sys_operate a inner join lf.sys_user b on a.userid = b.id
<where>
1 = 1
diff --git a/src/main/resources/mapper/sys/ResMapper.xml b/src/main/resources/mapper/sys/ResMapper.xml
index 1da40e5..f09e52b 100644
--- a/src/main/resources/mapper/sys/ResMapper.xml
+++ b/src/main/resources/mapper/sys/ResMapper.xml
@@ -1,7 +1,7 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lf.server.mapper.sys.ResMapper">
- <select id="selectCount" resultType="java.lang.Integer" parameterType="java.lang.String">
+ <select id="selectCount" resultType="java.lang.Integer">
select count(*) from lf.sys_res
<where>
<if test="name != null">
@@ -21,7 +21,7 @@
limit #{limit} offset #{offset}
</select>
- <select id="selectCountForRole" resultType="java.lang.Integer" parameterType="java.lang.String">
+ <select id="selectCountForRole" resultType="java.lang.Integer">
select count(a.*) from lf.sys_res a where not exists (select b.id from lf.sys_role_res b
<where>
b.resid = a.id
diff --git a/src/main/resources/mapper/sys/ResOpMapper.xml b/src/main/resources/mapper/sys/ResOpMapper.xml
index e2398e0..4c6a950 100644
--- a/src/main/resources/mapper/sys/ResOpMapper.xml
+++ b/src/main/resources/mapper/sys/ResOpMapper.xml
@@ -1,7 +1,7 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lf.server.mapper.sys.ResOpMapper">
- <select id="selectCount" resultType="java.lang.Integer" parameterType="java.lang.String">
+ <select id="selectCount" resultType="java.lang.Integer">
select count(*) from lf.sys_res_op a inner join lf.sys_user b on a.userid = b.id inner join lf.sys_res c on a.resid=c.id
<where>
1 = 1
diff --git a/src/main/resources/mapper/sys/RoleMapper.xml b/src/main/resources/mapper/sys/RoleMapper.xml
index 344c55e..b7660a3 100644
--- a/src/main/resources/mapper/sys/RoleMapper.xml
+++ b/src/main/resources/mapper/sys/RoleMapper.xml
@@ -1,7 +1,7 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lf.server.mapper.sys.RoleMapper">
- <select id="selectCount" resultType="java.lang.Integer" parameterType="java.lang.String">
+ <select id="selectCount" resultType="java.lang.Integer">
select count(*) from lf.sys_role a
<where>
1=1
diff --git a/src/main/resources/mapper/sys/RoleMenuAuthMapper.xml b/src/main/resources/mapper/sys/RoleMenuAuthMapper.xml
index fe487ad..78a6637 100644
--- a/src/main/resources/mapper/sys/RoleMenuAuthMapper.xml
+++ b/src/main/resources/mapper/sys/RoleMenuAuthMapper.xml
@@ -1,7 +1,7 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lf.server.mapper.sys.RoleMenuAuthMapper">
- <select id="selectCount" resultType="java.lang.Integer" parameterType="java.lang.String">
+ <select id="selectCount" resultType="java.lang.Integer">
select count(*) from lf.sys_role_menu_auth
<where>
<if test="roleid != null">
@@ -21,7 +21,7 @@
limit #{limit} offset #{offset}
</select>
- <select id="selectCountForRole" resultType="java.lang.Integer" parameterType="java.lang.String">
+ <select id="selectCountForRole" resultType="java.lang.Integer">
select count(a.id) from lf.sys_role_menu_auth a inner join lf.sys_menu_auth b on a.menu_auth_id = b.id inner join lf.sys_auth c on b.authid = c.id
<where>
1 = 1
diff --git a/src/main/resources/mapper/sys/RoleResMapper.xml b/src/main/resources/mapper/sys/RoleResMapper.xml
index 3070ac8..b34f830 100644
--- a/src/main/resources/mapper/sys/RoleResMapper.xml
+++ b/src/main/resources/mapper/sys/RoleResMapper.xml
@@ -1,7 +1,7 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lf.server.mapper.sys.RoleResMapper">
- <select id="selectCount" resultType="java.lang.Integer" parameterType="java.lang.String">
+ <select id="selectCount" resultType="java.lang.Integer">
select count(*) from lf.sys_role_res
<where>
<if test="roleid != null">
diff --git a/src/main/resources/mapper/sys/RoleUserMapper.xml b/src/main/resources/mapper/sys/RoleUserMapper.xml
index 7acb0c4..6beaf45 100644
--- a/src/main/resources/mapper/sys/RoleUserMapper.xml
+++ b/src/main/resources/mapper/sys/RoleUserMapper.xml
@@ -1,7 +1,7 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lf.server.mapper.sys.RoleUserMapper">
- <select id="selectCount" resultType="java.lang.Integer" parameterType="java.lang.String">
+ <select id="selectCount" resultType="java.lang.Integer">
select count(*) from lf.sys_role_user a
<where>
<if test="roleid != null">
diff --git a/src/main/resources/mapper/sys/TokenMapper.xml b/src/main/resources/mapper/sys/TokenMapper.xml
index c44b465..4c76f22 100644
--- a/src/main/resources/mapper/sys/TokenMapper.xml
+++ b/src/main/resources/mapper/sys/TokenMapper.xml
@@ -10,7 +10,7 @@
</resultMap>
<!-- 缁熻琛屾暟 -->
- <select id="selectCount" resultType="java.lang.Integer" parameterType="java.lang.String">
+ <select id="selectCount" resultType="java.lang.Integer">
select count(*) from lf.sys_token
<where>
1=1
diff --git a/src/main/resources/mapper/sys/UserMapper.xml b/src/main/resources/mapper/sys/UserMapper.xml
index 92892d2..fcb5cce 100644
--- a/src/main/resources/mapper/sys/UserMapper.xml
+++ b/src/main/resources/mapper/sys/UserMapper.xml
@@ -10,7 +10,7 @@
<result property="updateTime" column="update_time"></result>
</resultMap>
- <select id="selectCount" resultType="java.lang.Integer" parameterType="java.lang.String">
+ <select id="selectCount" resultType="java.lang.Integer">
select count(*) from lf.sys_user
<where>
<if test="uname != null">
@@ -30,7 +30,7 @@
limit #{limit} offset #{offset}
</select>
- <select id="selectCountForRole" resultType="java.lang.Integer" parameterType="java.lang.String">
+ <select id="selectCountForRole" resultType="java.lang.Integer">
select count(a.*) from lf.sys_user a
<where>
not exists (select b.id from lf.sys_role_user b where b.userid = a.id
--
Gitblit v1.9.3