1. Mybatis批量插入(正确)
<insert id="insertBatch">
INSERT INTO t_user
(id, name, password)
VALUES
<foreach collection ="userList" item="user" separator =",">
(#{id}, #{name}, #{password})
</foreach >
</insert>
2. Mybatis批量插入(错误)
<insert id="insertBatch">
<foreach collection ="userList" item="user" separator =";">
INSERT INTO t_user(id, name, password) VALUES(#{id}, #{name}, #{password})
</foreach >
</insert>
### Cause: java.sql.SQLException: No value specified for parameter 16
; bad SQL grammar []; nested exception is java.sql.SQLException: No value specified for parameter 16
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
at com.sun.proxy.$Proxy98.insert(Unknown Source)