src/main/resources/mapper/SysUserMapper.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.gxuwz.jyd.mapper.SysUserMapper">

    <resultMap id="UserRole" type="SysUser">
        <id column="id" property="id"/>
        <result property="userId" column="user_id"/>
        <result property="fullname" column="fullname"/>
        <result property="password" column="password"/>
        <result property="telePhone" column="tele_phone"/>
        <association property="role" javaType="SysRole">
            <id column="id" property="id"/>
            <result property="roleId" column="role_id"/>
            <result property="roleName" column="role_name"/>
        </association>
    </resultMap>

    <select id="queryUserPageByName" parameterType="String" resultType="SysUser">
        select * from sys_user
        <if test="fullname != null and fullname !=''">
            where fullname like concat('%',#{fullname,jdbcType=VARCHAR},'%')
        </if>
    </select>

    <select id="loginUser" resultMap="UserRole">
        select * from sys_user u ,sys_role r ,user_role ur
         where u.id=ur.user_id and r.id = ur.role_id and u.user_id=#{userId}
    </select>

    <select id="getMaxId" resultType="int">
        select max(id) id from sys_user
    </select>

    <insert id="addRole" parameterType="int">
        insert into user_role (user_id,role_id) values (#{userId},#{roleId})
    </insert>
</mapper>