现有两个实体类:订单类,用户类
现有两个实体类对应的表:订单表,用户表
需求:使用mybatis查询订单信息并查询订单所属的用户信息
SELECT *,o.id oid FROM USER u,orders o WHERE u.id=o.uid
所以在,mybatis的Mappersql.xml中的配置为:
<resultMap id="userMap" type="user">
<id column="uid" property="id"></id>
<result column="username" property="username"></result>
<result column="password" property="password"></result>
<result column="birthday" property="birthday"></result>
<!--配置集合信息
property:集合名称
ofType:当前集合中的数据类型
-->
<collection property="orderList" ofType="order">
<!--封装order的数据-->
<id column="oid" property="id"></id>
<result column="ordertime" property="ordertime"></result>
<result column="total" property="total"></result>
</collection>
</resultMap>
<select id="findAll" resultMap="userMap">
SELECT *,o.id oid FROM USER u,orders o WHERE u.id=o.uid
</select>