论坛发帖功能sql异常

最新推荐文章于 2022-03-04 09:42:28 发布

愿好

最新推荐文章于 2022-03-04 09:42:28 发布

阅读量230

点赞数

本文链接：https://blog.csdn.net/m0_37840000/article/details/79420891

版权

严重: Servlet.service() for servlet [dispatcher] in context with path [/forum] threw exception [Request processing failed; nested exception is org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [INSERT INTO my_main(main_id,main_title,main_content,main_creatime,main_creatuser,main_commend)VALUES(？,？,？,？,？,？)]; Parameter index out of range (1 > number of parameters, which is 0).; nested exception is java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).] with root cause
java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1084)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918)

错误原因为标点符号和问号都是中文输入法