Batis MyBatis关联查询示例
MyBatis关联查询示例：
<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>
<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_loginfrom 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>