MyBatis 多表关联映射

最新推荐文章于 2024-03-26 17:30:50 发布

117jf

最新推荐文章于 2024-03-26 17:30:50 发布

阅读量198

点赞数 1

分类专栏： myBatis java 文章标签： java

本文链接：https://blog.csdn.net/weixin_55556204/article/details/125365767

版权

myBatis 同时被 2 个专栏收录

6 篇文章 0 订阅

订阅专栏

java

6 篇文章 0 订阅

订阅专栏

连接查询

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>