Parameter 'userName' not found. Available parameters are [0, 1, 2, param3, param1, param2]

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>