Example usage for org.apache.ibatis.session RowBounds RowBounds

Introduction

In this page you can find the example usage for org.apache.ibatis.session RowBounds RowBounds.

Prototype

public RowBounds(int offset, int limit)

Source Link

Usage

From source file:com.glaf.base.modules.sys.service.mybatis.DictoryServiceImpl.java

License:Apache License

public List<Dictory> getDictorysByQueryCriteria(int start, int pageSize, DictoryQuery query) {
    RowBounds rowBounds = new RowBounds(start, pageSize);
    List<Dictory> rows = sqlSessionTemplate.selectList("getDictories", query, rowBounds);
    return rows;//from   w  w w . j  ava 2s .  c  om
}

From source file:com.glaf.base.modules.sys.service.mybatis.GroupServiceImpl.java

License:Apache License

public List<Group> getGroupsByQueryCriteria(int start, int pageSize, GroupQuery query) {
    RowBounds rowBounds = new RowBounds(start, pageSize);
    List<Group> rows = sqlSessionTemplate.selectList("getGroups", query, rowBounds);
    return rows;//from   w  w  w . j a va2s .  c om
}

From source file:com.glaf.base.modules.sys.service.mybatis.SysApplicationServiceImpl.java

License:Apache License

public List<SysApplication> getSysApplicationsByQueryCriteria(int start, int pageSize,
        SysApplicationQuery query) {//  w  ww  .j  ava2  s .co m
    RowBounds rowBounds = new RowBounds(start, pageSize);
    List<SysApplication> rows = sqlSessionTemplate.selectList("getSysApplications", query, rowBounds);
    return rows;
}

From source file:com.glaf.base.modules.sys.service.mybatis.SysDepartmentServiceImpl.java

License:Apache License

public List<SysDepartment> getSysDepartmentsByQueryCriteria(int start, int pageSize, SysDepartmentQuery query) {
    RowBounds rowBounds = new RowBounds(start, pageSize);
    List<SysDepartment> rows = sqlSessionTemplate.selectList("getSysDepartments", query, rowBounds);
    return rows;//w  ww. ja va2 s . c  o m
}

From source file:com.glaf.base.modules.sys.service.mybatis.SysDeptRoleServiceImpl.java

License:Apache License

public List<SysDeptRole> getSysDeptRolesByQueryCriteria(int start, int pageSize, SysDeptRoleQuery query) {
    RowBounds rowBounds = new RowBounds(start, pageSize);
    List<SysDeptRole> rows = sqlSessionTemplate.selectList("getSysDeptRoles", query, rowBounds);
    return rows;/*  ww w . j  a va  2 s.  c  om*/
}

From source file:com.glaf.base.modules.sys.service.mybatis.SysFunctionServiceImpl.java

License:Apache License

public List<SysFunction> getSysFunctionsByQueryCriteria(int start, int pageSize, SysFunctionQuery query) {
    RowBounds rowBounds = new RowBounds(start, pageSize);
    List<SysFunction> rows = sqlSessionTemplate.selectList("getSysFunctions", query, rowBounds);
    return rows;//from w w  w.j a  v a  2  s .c o m
}

From source file:com.glaf.base.modules.sys.service.mybatis.SysRoleServiceImpl.java

License:Apache License

public List<SysRole> getSysRolesByQueryCriteria(int start, int pageSize, SysRoleQuery query) {
    RowBounds rowBounds = new RowBounds(start, pageSize);
    List<SysRole> rows = sqlSessionTemplate.selectList("getSysRoles", query, rowBounds);
    return rows;/*from ww w  . jav a2s  .  c o  m*/
}

From source file:com.glaf.base.modules.sys.service.mybatis.SysTreeServiceImpl.java

License:Apache License

public List<SysTree> getSysTreesByQueryCriteria(int start, int pageSize, SysTreeQuery query) {
    RowBounds rowBounds = new RowBounds(start, pageSize);
    List<SysTree> rows = sqlSessionTemplate.selectList("getSysTrees", query, rowBounds);
    Collections.sort(rows);//from ww w  .  j a va 2s. c o m
    return rows;
}

From source file:com.glaf.base.modules.sys.service.mybatis.SysUserRoleServiceImpl.java

License:Apache License

public PageResult getAllAuthorizedUser(Map<String, String> filter) {
    int pageNo = 1;
    if ((String) filter.get("page_no") != null) {
        pageNo = Integer.parseInt((String) filter.get("page_no"));
    }/*from   w w w .ja v  a2s  .  c  o m*/
    int pageSize = 2 * Constants.PAGE_SIZE;
    if ((String) filter.get("page_size") != null) {
        pageSize = Integer.parseInt((String) filter.get("page_size"));
    }

    SysUserQuery query = new SysUserQuery();

    String deptId = (String) filter.get("deptId");
    if (deptId != null) {
        query.deptId(Long.parseLong(deptId));
    }

    String name = (String) filter.get("name");
    if (name != null) {
        query.nameLike(name);
    }

    String startDate = (String) filter.get("startDate");
    if (startDate != null) {
        query.setAvailDateStartGreaterThanOrEqual(DateUtils.toDate(startDate));
    }

    String endDate = (String) filter.get("endDate");
    if (endDate != null) {
        query.setAvailDateEndLessThanOrEqual(DateUtils.toDate(endDate));
    }

    // 
    PageResult pager = new PageResult();

    int count = sysUserMapper.getCountAuthorizedUsers(query);
    if (count == 0) {// 
        pager.setPageSize(pageSize);
        return pager;
    }
    query.setOrderBy(" E.SORT desc");

    int start = pageSize * (pageNo - 1);

    RowBounds rowBounds = new RowBounds(start, pageSize);
    List<SysUser> rows = sqlSessionTemplate.selectList("getAuthorizedUsers", query, rowBounds);
    this.initUserDepartments(rows);
    this.initUserRoles(rows);
    pager.setResults(rows);
    pager.setPageSize(pageSize);
    pager.setCurrentPageNo(pageNo);
    pager.setTotalRecordCount(count);

    return pager;
}

From source file:com.glaf.base.modules.sys.service.mybatis.SysUserRoleServiceImpl.java

License:Apache License

public List<SysUserRole> getSysUserRolesByQueryCriteria(int start, int pageSize, SysUserRoleQuery query) {
    RowBounds rowBounds = new RowBounds(start, pageSize);
    List<SysUserRole> rows = sqlSessionTemplate.selectList("getSysUserRoles", query, rowBounds);
    return rows;//  ww w .j a  va2  s.  c  o m
}