<update id="updateBatchUser" parameterType="com.fox.entity.User">
<foreach collection="list" item="obj" separator=";" >
update sys_user set
sex = #{obj.sex},
name = #{obj.name},
email = #{obj.email}
where no = #{obj.no}
</foreach>
</update>
解决办法:在MySQL的连接上加上&allowMultiQueries=true代表允许多查询
如下:
jdbc.url=jdbc:mysql://127.0.0.1:3306/edu?useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true