成功解决报错：batis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.Bind

成功解决报错：batis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.Bind

测试Service类时报错&#batis.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声明一下