在尝试使用Java的PreparedStatement向MySQL数据库插入数据时，遇到了'Column count doesn't match value count at row 1'的错误。问题出现在预编译的SQL语句中，没有明确指定每个参数对应的列。尽管表中有6个字段，但建议在SQL中明确指定每个值对应的列名以避免此类错误。
I have encountered an error, java.sql.SQLException:
Column count doesn't match value count at row 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2427)
It's super frustrating, because I have been making amendments to the code like changing in the arg to all string, but the error still appears.
public void readDataBase(int val, S
最低0.47元/天 解锁文章
4万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
