CRM-数据库查询助手QueryHelper

CRM-数据库查询助手QueryHelper

查询工具类QueryHelper, 里面需要对将要查询的hql和参数进行组装。这样不仅会简化我们的查询工作，
还可以减少错误，快速定位错误。

该工具类的主要方法有：
。该工具类主要方法有：
->QueryHelper(Class clazz, String alias) 构造器，主要组装from 子句
->addCondition(String condition, Object… param) 组装where子句
->addOrderByProperty(String property, String order) 组装order by 子句
->getListQueryHql() 返回查询列表的hql
->getCountQueryHql() 返回统计总记录数的hql
->getParameters() 返回参数列表

具体实现：

public class QueryHelper {

    //from 子句
    private String fromClause = "";
    //where 子句
    private String whereClause = "";
    //order by 子句
    private String orderByClause = "";

    //where 子句中?对应的参数值
    private List<Object> parameters;

    public static String ORDER_BY_ASC = "ASC";//升序
    public static String ORDER_BY_DESC = "DESC";//降序

    /**
     * 利用构造方法构造from子句
     * @param clazz 实体类
     * @param alias 别名
     */
    public QueryHelper(Class clazz, String alias){
        fromClause = "FROM " + clazz.getSimpleName() + " " + alias;
    }
    /**
     * 组装where子句
     * @param condition 条件
     * @param params 条件中?对应的参数值
     * @return QueryHelper
     */
    public QueryHelper addCondition(String condition, Object...params){
        if(whereClause.length() > 0){
            whereClause += " AND " + condition;
        } else {
            whereClause = " WHERE " + condition;
        }
        if(parameters == null){
            parameters = new ArrayList<Object>();
        }
        for(Object param: params){
            parameters.add(param);
        }
        return this;
    }
    /**
     * 构建order by 子句
     * @param property 排序的属性
     * @param order 升序(asc)或是降序(desc)
     * @return QueryHelper
     */
    public QueryHelper addOrderByProperty(String property, String order){
        if(orderByClause.length() > 0){
            orderByClause += "," + property + " " + order;
        } else {
            orderByClause += " ORDER BY " + property + " " + order;
        }
        return this;
    }

    //返回列表查询hql语句
    public String getListQueryHql(){
        return fromClause + whereClause + orderByClause;
    }

    //返回查询总记录数的hql
    public String getCountHql(){
        return "SELECT COUNT(*) " + fromClause + whereClause;
    }

    public List<Object> getParameters() {
        return parameters;
    }
}