mybatis批量插入怎么做 ？

[kuanner]

<insert id="addNormalPlan" parameterType="list" >
<selectKey keyProperty="id" resultType="int" order="BEFORE">
select max(id)+1 from TBL_NORMAL_PLAN
</selectKey>
<![CDATA[
INSERT INTO TEST( id, plan_type,week_type, start_time,end_time) VALUES ]]>
<foreach collection="list" item="item" index="index"
separator=",">
<![CDATA[ (#{id}, #{item.planType}, #{item.weekType},
#{item.startTime}, #{item.endTime} ) ]]>
</foreach>
</insert>



INSERT INTO TEST( id, plan_type,week_type, start_time,end_time) values(?,?,?,?,?),(?,?,?,?,?) 执行的时候就报个错。

求真相

[MiceRice]

好歹给个错误提示信息来。

否则的话，建议你看看这个吧？
http://www.cnblogs.com/xcch/articles/2042298.html

[ly1124263]

楼主怎么解决的，贴出来啊

[我就改个名]

<insert id="insertInstance" parameterType="hashMap">
insert into ${tableName} (customer_id,${insertColumns}) values (#{customer_id},${insertValues})
</insert>

<update id="updateReceiveById" parameterType="hashMap">
update ${tableName} set ${updateValues} where document_id = #{document_id} and customer_id = #{customer_id}
</update>