<result property="username" column="username"/>
<collection property="orders" ofType="Order">
<id property="id" column="order_id"/>
<result property="orderNo" column="order_no"/>
</collection>
<collection property="orders" column="id"
select="com.mapper.OrderMapper.findByUserId"/>
<result property="orderNo" column="order_no"/>
<result property="createTime" column="create_time"/>
<collection property="orderItems" ofType="OrderItem">
<id property="itemId" column="item_id"/>
<result property="productName" column="product_name"/>
<result property="price" column="price"/>
<result property="quantity" column="quantity"/>
<association property="product" javaType="Product">
<id property="productId" column="product_id"/>
<result property="productName" column="product_name"/>
<result property="mainImage" column="main_image"/>
</association>
</collection>
