在进行分页查询时出现了如下错误:
org.apache.ibatis.binding.BindingException: Parameter 'xxx' not found. Available parameters are {arg1,arg0,param1,param2}
代码如下:
@Select("select * from user limit #{pageNum},#{pageSize}")
List<User> selectPage(Integer pageNum, Integer pageSize);
1.尝试使用对象传递参数
@Select("select * from user limit #{pageNum,pageSize}")
List<User> selectPage( Integer pageNum, Integer pageSize);
又出现了如下错误:
Could not find value method on SQL annotation. Cause: org.apache.ibatis.builder.BuilderException: Parsing error was found in mapping #{pageNum,pageSize}. Check syntax #{property|(expression), var1=value1, var2=value2, ...}
2.在最后使用了@Param注解后解决了问题
@Select("select * from user limit #{pageNum},#{pageSize}")
List<User> selectPage(@Param("pageNum") Integer pageNum, @Param("pageSize") Integer pageSize);
注:存在对象时也需要把对象的实例写进去,如:
@Param("stu") Student stu