Package org.beangle.commons.collection.page

Examples of org.beangle.commons.collection.page.PageLimit

63
64
65
66
67
68
69
70
  public void setLimit(PageLimit limit) {
    this.limit = limit;
  }

  public LimitQuery<T> limit(PageLimit limit) {
    this.limit = new PageLimit(limit.getPageNo(), limit.getPageSize());
    return this;
  }
View Full Code Here
277
278
279
280
281
282
283
284
285
286
287
  public Query<Object> build() {
    QueryBean<Object> queryBean = new QueryBean<Object>();
    queryBean.setStatement(toQueryString());
    queryBean.setParams(getParams());
    if (null != limit) {
      queryBean.setLimit(new PageLimit(limit.getPageNo(), limit.getPageSize()));
    }
    queryBean.setCountStatement(toCountString());
    queryBean.setCacheable(cacheable);
    queryBean.setLang(getLang());
    return queryBean;
View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
    processSql();
    String newSql = sql;
    if (StringUtils.isEmpty(newSql)) { return Collections.emptyList(); }
    boolean thisPage = getBool("thisPage");
    if (thisPage) {
      PageLimit limit = getPageLimit();
      newSql = sqlService.getLimitString(sql, limit);
    }
    List<Map<String, Object>> datas = sqlService.queryForList(newSql);
    return datas;
  }
View Full Code Here
73
74
75
76
77
78
79
80
81
82
83
84
85
86
  private QueryResult query(String sqlString) {
    QueryResult result = new QueryResult(sqlString);
    try {
      if (sqlString.toLowerCase().startsWith("select")) {
        PageLimit limit = getPageLimit();
        String newSql = sqlService.getLimitString(sqlString, limit);
        List<Map<String, Object>> datas = sqlService.queryForList(newSql);
        Page<?> page = new SinglePage<Map<String, Object>>(limit.getPageNo(), limit.getPageSize(),
            sqlService.count(sqlString), datas);
        if (!datas.isEmpty()) {
          result.setColumns(new ArrayList<String>(datas.get(0).keySet()));
        }
        result.setDatas(page);
View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
    processSql();
    String newSql = sql;
    if (StringUtils.isEmpty(newSql)) { return Collections.emptyList(); }
    boolean thisPage = getBool("thisPage");
    if (thisPage) {
      PageLimit limit = getPageLimit();
      newSql = sqlService.getLimitString(sql, limit);
    }
    List<Map<String, Object>> datas = sqlService.queryForList(newSql);
    return datas;
  }
View Full Code Here
69
70
71
72
73
74
75
76
77
78
79
80
81
82
  private QueryResult query(String sqlString) {
    QueryResult result = new QueryResult(sqlString);
    try {
      if (sqlString.toLowerCase().startsWith("select")) {
        PageLimit limit = getPageLimit();
        String newSql = sqlService.getLimitString(sqlString, limit);
        List<Map<String, Object>> datas = sqlService.queryForList(newSql);
        Page<?> page = new SinglePage<Map<String, Object>>(limit.getPageNo(), limit
            .getPageSize(), sqlService.count(sqlString), datas);
        if (!datas.isEmpty()) {
          result.setColumns(new ArrayList<String>(datas.get(0).keySet()));
        }
        result.setDatas(page);
View Full Code Here
697
698
699
700
701
702
703
704
705
706
707
708
709
        LimitQuery<T> limitQuery = (LimitQuery<T>) query;
        Query hibernateQuery = buildHibernateQuery(limitQuery, hibernateSession);
        if (null == limitQuery.getLimit()) {
          return hibernateQuery.list();
        } else {
          final PageLimit limit = limitQuery.getLimit();
          hibernateQuery.setFirstResult((limit.getPageNo() - 1) * limit.getPageSize())
              .setMaxResults(limit.getPageSize());
          return hibernateQuery.list();
        }
      } else {
        return buildHibernateQuery(query, hibernateSession).list();
      }
View Full Code Here
62
63
64
65
66
67
68
69
70
71
  private void populateSessionActivities(User user) {
    OqlBuilder<SessionActivity> onlineQuery = OqlBuilder.from(SessionActivity.class,
        "sessionActivity");
    onlineQuery.where("sessionActivity.name =:name", user.getName());
    PageLimit limit = QueryHelper.getPageLimit();
    limit.setPageSize(10);
    onlineQuery.orderBy("sessionActivity.loginAt desc").limit(limit);
    ContextHelper.put("sessionActivities", entityDao.search(onlineQuery));
  }
View Full Code Here
192
193
194
195
196
197
198
199
200
201
202
  public Query<Object> build() {
    QueryBean<Object> queryBean = new QueryBean<Object>();
    queryBean.setStatement(toQueryString());
    queryBean.setParams(CollectUtils.newHashMap(getParams()));
    if (null != limit) {
      queryBean.setLimit(new PageLimit(limit.getPageNo(), limit.getPageSize()));
    }
    queryBean.setCountStatement(toCountString());
    queryBean.setCacheable(cacheable);
    queryBean.setLang(getLang());
    return queryBean;
View Full Code Here
74
75
76
77
78
79
80
81
82
83
84
  public Query<T> build() {
    QueryBean<T> queryBean = new QueryBean<T>();
    queryBean.setStatement(genStatement());
    queryBean.setParams(getParams());
    if (null != limit) {
      queryBean.setLimit(new PageLimit(limit.getPageNo(), limit.getPageSize()));
    }
    queryBean.setCountStatement(genCountStatement());
    queryBean.setCacheable(cacheable);
    queryBean.setLang(getLang());
    return queryBean;
View Full Code Here
TOP

Related Classes of org.beangle.commons.collection.page.PageLimit

  • org.apache.commons.lang.builder.ToStringBuilder
  • org.beangle.db.replication.impl.DatabaseReplicator
  • org.beangle.emsapp.security.action.MyAction
  • org.beangle.emsapp.security.helper.UserDashboardHelper
  • org.beangle.model.persist.hibernate.HibernateEntityDao$QuerySupport
  • org.beangle.model.query.builder.AbstractQueryBuilder
  • org.beangle.model.query.builder.EntityQuery
  • org.beangle.model.query.builder.OqlBuilder
  • org.beangle.model.query.builder.QueryBean
  • org.beangle.model.query.builder.SqlBuilder
    • 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.