Mybatis 报错`Parameter '0' not found. Available parameters are [arg1, arg0, param1, param2]`

1.异常信息:

Parameter ‘0’ not found. Available parameters are [arg1, arg0, param1, param2]

这是因为mybatis的Mapper接口方法传入了多个参数,如

List<User> findByNameAndPsd(String username, String password);

配置文件:

<select id="findByNameAndPsd" parameterType="User" resultType="User">
        SELECT * FROM user WHERE username = #{username} AND password = #{password}
    </select>

2.解决办法

a. 使用#{arg0}

使用#{arg0}和#{arg1}来告诉mybatis,当前变量使用哪个参数的值

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

b.使用注解@Param

List<User> findByNameAndPsd(@Param("username") String username,@Param("password")String password);