最近做项目时遇到一个很奇葩的现象,项目是 Spring + SpringMVC + Mybatis
<update id="batchUpdate" parameterType="java.util.List"> <foreach collection="list" item="item" index="index"> update kpxt_xtsz_spbm set sl = #{item.slpledit,jdbcType=VARCHAR} where del_flag='0' and id= #{item.id,jdbcType=VARCHAR}; </foreach> </update>
int batchUpdate(List list);
public int updateAllspbm(String slpledit,String data){ int result = 0; String[] dataS = data.split(","); List list = new ArrayList(); if(dataS.length>0){ for (int i=0;i<dataS.length;i++){ Map map = new HashMap(); map.put("id",dataS[i]); map.put("slpledit",slpledit); list.add(map); } } result = spbmMapper.batchUpdate(list); return result; }
运行时报错如下:
check the manual that corresponds to your MySQL server version for the right syntax to use near‘update kpxt_xtsz_spbm set sl =? where id=?’
找了很久发现jdbc.properties的url中少了配置
加上 &allowMultiQueries=true 就可以批量执行语句了