All Downloads are FREE. Search and download functionalities are using the official Maven repository.
Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $
You can buy this project and download/modify it how often you want.
com.quhaodian.data.core.Finder Maven / Gradle / Ivy
package com.quhaodian.data.core;
import java.util.ArrayList;
import java.util.Collection;
import java.util.List;
import java.util.Map;
import org.hibernate.Session;
import org.hibernate.query.Query;
import org.hibernate.type.Type;
/**
* HQL语句分页查询
*/
public class Finder {
protected Finder() {
hqlBuilder = new StringBuilder();
}
protected Finder(String hql) {
hqlBuilder = new StringBuilder(hql);
}
public static Finder create() {
return new Finder();
}
public static Finder create(String hql) {
return new Finder(hql);
}
public Finder append(String hql) {
hqlBuilder.append(hql);
return this;
}
/**
* 获得原始hql语句
*
* @return
*/
public String getOrigHql() {
return hqlBuilder.toString();
}
/**
* 获得查询数据库记录数的hql语句。
*
* @return
*/
public String getRowCountHql() {
String hql = hqlBuilder.toString();
int fromIndex = hql.toLowerCase().indexOf(FROM);
String projectionHql = hql.substring(0, fromIndex);
hql = hql.substring(fromIndex);
String rowCountHql = hql.replace(HQL_FETCH, "");
int index = rowCountHql.indexOf(ORDER_BY);
if (index > 0) {
rowCountHql = rowCountHql.substring(0, index);
}
return wrapProjection(projectionHql) + rowCountHql;
}
public int getFirstResult() {
return firstResult;
}
public void setFirstResult(int firstResult) {
this.firstResult = firstResult;
}
public int getMaxResults() {
return maxResults;
}
public void setMaxResults(int maxResults) {
this.maxResults = maxResults;
}
/**
* 是否使用查询缓存
*
* @return
*/
public boolean isCacheable() {
return cacheable;
}
/**
* 设置是否使用查询缓存
*
* @param cacheable
* @see Query#setCacheable(boolean)
*/
public void setCacheable(boolean cacheable) {
this.cacheable = cacheable;
}
/**
* 设置参数
*
* @param param
* @param value
* @return
* @see Query#setParameter(String, Object)
*/
public Finder setParam(String param, Object value) {
return setParam(param, value, null);
}
/**
* 设置参数。与hibernate的Query接口一致。
*
* @param param
* @param value
* @param type
* @return
* @see Query#setParameter(String, Object, Type)
*/
public Finder setParam(String param, Object value, Type type) {
getParams().add(param);
getValues().add(value);
getTypes().add(type);
return this;
}
/**
* 设置参数。与hibernate的Query接口一致。
*
* @param paramMap
* @return
* @see Query#setProperties(Map)
*/
public Finder setParams(Map paramMap) {
for (Map.Entry entry : paramMap.entrySet()) {
setParam(entry.getKey(), entry.getValue());
}
return this;
}
/**
* 设置参数。与hibernate的Query接口一致。
*
* @param name
* @param vals
* @param type
* @return
*/
public Finder setParamList(String name, Collection vals, Type type) {
getParamsList().add(name);
getValuesList().add(vals);
getTypesList().add(type);
return this;
}
/**
* 设置参数。与hibernate的Query接口一致。
*
* @param name
* @param vals
* @return
* @see Query#setParameterList(String, Collection)
*/
public Finder setParamList(String name, Collection vals) {
return setParamList(name, vals, null);
}
/**
* 设置参数。与hibernate的Query接口一致。
*
* @param name
* @param vals
* @param type
* @return
* @see Query#setParameterList(String, Object[], Type)
*/
public Finder setParamList(String name, Object[] vals, Type type) {
getParamsArray().add(name);
getValuesArray().add(vals);
getTypesArray().add(type);
return this;
}
/**
* 设置参数。与hibernate的Query接口一致。
*
* @param name
* @param vals
* @return
* @see Query#setParameterList(String, Object[])
*/
public Finder setParamList(String name, Object[] vals) {
return setParamList(name, vals, null);
}
/**
* 将finder中的参数设置到query中。
*
* @param query
*/
public Query setParamsToQuery(Query query) {
if (params != null) {
for (int i = 0; i < params.size(); i++) {
if (types.get(i) == null) {
query.setParameter(params.get(i), values.get(i));
} else {
query.setParameter(params.get(i), values.get(i), types
.get(i));
}
}
}
if (paramsList != null) {
for (int i = 0; i < paramsList.size(); i++) {
if (typesList.get(i) == null) {
query
.setParameterList(paramsList.get(i), valuesList
.get(i));
} else {
query.setParameterList(paramsList.get(i),
valuesList.get(i), typesList.get(i));
}
}
}
if (paramsArray != null) {
for (int i = 0; i < paramsArray.size(); i++) {
if (typesArray.get(i) == null) {
query.setParameterList(paramsArray.get(i), valuesArray
.get(i));
} else {
query.setParameterList(paramsArray.get(i), valuesArray
.get(i), typesArray.get(i));
}
}
}
return query;
}
public Query createQuery(Session s) {
Query query = setParamsToQuery(s.createQuery(getOrigHql()));
if (getFirstResult() > 0) {
query.setFirstResult(getFirstResult());
}
if (getMaxResults() > 0) {
query.setMaxResults(getMaxResults());
}
if (isCacheable()) {
query.setCacheable(true);
}
return query;
}
private String wrapProjection(String projection) {
// if (projection.indexOf("select") == -1) {
// return ROW_COUNT;
// } else {
// return projection.replace("select", "select count(") + ") ";
// }
return ROW_COUNT;
}
private List getParams() {
if (params == null) {
params = new ArrayList();
}
return params;
}
private List getValues() {
if (values == null) {
values = new ArrayList();
}
return values;
}
private List getTypes() {
if (types == null) {
types = new ArrayList();
}
return types;
}
private List getParamsList() {
if (paramsList == null) {
paramsList = new ArrayList();
}
return paramsList;
}
private List> getValuesList() {
if (valuesList == null) {
valuesList = new ArrayList>();
}
return valuesList;
}
private List getTypesList() {
if (typesList == null) {
typesList = new ArrayList();
}
return typesList;
}
private List getParamsArray() {
if (paramsArray == null) {
paramsArray = new ArrayList();
}
return paramsArray;
}
private List getValuesArray() {
if (valuesArray == null) {
valuesArray = new ArrayList();
}
return valuesArray;
}
private List getTypesArray() {
if (typesArray == null) {
typesArray = new ArrayList();
}
return typesArray;
}
private StringBuilder hqlBuilder;
private List params;
private List values;
private List types;
private List paramsList;
private List> valuesList;
private List typesList;
private List paramsArray;
private List valuesArray;
private List typesArray;
private int firstResult = 0;
private int maxResults = 0;
private boolean cacheable = false;
public static final String ROW_COUNT = "select count(*) ";
public static final String FROM = "from";
public static final String DISTINCT = "distinct";
public static final String HQL_FETCH = "fetch";
public static final String ORDER_BY = "order ";
public static void main(String[] args) {
Finder find = Finder
.create("select c.course,c from Tradingrecord c ");
System.out.println(find.getRowCountHql());
System.out.println(find.getOrigHql());
}
}
