赶快急于解决的

Question

请问各位。这个是什么错误呀。No value specified for parameter 479谢谢！

Answer 1

no value !!!看下你传了什么过去！

Answer 2

那我问你，这个是什么错误呀？qer134 3124135!@#$!#$ 31!#$@! 13&*&*(

Answer 3

select CH_DEV_SERVICE_ID,CH_DEV_NAME,I_DEV_TYPE,CH_DEV_IP,I_CAMERA_TOTAL,CH_DEV_PORT  from tab_dev where upper(CH_DEV_NAME) like upper(?) and I_DEV_SEQ='0' 
java.sql.SQLException: No value specified for parameter 479
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:2214)
at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:2138)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1853)
at com.tvlink.accesssvr.GetDevInfoByName.getDevInfo(GetDevInfoByName.java:70)
at org.apache.jsp.accesssvr.GetDevInfoByName_jsp._jspService(GetDevInfoByName_jsp.java:69)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)
麻烦各位帮我看看行不？谢谢

Answer 4

你用的是preparedStatement要给？赋值啊

Answer 5

 是不是没有给preparedStatement 设置参数？