Spring错误:org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.B
来源:互联网 发布:系统优化软件排行榜 编辑:程序博客网 时间:2024/04/26 09:09
使用springmvc+mybaties出现如下错误:
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter 'user_type' not found. Available parameters are [2, 1, 0, param1, param2, param3]
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:75)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:368)
at com.sun.proxy.$Proxy37.selectOne(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:163)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:63)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:43)
at com.sun.proxy.$Proxy41.getUserByPasswordAndType(Unknown Source)
at cn.piaole.mybatis.demo.core.service.impl.UserServiceImpl.register(UserServiceImpl.java:42)
at cn.piaole.mybatis.demo.action.RegisterAction.register(RegisterAction.java:51)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
原因:
其实是忘了使用@Param,当只有一个参数时,Mapper中可以不使用
public User getUser(String name);
但是当你有多个参数时就必须使用
public User getUser(@Param("name") String name,@Param("password") String password);
- Spring错误:org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.B
- mybatis异常:org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.B
- Spring错误:org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.Bi
- Spring错误:org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.Bi
- Spring+MyBatis 错误:org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.b
- mybatis 异常 org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding
- org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingExce
- Spring+mybatis错误:org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.bi
- mybatis报错:org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exception
- MyBatis批量更新报错org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.bindin
- org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.Persiste
- org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.executor.ExecutorEx
- org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.reflection.Reflecti
- org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.reflection.
- org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.reflection.Reflecti
- org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.reflection.Reflecti
- org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.Persiste
- org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.builder.BuilderExce
- Linux内核---41.arm 内存初始化
- 小马哥--高仿三星G9200 主板型号A208刷机拆机主板图
- android图片压缩处理
- 解决Eclipse使用Material Design风格出错问题
- Linux内核---42.arm 内存初始化2
- Spring错误:org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.B
- AJAX实现三级菜单联动
- greenDao框架浅入深出
- [Java]读取文件方法大全
- 数论快速入门(同余、扩展欧几里德、中国剩余定理、大素数测定和整数分解、素数三种筛法、欧拉函数以及各种模板)
- Install Shield教程
- scrapy简单爬取内容
- HDU-1850-Being a Good Boy in Spring Festival【Nim博弈】
- Linux内核---43.文件系统的挂载