Mybatis基础学习6——关联查询

Mybatis基础学习6——关联查询

关联查询

// 创建接收对象
public class OrderUser extends Order {
    private String username;// 用户姓名
    private String address;// 地址

    public String getUsername() {
        return username;
    }
    public void setUsername(String username) {
        this.username = username;
    }
    public String getAddress() {
        return address;
    }
    public void setAddress(String address) {
        this.address = address;
    }
}


// 左关联查询
<select id="getOrderUser" resultType="com.hhh.spring.demo.bean.OrderUser">
    <!-- SELECT * FROM USER WHERE username LIKE #{name} -->
    SELECT
    o.`id`,
    o.`user_id`,
    o.`number`,
    o.`createtime`,
    o.`note`,
    u.username,
    u.address
    from
    order1 o
    LEFT join user u
    on u.id = o.user_id
</select>

在map表中进行对象的映射

一对一：

<!-- 一对一关联查询-resultMap -->
	<resultMap type="order" id="order_user_map">
		<!-- id标签用于绑定主键 -->
		<id property="id" column="id"/>
		<!-- 使用result绑定普通字段 -->
		<result property="userId" column="user_id"/>
		<result property="number" column="number"/>
		<result property="createtime" column="createtime"/>
		<result property="note" column="note"/>
		
		<!-- association:配置一对一关联
			 property:绑定的用户属性
			 javaType:属性数据类型，支持别名
		-->
		<association property="user" javaType="com.itheima.mybatis.pojo.User">
			<id property="id" column="user_id"/>
			
			<result property="username" column="username"/>
			<result property="address" column="address"/>
			<result property="sex" column="sex"/>
		</association>
	</resultMap>

通过association对两个对象进行关联

一对多：

<!-- 一对多关联查询 -->
	<resultMap type="user" id="user_order_map">
		<id property="id" column="id" />
		<result property="username" column="username" />
		<result property="birthday" column="birthday" />
		<result property="address" column="address" />
		<result property="sex" column="sex" />
		<result property="uuid2" column="uuid2" />
		
		<!-- collection:配置一对多关系
			 property:用户下的order属性
			 ofType:property的数据类型，支持别名
		-->
		<collection property="orders" ofType="order">
			<!-- id标签用于绑定主键 -->
			<id property="id" column="oid"/>
			<!-- 使用result绑定普通字段 -->
			<result property="userId" column="id"/>
			<result property="number" column="number"/>
			<result property="createtime" column="createtime"/>
		</collection>

通过collection对两个对象进行关联