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.qq.tars.service.PatchService.java

License:Open Source License

public List<ServerPatch> getServerPatch(String application, String moduleName, int curPage, int pageSize) {
    return patchMapper.getServerPatch(application, moduleName, new RowBounds(curPage, pageSize));
}

From source file:com.qq.tars.service.server.ServerService.java

License:Open Source License

public List<ServerConf> getServerConf(String treeNodeId, int curPage, int pageSize) {
    ServerConf serverConf = getServerConf4Tree(treeNodeId);

    return serverMapper.getServerConf(StringUtils.trimToNull(serverConf.getApplication()),
            StringUtils.trimToNull(serverConf.getServerName()), "Y".equals(serverConf.getEnableSet()),
            StringUtils.trimToNull(serverConf.getSetName()), StringUtils.trimToNull(serverConf.getSetArea()),
            StringUtils.trimToNull(serverConf.getSetGroup()), new RowBounds(curPage, pageSize));
}

From source file:com.qq.tars.service.server.ServerService.java

License:Open Source License

public List<ServerConf> queryInactiveServerConfs(String application, String serverName, String nodeName,
        int curPage, int PageSize) {
    return serverMapper.queryInactiveServerConf(application, serverName, nodeName,
            new RowBounds(curPage, PageSize));
}

From source file:com.quancheng.mybatis.mapper.test.rowbounds.TestSelectRowBounds.java

License:Open Source License

@Test
public void testSelectByExample() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {/*from   w  w  w  .  j a  va  2  s  . c  o m*/
        CountryMapper mapper = sqlSession.getMapper(CountryMapper.class);
        Example example = new Example(Country.class);
        example.createCriteria().andGreaterThan("id", 100).andLessThan("id", 151);
        example.or().andLessThan("id", 41);
        List<Country> countries = mapper.selectByExampleAndRowBounds(example, new RowBounds(10, 20));
        //
        Assert.assertEquals(20, countries.size());
    } finally {
        sqlSession.close();
    }
}

From source file:com.raise.orgs.impl.persistence.entity.TableDataManager.java

License:Apache License

@SuppressWarnings("unchecked")
public TablePage getTablePage(TablePageQueryImpl tablePageQuery, int firstResult, int maxResults) {

    TablePage tablePage = new TablePage();

    @SuppressWarnings("rawtypes")
    List tableData = getDbSqlSession().getSqlSession().selectList("selectTableData", tablePageQuery,
            new RowBounds(firstResult, maxResults));

    tablePage.setTableName(tablePageQuery.getTableName());
    tablePage.setTotal(getTableCount(tablePageQuery.getTableName()));
    tablePage.setRows((List<Map<String, Object>>) tableData);
    tablePage.setFirstResult(firstResult);

    return tablePage;
}

From source file:com.rayootech.project.utils.orm.Page.java

License:Apache License

public RowBounds getRowBounds() {
    return new RowBounds(getPageSize() * (getPageNo() - 1), getPageSize());
}

From source file:com.readinglife.framework.dao.MyBatisDaoSupport.java

License:Open Source License

public <M> JsonPager<M> fetchPage(String selectId, String countId, JsonPager<M> page, Object parameter) {
    page.setTotal(selectPageCount(countId, parameter));
    //      int offset = page.getPage()>1?((page.getPage()-1)*page.getSize()):0;
    //      RowBounds rowBounds = new RowBounds(offset, page.getSize());
    RowBounds rowBounds = new RowBounds(page.getPage(), page.getSize());
    List<M> results = getSqlSession().selectList(selectId, parameter, rowBounds);
    page.setRows(results);/* w w w  . j  a  va 2 s  .  c  om*/
    return page;
}

From source file:com.saituo.talk.common.persistence.interceptor.PaginationInterceptor.java

License:Open Source License

@Override
public Object intercept(Invocation invocation) throws Throwable {

    final MappedStatement mappedStatement = (MappedStatement) invocation.getArgs()[0];

    // //?SQL//ww  w . j a  v  a  2s . c  o m
    // // if (mappedStatement.getId().matches(_SQL_PATTERN)) {
    // if (StringUtils.indexOfIgnoreCase(mappedStatement.getId(),
    // _SQL_PATTERN) != -1) {
    Object parameter = invocation.getArgs()[1];
    BoundSql boundSql = mappedStatement.getBoundSql(parameter);
    Object parameterObject = boundSql.getParameterObject();

    // ??
    Page<Object> page = null;
    if (parameterObject != null) {
        page = convertParameter(parameterObject, page);
    }

    // 
    if (page != null && page.getPageSize() != -1) {

        if (StringUtils.isBlank(boundSql.getSql())) {
            return null;
        }
        String originalSql = boundSql.getSql().trim();

        // 
        page.setCount(SQLHelper.getCount(originalSql, null, mappedStatement, parameterObject, boundSql, log));

        //   ??
        String pageSql = SQLHelper.generatePageSql(originalSql, page, DIALECT);
        // if (log.isDebugEnabled()) {
        // log.debug("PAGE SQL:" + StringUtils.replace(pageSql, "\n", ""));
        // }
        invocation.getArgs()[2] = new RowBounds(RowBounds.NO_ROW_OFFSET, RowBounds.NO_ROW_LIMIT);
        BoundSql newBoundSql = new BoundSql(mappedStatement.getConfiguration(), pageSql,
                boundSql.getParameterMappings(), boundSql.getParameterObject());
        MappedStatement newMs = copyFromMappedStatement(mappedStatement, new BoundSqlSqlSource(newBoundSql));

        invocation.getArgs()[0] = newMs;
    }
    // }
    return invocation.proceed();
}

From source file:com.sinotopia.mybatis.pagehelper.test.basic.PageHelperTest.java

License:Open Source License

/**
 * Mapper??RowBounds???xml??/* ww w.  ja  v  a 2s .  c om*/
 * <p/>
 * RowBounds??count?Page?
 * <p/>
 * ??startPagestartPage
 */
@Test
public void testMapperWithRowBounds() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {
        //?110?count
        List<Country> list = countryMapper.selectAll(new RowBounds(0, 10));
        assertEquals(10, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());
        //??
        assertEquals(1, list.get(0).getId());
        assertEquals(10, list.get(list.size() - 1).getId());

        //?210??count
        list = countryMapper.selectAll(new RowBounds(10, 10));
        assertEquals(10, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());
        //??
        assertEquals(11, list.get(0).getId());
        assertEquals(20, list.get(list.size() - 1).getId());

        //?320?count
        list = countryMapper.selectAll(new RowBounds(60, 20));
        assertEquals(20, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());
        //??
        assertEquals(61, list.get(0).getId());
        assertEquals(80, list.get(list.size() - 1).getId());

        //?startPageRowBoundsstartPage
        PageHelper.startPage(1, 20);
        list = countryMapper.selectAll(new RowBounds(60, 20));
        assertEquals(20, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());
        //??
        assertEquals(1, list.get(0).getId());
        assertEquals(20, list.get(list.size() - 1).getId());
    } finally {
        sqlSession.close();
    }
}

From source file:com.sinotopia.mybatis.pagehelper.test.basic.PageHelperTest.java

License:Open Source License

/**
 * ???RowBoundsRowBounds?count/*w w w  . j  av  a  2 s  . co  m*/
 * ??count??
 * ?count?startPage
 * <p/>
 * ?startPagestartPage?startPage??
 */
@Test
public void testNamespaceWithRowBounds() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        //?010?
        List<Country> list = sqlSession.selectList("selectAll", null, new RowBounds(0, 10));
        assertEquals(10, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());
        //??
        assertEquals(1, list.get(0).getId());
        assertEquals(10, list.get(list.size() - 1).getId());

        //?1010?
        list = sqlSession.selectList("selectAll", null, new RowBounds(10, 10));
        assertEquals(10, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());
        //??
        assertEquals(11, list.get(0).getId());
        assertEquals(20, list.get(list.size() - 1).getId());

        //?2020?
        list = sqlSession.selectList("selectAll", null, new RowBounds(20, 20));
        assertEquals(20, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());
        //??
        assertEquals(21, list.get(0).getId());
        assertEquals(40, list.get(list.size() - 1).getId());

        //?startPageRowBoundsstartPage
        PageHelper.startPage(1, 20);
        list = sqlSession.selectList("selectAll", null, new RowBounds(0, 10));
        assertEquals(20, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());
        //??
        assertEquals(1, list.get(0).getId());
        assertEquals(20, list.get(list.size() - 1).getId());
    } finally {
        sqlSession.close();
    }
}