Servlet.service() for servlet [springmvc] in context with path [/test] threw exception [Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException:
; bad SQL grammar []; nested exception is java.sql.SQLException: Column count doesn't match value count at row 1] with root cause
java.sql.SQLException: Column count doesn't match value count at row 1
请确认设置值的时候是否为3个,index是否从1开始
应该是SQL语句的问题 看最后的错误是前后列数不一致 类似于 INSERT INTO table_name(col_name1, col_name2, col_name3) VALUES('value1','value2');
列不统一 是不是mysql设置了自增长主键,然后sql语句里又插入了主键