cool.scx.data.QueryImpl Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of scx-data Show documentation
SCX Data
There is a newer version: 2.7.4
package cool.scx.data;

import cool.scx.data.query.GroupBy;
import cool.scx.data.query.LimitInfo;
import cool.scx.data.query.OrderBy;
import cool.scx.data.query.Where;

/**
 * 查询参数类

 * 针对  GroupBy , OrderBy , Limit , Where 等进行的简单封装 

 * 同时附带一些简单的参数校验 

 * 只是 为了方便传递参数使用

 *
 * @author scx567888
 * @version 0.1.3
 */
public class QueryImpl implements Query {

    /**
     * 自定义WHERE 添加
     */
    private final Where where;

    /**
     * 自定义分组 SQL 添加
     */
    private final GroupBy groupBy;

    /**
     * 排序的字段
     */
    private final OrderBy orderBy;

    /**
     * 分页参数
     */
    private final LimitInfo limitInfo;

    /**
     * 创建 Query 对象
     */
    public QueryImpl() {
        this.where = new Where();
        this.groupBy = new GroupBy();
        this.orderBy = new OrderBy();
        this.limitInfo = new LimitInfo();
    }

    /**
     * a
     *
     * @param oldQuery a
     */
    public QueryImpl(Query oldQuery) {
        this.where = new Where(oldQuery.getWhere());
        this.groupBy = new GroupBy(oldQuery.getGroupBy());
        this.orderBy = new OrderBy(oldQuery.getOrderBy());
        this.limitInfo = new LimitInfo(oldQuery.getLimitInfo());
    }

    public QueryImpl where(Object... whereClauses) {
        this.where.set(whereClauses);
        return this;
    }

    public QueryImpl groupBy(Object... groupByClauses) {
        this.groupBy.set(groupByClauses);
        return this;
    }

    public QueryImpl orderBy(Object... orderByClauses) {
        this.orderBy.set(orderByClauses);
        return this;
    }

    public QueryImpl offset(long limitOffset) {
        limitInfo.offset(limitOffset);
        return this;
    }

    /**
     * 设置分页参数
     *
     * @param numberOfRows 长度
     * @return p
     */
    public QueryImpl limit(long numberOfRows) {
        limitInfo.limit(numberOfRows);
        return this;
    }

    @Override
    public Where getWhere() {
        return where;
    }

    @Override
    public GroupBy getGroupBy() {
        return groupBy;
    }

    @Override
    public OrderBy getOrderBy() {
        return orderBy;
    }

    @Override
    public Long getOffset() {
        return limitInfo.getOffset();
    }

    @Override
    public Long getLimit() {
        return limitInfo.getLimit();
    }

    @Override
    public LimitInfo getLimitInfo() {
        return limitInfo;
    }

    public QueryImpl clearWhere() {
        where.clear();
        return this;
    }

    public QueryImpl clearGroupBy() {
        groupBy.clear();
        return this;
    }

    public QueryImpl clearOrderBy() {
        orderBy.clear();
        return this;
    }

    public QueryImpl clearOffset() {
        limitInfo.clearOffset();
        return this;
    }

    public QueryImpl clearLimit() {
        limitInfo.clearLimit();
        return this;
    }

}