target/classes/com/system/mapper/UserloginMapperCustom.xml

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

<?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.system.mapper.UserloginMapperCustom" >


    <resultMap id="UserloginResultMap" type="UserloginCustom">
        <id column="userID" property="userid"></id>

        <result column="userName" property="username" />
        <result column="password" property="password" />
        <result column="role" property="role" />

        <!--对象关联查询-->
        <association property="role_ob" javaType="Role">
            <id column="roleID" property="roleid"/>
            <result column="roleName"   property="rolename"/>
            <result column="permissions" property="permissions"/>
        </association>

    </resultMap>

    <select id="findOne" parameterType="String" resultMap="UserloginResultMap">
        SELECT
          userlogin.*,
          role.*,
        FROM
          userlogin,
          role
        WHERE
          userlogin.role = role.roleID
    </select>

</mapper>