Parameter 'userName' not found. Available parameters are [0, 1, 2, param3, param1, param2]
来源:互联网 发布:mac的终端是什么 编辑:程序博客网 时间:2024/06/06 00:49
spring+mybatis报错
主要原来我这样写
<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="com.psc.mrkong.func.login.mapper.LoginMapper"> <insert id="register"> insert into tb_userinfo (`name`,phone,`password`) values ( #{userName},#{phone},#{password}) </insert></mapper>
package com.psc.mrkong.func.login.mapper;import org.apache.ibatis.annotations.Param;import com.psc.mrkong.func.login.po.User;public interface LoginMapper {int register(String userName,String phone,String password);}
运行报了题目的错误:nested exception is org.apache.ibatis.binding.BindingException: Parameter 'userName' not found. Available parameters are [0, 1, 2, param3, param1, param2]
后来网上查询说是参数的问题,于是改为
package com.psc.mrkong.func.login.mapper;import org.apache.ibatis.annotations.Param;import com.psc.mrkong.func.login.po.User;public interface LoginMapper {int register(@Param("userName") String userName,@Param("phone") String phone,@Param("password") String password);}
运行正常
原来是有多个参数时,如果没有用@Param注解,mybatis就会不知道你想调用哪个参数
其实还有两个一种方法可以解决
就是将xml的sql引用参数改为如下:
<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="com.psc.mrkong.func.login.mapper.LoginMapper"> <insert id="register"> insert into tb_userinfo (`name`,phone,`password`) values ( #{0},#{1},#{2}) </insert></mapper>
阅读全文
0 0
- Parameter 'userName' 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 '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 'xxx' 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 'userName' not found. Available parameters are [1, 0, param1, param2]
- Parameter 'username' not found. Available parameters are [0, 1, 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]
- 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]
- Parameter 'book' not found. Available parameters are [0, 1, param1, param2]
- PyImport_ImportModule
- 关于SparkStreaming运行案例时控制台不打印的问题
- 数据库(表结构)设计技巧及注意事项
- JAVA NIO 例子
- Eureka 源码解析 —— 应用实例注册发现(七)之增量获取
- Parameter 'userName' not found. Available parameters are [0, 1, 2, param3, param1, param2]
- 数据结构链表习题2.27,假设以两个元素依值递增有序排列的线性表A和B分别表示两个集合,现要求另辟空间构成一个顺序链表
- CSDN 第一篇博文
- linux下启动svn实例
- Spring Cloud (19) | Eureka Server 高可用服务注册中心
- Django实现CAS+OAuth2
- demon14.5-14.6
- 合并排序,合为重
- React中setState回调