SQL
<!--分组测试-->
<select id="test" resultMap="test">
select * from mall_shoppingcart where company_id="companyIdTest"
</select>
resultMap
<resultMap type="com.ls.aluminum.supply.mallothers.bo.Test" id="test">
<id property="shopId" column="shop_id" jdbcType="INTEGER"/>
<collection property="mallShoppingcarts" ofType="com.ls.aluminum.supply.mallothers.bo.MallShoppingcart" javaType="java.util.ArrayList" resultMap="UMallShoppingcartMap"/>
</resultMap>
<resultMap type="com.ls.aluminum.supply.mallothers.bo.MallShoppingcart" id="UMallShoppingcartMap">
<id property="shoppingcartId" column="shoppingcart_id" jdbcType="INTEGER"/>
<result property="companyId" column="company_id" jdbcType="VARCHAR"/>
<result property="shopId" column="shop_id" jdbcType="INTEGER"/>
<result property="productId" column="product_id" jdbcType="INTEGER"/>
<result property="isProductExists" column="is_product_exists" jdbcType="INTEGER"/>
<result property="number" column="number" jdbcType="INTEGER"/>
<result property="unitName" column="unit_name" jdbcType="VARCHAR"/>
<result property="createTime" column="create_time" jdbcType="TIMESTAMP"/>
<result property="optionUserId" column="option_user_id" jdbcType="VARCHAR"/>
<result property="lastModifyOption" column="last_modify_option" jdbcType="VARCHAR"/>
<result property="lastModifyTime" column="last_modify_time" jdbcType="TIMESTAMP"/>
</resultMap>