Parameter 'yearid' not found. Available parameters are [0, 2, month, param3, param1, param2]--问题解决

 Resolving exception from handler [public java.util.List<com.shenshou.postalbank.dao.pojo.TCompanyAssess> com.shenshou.postalbank.controller.CompanyAssessController.getCompanyAssessList(java.lang.Integer,java.lang.Integer,java.lang.String)]: org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter 'yearid' not found. Available parameters are [0, 2, month, param3, param1, param2]

  

   
   2019-02-20 10:00 -DEBUG (DispatcherServlet.java:1197)- Handler execution resulted in exception - forwarding to resolved error view: ModelAndView: reference to view with name 'error'; model is {success=false, message=System error}
    org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter 'yearid' not found. Available parameters are [0, 2, month, param3, param1, param2]
    	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:75)
    	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:371)
    	at com.sun.proxy.$Proxy32.selectList(Unknown Source)
    	at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:198)
    	at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:119)
    	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:63)

遇到这样的问题时我们可以查找相对应mapper文件，是否缺少@Param(" xxx")