src/com/yh/mapper/RoleMapper.xml

微信扫码关注公众号，代码整理好后第一时间通知你。

<?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.yh.mapper.RoleMapper">
	
	<select id="findAll" resultType="role">
		select * from t_role
	</select>
	
	<insert id="insert" parameterType="role">
		insert into t_role values (null,#{rolename},#{roledesc})
	</insert>
	
	<delete id="delete" parameterType="int">
		delete from t_role where id=#{id}
	</delete>
	
	<select id="findRoleById" parameterType="int" resultType="role">
		select * from t_role where id = #{id}
	</select>
	
	<update id="update" parameterType="role">
		update t_role set rolename=#{rolename},roledesc=#{roledesc} where id=#{id}
	</update>
	
	
	<select id="findPermissionById" resultType="permission">
		select * from t_permission
	</select>
	
	<!-- 添加权限 -->
	<insert id="insertRP" parameterType="map">
		insert into t_role_permission values (null,#{key1},#{key2})
	</insert>
	
	
	<!-- 分页 -->
	<select id="fenYe" parameterType="page" resultType="role">
		select * from t_role where rolename like '%${mohu}%' limit #{xb},#{pageSize}
	</select>
	
	<select id="count" resultType="int">
		select count(*) from t_role
	</select>
	
</mapper>