public List<DYRKBUser> getUserPaging(DYRKBUser user, int page, int pageSize){
int from = (page-1) * pageSize;
Map<String,Object> queryMap = new HashMap();
queryMap.put("userName","%"+user.getUserName()+"%");
queryMap.put("privilege",user.getPrivilege());
queryMap.put("from",from);
queryMap.put("pageSize",pageSize);
// user.setUserName("%"+user.getUserName()+"%");//mybatis的模糊查询
return userMapper.selectUserPaging(queryMap);
}
List<DYRKBUser> selectUserPaging(@Param("hashMapQuery") Map<String,Object> hashmap);
select
<include refid="Base_Column_List"/>
from DYRKB_USER
where ACCOUNT_STATE != 8
<if test=" hashMapQuery.privilege != null" >
and PRIVILEGE = #{ hashMapQuery.privilege}
</if>
<if test=" hashMapQuery.userName != null">
and USER_NAME like #{ hashMapQuery.userName}
</if>
limit #{ hashMapQuery.pageSize} offset #{ hashMapQuery.from}
</select>