报错：Available parameters are [arg

1. mybatis和spring mvc整合项目中报错

Available parameters are [arg1, arg0, param1, param2]

原因：userMapper.java接口中传入了多个参数如：

User login(String username, String password);
User login(@Param("username") String username, @Param("password") String password);

userMapper.xml文件

  <resultMap id="LoginResultMap" type="com.basic.entity.User">
    <result property="id" column="id"/>
    <result property="username" column="username"/>
    <result property="password" column="password"/>
  </resultMap>

  <select id="login" parameterType="String" resultMap="LoginResultMap">
    SELECT * FROM user WHERE username = #{username} AND password = #{password}
  </select>

2. 解决
   • 方法一：使用#{arg0}和#{arg1}确认使用哪个参数的值

  <select id="login" parameterType="User" resultMap="LoginResultMap">
    SELECT * FROM user WHERE username = #{arg0} AND password = #{arg1}
  </select>

• 方法二：使用@Param注解

User login(@Param("username") String username, @Param("password") String password);

参考
https://blog.csdn.net/zzzgd_666/article/details/81811332