mybait 分页查询报错

2017-06-26  本文已影响0人  左洁

报错信息如下

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文件

上一篇 下一篇

猜你喜欢

热点阅读