Java. SQL. SQLException: Incorrect integer value: 'for column' sno at row 1
At com. Mysql. JDBC. SQLError. CreateSQLException (SQLError. Java: 1055)
At com. Mysql. JDBC. SQLError. CreateSQLException (SQLError. Java: 956)
At com. Mysql. JDBC. MysqlIO. CheckErrorPacket (MysqlIO. Java: 3558)
At com. Mysql. JDBC. MysqlIO. CheckErrorPacket (MysqlIO. Java: 3490)
At com. Mysql. JDBC. MysqlIO. SendCommand (MysqlIO. Java: 1959)
At com. Mysql. JDBC. MysqlIO. SqlQueryDirect (MysqlIO. Java: 2109)
At com. Mysql. JDBC. ConnectionImpl. ExecSQL (ConnectionImpl. Java: 2637)
At com. Mysql. JDBC. StatementImpl. ExecuteUpdate (StatementImpl. Java: 1647)
At com. Mysql. JDBC. StatementImpl. ExecuteUpdate (StatementImpl. Java: 1566)
The at course_design. Gaokao1. Main (gaokao1. Java: 234)

CodePudding user response:

May be the type of the field name or name didn't line up

CodePudding user response:

Gaokao1 234 lines to look at, your sno may be string string type, you gave the int type

CodePudding user response:

Sno, corresponding to column names in the database should be spelt wrong, you can see for corresponding to its own database, the column name is son misspelled into sno

CodePudding user response:

Listen to the upstairs,,

CodePudding user response:

Sno field has a problem