数据库异常：Invalid parameter index 1.

davidxp

我在select控件下增加一个点击事件，代码如下：

1.         Model.prototype.select9Change = function(event){
   
2.                 var value=$(this.getElementByXid("select9")).find("option:selected").text();
   
3.                 var params = {"owner" : value};
   
4.         justep.Baas.sendRequest({
   
5.                                 "url" : "/KS/gan",
   
6.                                 "action" : "selectByOwner",
   
7.                                 "async" : false,
   
8.                                 "params" : params,
   
9.                                 "success" :function(ret)
   
10.                                 {
    
11.                                 console.log(ret);
    
12.                                 }
    
13.                         });
    
14.                 console.log(value);
    
15.         };

复制代码

在selectByOwner的动作里，写的sql语句在数据库中单独执行是可以的，但是写到自己的action中就出现如下错误，有人能帮忙看看嘛，谢谢。

1. 八月 12, 2016 11:21:38 上午 org.apache.catalina.core.StandardWrapperValve invoke
   
2. 严重: Servlet.service() for servlet WeX5_Baas_Servlet threw exception
   
3. java.sql.SQLException: Invalid parameter index 1.
   
4.         at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.getParameter(JtdsPreparedStatement.java:255)
   
5.         at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.setParameter(JtdsPreparedStatement.java:326)
   
6.         at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.setObjectBase(JtdsPreparedStatement.java:312)
   
7.         at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.setObject(JtdsPreparedStatement.java:584)
   
8.         at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:169)
   
9.         at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:169)
   
10.         at com.justep.baas.data.DataUtils.queryData(Unknown Source)
    
11.         at KS.Api.selectByOwner(Api.java:39)
    
12.         at KS.Gan__do.selectByOwner(Gan__do.java:139)
    
13.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    
14.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    
15.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    
16.         at java.lang.reflect.Method.invoke(Method.java:497)
    
17.         at com.justep.baas.action.Engine.execAction(Unknown Source)
    
18.         at com.justep.baas.action.Engine.execAction(Unknown Source)
    
19.         at com.justep.baas.servlet.BaasServlet.execService(Unknown Source)
    
20.         at com.justep.baas.servlet.BaasServlet.service(Unknown Source)
    
21.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    
22.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
23.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    
24.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    
25.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    
26.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    
27.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    
28.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
    
29.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
    
30.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
    
31.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    
32.         at java.lang.Thread.run(Thread.java:745)
    
33. 
    
34. 2016-08-12 11:21:38 SQL执行失败，SQL:SELECT * FROM gan where 执行者='test';
    
35. java.sql.SQLException: Invalid parameter index 1.
    
36.         at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.getParameter(JtdsPreparedStatement.java:255)
    
37.         at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.setParameter(JtdsPreparedStatement.java:326)
    
38.         at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.setObjectBase(JtdsPreparedStatement.java:312)
    
39.         at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.setObject(JtdsPreparedStatement.java:584)
    
40.         at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:169)
    
41.         at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:169)
    
42.         at com.justep.baas.data.DataUtils.queryData(Unknown Source)
    
43.         at KS.Api.selectByOwner(Api.java:39)
    
44.         at KS.Gan__do.selectByOwner(Gan__do.java:139)
    
45.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    
46.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    
47.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    
48.         at java.lang.reflect.Method.invoke(Method.java:497)
    
49.         at com.justep.baas.action.Engine.execAction(Unknown Source)
    
50.         at com.justep.baas.action.Engine.execAction(Unknown Source)
    
51.         at com.justep.baas.servlet.BaasServlet.execService(Unknown Source)
    
52.         at com.justep.baas.servlet.BaasServlet.service(Unknown Source)
    
53.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    
54.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
55.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    
56.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    
57.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    
58.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    
59.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    
60.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
    
61.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
    
62.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
    
63.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    
64.         at java.lang.Thread.run(Thread.java:745)
    
65. 2016-08-12 11:21:38 Action[KS/gan/selectByOwner]执行失败，SQL执行失败，SQL:SELECT * FROM gan where 执行者='test';
    
66. java.lang.reflect.InvocationTargetException
    
67.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    
68.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    
69.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    
70.         at java.lang.reflect.Method.invoke(Method.java:497)
    
71.         at com.justep.baas.action.Engine.execAction(Unknown Source)
    
72.         at com.justep.baas.action.Engine.execAction(Unknown Source)
    
73.         at com.justep.baas.servlet.BaasServlet.execService(Unknown Source)
    
74.         at com.justep.baas.servlet.BaasServlet.service(Unknown Source)
    
75.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    
76.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
77.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    
78.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    
79.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    
80.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    
81.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    
82.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
    
83.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
    
84.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
    
85.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    
86.         at java.lang.Thread.run(Thread.java:745)
    
87. Caused by: com.justep.baas.data.sql.SQLException: SQL执行失败，SQL:SELECT * FROM gan where 执行者='test';
    
88.         at com.justep.baas.data.DataUtils.queryData(Unknown Source)
    
89.         at KS.Api.selectByOwner(Api.java:39)
    
90.         at KS.Gan__do.selectByOwner(Gan__do.java:139)
    
91.         ... 20 more
    
92. Caused by: java.sql.SQLException: Invalid parameter index 1.
    
93.         at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.getParameter(JtdsPreparedStatement.java:255)
    
94.         at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.setParameter(JtdsPreparedStatement.java:326)
    
95.         at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.setObjectBase(JtdsPreparedStatement.java:312)
    
96.         at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.setObject(JtdsPreparedStatement.java:584)
    
97.         at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:169)
    
98.         at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:169)
    
99.         ... 23 more
    

复制代码

davidxp

已解决，自己手贱，table = DataUtils.queryData(conn, sql, sqlParams, null, null, null);其中第三个参数应该是null