mapper.java里的方法 public int geCountByUser(@Param("year")Integer year, @Param("user")String user )
mapper.xml <select id="geCountByUser" resultType="Integer"> select count(*) from t_user where year(create_time) = #{year} and create_number= #{user} </select>
报错提示:
Parameter ‘year‘ not found. Available parameters are [arg1, arg0, param1, param2]
解决办法:
idea工具开发,直接alt+回车键快捷导入包,没太注意引错了,编译也没报错导入了
应该导入:import org.apache.ibatis.annotations.Param