message Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: ne

最新推荐文章于 2024-06-21 15:21:23 发布

原创最新推荐文章于 2024-06-21 15:21:23 发布 · 5.2k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#@Param #not fund

本文详细解析了在使用MyBatis框架时遇到的参数绑定异常问题，具体表现为Parameter 'email' not found错误，并提供了有效的解决方案，即通过在Mapper文件中使用@Param注解来正确绑定参数。

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter 'email' not found. Available parameters are [1, 0, param1, param2]
    at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
    at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:364)
    at com.sun.proxy.$Proxy15.selectList(Unknown Source)
    at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:194)
    at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:114)
    at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:58)
    at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:43)
    at com.sun.proxy.$Proxy17.getSCBycouAndcla(Unknown Source)
    at cn.springmvc.serviceiml.SortCourseServiceIml.addSCs(Unknown Source)
    at cn.springmvc.controller.SortCourseController.leadinSCs(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at