mybatis报错：Parameter 'DetailExamDto' not found. Available parameters are [DetailExamDto,param1]

最新推荐文章于 2024-06-12 23:38:35 发布
最新推荐文章于 2024-06-12 23:38:35 发布
阅读量1.8k 收藏
点赞数 2
分类专栏： BUG 文章标签： mybtis bug  Available parameters Parameter '' not found
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_38446250/article/details/80390752
版权

首先，以下是我的报错内容：

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter 'DetailExamDto' not found. Available parameters are [DetailExamDto,  param1]
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
	at com.sun.proxy.$Proxy100.selectList(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:238)
	at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:135)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:75)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
	at com.sun.proxy.$Proxy124.getFeed(Unknown Source)
	at com.hantek.tbbl.basicsys.service.impl.FeedbackServiceImpl.select(FeedbackServiceImpl.java:49)
	at com.hantek.tbbl.basicsys.service.impl.FeedbackServiceImpl$$FastClassBySpringCGLIB$$301149d0.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)
	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.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)
	at com.hantek.tbbl.basicsys.service.impl.FeedbackServiceImpl$$EnhancerBySpringCGLIB$$ba8d7b14.select(<generated>)
	at com.hantek.tbbl.basicsys.service.impl.FeedbackServiceImpl$$FastClassBySpringCGLIB$$301149d0.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)
	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.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)
	at com.hantek.tbbl.basicsys.service.impl.FeedbackServiceImpl$$EnhancerBySpringCGLIB$$1a062592.select(<generated>)
	at com.hantek.tbbl.basicsys.controller.FeedbackController.selectConFeed(FeedbackController.java:88)
	at com.hantek.tbbl.basicsys.controller.FeedbackController$$FastClassBySpringCGLIB$$e7752cde.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)
	at org.apache.shiro.spring.security.interceptor.AopAllianceAnnotationsAuthorizingMethodInterceptor$1.proceed(AopAllianceAnnotationsAuthorizingMethodInterceptor.java:82)
	at org.apache.shiro.authz.aop.AuthorizingMethodInterceptor.invoke(AuthorizingMethodInterceptor.java:39)
	at org.apache.shiro.spring.security.interceptor.AopAllianceAnnotationsAuthorizingMethodInterceptor.invoke(AopAllianceAnnotationsAuthorizingMethodInterceptor.java:115)
	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.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)
	at com.hantek.tbbl.basicsys.controller.FeedbackController$$EnhancerBySpringCGLIB$$3745ca03.selectConFeed(<generated>)
	at com.hantek.tbbl.basicsys.controller.FeedbackController$$FastClassBySpringCGLIB$$e7752cde.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.apache.shiro.spring.security.interceptor.AopAllianceAnnotationsAuthorizingMethodInterceptor$1.proceed(AopAllianceAnnotationsAuthorizingMethodInterceptor.java:82)
	at org.apache.shiro.authz.aop.AuthorizingMethodInterceptor.invoke(AuthorizingMethodInterceptor.java:39)
	at org.apache.shiro.spring.security.interceptor.AopAllianceAnnotationsAuthorizingMethodInterceptor.invoke(AopAllianceAnnotationsAuthorizingMethodInterceptor.java:115)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)
	at com.hantek.tbbl.basicsys.controller.FeedbackController$$EnhancerBySpringCGLIB$$f9c239b.selectConFeed(<generated>)
	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:205)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
	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:967)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
	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:661)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:112)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:112)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)
	at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
	at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
	at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
	at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347)
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	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:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.ibatis.binding.BindingException: Parameter 'replyContent' not found. Available parameters are [gmtCreate, userId, param1, param2]
	at org.apache.ibatis.binding.MapperMethod$ParamMap.get(MapperMethod.java:202)
	at org.apache.ibatis.scripting.xmltags.DynamicContext$ContextAccessor.getProperty(DynamicContext.java:115)
	at org.apache.ibatis.ognl.OgnlRuntime.getProperty(OgnlRuntime.java:2671)
	at org.apache.ibatis.ognl.ASTProperty.getValueBody(ASTProperty.java:114)
	at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)
	at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258)
	at org.apache.ibatis.ognl.ASTNotEq.getValueBody(ASTNotEq.java:50)
	at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)
	at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258)
	at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:470)
	at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:434)
	at org.apache.ibatis.scripting.xmltags.OgnlCache.getValue(OgnlCache.java:44)
	at org.apache.ibatis.scripting.xmltags.ExpressionEvaluator.evaluateBoolean(ExpressionEvaluator.java:32)
	at org.apache.ibatis.scripting.xmltags.IfSqlNode.apply(IfSqlNode.java:34)
	at org.apache.ibatis.scripting.xmltags.MixedSqlNode.apply(MixedSqlNode.java:33)
	at org.apache.ibatis.scripting.xmltags.DynamicSqlSource.getBoundSql(DynamicSqlSource.java:41)
	at org.apache.ibatis.mapping.MappedStatement.getBoundSql(MappedStatement.java:292)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
	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.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)
	... 116 more

报错是说参数"DetailExamDto"没有找到，可用的参数只有[detailExamDto,param1]中括号里面这些，这几天一直有报这个错，基本上都是因为粗心，要么是因为mapper里面的方法写了多个参数，但是没有写@Param注解；要么是因为mapper里面@Param("参数名")这里的参数名与mapper.xml里面的不匹配；要么是传的是一个对象，但是在mapper.xml里面if标签之类的对比用的直接是用的属性名而不是对象名点出属性名，具体参考还可以看下下图：


浅浅吖
关注
  • 2
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Mybatis报错: org.apache.ibatis.exceptions.PersistenceException解决办法
09-09
在使用Mybatis框架时，你可能会遇到`org.apache.ibatis.exceptions.PersistenceException`这样的异常。这个异常通常表示在执行数据库查询操作时遇到了问题。本篇将详细分析这个问题并提供解决方法。 ### 问题概述 ...
Parameter ‘xxx‘ not found. Available parameters are [param, param1]
qq_39236283的博客
08-17 6272
发生场景：mapper层方法传2个参数，默认一个参数可以不需要@Param，但传多个参数必须指定@Param(“别名”)
【报错解决：Parameter ‘id‘ not found. Available parameters are...】
R_obert的博客
11-02 4529
报错解决：org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter 'id' not found. Available parameters are...
org.apache.ibatis.binding.BindingException: Parameter not found
最新发布
sdfsdfsdfgdfg的博客
06-12 339
在mapper添加@param。
【无标题】Parameter ‘QueryProductTypeDTO‘ not found.
A_JiaoYa的博客
04-07 96
【已解决】Parameter ‘xxx‘ not found. Available parameters are [xxx,xxx]
qq_42971491的博客
08-28 313
Parameter ‘xxx‘ not found. Available parameters are [xxx,xxx]
Mybatis中发生Parameter xx not found. Available parameters are [arg1, arg0, param1, param] 错误可能的情况
Huang405267467的博客
04-10 3万+
Mybatis中发生Parameter xx not found. Available parameters are [arg1, arg0, param1, param] 错误时可能的一种情况，希望对你有帮助
mybatis中foreach报错：_frch_item_0 not found的解决方法
08-30
然而，当你遇到“_frch_item_0 not found”这样的错误时，通常是由于在使用`<foreach>`时出现了配置或编码上的问题。下面我们将深入探讨这个问题及其解决方法。 首先，我们要理解这个错误通常表示MyBatis在尝试访问...
mybatis-3-config/mapper.dtd 解决mybatis头文件报错
04-10
>Window->prefenrence->XML->XML Catalog->User Specifiled Entreis->Add->Location(此处是你放dtd文件的位置例如：‪D:\mybatis\mybatis-3-config.dtd)->Key(如果更改config，此处应该是：-//mybatis.org//DTD ...
使用mybatis-plus报错Invalid bound statement (not found)错误
09-07
在使用Mybatis-Plus时，有时开发者可能会遇到一个常见的错误——`Invalid bound statement (not found)`。这个错误意味着Mybatis-Plus无法找到对应的SQL映射语句，这通常是由于配置问题或者依赖缺失所引起的。本文将...
org.mybatis.spring.MyBatisSystemException:参数未找到（NOT FOUND）问题
qq_50975017的博客
02-04 391
在这个例子中，可能会引发报错，因为SQL语句中引用了#{dto.name}、#{dto.orgId}和#{dto.defaulted}，但方法参数并没有名为'dto'的参数。为了解决这个问题，可以从该方法签名类前往对应的mapper.xml文件SQL语句中的#{dto.name}改为#{name}，#{dto.orgId}改为#{orgId}，#{dto.defaulted}改为#{defaulted}，以匹配方法参数的属性名。
Parameter ‘**‘ not found. Available parameters are [0, 1, param1, param2]解决办法
刘大猫
11-25 2万+
发生场景：mapper层方法传2个参数，默认一个参数可以不需要@Param，但传多个参数必须指定@Param(“别名”) 说明：该问题出错在mapper层与xml层的参数设置问题 文章目录第一种情况：mapper层方法缺少@Param注解第二种情况：传2个参数都是对象的时候，而不是简单地string、int等等 第一种情况：mapper层方法缺少@Param注解 第二种情况：传2个参数都是对象的时候，而不是简单地string、int等等 出错原因：对象具体的xx属性没加对象名 出错代码： 正确代码：
Parameter '*' not found. Available parameters are [0, 1, param1, param2]解决办法
qq_41172982的博客
10-10 3万+
出现该报错的大部分原因是mapper.xml文件中的参数没有对应匹配。 当传入参数只有一个时候，就不需要设定@Param。接口参数只有一个，不管接口参数名是什么，这个时候#{xxx}没有限制，可以是0，param1，也可以是aaa,bbb。可以不加注解。 当传入的的参数>1的时候，就会出现该报错：mybatis的参数集就是上边说的默认值[0, 1, param1, param2]，如...
【多种解决方法】Parameter ‘xxx‘ not found. Available parameters are [xxx,xxx, param3, param1,param2]
热门推荐
筱筱攻程师的博客
04-02 9万+
出现这个问题是因为Mybatis识别不了你的参数列表，所以才报这个错，如下： org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter 'user_id' not found. Available parameters are [number, postId, page, param3, param1, param2] 解决过程如下
解决BindingException: Parameter ‘name‘ not found. Available parameters are [xxxx, param1, param2]
haroroc的博客
06-18 1万+
在做分页查询的时候，后台报出BindingException: Parameter ‘name‘ not found. Available parameters are [xxxx, param1, param2]错误。
Parameter ‘xxx‘ not found错误
qq_51025538的博客
11-11 6973
Parameter 'xxx' not found. Available parameters are [arg1, arg0, param1, param2]. 原因是后台接收数据应该为两个值，但是没有两个值传入，所以报此错。 在xxxService和xxxMapper的方法中加入(@Param("value") String value)，需要几个值就加入几个注解。 ...
Parameter not found或"不正常定义参数对象 提供了不一致或不完整信息"问题原因(Delphi)...
weixin_30748995的博客
09-25 1748
在使用Delphi对SQLServer进行操作时,出现了"不正常定义的参数对象,提供了不一致或者不完整信息"的异常. 原因大概有以下几种: 1.使用的parameters有无重名的. 2.是否设置了Connection或者ConnectionString. 3.确认表名是否则正确. 出现Parameter not found的原因: 1.确认参数是否写错. 2.确认是否有使用多个...
mybatis parameterType引入自定义类型报BindingException：Available parameters
B3325的博客
01-28 292
mybatis parameterType引入自定义类型报BindingException：Available parameters
Mybatis报错: Parameter ‘XXX‘ not found. Available parameters are [arg1, arg0, param1, param2]解决方案及问题原因
程序猿追的博客
08-30 1万+
哈喽~大家好，这专栏是记录经常出现的报错一些问题，这篇来看看Mybatis报错: Parameter ‘XXX‘ not found. Available parameters are [arg1, arg0, param1, param2]解决方案及问题原因。
mybatis Parameter 'balance' not found. Available parameters are [0, 1, param1, param2]]
05-31
这个错误提示通常是因为在MyBatis的SQL语句中使用了参数名，但是在执行SQL语句时没有向参数中传入对应的参数值。请检查你的SQL语句和参数传递是否正确。 如果你是使用注解的方式传递参数，可以尝试使用@Param注解来指定参数名，例如： ``` @Select("SELECT * FROM user WHERE balance > #{balance}") List<User> getUsersByBalance(@Param("balance") int balance); ``` 如果你是使用XML配置文件的方式传递参数，可以检查mapper.xml文件中是否正确指定了参数名称，例如： ``` <select id="getUsersByBalance" resultType="User"> SELECT * FROM user WHERE balance > #{balance} </select> ``` 其中#{balance}就是需要传递的参数名。确保在执行SQL语句时，向参数中传入了正确的参数值，即可解决该错误。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值