Parameter index out of range (2 > number of parameters, which is 1)
来源:互联网 发布:PHP zend val 编辑:程序博客网 时间:2024/06/02 03:39
### Error querying database. Cause: java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1).### The error may exist in com/xx/dao/TbItemMapper.xml### The error may involve com.qf.dao.TbItemMapper.selectItemByPage-Inline### The error occurred while setting parameters### SQL: select i.id, i.title,i.sell_point as sellPoint , format(i.price/100,2) as priceExt, i.num, i.barcode, i.image, i.cid, i.status, date_format(i.created,'%Y-%m-%d %k:%i:%s') as createdExt, i.updated, c.name as catName, CASE i.status WHEN 1 THEN "正常" WHEN 2 THEN "下架" WHEN 3 THEN "删除" ELSE "未知" END as statusName from tb_item i,tb_item_cat c where i.cid = c.id and title like concat('%',?,%') order by i.id desc limit ?,?### Cause: java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1).; SQL []; Parameter index out of range (2 > number of parameters, which is 1).; nested exception is java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1).at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:108)at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:371)at com.sun.proxy.$Proxy30.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 com.sun.proxy.$Proxy31.selectItemByPage(Unknown Source)at com.qf.service.impl.TbItemServiceImpl.selectItemByPage(TbItemServiceImpl.java:22)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.lang.reflect.Method.invoke(Method.java:498)at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)at com.sun.proxy.$Proxy34.selectItemByPage(Unknown Source)at com.qf.controller.TbItemController.getItemList(TbItemController.java:43)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.lang.reflect.Method.invoke(Method.java:498)at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:220)at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:134)at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:116)at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)at org.apache.catalina.core.StandardWrapperValve.sql语句出错,可能是中英文符号串了,或者是sql语句不完整。
阅读全文
1 0
- java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1).
- MySQL 报错:Parameter index out of range (2> number of parameters, which is 1)
- Parameter index out of range (2 > number of parameters, which is 1).
- Parameter index out of range (2 > number of parameters, which is 1)
- mysql Parameter index out of range (2 > number of parameters, which is 1).
- 兔子--Parameter index out of range (3 > number of parameters, which is 2).
- Parameter index out of range (3 > number of parameters, which is 2).
- java.sql.SQLException: Parameter index out of range (3 > number of parameters, which is 2).
- Parameter index out of range (1 > number of parameters, which is 0)
- Parameter index out of range (1 > number of parameters, which is 0)
- Parameter index out of range (1 > number of parameters, which is 0).] with r
- 操作MySQL数据库报出:Parameter index out of range (1 > number of parameters, which is
- java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
- ibatis Parameter index out of range (1 > number of parameters, which is 0)
- mybatis Parameter index out of range (1 > number of parameters, which is 0)
- Parameter index out of range (1 > number of parameters, which is 0).
- sql异常之Parameter index out of range (1 > number of parameters, which is 0)
- java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0)
- How To Build A Pipeline
- OJ 2691: 输出一定范围内的素数
- 【oracle】事务更新及处理
- 2016 ACM-ICPC Asia Regional A – Best Matched Pair(打表)
- 项目笔记001(前端框架学习)
- Parameter index out of range (2 > number of parameters, which is 1)
- 线性表的顺序存储——顺序表
- DB中Oracle with as 用法
- Java中的栈、堆和方法区
- 见贤思齐焉
- week_2_Add Two Numbers
- MyBatis--动态代理
- 【oracle】替代变量
- C语言实现冒泡排序算法(升序)