Batis MyBatis关联查询示例

MyBatis关联查询示例：

[html]
<resultMap type="UserView" id="userAndRoleViewResultMap">
    <id column="user_id" property="userId"/>
    <result column="loginname" property="loginname"/>
    <result column="username" property="username"/>
    <result column="password" property="password"/>
    <result column="user_rights" property="rights"/>
    <result column="status" property="status"/>
    <result column="last_login" property="lastLogin"/>
    <association property="role" column="role_id" javaType="Role">
        <id column="role_id" property="roleId"/>
        <result column="role_name" property="roleName"/>
        <result column="role_rights" property="rights"/>
    </association>
</resultMap>

[sql]
<select id="listPageUser" parameterType="User" resultMap="userAndRoleResultMap">
        select u.user_id,u.username,u.loginname,u.password,r.role_id,r.role_name ,u.last_login
        from tb_user u
        left join tb_role r on u.role_id=r.role_id
        where u.status=0
        <if test="loginname!=null and loginname!=''">
            and u.loginname like "%"#{loginname}"%"
        </if>
        <if test="roleId!=null and roleId!=0">
            and u.role_id=#{roleId}
        </if>
        <if test="lastLoginStart!=null">
        and u.last_login>=#{lastLoginStart}
        </if>
        <if test="lastLoginEnd!=null">
        and u.last_login<=#{lastLoginEnd}
        </if>
    </select>

作者：jpr1990

补充：web前端 , HTML 5 ,