servlet ssm 实现添加角色功能

servlet ssm 实现添加角色功能

1.IRoleService

public interface IRoleService {
   
    List<Integer> findRoleId(int userId);

    List<Role> findRoleByUserId(int id);

    void add(List<Integer> ids, String userId);
}

2.RoleDao

public interface RoleDao {
   
    List<Integer> findRoleIdByUserId(int userId);

    List<Role> findRoleByUserId(int id);

    void addRole(UserRole userRole);
}

3.RoleMapper

<mapper namespace="com.wu.dao.RoleDao" >
    <select id="findRoleIdByUserId" parameterType="int" resultType="int">
        select roleId from user_role where userId=#{
   userId}
    </select>
    <select id="findRoleByUserId" resultType="role" parameterType="int">
        select * from tb_role where id not in (select roleId from user_role where userId=#{
   id})
    </select>
    <insert id="addRole" parameterType="userRole">
        insert into user_role(userId,roleId) value (#{
   userId},#{
   roleId})
    </insert>
</mapper>