Examples of Pager

Examples of org.nutz.dao.pager.Pager

41
42
43
44
45
46
47
48
49
50
        if (null != pager && pager.getPageNumber() > 0)
            pojo.append(Pojos.Items.wrapf(" OFFSET %d ROWS FETCH NEXT %d ROW ONLY", pager.getOffset(), pager.getPageSize()));
    }
   
    public void formatQuery(Sql sql) {
        Pager pager = sql.getContext().getPager();
        // 需要进行分页
        if (null != pager && pager.getPageNumber() > 0)
            sql.setSourceSql(sql.getSourceSql() + String.format(" OFFSET %d ROWS FETCH NEXT %d ROW ONLY", pager.getOffset(), pager.getPageSize()));
    }
View Full Code Here

Examples of org.nutz.dao.pager.Pager

32
33
34
35
36
37
38
39
40
        where.setPojo(pojo);
        orderBy.setPojo(pojo);
    }

    public void setPager(int pageNumber, int pageSize) {
        pager = new Pager();
        pager.setPageNumber(pageNumber);
        pager.setPageSize(pageSize);
    }
View Full Code Here

Examples of org.nutz.dao.pager.Pager

126
127
128
129
130
131
132
133
134
135
136
137
138
139
        return true;
    }

    public void formatQuery(Pojo pojo) {
        Pager pager = pojo.getContext().getPager();
        // 需要进行分页
        if (null != pager && pager.getPageNumber() > 0) {
            pojo.insertFirst(Pojos.Items.wrap("SELECT * FROM (SELECT T.*, ROWNUM RN FROM ("));
            pojo.append(Pojos.Items.wrapf(") T WHERE ROWNUM <= %d) WHERE RN > %d",
                                          pager.getOffset() + pager.getPageSize(),
                                          pager.getOffset()));
        }
    }
View Full Code Here

Examples of org.nutz.dao.pager.Pager

138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
        }
    }

    @Override
    public void formatQuery(Sql sql) {
        Pager pager = sql.getContext().getPager();
        // 需要进行分页
        if (null != pager && pager.getPageNumber() > 0) {
            String pre = "SELECT * FROM (SELECT T.*, ROWNUM RN FROM (";
            String last = String.format(") T WHERE ROWNUM <= %d) WHERE RN > %d",
                                        pager.getOffset() + pager.getPageSize(),
                                        pager.getOffset());
            sql.setSourceSql(pre + sql.getSourceSql() + last);
        }
    }
View Full Code Here

Examples of org.nutz.dao.pager.Pager

643
644
645
646
647
648
649
650
651
652
        _exec(pojo);
        return pojo.getInt();
    }

    public Pager createPager(int pageNumber, int pageSize) {
        Pager pager = new Pager();
        pager.setPageNumber(pageNumber);
        pager.setPageSize(pageSize);
        return pager;
    }
View Full Code Here

Examples of org.nutz.dao.pager.Pager

158
159
160
161
162
163
164
165
166
167
168
169
170
171
        // 以下代码,就为了该死的游标分页!!
        // -------------------------------------------------
        int startRow = -1;
        int lastRow = -1;
        if (st.getContext().getResultSetType() == ResultSet.TYPE_SCROLL_INSENSITIVE) {
            Pager pager = st.getContext().getPager();
            if (pager != null) {
                startRow = pager.getOffset();
                lastRow = pager.getOffset() + pager.getPageSize();
            }
        }
        // -------------------------------------------------
        // 生成 Sql 语句
        String sql = st.toPreparedStatement();
View Full Code Here

Examples of org.nutz.dao.pager.Pager

204
205
206
207
208
209
210
211
212
213
214
215
    public void test_sql_pager() {
        dao.create(Pet.class, true);
        for (int i = 0; i < 100; i++) {
            dao.insert(Pet.class, Chain.make("name", "record" + i).add("nickName", "Time="+System.currentTimeMillis()));
        }
        Pager pager = dao.createPager(5, 5);
        pager.setRecordCount(dao.count(Pet.class));
        Sql sql = Sqls.queryEntity("select * from t_pet");
        sql.setEntity(dao.getEntity(Pet.class));
        sql.setPager(pager);
        dao.execute(sql);
       
View Full Code Here

Examples of org.opoo.press.Pager

155
156
157
158
159
160
161
162
163
164
165
      if(toIndex > totalPosts){
        toIndex = totalPosts;
      }
      List<Post> pagePosts = posts.subList(fromIndex, toIndex);
     
      Pager pager = new Pager(pageNumber, totalPages, totalPosts, pageSize, pagePosts);
      if(pageNumber > 1){
        PageImpl impl = new PageImpl(site, page.getSource(), pager);
//        site.getPages().add(impl);
        pages[i] = impl;
        newPages.add(impl);
View Full Code Here

Examples of org.opoo.press.Pager

143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
  public Page getPage(Page current, int targetPageNumber){
    if(current == null){
      log.warn("Current page is null, cannot found target page for pagenumber " + targetPageNumber);
      return null;
    }
    Pager pa = current.getPager();
    if(pa == null){
      log.warn("Current page is not one of a pigination page.");
      return null;
    }
    int currentPageNumber = pa.getPageNumber();
    if(currentPageNumber == targetPageNumber){
      return current;
    }else if(targetPageNumber > currentPageNumber){
      return getPage(pa.getNext(), targetPageNumber);
    }else{
      return getPage(pa.getPrevious(), targetPageNumber);
    }
  }
View Full Code Here

Examples of org.rstudio.studio.client.workbench.views.vcs.common.Pager

149
150
151
152
153
154
155
   }

   @Override
   public AbstractPager getPager()
   {
      return new Pager(100, -1);
   }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.