请问报错是哪方面的问题

Question

Servlet.service() for servlet [springmvc] in context with path [/test] threw exception [Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException:

Error updating database. Cause: java.sql.SQLException: Column count doesn't match value count at row 1

The error may involve dao.mapper.AccountDao.insertAccount-Inline

The error occurred while setting parameters

SQL: insert into account values(?,?,?)

Cause: java.sql.SQLException: Column count doesn't match value count at row 1

; 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

Answer 1

请确认设置值的时候是否为3个，index是否从1开始