异常：java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0)

最新推荐文章于 2025-06-16 09:33:14 发布
最新推荐文章于 2025-06-16 09:33:14 发布
阅读量5.9k 收藏
点赞数
CC 4.0 BY-SA版权
分类专栏： 异常 文章标签： java.sql.SQLException: Paramet
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/aimashi620/article/details/80987738
本文介绍了一个关于SpringBoot结合Mybatis和Shiro进行权限控制时出现的异常情况，并分析了异常产生的原因及解决办法。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

一、产生环境

spring Boot + Mybatis + shiro 实现权限控制功能

二、异常情况

java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964) ~[mysql-connector-java-5.1.44.jar:5.1.44]
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897) ~[mysql-connector-java-5.1.44.jar:5.1.44]
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886) ~[mysql-connector-java-5.1.44.jar:5.1.44]
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860) ~[mysql-connector-java-5.1.44.jar:5.1.44]
	at com.mysql.jdbc.PreparedStatement.checkBounds(PreparedStatement.java:3327) ~[mysql-connector-java-5.1.44.jar:5.1.44]
	at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3312) ~[mysql-connector-java-5.1.44.jar:5.1.44]
	at com.mysql.jdbc.PreparedStatement.setString(PreparedStatement.java:4027) ~[mysql-connector-java-5.1.44.jar:5.1.44]
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.setString(DruidPooledPreparedStatement.java:366) ~[druid-1.1.4.jar:1.1.4]
	at org.apache.shiro.realm.jdbc.JdbcRealm.getPasswordForUser(JdbcRealm.java:287) ~[shiro-core-1.4.0.jar:1.4.0]
	at org.apache.shiro.realm.jdbc.JdbcRealm.doGetAuthenticationInfo(JdbcRealm.java:227) ~[shiro-core-1.4.0.jar:1.4.0]
	at org.apache.shiro.realm.AuthenticatingRealm.getAuthenticationInfo(AuthenticatingRealm.java:571) ~[shiro-core-1.4.0.jar:1.4.0]
	at org.apache.shiro.authc.pam.ModularRealmAuthenticator.doSingleRealmAuthentication(ModularRealmAuthenticator.java:180) ~[shiro-core-1.4.0.jar:1.4.0]
	at org.apache.shiro.authc.pam.ModularRealmAuthenticator.doAuthenticate(ModularRealmAuthenticator.java:267) ~[shiro-core-1.4.0.jar:1.4.0]
	at org.apache.shiro.authc.AbstractAuthenticator.authenticate(AbstractAuthenticator.java:198) ~[shiro-core-1.4.0.jar:1.4.0]
	at org.apache.shiro.mgt.AuthenticatingSecurityManager.authenticate(AuthenticatingSecurityManager.java:106) ~[shiro-core-1.4.0.jar:1.4.0]
	at org.apache.shiro.mgt.DefaultSecurityManager.login(DefaultSecurityManager.java:274) ~[shiro-core-1.4.0.jar:1.4.0]
	at org.apache.shiro.subject.support.DelegatingSubject.login(DelegatingSubject.java:260) ~[shiro-core-1.4.0.jar:1.4.0]
	at com.sulong.service.impl.UserServiceImpl.login(UserServiceImpl.java:148) ~[classes/:na]
	at com.sulong.controller.UserController.login(UserController.java:47) ~[classes/:na]
	at com.sulong.controller.UserController$$FastClassBySpringCGLIB$$755e4336.invoke(<generated>) ~[classes/:na]
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) ~[spring-core-4.3.11.RELEASE.jar:4.3.11.RELEASE]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738) ~[spring-aop-4.3.11.RELEASE.jar:4.3.11.RELEASE]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) ~[spring-aop-4.3.11.RELEASE.jar:4.3.11.RELEASE]
	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85) ~[spring-aop-4.3.11.RELEASE.jar:4.3.11.RELEASE]
	at com.sulong.aop.ValidateAspect.around(ValidateAspect.java:47) ~[classes/:na]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_144]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_144]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_144]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_144]
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629) ~[spring-aop-4.3.11.RELEASE.jar:4.3.11.RELEASE]
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618) ~[spring-aop-4.3.11.RELEASE.jar:4.3.11.RELEASE]
	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70) ~[spring-aop-4.3.11.RELEASE.jar:4.3.11.RELEASE]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.3.11.RELEASE.jar:4.3.11.RELEASE]
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) ~[spring-aop-4.3.11.RELEASE.jar:4.3.11.RELEASE]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.3.11.RELEASE.jar:4.3.11.RELEASE]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673) ~[spring-aop-4.3.11.RELEASE.jar:4.3.11.RELEASE]
	at com.sulong.controller.UserController$$EnhancerBySpringCGLIB$$2b5b582d.login(<generated>) ~[classes/:na]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_144]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_144]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_144]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_144]
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205) ~[spring-web-4.3.11.RELEASE.jar:4.3.11.RELEASE]
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133) ~[spring-web-4.3.11.RELEASE.jar:4.3.11.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97) ~[spring-webmvc-4.3.11.RELEASE.jar:4.3.11.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827) ~[spring-webmvc-4.3.11.RELEASE.jar:4.3.11.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738) ~[spring-webmvc-4.3.11.RELEASE.jar:4.3.11.RELEASE]
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) ~[spring-webmvc-4.3.11.RELEASE.jar:4.3.11.RELEASE]
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967) ~[spring-webmvc-4.3.11.RELEASE.jar:4.3.11.RELEASE]
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) ~[spring-webmvc-4.3.11.RELEASE.jar:4.3.11.RELEASE]
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) ~[spring-webmvc-4.3.11.RELEASE.jar:4.3.11.RELEASE]
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872) ~[spring-webmvc-4.3.11.RELEASE.jar:4.3.11.RELEASE]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) ~[tomcat-embed-core-8.5.20.jar:8.5.20]
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) ~[spring-webmvc-4.3.11.RELEASE.jar:4.3.11.RELEASE]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) ~[tomcat-embed-core-8.5.20.jar:8.5.20]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[tomcat-embed-core-8.5.20.jar:8.5.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.20.jar:8.5.20]
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) ~[tomcat-embed-websocket-8.5.20.jar:8.5.20]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-8.5.20.jar:8.5.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.20.jar:8.5.20]
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) ~[spring-web-4.3.11.RELEASE.jar:4.3.11.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-4.3.11.RELEASE.jar:4.3.11.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-8.5.20.jar:8.5.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.20.jar:8.5.20]
	at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:108) ~[spring-web-4.3.11.RELEASE.jar:4.3.11.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-4.3.11.RELEASE.jar:4.3.11.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-8.5.20.jar:8.5.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.20.jar:8.5.20]
	at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81) ~[spring-web-4.3.11.RELEASE.jar:4.3.11.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-4.3.11.RELEASE.jar:4.3.11.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-8.5.20.jar:8.5.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.20.jar:8.5.20]
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197) ~[spring-web-4.3.11.RELEASE.jar:4.3.11.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-4.3.11.RELEASE.jar:4.3.11.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-8.5.20.jar:8.5.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.20.jar:8.5.20]
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) ~[tomcat-embed-core-8.5.20.jar:8.5.20]
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-embed-core-8.5.20.jar:8.5.20]
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478) [tomcat-embed-core-8.5.20.jar:8.5.20]
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) [tomcat-embed-core-8.5.20.jar:8.5.20]
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80) [tomcat-embed-core-8.5.20.jar:8.5.20]
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) [tomcat-embed-core-8.5.20.jar:8.5.20]
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) [tomcat-embed-core-8.5.20.jar:8.5.20]
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799) [tomcat-embed-core-8.5.20.jar:8.5.20]
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-embed-core-8.5.20.jar:8.5.20]
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-embed-core-8.5.20.jar:8.5.20]
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1457) [tomcat-embed-core-8.5.20.jar:8.5.20]
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-8.5.20.jar:8.5.20]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_144]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_144]
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-8.5.20.jar:8.5.20]
	at java.lang.Thread.run(Thread.java:748) [na:1.8.0_144]

三、产生原因

由于参数多次添加到SQL语句中

四、解决办法

把1位置的参数用？代替，因为后面有填充参数

    
        //使用自定义sql
        String sql = "select password from sl_user where account = ?";
        jdbcRealm.setAuthenticationQuery(sql);
        String roleSql = "select role from sl_user where account = ?";
        jdbcRealm.setUserRolesQuery(roleSql);


Caused by: java.sql.SQLException: Parameter index out of range (1 ＞ number of parameters, which is 0
知识改变命运，ヾ(◍°∇°◍)ﾉﾞ【求关注】
08-12 811
在编写like模糊匹配时报错
Parameter index out of range (1 > number of parameters, which is 0).
A458545418的博客
11-24 2599
数据库错误：Parameter index out of range (1 > number of parameters, which is 0). 错误发生原因其实很简单，就是当设置参数时，没有相应的问号与之匹配（或者根本就没有？号）. 如果是：Parameter index out of rang...
java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
diyingshou8608的博客
06-13 440
java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0). at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1056) at com.mysql.jdbc...
JAVA运行报错Parameter index out of range (2 ＞ number of parameters, which is 1).（已解决）
最新发布
Hello_Andrw的博客
06-16 250
MyBatis 尝试设置第 2 个参数，但是我入参只有一个，找不到对应的占位符，因为我有两个占位符，一个是正常的sql，一个是注释的sql。出现错误的原因，上面我有注释一段原有的sql，sql里面包含一个#{projectId}，没有注释的代码也有一个#{projectId}
java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0)
lijunfan_rh的博客
01-05 3万+
详细错误描述： import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Select; import cn.zw.custEntity.Cust; @Mapper public interface CustMapper { @Select("select bc.id as
java.sql.SQLException: Parameter index out of range (X ＞ number of parameters, which is X).
非专业Bug开发工程师的博客
07-16 510
开发中在使用MyBatis-Plus过程中，调用xml进行分页查询时报错：java.sql.SQLException: Parameter index out of range (X ＞ number of parameters, which is X).
java.sql.SQLException:Parameter index out of range (1＞number of paramters,which is 0)异常解决
简介
03-12 2401
java.sql.SQLException:Parameter index out of range (1>number of paramters,which is 0)异常解决 今天在编程做MySQL groupby DATE_FORMAT分组统计 写入SpringBoot项目，运行时发现出现了***java.sql.SQLException***异常，以为是查询结果接收错误，修改了半天，还是一样的异常结果。最后发现是DATE_FORMAT()中，预编译处理#{}外不需要添加’ '。问题终于解
java.sql.SQLException: Parameter index out of range (12 > numbers of parameters, which is 11).
小景的博客
04-26 1141
今天使用MyBatis的过程中遇到一个奇怪的错误，错误信息提示“参数个数不匹配”，不过我对了几遍Service、Mapper、Mapper.xml中的参数都没有发现问题。 后面注意到，在错误提示的第一行中还有一句“Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #12 with J...
使用mybatis解决sql报错： Parameter index out of range (1 ＞ number of parameters, which is 0）。
腐草灬为萤的博客
08-11 939
报的异常信息： java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0). ...... ...... ...... 修改前的代码： @Select("select * from t_goods where goodsname like '%#{goodsname}%'") @Results( { @Re
报错SQL异常：Parameter index out of range (1 ＞ number of parameters, which is 0).
cywleo的博客
12-20 1931
报错SQL异常：Parameter index out of range (1 > number of parameters, which is 0). 异常：Parameter index out of range (1 > number of parameters, which is 0). 意思是：参数索引超出范围（1>参数数，即0） sql语句错误导致的原因如下： 第一种：在问号旁边加了单引号 例1.select* from User where name = ’ ? ’ ; 这
java.sql.SQLException: Parameter index out of range (1 ＞ number of parameters, which is 0). 错误的原因
学不会就砸电脑——的博客
11-22 4722
因为我的idea设置的字体的问题，中文的问号，和，英文的问号，看起来几乎一致，导致我经常犯这种错误。使用java操作数据库的时候经常遇到这个错误，弄完之后就忘了，所以记录下来。这个错误的原因是，sql语句中的问号是中文的问号。
Java.sql.SQLException: Parameter index out of range (1 ＞ number of parameter)
c_c18的博客
11-23 3010
在上面的代码中，我们试图向数据库中的users表插入一条新的记录，传入了name和age作为参数。然而，有时候我们可能会遇到一个名为"java.sql.SQLException: Parameter index out of range (1 > number of parameter)"的异常。这个异常的意思是参数索引超出范围，通常是由于预编译的SQL语句中的参数索引与提供的参数数量不匹配所导致的。出现这个异常的原因是由于我们错误地设置了参数的索引，不匹配预编译的SQL语句中的参数索引。
[异常]java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0)
菜鸟腾飞
10-12 2536
Caused by: org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property....
报SQL异常：java.sql.SQLException: Parameter index out of range (1 ＞ number of parameters, which is 0).
weixin_46029637的博客
01-03 7818
数据库报错：java.sql.SQLException: 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).报错问题
WHT9999的博客
07-31 314
该错误属于数据库语句错误，需要调整mapper中的数据库语句，查看相关类型是否匹配。查看占位符是否匹配，有可能#{}格式不对，我的是删掉重写，然后就是。报错位置 serviceimpl调用mapper层方法。=null"写错了，修改之后。修改之后正常运行代码展示。mapper代码部分。
报SQL异常Parameter index out of range (1 ＞ number of parameters, which is 0).
热门推荐
JavaAlliance
08-17 11万+
数据库错误：Parameter index out of range (1 > number of parameters, which is 0). 错误发生原因其实很简单，就是当设置参数时，没有相应的问号与之匹配（或者根本就没有？号）. 如果是：Parameter index out of range (26 > number of paramet...
Cause: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
04-26
<think>好的，用户遇到了MyBatis的“Parameter index out of range (1 > number of parameters, which is 0)”错误，需要我帮忙解决。先回顾一下用户提供的引用内容和之前的对话。 用户之前给出的引用[1]和[2]提到...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值