连接查询
dao
User queryUserByName(String name);
pojo
public class User {
private int userId;
private String userName;
private String userPwd;
private String userRealname;
private String userImg;
private Detail detail;
}
mapper
<resultMap id="userMap" type="com.swkj.pojo.User">
<id column="user_id" property="userId"></id>
<result column="user_name" property="userName"></result>
<result column="user_pwd" property="userPwd"></result>
<result column="user_realname" property="userRealname"></result>
<result column="user_img" property="userImg"></result>
<result column="detail_id" property="detail.detailId"></result>
<result column="user_addr" property="detail.userAddr"></result>
<result column="user_tel" property="detail.userTel"></result>
<result column="user_desc" property="detail.userDesc"></result>
</resultMap>
<select id="queryUserByName" resultMap="userMap">
select user_id, user_name, user_pwd, user_realname, user_img, detail_id, user_addr, user_tel, user_desc
from users
inner join details
on users.user_id = details.uid
where users.user_name=#{userName}
</select>
子查询
dao
UserDAO
User queryUserByName2(String name);
DetailDAO
Detail queryDetailById(int id);
pojo
public class User {
private int userId;
private String userName;
private String userPwd;
private String userRealname;
private String userImg;
}
mapper
UserMapper.xml
<resultMap id="userMap2" type="com.swkj.pojo.User">
<id column="user_id" property="userId"></id>
<result column="user_name" property="userName"></result>
<result column="user_pwd" property="userPwd"></result>
<result column="user_realname" property="userRealname"></result>
<result column="user_img" property="userImg"></result>
<!-- association 调用子查询,关联查询一个对象 -->
<association property="detail" select="com.swkj.dao.DetailDAO.queryDetailById" column="user_id"/>
</resultMap>
<select id="queryUserByName2" resultMap="userMap2">
select user_id, user_name, user_pwd, user_realname, user_img
from users
where user_name=#{userName}
</select>
DetailMapper.xml
<resultMap id="detailMap" type="com.swkj.pojo.Detail">
<id column="detail_id" property="detailId"></id>
<result column="user_addr" property="userAddr"></result>
<result column="user_tel" property="userTel"></result>
<result column="user_desc" property="userDesc"></result>
</resultMap>
<select id="queryDetailById" resultMap="detailMap">
select detail_id, user_addr, user_tel, user_desc
from details
where uid=#{userId}
</select>