aused by: org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter 'institutionCode' not found. Available parameters are [0, 1, param1, param2]
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:76)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:421)
at com.sun.proxy.$Proxy44.selectOne(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:166)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:63)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:43)
at com.sun.proxy.$Proxy80.selectByIcodeBizType(Unknown Source)
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.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)
at com.baidu.fbu.loaningdistribution.common.aop.BaseHandler.doAround(BaseHandler.java:53)
at com.baidu.fbu.loaningdistribution.common.aop.ApiDaoHandler.aopAround(ApiDaoHandler.java:51)
... 69 common frames omitted
Caused by: org.apache.ibatis.binding.BindingException: Parameter 'institutionCode' not found. Available parameters are [0, 1, param1, param2]
相关sql:
import org.springframework.data.repository.query.Param;
//import org.apache.ibatis.annotations.Param;
XXXX selectByIcodeBizType(@Param("institutionCode") String institutionCode, @Param("bizType") String bizType);
由于使用了@Param 类为: Spring相关,导致
具体参考: 使用@Param注解时注意org.springframework.data.repository.query.Param与org.apache.ibatis.annotations.Param的区别
https://blog.csdn.net/qq_42945742/article/details/87365886
在mybatis的Map类中,方法参数为多个时,前面一般需要加上@Param注解,例如
User getUser(@Param(“userId”)String userId,@Param(“password”)String password);
@Param注解分为spring的和mybatis的:
org.springframework.data.repository.query.Param与org.apache.ibatis.annotations.Param
两者的区别在于
在使用org.springframework.data.repository.query.Param时,参数要按照先后顺序传入
select * from user where user_id= #{0,jdbcType=VARCHAR} and password=#{1,jdbcType=VARCHAR}
而在使用org.apache.ibatis.annotations.Param时,只需要使用参数名即可
select * from user where user_id= #{userId,jdbcType=VARCHAR} and password=#{password,jdbcType=VARCHAR}
所以在使用上,我们一般都使用mybatis的@Param注解
————————————————
版权声明:本文为CSDN博主「 天蓝色的风」的原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/qq_42945742/article/details/87365886
所以注意: 多参数使用@Param 时, 必须使用
import org.apache.ibatis.annotations.Param 注解