mybatis的问题

出现的错误如下:

### Error querying database.  Cause: java.lang.ArrayIndexOutOfBoundsException: 1

### The error may exist in ./mybatis_config/userinfo.xml

### The error may involve com.nsn.sp.userinfo.dao.UserInfoDAO.queryUserInfo-Inline

### The error occurred while setting parameters

### SQL: select * ,msisdn as checkboxid from user_info       WHERE 1=1       order by uid         limit 20 offset 0

### Cause: java.lang.ArrayIndexOutOfBoundsException: 1

        at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:75)

        at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:371)

        at $Proxy50.selectList(Unknown Source)

        at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:198)

        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 $Proxy58.queryUserInfo(Unknown Source)

        at sun.reflect.GeneratedMethodAccessor55.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:616)

        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)

        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)

        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:108)

        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

        at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)

        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)

        at $Proxy59.queryUserInfo(Unknown Source)

        at com.nsn.sp.userinfo.service.UserInfoServiceImpl.queryUserInfo(UserInfoServiceImpl.java:42)

        at com.nsn.sp.userinfo.controller.UserInfoController.queryUserInfo(UserInfoController.java:198)

        at sun.reflect.GeneratedMethodAccessor54.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:616)

        at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.doInvokeMethod(HandlerMethodInvoker.java:710)

        at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:167)

        at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:414)

        at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:402)

        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:771)

        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:716)

        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:647)

        at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:563)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

        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 com.nsn.commons.session.GetContent.doFilter(GetContent.java:25)

        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:852)

        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(Thread.java:679)

Dao：public List<Map<String, Object>> queryUserInfo(Map<String, Object> m);

mybatis：

<select id="queryUserInfo" parameterType="map" resultMap="map">

SELECT uid,username,msisdn,imsi,area,city,jointime,opentype,taocan,phone,email,address,

bigclass,smallclass,talktime,talkband,smsnum,datagprs,ontime,avgconsume,fax,accountid,msisdn as checkboxid,vipstatus FROM user_info

  <where>  1=1

</where>  order by uid

 <if test="rows !='' and rows !=null">

limit ${rows} offset ${page}

</if>

</select>

Map值：{uid=null, bigclass=null, opentype=null, smallclass=null, avgconsume=null, msisdn=null, talktime=null, rows=20, username=null, ontime=null, jointime=null, page=0, datagprs=null}

转载于:https://my.oschina.net/shennan/blog/472121