Parameter index out of range 谢谢！

[tenor]

谢谢大家！帮我看看这个错误怎么回事，谢谢！！

java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:2493)
at com.mysql.jdbc.PreparedStatement.setString(PreparedStatement.java:3213)
at database.LinkDB.addBook(LinkDB.java:35)
at action.addBookAction.execute(addBookAction.java:37)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)

[j993wf]

Parameter index out of range
是因为你要执行的sql里参数超过你声明的个数。

[zhao_999]

想不到我遇到和lz差不多的错误！
不知道怎么解决啊

[Kwok]

就是在你声明时的问号个数和你获得的参数个数不一致。

[有妻徒刑岁月长]

[Quote=引用 3 楼 dragons5870 的回复:]
就是在你声明时的问号个数和你获得的参数个数不一致。
[/Quote]

就是这个原因

[hoseli007]

[Quote=引用 3 楼 dragons5870 的回复:]

就是在你声明时的问号个数和你获得的参数个数不一致。
[/Quote]
引用

[donghero2010]

我的也是这个问题，但是检查了参数个数匹配啊

[dw1178769973]

是你输入的字符串的长度超出了你定义的长度