Package org.nutz.dao.pager

Examples of org.nutz.dao.pager.Pager

121
122
123
124
125
126
127
128
129
130
131
132
133
                                            pager.getOffset()));
        }
    }

    public void formatQuery(Sql sql) {
        Pager pager = sql.getContext().getPager();
        if (null != pager && pager.getPageNumber() > 0) {
            // See http://hsqldb.org/doc/guide/ch09.html#select-section
            sql.setSourceSql(sql.getSourceSql() + String.format(" LIMIT %d offset %d",
                                            pager.getPageSize(),
                                            pager.getOffset()));
        }
    }
View Full Code Here
12
13
14
15
16
17
18
19
20
21
    public Sqlserver2012JdbcExpert(JdbcExpertConfigFile conf) {
        super(conf);
    }

    public void formatQuery(Pojo pojo) {
        Pager pager = pojo.getContext().getPager();
        // 需要进行分页
        if (null != pager && pager.getPageNumber() > 0)
            pojo.append(Pojos.Items.wrapf(" OFFSET %d ROWS FETCH NEXT %d ROW ONLY", pager.getOffset(), pager.getPageSize()));
    }
View Full Code Here
19
20
21
22
23
24
25
26
27
28
        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
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
        }
        return super.evalFieldType(mf);
    }

    public void formatQuery(Pojo pojo) {
        Pager pager = pojo.getContext().getPager();
        // 需要进行分页
        if (null != pager && pager.getPageNumber() > 0) {
            // 之前插入
            pojo.insertFirst(Pojos.Items.wrap("SELECT * FROM ("
                                                + "SELECT ROW_NUMBER() OVER() AS ROWNUM, "
                                                + "T.* FROM ("));
            // 之后插入
            pojo.append(Pojos.Items.wrapf(    ") T) AS A WHERE ROWNUM BETWEEN %d AND %d",
                                            pager.getOffset() + 1,
                                            pager.getOffset() + pager.getPageSize()));
        }
    }
View Full Code Here
121
122
123
124
125
126
127
128
129
130
131
132
133
134
                                            pager.getOffset() + pager.getPageSize()));
        }
    }

    public void formatQuery(Sql sql) {
        Pager pager = sql.getContext().getPager();
        if (null != pager && pager.getPageNumber() > 0) {
            String pre = "SELECT * FROM (SELECT ROW_NUMBER() OVER() AS ROWNUM, T.* FROM (";
            String last = String.format(    ") T) AS A WHERE ROWNUM BETWEEN %d AND %d",
                    pager.getOffset() + 1,
                    pager.getOffset() + pager.getPageSize());
            sql.setSourceSql(pre + sql.getSourceSql() + last);
        }
    }
View Full Code Here
164
165
166
167
168
169
170
171
172
173
174
175
176
177
        // 以下代码,就为了该死的游标分页!!
        // -------------------------------------------------
        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
152
153
154
155
156
157
158
159
160
    @Test
    public void test_cnd_pager() {
        pojos.init();
        Sql sql = Sqls.create("select * from t_pet $condition");
        sql.setCondition(Cnd.where("name", "=", "wendal"));
        Pager pager = dao.createPager(1, 20);
        sql.setPager(pager);
        dao.execute(sql);
    }
View Full Code Here
39
40
41
42
43
44
45
46
47
        if (groupBy != null)
          groupBy.setPojo(pojo);
    }

    public void setPager(int pageNumber, int pageSize) {
        pager = new Pager();
        pager.setPageNumber(pageNumber);
        pager.setPageSize(pageSize);
    }
View Full Code Here
247
248
249
250
251
252
253
254
255
256
257
258
            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
746
747
748
749
750
751
752
753
754
755
        _exec(pojo);
        return pojo.getResult();
    }

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

Related Classes of org.nutz.dao.pager.Pager

  • org.nutz.dao.impl.jdbc.db2.Db2JdbcExpert
  • org.nutz.dao.impl.jdbc.derby.DerbyJdbcExpert
  • org.nutz.dao.impl.jdbc.gbase.GBaseJdbcExpert
  • org.nutz.dao.impl.jdbc.hsqldb.HsqldbJdbcExpert
  • org.nutz.dao.impl.jdbc.mysql.MysqlJdbcExpert
  • org.nutz.dao.impl.jdbc.oracle.OracleJdbcExpert
  • org.nutz.dao.impl.jdbc.psql.PsqlJdbcExpert
  • org.nutz.dao.impl.jdbc.sqlserver2005.Sqlserver2005JdbcExpert
  • org.nutz.dao.impl.jdbc.sqlserver2012.Sqlserver2012JdbcExpert
  • org.nutz.dao.impl.NutDao
    • 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.