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.SysUserServiceImpl.java

License:Apache License

/**
 * ??/*ww  w  .  j a  v a2 s .  co  m*/
 * 
 * @param searchWord
 * 
 * @param pageNo
 * 
 * @param pageSize
 * 
 * @return
 */
public PageResult getDeptUserList(String searchWord, int pageNo, int pageSize) {
    SysUserQuery query = new SysUserQuery();
    query.searchWord(searchWord);
    // 
    PageResult pager = new PageResult();
    int count = sysUserMapper.getCountDeptUsers(query);

    if (count == 0) {// 
        pager.setPageSize(pageSize);
        return pager;
    }

    int start = pageSize * (pageNo - 1);
    RowBounds rowBounds = new RowBounds(start, pageSize);
    List<SysUser> list = sqlSessionTemplate.selectList("getDeptUsers", query, rowBounds);
    this.initUserDepartments(list);
    pager.setResults(list);
    pager.setPageSize(pageSize);
    pager.setCurrentPageNo(pageNo);
    pager.setTotalRecordCount(count);

    return pager;
}

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

License:Apache License

public List<SysUser> getDeptUsers(String searchWord, int pageNo, int pageSize) {
    SysUserQuery query = new SysUserQuery();
    query.searchWord(searchWord);// w  ww  . j a v a  2s .  c o  m
    int start = pageSize * (pageNo - 1);
    RowBounds rowBounds = new RowBounds(start, pageSize);
    List<SysUser> list = sqlSessionTemplate.selectList("getDeptUsers", query, rowBounds);
    this.initUserDepartments(list);
    return list;
}

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

License:Apache License

public List<SysUser> getSysUsersByQueryCriteria(int start, int pageSize, SysUserQuery query) {
    RowBounds rowBounds = new RowBounds(start, pageSize);
    List<SysUser> rows = sqlSessionTemplate.selectList("getSysUsers", query, rowBounds);
    this.initUserDepartments(rows);
    return rows;//from   ww w . ja v  a2 s .  com
}

From source file:com.glaf.base.modules.workspace.service.mybatis.MessageServiceImpl.java

License:Apache License

public List<Message> getMessagesByQueryCriteria(int start, int pageSize, MessageQuery query) {
    RowBounds rowBounds = new RowBounds(start, pageSize);
    List<Message> rows = sqlSessionTemplate.selectList("getMessages", query, rowBounds);
    if (rows != null && !rows.isEmpty()) {
        List<SysUser> users = sysUserService.getSysUserList();
        Map<Long, SysUser> userMap = new java.util.HashMap<Long, SysUser>();
        for (SysUser user : users) {
            userMap.put(user.getId(), user);
        }/* w  ww  .  j a v a  2 s . co m*/
        for (Message message : rows) {
            message.setRecver(userMap.get(message.getRecverId()));
            message.setSender(userMap.get(message.getSenderId()));
        }
    }
    return rows;
}

From source file:com.glaf.base.modules.workspace.service.mybatis.MyMenuServiceImpl.java

License:Apache License

public List<MyMenu> getMyMenusByQueryCriteria(int start, int pageSize, MyMenuQuery query) {
    RowBounds rowBounds = new RowBounds(start, pageSize);
    List<MyMenu> rows = sqlSessionTemplate.selectList("getMyMenus", query, rowBounds);
    return rows;//from   w  ww . jav a 2s.  co m
}

From source file:com.glaf.base.online.service.UserOnlineLogServiceImpl.java

License:Apache License

public List<UserOnlineLog> getUserOnlineLogsByQueryCriteria(int start, int pageSize, UserOnlineLogQuery query) {
    RowBounds rowBounds = new RowBounds(start, pageSize);
    List<UserOnlineLog> rows = sqlSessionTemplate.selectList("getUserOnlineLogs", query, rowBounds);
    return rows;//from  w  w  w. j  a  va 2s  .  c  o m
}

From source file:com.glaf.base.online.service.UserOnlineServiceImpl.java

License:Apache License

public List<UserOnline> getUserOnlinesByQueryCriteria(int start, int pageSize, UserOnlineQuery query) {
    RowBounds rowBounds = new RowBounds(start, pageSize);
    List<UserOnline> rows = sqlSessionTemplate.selectList("getUserOnlines", query, rowBounds);
    return rows;// w  w  w  .  j ava  2s . com
}

From source file:com.glaf.batch.service.impl.MxJobDefinitionServiceImpl.java

License:Apache License

public List<JobDefinition> getJobDefinitionsByQueryCriteria(int start, int pageSize, JobDefinitionQuery query) {
    RowBounds rowBounds = new RowBounds(start, pageSize);
    List<JobDefinition> rows = sqlSessionTemplate.selectList("getJobDefinitions", query, rowBounds);
    return rows;//w  w  w  . j  a  v  a 2  s .  c  o  m
}

From source file:com.glaf.batch.service.impl.MxJobServiceImpl.java

License:Apache License

public List<JobInstance> getJobInstances(String jobName, int start, int limit) {
    JobInstanceQuery query = new JobInstanceQuery();
    query.jobName(jobName);/*from  w w w.  j a v  a 2s  .  com*/
    RowBounds rowBounds = new RowBounds(start, limit);
    List<JobInstance> rows = sqlSession.selectList("getJobInstances", query, rowBounds);
    return rows;
}

From source file:com.glaf.batch.service.impl.MxJobServiceImpl.java

License:Apache License

/**
 * ????//w w w .  ja  v  a2s  .  c  o  m
 * 
 * @return
 */
public List<JobInstance> getJobInstancesByQueryCriteria(int start, int pageSize, JobInstanceQuery query) {
    RowBounds rowBounds = new RowBounds(start, pageSize);
    List<JobInstance> rows = sqlSession.selectList("getJobInstances", query, rowBounds);
    return rows;
}