1. 报错原因,foreach中未换行
2. 原报错xml代码
<insert id="insertGoodsList" parameterType="java.util.List">
insert into goods
(`name`,
`desc`,
`num`,
create_time)
values
<foreach collection="goodsList" item="goods" separator=",">
(#{goods.name}, #{goods.desc}, #{goods.num}, current_timestamp)
</foreach>
</insert>
3. 正确xml代码
<insert id="insertGoodsList" parameterType="java.util.List">
insert into goods
(`name`,
`desc`,
`num`,
create_time)
values
<foreach collection="goodsList" item="goods" separator=",">
(#{goods.name},
#{goods.desc},
#{goods.num},
current_timestamp)
</foreach>
</insert>