Mybatis两条sql语句放在一个标签中

最新推荐文章于 2024-04-01 11:47:28 发布

原创最新推荐文章于 2024-04-01 11:47:28 发布 · 2.7k 阅读

5 ·

CC 4.0 BY-SA版权

文章标签：

#Mybatis #allowMultiQueries

MyBatis 专栏收录该内容

4 篇文章

订阅专栏

本文介绍了一个关于Mybatis执行多条SQL语句时出现的语法错误问题及解决方案。错误发生在尝试删除订单及其相关项时，由于SQL语法不正确导致。解决方法是在Mybatis的数据库连接URL中添加参数allowMultiQueries=true，允许执行多条SQL语句。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

.xml

<delete id="deleteOrder" parameterType="_int">
    delete from order_item_ where oid =#{id};
    delete from order_ where id =#{id};
</delete>

报错

Exception in thread "main" org.apache.ibatis.exceptions.PersistenceException: 
### 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 'delete from order_ where id =1' at line 2
### The error may involve com.how2java.pojo.deleteOrder-Inline
### The error occurred while setting parameters
### SQL: delete from order_item_ where oid =?;         delete from order_ where 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 'delete from order_ where id =1' at line 2
	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:200)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.delete(DefaultSqlSession.java:213)
	at com.how2java.TestMybatis.deleteOrder(TestMybatis.java:113)
	at com.how2java.TestMybatis.main(TestMybatis.java:96)
Caused by: 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 'delete from order_ where id =1' at line 2
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:960)
	at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:388)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:46)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)
	... 3 more

通过Mybatis执行多条sql语句需要增加一个参数：allowMultiQueries
mybatis配置文件（jdbc连接url）：

<property name="url" value="jdbc:mysql://localhost:3306/test?characterEncoding=UTF-8&amp;allowMultiQueries=true"/>