Examples of Pager

Examples of org.nutz.dao.pager.Pager

533
534
535
536
537
538
539
540
541
542
    _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

104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
    }
    return super.evalFieldType(mf);
  }

  public void formatQuery(Pojo pojo) {
    Pager pager = pojo.getContext().getPager();
    // 需要进行分页
    if (null != pager) {
      // 之前插入
      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

Examples of org.nutz.dao.pager.Pager

98
99
100
101
102
103
104
105
106
107
108
    }
    return super.evalFieldType(mf);
  }

  public void formatQuery(Pojo pojo) {
    Pager pager = pojo.getContext().getPager();
    if (pager == null)
      return;
    // See http://hsqldb.org/doc/guide/ch09.html#select-section
    pojo.append(Pojos.Items.wrapf(" LIMIT %d offset %d", pager.getPageSize(), pager.getOffset()));
  }
View Full Code Here

Examples of org.nutz.dao.pager.Pager

28
29
30
31
32
33
34
35
36
37
  public String getDatabaseType() {
    return DB.MYSQL.name();
  }

  public void formatQuery(Pojo pojo) {
    Pager pager = pojo.getContext().getPager();
    // 需要进行分页
    if (pager != null)
      pojo.append(Pojos.Items.wrapf(" LIMIT %d, %d", pager.getOffset(), pager.getPageSize()));
  }
View Full Code Here

Examples of org.nutz.dao.pager.Pager

24
25
26
27
28
29
30
31
32
33
34
35
  public String getDatabaseType() {
    return DB.PSQL.name();
  }

  public void formatQuery(Pojo pojo) {
    Pager pager = pojo.getContext().getPager();
    // 需要进行分页
    if (pager != null)
      pojo.append(Pojos.Items.wrapf(  " LIMIT %d OFFSET %d",
                      pager.getPageSize(),
                      pager.getOffset()));
  }
View Full Code Here

Examples of org.nutz.dao.pager.Pager

132
133
134
135
136
137
138
139
140
141
142
143
144
145
    return true;
  }

  public void formatQuery(Pojo pojo) {
    Pager pager = pojo.getContext().getPager();
    // 需要进行分页
    if (pager != null) {
      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

109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
    }
    return super.evalFieldType(mf);
  }

  public void formatQuery(Pojo pojo) {
    Pager pager = pojo.getContext().getPager();
    if (pager == null)
      return;
    // -----------------------------------------------------
    // TODO XXX 这个写法灰常暴力!!But , it works!!!! 期待更好的写法
    PItem pi = pojo.getItem(0);
    StringBuilder sb = new StringBuilder();
    pi.joinSql(pojo.getEntity(), sb);
    String str = sb.toString();
    if (str.trim().toLowerCase().startsWith("select")) {
      pojo.setItem(0, Pojos.Items.wrap(str.substring(6)));
    } else
      return;// 以免出错.
    pojo.insertFirst(Pojos.Items.wrapf(  "select * from(select row_number()over(order by __tc__)__rn__,* from(select top %d 0 __tc__, ",
                      pager.getOffset() + pager.getPageSize()));
    pojo.append(Pojos.Items.wrapf(")t)tt where __rn__ > %d", pager.getOffset()));
  }
View Full Code Here

Examples of org.nutz.dao.pager.Pager

30
31
32
33
34
35
36
37
38
39
    public String getDatabaseType() {
        return DB.MYSQL.name();
    }

    public void formatQuery(Pojo pojo) {
        Pager pager = pojo.getContext().getPager();
        // 需要进行分页
        if (null != pager && pager.getPageNumber() > 0)
            pojo.append(Pojos.Items.wrapf(" LIMIT %d, %d", pager.getOffset(), pager.getPageSize()));
    }
View Full Code Here

Examples of org.nutz.dao.pager.Pager

37
38
39
40
41
42
43
44
45
46
        if (null != pager && pager.getPageNumber() > 0)
            pojo.append(Pojos.Items.wrapf(" LIMIT %d, %d", 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(" LIMIT %d, %d", pager.getOffset(), pager.getPageSize()));
    }
View Full Code Here

Examples of org.nutz.dao.pager.Pager

34
35
36
37
38
39
40
41
42
43
            return new DerbyBooleanAdaptor();
        return super.getAdaptor(ef);
    }
   
    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
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.