dao:
void batchInsert(@Param("tableName")String tableName,@Param("list")List<Trade> list);
mapper.xml:
<insert id="batchInsert" parameterType="java.util.List">
INSERT INTO ${tableName} (<include refid="COLUMN"/>) VALUES
<foreach collection="list" item="item" index="index" open="(" separator="," close=")">
#{item.id},
#{item.no},
#{item.status},
#{item.buyerId},
#{item.channelName},
#{item.cardPack}
</foreach>
</insert>
注意检查item后的每一个字段 是否拼写错误