Parameter 'id' not found. Available parameters are [0, 1, 2, param3, param1, param2]
来源:互联网 发布:战舰世界 战列舰 知乎 编辑:程序博客网 时间:2024/06/08 13:27
解决的方法很简单
先说第一种
DAO层的函数方法
Public
User
selectUser(String
imgURL
,String id);
对应的Mapper.xml
<sql id="updateByPo1">
<trim prefix="set" suffixOverrides=",">
<if test="_parameter!= null">
imgURL = #{imgURL
},
</if>
</trim>
</sql>
update customer_account_info//表名
<include refid="updateByPo1"/>
where id = #{id}
</update>
修改后
<sql id="updateByPo1">
<trim prefix="set" suffixOverrides=",">
<if test="_parameter!= null">
imgURL = #{0
},
</if>
</trim>
</sql>
update customer_account_info//表名
<include refid="updateByPo1"/>
where id = #{1}
</update>
其中,#{0}代表接收的是dao层中的第一个参数,#{1}代表dao层中第二参数,更多参数一致往后加即可。
阅读全文
0 0
- 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]
- MyBites:Parameter 'wechatId' not found. Available parameters are [2, 1, 0, param1, param2, param3]
- Parameter not found.Available parameters are [0, 1, 2, param3, param1, param2]
- Parameter 'xxx' not found. Available parameters are [3, 2, 1, 0, param1, param2, param3, para
- 关于Parameter 'xxx' not found. Available parameters are [0, 1, 2, param3, param1, param2]错误
- Parameter 'userName' not found. Available parameters are [0, 1, 2, param3, param1, param2]
- Parameter '0' not found. Available parameters are [arg2, arg1, arg0, param3, param1, param2]
- Parameter '0' not found. Available parameters are [arg2, arg1, arg0, param3, param1, param2]
- Parameter 'id' not found. Available parameters are [0, 1, param1, param2]
- Parameter 'id名' not found. Available parameters are [1, 0, param1, param2]
- MyBatis3错误:Parameter 'id' not found. Available parameters are [arg2, arg1, arg0, param3, param1, par
- Mybatis错误:Parameter 'XXX' not found. Available parameters are [1, 0, param1, param2]
- 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]
- STM32程序进入HardFault_Handler
- CodeForces
- UDP和TCP
- 重识java9
- Font Awesome(二)
- Parameter 'id' not found. Available parameters are [0, 1, 2, param3, param1, param2]
- 淘宝商品库存数据包
- onMouseEnter、onMouseLeave、onMouseOver、onMouseOut冒泡事件
- python学习之路(json & pickle 模块 ---序列化,反序列化)
- Font Awesome(三)
- 凸包算法
- 重识java10
- JavaSpark-编程进阶-数值RDD管道基于分区操作
- Font Awesome(四)