java - 列计数与第1行Java的值计数不匹配

This question already has answers here:

Column count doesn't match value count at row 1
                                
                                    （5个答案）
                                
                        
                                2年前关闭。
            
                    
String query = "INSERT INTO用户( int , fname , lname , age , sname , bname ) VALUES ('"+jTextField_FirstName.getText()+"','"+jTextField_LastName.getText()+"',"+jTextField_Age.getText()+",'"+jTextField_SName.getText()+"','"+jTextField_BName.getText()+"')";

这是堆栈跟踪：

java.sql.SQLException: Column count doesn't match value count at row 1 at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976) at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912) at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683) at
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2482) at
com.mysql.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1552)

最佳答案

您要设置6列int, fname, lname, age, sname, bname

但是，您仅提供5个列值。

再添加一个列值，就可以了

关于java - 列计数与第1行Java的值计数不匹配，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/50167140/