mybait 分页查询报错

报错信息如下

Caused by: org.apache.ibatis.binding.BindingException: Parameter 'pageNumber' not found. Available parameters are [arg1, arg0, param1, param2]

at org.apache.ibatis.binding.MapperMethod$ParamMap.get(MapperMethod.java:202)

at org.apache.ibatis.reflection.wrapper.MapWrapper.get(MapWrapper.java:45)

at org.apache.ibatis.reflection.MetaObject.getValue(MetaObject.java:122)

at org.apache.ibatis.executor.BaseExecutor.createCacheKey(BaseExecutor.java:219)

at org.apache.ibatis.executor.CachingExecutor.createCacheKey(CachingExecutor.java:146)

at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:82)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)

... 55 more

dao层

@Repository

public interfaceProductDao {

publicList findAll();

public voidadd(Productproduct);

publicList searchList(@Param("pageNumber")intpageNumber,@Param("pageSize")intpageSize);

}

查找资料之后发现mybaits方法传多个参数时候需要加上@param注解

xml文件

最后编辑于
©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容