Parameter 'id' not found. Available parameters are [0, 1, param1, param2]
来源:互联网 发布:股票数据接口 刷新 编辑:程序博客网 时间:2024/05/18 08:40
报错:
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter 'userid' not found. Available parameters are [0, 1, param1, param2] org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:76) org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:421) com.sun.proxy.$Proxy17.selectOne(Unknown Source) org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:166) org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:69) org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
............
解决办法:
Mapper.java中原来是:
int identifyAuth_repository(Integer userid,Integer permissionid);
修改为:
int identifyAuth_repository(@Param("userid")Integer userid,@Param("permissionid")Integer permissionid);
- Parameter 'id' not found. Available parameters are [0, 1, param1, param2]
- Parameter 'id名' not found. Available parameters are [1, 0, param1, param2]
- Parameter 'id' not found. Available parameters are [0, 1, 2, param3, param1, param2]
- Parameter 'id' not found. Available parameters are [0, 1, 2, param3, param1, param2]
- Parameter 'id' not found. Available parameters are [0, 1, 2, param3, param1, param2]
- Parameter 'id' not found. Available parameters are [0, 1, 2, param3, param1, param2]
- Mybatis错误:Parameter 'XXX' not found. Available parameters are [1, 0, param1, param2]
- Parameter 'xxx' not found. Available parameters are [1, 0, param1, param2]
- MyBites:Parameter 'wechatId' not found. Available parameters are [2, 1, 0, param1, param2, param3]
- Mybatis错误:Parameter 'XXX' not found. Available parameters are [1, 0, param1, param2]
- Parameter not found.Available parameters are [0, 1, 2, param3, param1, param2]
- 【Mybatis】Parameter 'xxx' not found. Available parameters are [1, 0, param1, param2]
- Parameter 'userName' not found. Available parameters are [1, 0, param1, param2]
- Parameter 'book' not found. Available parameters are [0, 1, param1, param2]
- mybatis报错 Parameter 'list' not found. Available parameters are [1, 0, param1, param2]
- Mybatis错误:Parameter 'XXX' not found. Available parameters are [1, 0, param1, param2]
- Parameter 'xxx' not found. Available parameters are [3, 2, 1, 0, param1, param2, param3, para
- Parameter 'name' not found. Available parameters are [0, 1, param1, param2]
- Hibernate框架学习(二)
- angularJS 1和2的区别
- Git 本地仓库管理
- 设计模式六大原则(3):依赖倒置原则
- xml基本语法
- Parameter 'id' not found. Available parameters are [0, 1, param1, param2]
- markdown编辑器简单使用说明
- Hibernate框架学习(三) 关系映射
- ruby奇技淫巧 之 字符串格式化和进制转换
- 基础备忘:细说new与malloc的10点区别
- 使用canvas和js实现多种图形拖动效果
- dubbo的负载均衡的几种算法
- pwd
- SQL语句执行顺序