这个问题把小编急毁了，捣腾了好几天还没有结果出来，今天终于捣腾出来了，下面小编把经过分享给大家，大家多多提出宝贵意见。
错误 信息如下
|
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
查看更多关于Mabatis错误提示Parameter index out of range的处理方法的详细内容...