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 *