mybatis批量更新

最新推荐文章于 2023-11-30 09:26:02 发布

杜林晓

最新推荐文章于 2023-11-30 09:26:02 发布

阅读量86

点赞数 1

文章标签： mysql mybatis

本文链接：https://blog.csdn.net/qq_36843946/article/details/112228817

版权

<update id="batchUpdate" parameterType="java.util.List" >
	<foreach collection="list" item="item" index="index" separator=";">
		UPDATE table set name = #{item.name} , code = #{item.code} , time = #{item.time} WHERE id = #{item.id}
	</foreach>
</update>

以上批量更新的方法是一次执行多条update语句，所以需要额外配置：在spring.datasource.url后加上allowMultiQueries=true，表示允许一次批量执行多条sql。

如果不加，会报如下错误：

[org.apache.ibatis.session.defaults.DefaultSqlSession@76a2f910]
org.springframework.jdbc.BadSqlGrammarException:
###Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'update b_email_msg_remind
SET send_status = 1, send_email_code='abc@abc.abc'' at line 6
###The error may involve com.hhsoft.sectionservice.model.persistence.EmailMapper.updateEmailTasks-Inline
###The error occurred while setting parameters
###Cause:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'update table
SET status = 1, send_email_code='abc@abc.abc';update staff SET status = 2,send_email_code='test@qq.com' ‘  at line 6; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'update b_email_msg_remind
SET send_status = 1, send_email_code='abc@abc.abc'' at line