int batchInsert(Map map);
<insert id="batchInsert">
insert into T_WEEIN_OAO_STATISTICS_INFO_${tableNamePostfix}
<trim prefix="(" suffix=")" suffixOverrides=",">
<foreach collection="list" item="item" index="index" separator=",">
<if test="index==0">
<if test="item.id != null">
id,
</if>
<if test="item.minipId != null">
minip_id,
</if>
<if test="item.openId != null">
open_id,
</if>
<if test="item.type != null">
`type`,
</if>
<if test="item.skuId != null">
sku_id,
</if>
<if test="item.skuName != null">
sku_name,
</if>
<if test="item.productType != null">
product_type,
</if>
<if test="item.provinceCode != null">
province_code,
</if>
<if test="item.provinceName != null">
province_name,
</if>
<if test="item.cityCode != null">
city_code,
</if>
<if test="item.cityName != null">
city_name,
</if>
<if test="item.districtCode != null">
district_code,
</if>
<if test="item.districtName != null">
district_name,
</if>
<if test="item.ext1 != null">
ext1,
</if>
<if test="item.ext2 != null">
ext2,
</if>
<if test="item.ext3 != null">
ext3,
</if>
<if test="item.createTime != null">
create_time,
</if>
<if test="item.updateTime != null">
update_time,
</if>
</if>
</foreach>
</trim>
values
<foreach collection="list" item="item" index="index" separator=",">
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="item.id != null">
#{item.id,jdbcType=BIGINT},
</if>
<if test="item.minipId != null">
#{item.minipId,jdbcType=VARCHAR},
</if>
<if test="item.openId != null">
#{item.openId,jdbcType=VARCHAR},
</if>
<if test="item.type != null">
#{item.type,jdbcType=INTEGER},
</if>
<if test="item.skuId != null">
#{item.skuId,jdbcType=VARCHAR},
</if>
<if test="item.skuName != null">
#{item.skuName,jdbcType=VARCHAR},
</if>
<if test="item.productType != null">
#{item.productType,jdbcType=VARCHAR},
</if>
<if test="item.provinceCode != null">
#{item.provinceCode,jdbcType=VARCHAR},
</if>
<if test="item.provinceName != null">
#{item.provinceName,jdbcType=VARCHAR},
</if>
<if test="item.cityCode != null">
#{item.cityCode,jdbcType=VARCHAR},
</if>
<if test="item.cityName != null">
#{item.cityName,jdbcType=VARCHAR},
</if>
<if test="item.districtCode != null">
#{item.districtCode,jdbcType=VARCHAR},
</if>
<if test="item.districtName != null">
#{item.districtName,jdbcType=VARCHAR},
</if>
<if test="item.ext1 != null">
#{item.ext1,jdbcType=VARCHAR},
</if>
<if test="item.ext2 != null">
#{item.ext2,jdbcType=VARCHAR},
</if>
<if test="item.ext3 != null">
#{item.ext3,jdbcType=VARCHAR},
</if>
<if test="item.createTime != null">
#{item.createTime,jdbcType=TIMESTAMP},
</if>
<if test="item.updateTime != null">
#{item.updateTime,jdbcType=TIMESTAMP},
</if>
</trim>
</foreach>
</insert>