Package org.apache.ibatis.session

Examples of org.apache.ibatis.session.RowBounds


     */
    @SuppressWarnings("unchecked")
    public Object execute(Object[] args) {
        final Object param = getParam(args);
        Page<Object> page;
        RowBounds rowBounds;
        if (paginationIndex != null) {
            page = (Page<Object>) args[paginationIndex];
            rowBounds =  new RowBounds(page.getFirstResult(), page.getMaxResults());
        } else if (rowBoundsIndex != null) {
            rowBounds = (RowBounds) args[rowBoundsIndex];
            page = new Page<Object>();
        } else {
            throw new BindingException("Invalid bound statement (not found rowBounds or pagination in paramenters)");
View Full Code Here


            PkfieldsExample example = new PkfieldsExample();
            example.createCriteria().andId2Between(1, 3);

            example.setOrderByClause("ID1, ID2");
            RowBounds rb = new RowBounds(2, 3);
            List<Pkfields> answer = mapper.selectByExampleWithRowbounds(example, rb);
            assertEquals(3, answer.size());
            assertEquals("Pebbles", answer.get(0).getFirstname());
            assertEquals("Barney", answer.get(1).getFirstname());
            assertEquals("Betty", answer.get(2).getFirstname());
View Full Code Here

            PkfieldsExample example = new PkfieldsExample();
            example.createCriteria().andId2Between(1, 3);

            example.setOrderByClause("ID1, ID2");
            RowBounds rb = new RowBounds(2, 3);
            List<Pkfields> answer = mapper.selectByExampleWithRowbounds(example, rb);
            assertEquals(3, answer.size());
            assertEquals("Pebbles", answer.get(0).getFirstname());
            assertEquals("Barney", answer.get(1).getFirstname());
            assertEquals("Betty", answer.get(2).getFirstname());
View Full Code Here

  void processIntercept(final Object[] queryArgs) {
    //queryArgs = query(MappedStatement ms, Object parameter, RowBounds rowBounds, ResultHandler resultHandler)
    MappedStatement ms = (MappedStatement)queryArgs[MAPPED_STATEMENT_INDEX];
    Object parameter = queryArgs[PARAMETER_INDEX];
    final RowBounds rowBounds = (RowBounds)queryArgs[ROWBOUNDS_INDEX];
    int offset = rowBounds.getOffset();
    int limit = rowBounds.getLimit();
   
    if(dialect.supportsLimit() && (offset != RowBounds.NO_ROW_OFFSET || limit != RowBounds.NO_ROW_LIMIT)) {
      BoundSql boundSql = ms.getBoundSql(parameter);
      String sql = boundSql.getSql().trim();
      if (dialect.supportsLimitOffset()) {
        sql = dialect.getLimitString(sql, offset, limit);
        offset = RowBounds.NO_ROW_OFFSET;
      } else {
        sql = dialect.getLimitString(sql, 0, limit);
      }
      limit = RowBounds.NO_ROW_LIMIT;
     
      queryArgs[ROWBOUNDS_INDEX] = new RowBounds(offset,limit);
     
      BoundSql newBoundSql = copyFromBoundSql(ms, boundSql, sql);
     
      MappedStatement newMs = copyFromMappedStatement(ms, new BoundSqlSqlSource(newBoundSql));
      queryArgs[MAPPED_STATEMENT_INDEX] = newMs;
View Full Code Here

TOP

Related Classes of org.apache.ibatis.session.RowBounds

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.