Mybatis-关联查询

一对一关联

	<resultMap type="order" id="order_user_map">
		<id property="id" column="id"/>
		<result property="userId" column="user_id"/>
		<result property="number" column="number"/>
		<result property="createtime" column="createtime"/>
		<result property="note" column="note"/>
		
		<!-- 配置一对一关系 -->
		<association property="user" javaType="user">
			<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"/>
		</association>
	</resultMap>

	<select id="getOrderUser" resultMap="order_user_map">
		select
		o.id,o.user_id,o.number,o.createtime,o.note,u.username,u.birthday,u.address,u.sex
		from `order` o left join user u on o.user_id = u.id
	</select>

一对多关联

	<resultMap type="user" id="user_order_map">
		<id property="id" column="id" />
		<result property="username" column="username" />
		<result property="address" column="address" />
		<result property="birthday" column="birthday" />
		<result property="sex" column="sex" />
		<!-- 配置一对多 -->
		<collection property="orders" ofType="order">
			<id property="id" column="oid" />
			<result property="userId" column="user_id" />
			<result property="number" column="number" />
			<result property="createtime" column="createtime" />
			<result property="note" column="note" />
		</collection>
	</resultMap>
	
	<select id="getUserOrderMap" resultMap="user_order_map">
		select
		u.username,u.id,u.address,u.birthday,u.sex,o.id
		oid,o.number,o.createtime
		from user u LEFT JOIN `order` o on
		u.id=o.user_id
	</select>