rolePermission-sqlmap.xml （编号：20110622A1605 ）

最新推荐文章于 2025-12-29 22:00:28 发布

原创最新推荐文章于 2025-12-29 22:00:28 发布 · 449 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#encoding #class #sql

本文展示了一个使用MyBatis框架进行数据库操作的具体配置文件示例。通过定义SQL映射规则，实现对数据库中角色权限数据的高效增删查改操作。文章详细介绍了如何设置resultMap映射结果集，以及如何利用动态SQL实现灵活的数据查询。

<?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="rolePermission">  <resultMap id="rolePermissionBean" class="rolePermission.service.bean.PermissionBean"> <result property="rowNumber" column="rowNumber" nullValue=""/> <result property="rolePermissionIds" column="rolePermissionIds" nullValue=""/> <result property="roleIds" column="roleIds" nullValue=""/> <result property="permissionIds" column="permissionIds" nullValue=""/> <result property="strNote" column="strNote" 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_intRolePermissionId AS 'rolePermissionIds' ,t1.f_intRoleId AS 'roleIds' ,t1.f_intPermissionId AS 'permissionIds' ,t1.f_dtmCreated AS 'createdDate' ,t1.f_strNote AS 'strNote' from t_RolePermission t1 /* 主表 */ <dynamic prepend="WHERE"> <isNotNull property="roleIds" prepend="and"> t1.f_intRoleId in ( #roleIds# ) </isNotNull> </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="roleIds" prepend="and"> t1.f_intRoleId in ( #roleIds# ) </isNotNull> </dynamic> </statement>  <select id="permissionManage" parameterClass="permission.service.bean.PermissionBean" resultClass="permission.service.bean.PermissionBean" > exec p_RolePermission #action# ,#rolePermissionIds# ,#roleIds# ,#permissionIds# ,#note# </select> </sqlMap>