测试Service类时报错:org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter 'loginId' not found. Available parameters are [arg1, arg0, param1, param2]
原因and要和@param配合使用
错误的写法:
@Select("select * from t_user_basic where loginId=#{loginId} and pwd=#{pwd}") public UserBasic getUserBasic(String loginId, String pwd);
更正:
@Select("select * from t_user_basic where loginId=#{loginId} and pwd=#{pwd}") public UserBasic getUserBasic(@Param("loginId") String loginId, @Param("pwd") String pwd) ;
就是说在形参列表里用@Param声明一下