HTTP Status 500 - Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter 'loginname' not found. Available parameters are [arg1, arg0, param1, param2]
【报错原因】映射器需要传递多个参数,如下:
<select id="selectUserByLoginnamePwd" resultType="com.study.pojo.User">
select * from User where loginname = #{loginname} and password = #{password}
</select>
【解决办法】加上@Param注解
User selectUserByLoginnamePwd(@Param("loginname") String loginname,@Param("password") String password);
理论上不添加@Param注解,MyBatis会根据参数的顺序位置和SQL语句的表达式进行映射,但是不知道为什么就是报错