這個問題把小編急毀了，搗騰了好幾天還沒有結果出來，今天終于搗騰出來了，下面小編把經過分享給大家，大家多多提出寶貴意見。
錯誤信息如下
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
|
08:34:43,302 debug getteachers:139 - ==> preparing: select a.*,b.classid,b.classname from teacherinfo a inner join classinfo b on a.teacherid=b.teacherid 08:34:43,316 debug newpooledconnection:430 - com.mchange.v2.c3p0.impl.newpooledconnection@2f187f handling a throwable.java.sql.sqlexception: parameter index out of range (1 > number of parameters, which is 0). at com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:959) at com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:898) at com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:887) at com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:862) at com.mysql.jdbc.preparedstatement.checkbounds(preparedstatement.java:3319) at com.mysql.jdbc.preparedstatement.setinternal(preparedstatement.java:3304) at com.mysql.jdbc.preparedstatement.setinternal(preparedstatement.java:3341) at com.mysql.jdbc.preparedstatement.setnull(preparedstatement.java:3380) at com.mchange.v2.c3p0.impl.newproxypreparedstatement.setnull(newproxypreparedstatement.java:157) at sun.reflect.nativemethodaccessorimpl.invoke0(native method) at sun.reflect.nativemethodaccessorimpl.invoke(unknown source) at sun.reflect.delegatingmethodaccessorimpl.invoke(unknown source) at java.lang.reflect.method.invoke(unknown source) at org.apache.ibatis.logging.jdbc.preparedstatementlogger.invoke(preparedstatementlogger.java:70) at com.sun.proxy.$proxy34.setnull(unknown source) at org.apache.ibatis.type.basetypehandler.setparameter(basetypehandler.java:43) at org.apache.ibatis.scripting.defaults.defaultparameterhandler.setparameters(defaultparameterhandler.java:81) at org.apache.ibatis.executor.statement.preparedstatementhandler.parameterize(preparedstatementhandler.java:80) at org.apache.ibatis.executor.statement.routingstatementhandler.parameterize(routingstatementhandler.java:61) at org.apache.ibatis.executor.simpleexecutor.preparestatement(simpleexecutor.java:74) at org.apache.ibatis.executor.simpleexecutor.doquery(simpleexecutor.java:59) at org.apache.ibatis.executor.baseexecutor.queryfromdatabase(baseexecutor.java:267) at org.apache.ibatis.executor.baseexecutor.query(baseexecutor.java:137) at org.apache.ibatis.executor.cachingexecutor.query(cachingexecutor.java:96) at org.apache.ibatis.executor.cachingexecutor.query(cachingexecutor.java:77) at org.apache.ibatis.session.defaults.defaultsqlsession.selectlist(defaultsqlsession.java:108) at org.apache.ibatis.session.defaults.defaultsqlsession.selectlist(defaultsqlsession.java:102) at sun.reflect.nativemethodaccessorimpl.invoke0(native method) at sun.reflect.nativemethodaccessorimpl.invoke(unknown source) at sun.reflect.delegatingmethodaccessorimpl.invoke(unknown source) at java.lang.reflect.method.invoke(unknown source) at org.mybatis.spring.sqlsessiontemplate$sqlsessioninterceptor.invoke(sqlsessiontemplate.java:434) at com.sun.proxy.$proxy15.selectlist(unknown source) at org.mybatis.spring.sqlsessiontemplate.selectlist(sqlsessiontemplate.java:231) at org.apache.ibatis.binding.mappermethod.executeformany(mappermethod.java:119) at org.apache.ibatis.binding.mappermethod.execute(mappermethod.java:63) at org.apache.ibatis.binding.mapperproxy.invoke(mapperproxy.java:52) at com.sun.proxy.$proxy20.getteachers(unknown source) at com.taohan.online.exam.service.impl.teacherinfoserviceimpl.getteachers(teacherinfoserviceimpl.java:59) at com.taohan.online.exam.handler.classinfohandler.preupdateclass(classinfohandler.java:176) at sun.reflect.nativemethodaccessorimpl.invoke0(native method) at sun.reflect.nativemethodaccessorimpl.invoke(unknown source) at sun.reflect.delegatingmethodaccessorimpl.invoke(unknown source) at java.lang.reflect.method.invoke(unknown source) at org.springframework.web.method.support.invocablehandlermethod.doinvoke(invocablehandlermethod.java:222) at org.springframework.web.method.support.invocablehandlermethod.invokeforrequest(invocablehandlermethod.java:137) at org.springframework.web.servlet.mvc.method.annotation.servletinvocablehandlermethod.invokeandhandle(servletinvocablehandlermethod.java:110) at org.springframework.web.servlet.mvc.method.annotation.requestmappinghandleradapter.invokehandlermethod(requestmappinghandleradapter.java:814) at org.springframework.web.servlet.mvc.method.annotation.requestmappinghandleradapter.handleinternal(requestmappinghandleradapter.java:737) at org.springframework.web.servlet.mvc.method.abstracthandlermethodadapter.handle(abstracthandlermethodadapter.java:85) at org.springframework.web.servlet.dispatcherservlet.dodispatch(dispatcherservlet.java:959) at org.springframework.web.servlet.dispatcherservlet.doservice(dispatcherservlet.java:893) at org.springframework.web.servlet.frameworkservlet.processrequest(frameworkservlet.java:969) at org.springframework.web.servlet.frameworkservlet.doget(frameworkservlet.java:860) at javax.servlet.http.httpservlet.service(httpservlet.java:617) at org.springframework.web.servlet.frameworkservlet.service(frameworkservlet.java:845) 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.springframework.web.filter.hiddenhttpmethodfilter.dofilterinternal(hiddenhttpmethodfilter.java:77) at org.springframework.web.filter.onceperrequestfilter.dofilter(onceperrequestfilter.java:107) at org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) at org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) at org.springframework.web.filter.characterencodingfilter.dofilterinternal(characterencodingfilter.java:121) at org.springframework.web.filter.onceperrequestfilter.dofilter(onceperrequestfilter.java:107) at org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) 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:127) 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:298) at org.apache.coyote.http11.http11processor.process(http11processor.java:857) at org.apache.coyote.http11.http11protocol$http11connectionhandler.process(http11protocol.java:588) at org.apache.tomcat.util.net.jioendpoint$worker.run(jioendpoint.java:489) at java.lang.thread.run(unknown source)08:34:43,319 debug sqlutils:85 - attempted to convert sqlexception to sqlexception. leaving it alone. [sqlstate: s1009; errorcode: 0]java.sql.sqlexception: parameter index out of range (1 > number of parameters, which is 0). at com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:959) at com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:898) at com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:887) at com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:862) at com.mysql.jdbc.preparedstatement.checkbounds(preparedstatement.java:3319) at com.mysql.jdbc.preparedstatement.setinternal(preparedstatement.java:3304) at com.mysql.jdbc.preparedstatement.setinternal(preparedstatement.java:3341) at com.mysql.jdbc.preparedstatement.setnull(preparedstatement.java:3380) at com.mchange.v2.c3p0.impl.newproxypreparedstatement.setnull(newproxypreparedstatement.java:157) at sun.reflect.nativemethodaccessorimpl.invoke0(native method) at sun.reflect.nativemethodaccessorimpl.invoke(unknown source) at sun.reflect.delegatingmethodaccessorimpl.invoke(unknown source) at java.lang.reflect.method.invoke(unknown source) at org.apache.ibatis.logging.jdbc.preparedstatementlogger.invoke(preparedstatementlogger.java:70) at com.sun.proxy.$proxy34.setnull(unknown source) at org.apache.ibatis.type.basetypehandler.setparameter(basetypehandler.java:43) at org.apache.ibatis.scripting.defaults.defaultparameterhandler.setparameters(defaultparameterhandler.java:81) at org.apache.ibatis.executor.statement.preparedstatementhandler.parameterize(preparedstatementhandler.java:80) at org.apache.ibatis.executor.statement.routingstatementhandler.parameterize(routingstatementhandler.java:61) at org.apache.ibatis.executor.simpleexecutor.preparestatement(simpleexecutor.java:74) at org.apache.ibatis.executor.simpleexecutor.doquery(simpleexecutor.java:59) at org.apache.ibatis.executor.baseexecutor.queryfromdatabase(baseexecutor.java:267) at org.apache.ibatis.executor.baseexecutor.query(baseexecutor.java:137) at org.apache.ibatis.executor.cachingexecutor.query(cachingexecutor.java:96) at org.apache.ibatis.executor.cachingexecutor.query(cachingexecutor.java:77) at org.apache.ibatis.session.defaults.defaultsqlsession.selectlist(defaultsqlsession.java:108) at org.apache.ibatis.session.defaults.defaultsqlsession.selectlist(defaultsqlsession.java:102) at sun.reflect.nativemethodaccessorimpl.invoke0(native method) at sun.reflect.nativemethodaccessorimpl.invoke(unknown source) at sun.reflect.delegatingmethodaccessorimpl.invoke(unknown source) at java.lang.reflect.method.invoke(unknown source) at org.mybatis.spring.sqlsessiontemplate$sqlsessioninterceptor.invoke(sqlsessiontemplate.java:434) at com.sun.proxy.$proxy15.selectlist(unknown source) at org.mybatis.spring.sqlsessiontemplate.selectlist(sqlsessiontemplate.java:231) at org.apache.ibatis.binding.mappermethod.executeformany(mappermethod.java:119) at org.apache.ibatis.binding.mappermethod.execute(mappermethod.java:63) at org.apache.ibatis.binding.mapperproxy.invoke(mapperproxy.java:52) at com.sun.proxy.$proxy20.getteachers(unknown source) at com.taohan.online.exam.service.impl.teacherinfoserviceimpl.getteachers(teacherinfoserviceimpl.java:59) at com.taohan.online.exam.handler.classinfohandler.preupdateclass(classinfohandler.java:176) at sun.reflect.nativemethodaccessorimpl.invoke0(native method) at sun.reflect.nativemethodaccessorimpl.invoke(unknown source) at sun.reflect.delegatingmethodaccessorimpl.invoke(unknown source) at java.lang.reflect.method.invoke(unknown source) at org.springframework.web.method.support.invocablehandlermethod.doinvoke(invocablehandlermethod.java:222) at org.springframework.web.method.support.invocablehandlermethod.invokeforrequest(invocablehandlermethod.java:137) at org.springframework.web.servlet.mvc.method.annotation.servletinvocablehandlermethod.invokeandhandle(servletinvocablehandlermethod.java:110) at org.springframework.web.servlet.mvc.method.annotation.requestmappinghandleradapter.invokehandlermethod(requestmappinghandleradapter.java:814) at org.springframework.web.servlet.mvc.method.annotation.requestmappinghandleradapter.handleinternal(requestmappinghandleradapter.java:737) at org.springframework.web.servlet.mvc.method.abstracthandlermethodadapter.handle(abstracthandlermethodadapter.java:85) at org.springframework.web.servlet.dispatcherservlet.dodispatch(dispatcherservlet.java:959) at org.springframework.web.servlet.dispatcherservlet.doservice(dispatcherservlet.java:893) at org.springframework.web.servlet.frameworkservlet.processrequest(frameworkservlet.java:969) at org.springframework.web.servlet.frameworkservlet.doget(frameworkservlet.java:860) at javax.servlet.http.httpservlet.service(httpservlet.java:617) at org.springframework.web.servlet.frameworkservlet.service(frameworkservlet.java:845) 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.springframework.web.filter.hiddenhttpmethodfilter.dofilterinternal(hiddenhttpmethodfilter.java:77) at org.springframework.web.filter.onceperrequestfilter.dofilter(onceperrequestfilter.java:107) at org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) at org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) at org.springframework.web.filter.characterencodingfilter.dofilterinternal(characterencodingfilter.java:121) at org.springframework.web.filter.onceperrequestfilter.dofilter(onceperrequestfilter.java:107) at org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) 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:127) 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:298) at org.apache.coyote.http11.http11processor.process(http11processor.java:857) at org.apache.coyote.http11.http11protocol$http11connectionhandler.process(http11protocol.java:588) at org.apache.tomcat.util.net.jioendpoint$worker.run(jioendpoint.java:489) at java.lang.thread.run(unknown source)08:34:43,320 debug defaultconnectiontester:126 - testing a connection in response to an exception:java.sql.sqlexception: parameter index out of range (1 > number of parameters, which is 0). at com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:959) at com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:898) at com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:887) at com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:862) at com.mysql.jdbc.preparedstatement.checkbounds(preparedstatement.java:3319) at com.mysql.jdbc.preparedstatement.setinternal(preparedstatement.java:3304) at com.mysql.jdbc.preparedstatement.setinternal(preparedstatement.java:3341) at com.mysql.jdbc.preparedstatement.setnull(preparedstatement.java:3380) at com.mchange.v2.c3p0.impl.newproxypreparedstatement.setnull(newproxypreparedstatement.java:157) at sun.reflect.nativemethodaccessorimpl.invoke0(native method) at sun.reflect.nativemethodaccessorimpl.invoke(unknown source) at sun.reflect.delegatingmethodaccessorimpl.invoke(unknown source) at java.lang.reflect.method.invoke(unknown source) at org.apache.ibatis.logging.jdbc.preparedstatementlogger.invoke(preparedstatementlogger.java:70) at com.sun.proxy.$proxy34.setnull(unknown source) at org.apache.ibatis.type.basetypehandler.setparameter(basetypehandler.java:43) at org.apache.ibatis.scripting.defaults.defaultparameterhandler.setparameters(defaultparameterhandler.java:81) at org.apache.ibatis.executor.statement.preparedstatementhandler.parameterize(preparedstatementhandler.java:80) at org.apache.ibatis.executor.statement.routingstatementhandler.parameterize(routingstatementhandler.java:61) at org.apache.ibatis.executor.simpleexecutor.preparestatement(simpleexecutor.java:74) at org.apache.ibatis.executor.simpleexecutor.doquery(simpleexecutor.java:59) at org.apache.ibatis.executor.baseexecutor.queryfromdatabase(baseexecutor.java:267) at org.apache.ibatis.executor.baseexecutor.query(baseexecutor.java:137) at org.apache.ibatis.executor.cachingexecutor.query(cachingexecutor.java:96) at org.apache.ibatis.executor.cachingexecutor.query(cachingexecutor.java:77) at org.apache.ibatis.session.defaults.defaultsqlsession.selectlist(defaultsqlsession.java:108) at org.apache.ibatis.session.defaults.defaultsqlsession.selectlist(defaultsqlsession.java:102) at sun.reflect.nativemethodaccessorimpl.invoke0(native method) at sun.reflect.nativemethodaccessorimpl.invoke(unknown source) at sun.reflect.delegatingmethodaccessorimpl.invoke(unknown source) at java.lang.reflect.method.invoke(unknown source) at org.mybatis.spring.sqlsessiontemplate$sqlsessioninterceptor.invoke(sqlsessiontemplate.java:434) at com.sun.proxy.$proxy15.selectlist(unknown source) at org.mybatis.spring.sqlsessiontemplate.selectlist(sqlsessiontemplate.java:231) at org.apache.ibatis.binding.mappermethod.executeformany(mappermethod.java:119) at org.apache.ibatis.binding.mappermethod.execute(mappermethod.java:63) at org.apache.ibatis.binding.mapperproxy.invoke(mapperproxy.java:52) at com.sun.proxy.$proxy20.getteachers(unknown source) at com.taohan.online.exam.service.impl.teacherinfoserviceimpl.getteachers(teacherinfoserviceimpl.java:59) at com.taohan.online.exam.handler.classinfohandler.preupdateclass(classinfohandler.java:176) at sun.reflect.nativemethodaccessorimpl.invoke0(native method) at sun.reflect.nativemethodaccessorimpl.invoke(unknown source) at sun.reflect.delegatingmethodaccessorimpl.invoke(unknown source) at java.lang.reflect.method.invoke(unknown source) at org.springframework.web.method.support.invocablehandlermethod.doinvoke(invocablehandlermethod.java:222) at org.springframework.web.method.support.invocablehandlermethod.invokeforrequest(invocablehandlermethod.java:137) at org.springframework.web.servlet.mvc.method.annotation.servletinvocablehandlermethod.invokeandhandle(servletinvocablehandlermethod.java:110) at org.springframework.web.servlet.mvc.method.annotation.requestmappinghandleradapter.invokehandlermethod(requestmappinghandleradapter.java:814) at org.springframework.web.servlet.mvc.method.annotation.requestmappinghandleradapter.handleinternal(requestmappinghandleradapter.java:737) at org.springframework.web.servlet.mvc.method.abstracthandlermethodadapter.handle(abstracthandlermethodadapter.java:85) at org.springframework.web.servlet.dispatcherservlet.dodispatch(dispatcherservlet.java:959) at org.springframework.web.servlet.dispatcherservlet.doservice(dispatcherservlet.java:893) at org.springframework.web.servlet.frameworkservlet.processrequest(frameworkservlet.java:969) at org.springframework.web.servlet.frameworkservlet.doget(frameworkservlet.java:860) at javax.servlet.http.httpservlet.service(httpservlet.java:617) at org.springframework.web.servlet.frameworkservlet.service(frameworkservlet.java:845) 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.springframework.web.filter.hiddenhttpmethodfilter.dofilterinternal(hiddenhttpmethodfilter.java:77) at org.springframework.web.filter.onceperrequestfilter.dofilter(onceperrequestfilter.java:107) at org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) at org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206) at org.springframework.web.filter.characterencodingfilter.dofilterinternal(characterencodingfilter.java:121) at org.springframework.web.filter.onceperrequestfilter.dofilter(onceperrequestfilter.java:107) at org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235) 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:127) 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:298) at org.apache.coyote.http11.http11processor.process(http11processor.java:857) at org.apache.coyote.http11.http11protocol$http11connectionhandler.process(http11protocol.java:588) at org.apache.tomcat.util.net.jioendpoint$worker.run(jioendpoint.java:489) at java.lang.thread.run(unknown source) |
錯誤信息關鍵描述
parameter index out of range (1 > number of parameters, which is 0)
反正就是說我的參數存在問題
業務代碼描述
修改班級信息時可以修改班級對應班主任，所以需要查詢出對應的非班主任教師。
handler
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
@requestmapping(value="edit/class/{classid}", method=requestmethod.get) public modelandview preupdateclass(@pathvariable("classid") integer classid) { logger.info("預修改班級處理"); modelandview model = new modelandview(); //獲取要修改班級 classinfo classinfo = classinfoservice.getclassbyid(classid); model.setviewname("/admin/classedit"); model.addobject("editclass", classinfo); list<gradeinfo> grades = gradeinfoservice.getgrades(); //獲取不是班主任的教師 teacher.setiswork(0); // iswork為0就不是班主任 list<teacherinfo> teachers = teacherinfoservice.getteachers(null); //通過下面配置文件可知，該方法需要傳入一個 map 集合，而我這里傳入一個 null //如果沒有可用班主任 if (teachers.size() == 0 || teachers == null) { teacher.setteacherid(classinfo.getteacher().getteacherid()); teacher.setteachername("暫無剩余教師"); teachers.add(teacher); } model.addobject("teachers", teachers); model.addobject("grades", grades); return model; } |
映射文件
statement會接收一個 map 集合
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
|
<resultmap type="com.taohan.online.exam.po.teacherinfo" id="getteacherresultmap"> <id column="teacherid" property="teacherid"/> <result column="teachername" property="teachername" /> <result column="teacheraccount" property="teacheraccount"/> <result column="teacherpwd" property="teacherpwd"/> <result column="adminpower" property="adminpower"/> <result column="iswork" property="iswork"/> <association property="classinfo" javatype="com.taohan.online.exam.po.classinfo"> <id column="classid" property="classid"/> <result column="classname" property="classname"/> </association> </resultmap> <parametermap type="java.util.map" id="getteachersparametermap"> <!-- 教師對象 --> <parameter property="teacher" resultmap="getteacherresultmap"/> <!-- 起始位置索引 --> <parameter property="startindex" resultmap="getteacherresultmap"/> <!-- 每頁顯示數據量 --> <parameter property="pageshow" resultmap="getteacherresultmap"/> </parametermap> <!-- 使用 paramentermap 查詢 --> <select id="getteachers" parametermap="getteachersparametermap" resultmap="getteacherresultmap"> select a.*,b.classid,b.classname from teacherinfo a inner join classinfo b on a.teacherid=b.teacherid <!-- getteachers()方法我傳入的是 null，那么，在下面進行條件判斷的時候并不能找到 teacher、startindex、pageshow，所以拋出異常 --> <where> <if test="teacher != null"> iswork=#{teacher.iswork} </if> </where> <if test="startindex != null and pageshow != null"> limit #{startindex}, #{pageshow} </if> </select> |
總結
通過之前犯過類似的錯誤，以及這次錯誤，我發現 今后只要是 parameter index out of range (1 > number of parameters, which is 0) 類似的錯誤大致定位在 映射文件和調用方法傳入參數，
映射文件
如果使用了 parametermap, resultmap，或是返回集合，就要檢查參數名稱和屬性名稱是否一致
調用方法
針對使用了 parametermap 或 parametertype，需要檢查傳入map中的鍵是否存在、匹配，或傳入對象是否存在指定屬性
下面看下在數據庫中遇到parameter index out of range 錯誤該如何處理？
最近學ssm框架的時候，遇到了這個錯誤，找了半天的原因，最后發現原來是sql語句中多了一對單引號。傳入值的類型為string類型，就以為還要加引號以表示傳入的是字符串，其實是錯的，還是初學對其還不太了解。
如下：
錯誤的：
|
1
2
3
|
<update id="updatestate" parametertype="java.lang.string"> update login set state = 0 where lid = '#{value}'</update> |
正確的：
|
1
2
3
|
<update id="updatestate" parametertype="java.lang.string"> update login set state = 0 where lid = #{value}</update> |
以上所述是小編給大家介紹的mabatis錯誤提示parameter index out of range的處理方法，希望對大家有所幫助，如果大家有任何疑問請給我留言，小編會及時回復大家的。在此也非常感謝大家對服務器之家網站的支持！
原文鏈接：https://www.cnblogs.com/dream-saddle/archive/2018/08/22/9515775.html
