resultmap复杂查询

association

 

<resultmap id = “xxx" type = "videoorder">

<id colum= "id" property="id"/>

<result column = "user_id" property = "userid">

<result column = "cdeatr_time" property = "createtime">

<result column = "video_id" property = "videoid">

//配置属性一对一

//property对应videooder中user属性名，javatype属性类型

<assoction property ="user" javatype = "user">

<id colum = "user_id" property = "userid">

<result column = "name" property = "name">

<result column = "iphone" property = "iphone">

</assoction>

</resultmap>

//一对一关联查询，订单内容包括用户属性

​

   select    order.id id,   order.create_time createtime,   order.video_id videoid,   user.id userid ,   user.name,   user.iphone   

from video_order as order   

left join

user on order.userid = user.id​

</select>