permission-sqlmap.xml （编号：20110621A1127 ）

最新推荐文章于 2026-01-01 22:38:21 发布

原创最新推荐文章于 2026-01-01 22:38:21 发布 · 552 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#encoding #class #sql

本文详细介绍了如何使用SQLMap进行权限管理的查询与验证，包括获取权限列表、记录总数、增删改操作以及有效性检查，适用于数据库权限管理的需求。

<?xml version="1.0" encoding="GB2312"?> <!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd"> <sqlMap namespace="permission">  <resultMap id="permissionBean" class="permission.service.bean.PermissionBean"> <result property="rowNumber" column="rowNumber" nullValue=""/> <result property="permissionIds" column="permissionIds" nullValue=""/> <result property="permissionNumber" column="permissionNumber" nullValue=""/> <result property="permissionName" column="permissionName" nullValue=""/> <result property="createdDate" column="createdDate" nullValue=""/> <result property="records" column="records" nullValue=""/> </resultMap>  <statement id="getPermissionBeanList" resultMap="permissionBean" parameterClass="permission.service.bean.PermissionBean"> select top $pageSize$ * from ( select * from ( select ROW_NUMBER() OVER (ORDER BY f_dtmCreated DESC) AS 'rowNumber' ,t1.f_intPermissionId AS 'permissionIds' ,t1.f_strPermissionNumber AS 'permissionNumber' ,t1.f_strPermissionName AS 'permissionName' ,t1.f_dtmCreated AS 'createdDate' ,0 AS 'records' from t_Permission t1 /* 主表 */ <dynamic prepend="WHERE"> <isNotNull property="filterKeys" prepend="WHERE"> <iterate property="filterKeys" conjunction="AND"> ( t1.f_strPermissionNumber LIKE '%$filterKeys[]$%' OR t1.f_strPermissionName LIKE '%$filterKeys[]$%' ) </iterate> </isNotNull> <isNotNull property="permissionIds" prepend="and"> t1.f_intPermissionId in ( #permissionIds# ) </isNotNull> <isNotEmpty prepend="and" property="permissionName"> t1.f_strPermissionName = #permissionName# </isNotEmpty> <isNotEmpty prepend="and" property="permissionNumber"> t1.f_strPermissionNumber = #permissionNumber# </isNotEmpty> </dynamic> ) t WHERE rowNumber > $pageSize$ * ( $pageNumber$ - 1 ) ) t </statement>  <statement id="getPermissionBeanList_records" resultClass="java.lang.Integer" parameterClass="permission.service.bean.PermissionBean"> select count(f_intPermissionId) as records from t_Permission t1 /* 主表 */ <dynamic prepend="WHERE"> <isNotNull property="filterKeys" prepend="WHERE"> <iterate property="filterKeys" conjunction="AND"> ( t1.f_strPermissionNumber LIKE '%$filterKeys[]$%' OR t1.f_strPermissionName LIKE '%$filterKeys[]$%' ) </iterate> </isNotNull> <isNotNull property="permissionIds" prepend="and"> t1.f_intPermissionId in ( #permissionIds# ) </isNotNull> <isNotEmpty prepend="and" property="permissionName"> t1.f_strPermissionName = #permissionName# </isNotEmpty> <isNotEmpty prepend="and" property="permissionNumber"> t1.f_strPermissionNumber = #permissionNumber# </isNotEmpty> </dynamic> </statement>  <select id="permissionManage" parameterClass="permission.service.bean.PermissionBean" resultClass="permission.service.bean.PermissionBean" > exec p_Permission #action# ,#permissionIds# ,#organizationId# ,#permissionNumber# ,#permissionName# ,#description# ,#isActive# ,#note# </select>  <select id="validCheck" parameterClass="permission.service.bean.PermissionBean" resultClass="permission.service.bean.PermissionBean" > select count(t.f_intPermissionId) as 'records' , case when count(t.f_intPermissionId) > 0 then '无效值！' end as 'message' from ( select * from t_Permission t1 <dynamic prepend="WHERE"> <isNotNull prepend="and" property="permissionIds"> t1.f_intPermissionId <> #permissionIds# </isNotNull> <isNotEmpty prepend="and" property="permissionName"> t1.f_strPermissionName = #permissionName# </isNotEmpty> <isNotEmpty prepend="and" property="permissionNumber"> t1.f_strPermissionNumber = #permissionNumber# </isNotEmpty> </dynamic> ) t </select> </sqlMap>