Home > Back-end >  For the great god, I this is what happened
For the great god, I this is what happened

Time:10-07

March 17, 2020 9:30:02 morning org. Apache. Catalina. Core. StandardWrapperValve invoke
Serious: Servlet service () for the Servlet/JSP in context with the path [/managerNews] threw the exception in [30] [line processing [/newsInsertDo JSP] an exception occurs when the

27: String SQL="insert into news (id, title, author) value (null, '" + title +"', '" + author + ") ";
28:
29:
30: int I=STMT. ExecuteUpdate (SQL);
31:
32: STMT. Close ();
33: con. The close ();


Stacktrace:] with root cause
Com. Mysql. JDBC. Exceptions. Jdbc4. MySQLSyntaxErrorException: Unknown column 'title' in 'the field list'

CodePudding user response:

An error prompt, check your titile the column names in the table are consistent,

CodePudding user response:

Solution: * usually this is what you write SQL statements contained in the column names in the database, there is no *
  • Related