Package javacommon.xsqlbuilder.XsqlBuilder

Examples of javacommon.xsqlbuilder.XsqlBuilder.XsqlFilterResult

125
126
127
128
129
130
131
132
133
134
135
136
   
    Map otherFilters = new HashMap();
    otherFilters.put("sortColumns", pageRequest.getSortColumns());
   
    //混合使用otherFilters与pageRequest.getFilters()为一个filters使用
    XsqlFilterResult queryXsqlResult = getXsqlBuilder().generateHql(query,otherFilters,pageRequest);
    String sql = queryXsqlResult.getXsql();
//    Map acceptedFilters = queryXsqlResult.getAcceptedFilters();
    int pageSize = pageRequest.getPageSize();
    int pageNumber = pageRequest.getPageNumber();
    return pageQuery(sql, cn.org.rapid_framework.beanutils.PropertyUtils.describe(pageRequest), totalCount, pageSize, pageNumber,rowMapper);
  }
View Full Code Here
143
144
145
146
147
148
149
150
151
152
    }
    return builder;
  }

  private int queryTotalCount(String countQuery,Object filtersObject) {
    XsqlFilterResult countQueryXsqlResult = getXsqlBuilder().generateHql(countQuery,filtersObject);
    String removedOrderByQuery = SqlRemoveUtils.removeOrders(countQueryXsqlResult.getXsql());
    final int totalCount = getNamedParameterJdbcTemplate().queryForInt(removedOrderByQuery,new BeanPropertySqlParameterSource(filtersObject));
    return totalCount;
  }
View Full Code Here
96
97
98
99
100
101
102
103
104
105
    otherFilters.put("sortColumns", pageRequest.getSortColumns());
   
    XsqlBuilder builder = getXsqlBuilder();
   
    //混合使用otherFilters与pageRequest为一个filters使用
    XsqlFilterResult queryXsqlResult = builder.generateHql(sql,otherFilters,pageRequest);
    XsqlFilterResult countQueryXsqlResult = builder.generateHql(countQuery,otherFilters,pageRequest);
   
    return PageQueryUtils.pageQuery(getHibernateTemplate(),pageRequest,queryXsqlResult,countQueryXsqlResult);
  }
View Full Code Here
TOP

Related Classes of javacommon.xsqlbuilder.XsqlBuilder.XsqlFilterResult

  • javacommon.base.BaseHibernateDao
  • javacommon.base.BaseSpringJdbcDao
    • 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.