mybatis 一个方法执行多条sql报错

最新推荐文章于 2024-04-17 10:47:18 发布

耗子他大哥

最新推荐文章于 2024-04-17 10:47:18 发布

阅读量1.2k

点赞数

分类专栏： java 文章标签： mybatis mysql 多条 sql

本文链接：https://blog.csdn.net/Zheng_xiao_xin/article/details/101161311

版权

java 专栏收录该内容

25 篇文章 1 订阅

订阅专栏

在配置数据库连接 url 时加上

allowMultiQueries=true
// ps:  jdbc:mysql://127.0.0.1:3306/demo?allowMultiQueries=true

否则：

// ps：注意多条 sql 用分号隔开
 <update id="test">
    UPDATE t_student SET name='33',age=22 WHERE stu_id = '1';
    UPDATE t_student SET name='33',age=22 WHERE stu_id = '2';
</update>

执行报错：

// 报错信息
### Error updating database. Cause: java.sql.SQLSyntaxErrorException: 
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 t_student set name='33',age=22 WHERE stu_id = '2' at line 5 
### SQL: UPDATE t_student set name=?,age=? WHERE stu_id = ? ; UPDATE t_student set name=?,age=? WHERE stu_id = ? 
### Cause: java.sql.SQLSyntaxErrorException: 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 t_student set name='33',age=22 WHERE stu_id = '2' at line 5 ; 
    bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: 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 t_student set name='33',age=22 WHERE stu_id = '2' at line 5