mybatis多参数传递问题 Parameter 'usersId' not found. Available parameters are [arg1, arg0, param1, param2]]

最新推荐文章于 2024-04-06 00:24:10 发布
最新推荐文章于 2024-04-06 00:24:10 发布
阅读量644 收藏
点赞数
分类专栏： 常见异常
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_41553871/article/details/90213260
版权

异常信息

五月 14, 2019 7:14:29 下午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet [springmvc] in context with path [/ssm-web] threw exception [Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter 'usersId' not found. Available parameters are [arg1, arg0, param1, param2]] with root cause
org.apache.ibatis.binding.BindingException: Parameter 'usersId' not found. Available parameters are [arg1, arg0, param1, param2]
	at org.apache.ibatis.binding.MapperMethod$ParamMap.get(MapperMethod.java:202)
	at org.apache.ibatis.reflection.wrapper.MapWrapper.get(MapWrapper.java:45)
	at org.apache.ibatis.reflection.MetaObject.getValue(MetaObject.java:122)
	at org.apache.ibatis.scripting.defaults.DefaultParameterHandler.setParameters(DefaultParameterHandler.java:79)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.parameterize(PreparedStatementHandler.java:93)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.parameterize(RoutingStatementHandler.java:64)
	at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:86)
	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:49)
	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
	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.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
	at com.sun.proxy.$Proxy62.update(Unknown Source)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:185)
	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:434)
	at com.sun.proxy.$Proxy40.insert(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:279)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:57)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
	at com.sun.proxy.$Proxy53.insUsersRolesByUsersIdRoleId(Unknown Source)
	at ssm_service.Impl.IUserServiceImpl.insUsersRoles(IUserServiceImpl.java:86)
	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:338)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:197)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
	at com.sun.proxy.$Proxy54.insUsersRoles(Unknown Source)
	at controller.IUsersController.addUsersRoles(IUsersController.java:77)
	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:209)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:871)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:777)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:991)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:978)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:881)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:855)
	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:200)
	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.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
	at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
	at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
	at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
	at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
	at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
	at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
	at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
	at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
	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.invoke(StandardWrapperValve.java:222)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:748)

写的代码

    @Insert("insert into users_role values(#{usersId},#{roleId})")
    int insUsersRolesByUsersIdRoleId(String usersId,String roleId);

解决办法一

直接将参数换成arg0，arg1或者param1，param2两种都可以

    @Insert("insert into users_role values(#{arg0},#{arg1})")
    int insUsersRolesByUsersIdRoleId(String usersId,String roleId);

    @Insert("insert into users_role values(#{param1},#{param2})")
    int insUsersRolesByUsersIdRoleId(String usersId,String roleId);

解决办法二

在参数前面加注解@Param（“名字”）

 @Insert("insert into users_role values(#{usersId},#{roleId})")
    int insUsersRolesByUsersIdRoleId(@Param("usersId") String usersId,@Param("roleId") String roleId);
阮世
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
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] 错误时可能的一种情况，希望对你有帮助
Parameter 'userid' not found. Available parameters are [arg1, arg0, param1, param2]的解决办法
热门推荐
fenger_c的博客
02-02 2万+
HTTP Status 500 – Internal Server Error Type异常报告 消息Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.Bindin...
已解决：Parameter ‘sessionId‘ not found. Available parameters are [arg1, arg0, param1, param2]
最新发布
qq_45559559的博客
04-06 266
这种错误应该是参数有多个，没有指定名称导致的，所以当参数有多个时，我们需要指定参数名称要在mapper接口中使用@Param注解指定名称。
BindingException: Parameter ‘username‘ not found. Available parameters are [arg1, arg0, param1, para
weixin_53907265的博客
10-27 1035
idea报错如下： Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: P
Parameter 'userId' not found. Available parameters are [arg1, arg0, param1, param2]
qq_44161999的博客
04-17 1596
原因：有多个参数映射时，需加@param注解 修改前： 修改后：
解决nested exception is org.apache.ibatis.binding.BindingException: Parameter ‘userid‘ not found
Elltor
07-09 2803
报错 Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter ‘userid’ not found. Available parameters are [arg1, arg0, param1, param2] 原因 Mybatis参数映射出
MyBatis3传递多个参数(Multiple Parameters)
08-18
主要介绍了MyBatis3传递多个参数，文中通过示例代码介绍的非常详细，对大家的学习或者工作具有一定的参考学习价值，需要的朋友们下面随着小编来一起学习学习吧
mybatis-demo9-方法多参数@Param.zip
08-05
方法多参数@Param。
mybatis多个接口参数的注解使用方式（@Param)
08-26
主要介绍了mybatis多个接口参数的注解使用方式（@Param),小编觉得挺不错的，现在分享给大家，也给大家做个参考。一起跟随小编过来看看吧
mybatis利用association或collection传递多参数子查询
08-26
今天小编就为大家分享一篇关于mybatis利用association或collection传递多参数子查询，小编觉得内容挺不错的，现在分享给大家，具有很好的参考价值，需要的朋友一起跟随小编来看看吧
Mybatis多参数及实体对象传递实例讲解
08-31
在使用Mybatis的时候，经常会有各种各样的参数传递，不同类型，不同个数的参数，下面小编通过例子给大家讲解下Mybatis多参数及实体对象传递，一起看看吧
Parameter ‘username‘ not found. Available parameters are [arg1, arg0, param1, param2]解决
qq_35860810的博客
11-28 1868
Parameter 'username' not found. Available parameters are [arg1, arg0, param1, param2]解决
Parameter ‘userid‘ not found. Available parameters are [arg1, arg0, param1, param2] 解决
赵小轩的博客
03-23 9236
Parameter ‘userid’ not found. Available parameters are [arg1, arg0, param1, param2] mapper.java导包
使用Mybatis时发生的错误 Parameter 'userId' not found. Available parameters are [arg1, arg0, param1, param2]
pan_you0的博客
06-06 5322
做项目的时候，出现的一个小错误，刚开始还是为是Mapper接口写的参数名与XML中的SQL定义中取值时写的参数名不一致。后来发现我在Mapper接口文件中没有使用@Param注解。错误修正前，xml和Mapper中的代码如下：    xml中的SQL查询语句：select <include refid="Base_Column_List" /> from XXX where u_id...
BindingException: Parameter 'username' not found. Available parameters are [1, 0, param1, param2]
a_newbird的博客
02-09 3162
练习ssm时，使用mybatis进行查询报org.apache.ibatis.binding.BindingException: Parameter 'username' not found. Available parameters are [1, 0, param1, param2] 1.代码如下： mapper层UsersMapper接口代码如下： @Select(value="sel...
Parameter ‘courseId‘ not found. Available parameters are [arg1, arg0, param1, para
weixin_46071647的博客
07-31 320
传参问题xml [arg1, arg0, param1, param2]
Mybatis出现 Parameter ‘active_id‘ not found. Available parameters are [arg1, arg0, param1, param2]问题
u013744998的博客
03-26 177
将Mapper里面对应的值换为 [arg1, arg0, param1, param2]里面的 如上图。
错误Parameter 'userId' not found. Available parameters are [arg1, arg0, param1, param2]
a1694375032的博客
09-06 4999
mybatis中传入多个参数时，应该使用@param注解 @Insert("insert into users_role(userId, roleId) values (#{userId}, #{roleId})") void addRoleToUser(@Param("userId") String userId, @Param("roleId") String roleId); ...
解决@org.apache.ibatis.binding.BindingException: Parameter ‘username‘ not found. Available parameters
qq_45882125的博客
01-03 1262
解决@org.apache.ibatis.binding.BindingException: Parameter ‘username’ not found. Available parameters are [arg1, arg0, param1, param2] 报错详细信息 造成原因: Mybatis没有匹配到这个参数或者找到相对应的参数 解决方法 检查Dao/Mapper层 ...
Parameter 'staffId' not found. Available parameters are [arg1, arg0, param1, param2]
12-22
根据提供的引用内容，错误信息"Parameter 'staffId' not found. Available parameters are [arg1, arg0, param1, param2]"表示在查询中找不到名为'staffId'的参数，可用的参数是[arg1, arg0, param1, param2]。这个错误通常发生在使用MyBatis进行数据库查询时，可能是由于参数名拼写错误或者查询语句中没有正确引用参数导致的。 为了解决这个问题，你可以按照以下步骤进行排查和修复： 1. 检查参数名是否正确拼写，确保在查询语句中使用的参数名与代码中传入的参数名一致。 2. 确保在查询语句中正确引用了参数。在MyBatis中，可以使用#{paramName}的形式引用参数，例如#{staffId}。 3. 如果你使用了foreach循环进行参数的拼接，确保循环中的参数名与查询语句中引用的参数名一致。 以下是一个示例查询语句的修复方法： ```xml SELECT stafid, companyId, area FROM user <trim prefix="GROUP BY" suffixOverrides=","> <if test="staffId != null"> t.staffId, </if> <if test="companyId != null"> t.companyId, </if> <if test="area != null"> area, </if> </trim> ``` 修复后的查询语句中使用了正确的参数引用方式，并且参数名与代码中传入的参数名一致。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值