Mybatis错误:Parameter 'XXX' not found. Available parameters are [1, 0, param1, param2]
来源:互联网 发布:农业大数据方案 编辑:程序博客网 时间:2024/06/06 04:53
这个问题我遇到了两次,我也不太清楚到底是什么原因,先贴出解决方案吧
修改前的代码:
@Select("select * from fruitsell where f_id=#{f_id} and u_id=#{u_id}")public Fruitsell finbyfruitsell(Long f_id,Long u_id);
修改后的代码:
@Select("select * from fruitsell where f_id=#{0} and u_id=#{1}")public Fruitsell finbyfruitsell(Long f_id,Long u_id);
总结:原本用的是名称匹配发现不可以,我就换成了0、1、2、3这样的方式序列匹配。
如果还是解决不了的话可能是参数类型不一致或者其中参数为NULL。
后续补充
错误 : ${Name}
正确:${name}
因为EL是读取属性的getter方法的,一般按照属性首字母小写来处理.
4 0
- Mybatis错误:Parameter 'XXX' not found. Available parameters are [1, 0, param1, param2]
- Mybatis错误:Parameter 'XXX' not found. Available parameters are [1, 0, param1, param2]
- Mybatis错误:Parameter 'XXX' not found. Available parameters are [1, 0, param1, param2]
- Mybatis错误:Parameter 'XXX' not found. Available parameters are [1, 0, param1, param2]
- MyBatis:Parameter 'xxx' not found. Available parameters are [1, 0, param1, param2]错误
- Mybatis错误:Parameter 'XXX' not found. Available parameters are [1, 0, param1, param2]
- Mybatis错误:Parameter 'XXX' not found. Available parameters are [1, 0, param1, param2]
- Mybatis错误:Parameter 'XXX' not found. Available parameters are [1, 0, param1, param2]
- MyBatis:Parameter 'xxx' 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 [0, 1, 2, param3, param1, param2]错误
- 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 'xxx' not found. Available parameters are [1, 0, param1, param2]
- mybatisy异常 Parameter 'xxx' not found. Available parameters are[1, 0, param1, param2]
- mybatis错误: Parameter 'XXX' not found. Available parameters are [0, 1,2, param5, param2]
- mybatis报错 Parameter 'list' not found. Available parameters are [1, 0, param1, param2]
- MyBatis报错: Parameter '*' not found. Available parameters are [1, 0, param1, param2]
- linux文件和目录权限
- Android系统自带样式(android:theme)(转)
- OpenSSL再曝CCS注入漏洞-心伤未愈又成筛子
- 黑马程序员-java学习方法
- MyEclipse6.5集成Axis2和部署步骤
- Mybatis错误:Parameter 'XXX' not found. Available parameters are [1, 0, param1, param2]
- mysql 建立索引
- C++类的Constructors,Copy,Assignment,Destruction(二)
- 黑马程序员-Java入门需掌握的30个基本概念
- 常用排序算法总结与分析(含全部源码)
- OCP 1Z0 052 11
- Remove Duplicates from Sorted Array II
- 一种对拉格朗日乘子的直观理解
- leedcode做题总结,题目Reverse Words in a String14/03/05