ibatis执行多条sql？

发布于 2021-11-24 03:36:17 字数 2820 浏览 859 评论 7

ibatis怎么配置执行多条sql

类似这个意思：

<delete id="deleteRelatedDatas" parameterClass="java.lang.Long">
       delete from t_table_1 t1 where t1.user_id=#value#;
       delete from t_table_2 t2 where t2.user_id=#value#;
       delete from t_table_3 t3 where t3.user_id=#value#;
</delete>

错误：

{conn-100593} Preparing Statement:    delete from t_table_1 t1 where t1.user_id=?;   delete from t_table_2 t2 where t2.user_id=?;   delete from t_table_3 t3 where t3.user_id=?;
Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/xxx/pojo/xml/Xxxx.xml.
--- The error occurred while applying a parameter map.
--- Check the com.xxxx.pojo.Xxxxx.deleteRelatedDatas-InlineParameterMap.
--- Check the statement (update failed).
--- 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 't1 where t1.user_id=99;   delete from t_table_2 t2 where t2.user_id=99;   delete' at line 1
org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/xxxx/pojo/xml/Xxxxx.xml.
--- The error occurred while applying a parameter map.
--- Check the com.xxxx.pojo.Xxxx.deleteRelatedDatas-InlineParameterMap.
--- Check the statement (update failed).
--- 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 't1 where t1.user_id=99;   delete from t_table_2 t2 where t2.user_id=99;   delete' at line 1
   at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233)
   at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
   at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:203)