All Downloads are FREE. Search and download functionalities are using the official Maven repository.

com.queryflow.sql.Where Maven / Gradle / Ivy

Go to download

An ORM framework that can be developed as quickly as water flows!

The newest version!
package com.queryflow.sql;

import com.queryflow.common.QueryFlowException;

import java.util.LinkedList;
import java.util.List;

@SuppressWarnings("unchecked")
public abstract class Where {

    private static final String AND = " AND ";
    private static final String OR = " OR ";
    private static final String AND_NEW = ") AND (";
    private static final String OR_NEW = ") OR (";

    protected List values = new LinkedList<>();
    protected StringBuilder appender = new StringBuilder();
    protected boolean hasWhere = false;

    public T where() {
        appender.append(" WHERE (");
        hasWhere = true;
        return (T) this;
    }

    // a.b = c.b
    public T where(String condition) {
        appender.append(" WHERE (").append(condition);
        hasWhere = true;
        return (T) this;
    }

    public T and() {
        appender.append(AND);
        return (T) this;
    }

    // a.b = c.b
    public T and(String condition) {
        appender.append(AND).append(condition);
        return (T) this;
    }

    public T andNew() {
        appender.append(AND_NEW);
        return (T) this;
    }

    public T or() {
        appender.append(OR);
        return (T) this;
    }

    public T orNew() {
        appender.append(OR_NEW);
        return (T) this;
    }

    public T isNull(String column) {
        appender.append(column).append(" IS NULL ");
        return (T) this;
    }

    public T isNotNull(String column) {
        appender.append(column).append(" IS NOT NULL ");
        return (T) this;
    }

    public T like(String column, Object value) {
        appender.append(column).append(" LIKE ?");
        values.add(value);
        return (T) this;
    }

    public T notLike(String column, Object value) {
        appender.append(column).append(" NOT LIKE ?");
        values.add(value);
        return (T) this;
    }

    public T in(String column, Object... values) {
        appender.append(column).append(" IN (");
        if (values == null || values.length == 0) {
            throw new QueryFlowException("");
        }
        addValueAndMark(values);
        appender.append(")");
        return (T) this;
    }

    public T notIn(String column, Object... values) {
        appender.append(column).append(" NOT IN (");
        if (values == null || values.length == 0) {
            throw new QueryFlowException("");
        }
        addValueAndMark(values);
        appender.append(") ");
        return (T) this;
    }

    private void addValueAndMark(Object... values) {
        Object value;
        for (int i = 0, len = values.length; i < len; i++) {
            value = values[i];
            appender.append("?");
            if (i < len - 1) {
                appender.append(", ");
            }
            this.values.add(value);
        }
    }

    public T gt(String column, Object value) {
        appender.append(column).append(" > ?");
        values.add(value);
        return (T) this;
    }

    public T ge(String column, Object value) {
        appender.append(column).append(" >= ");
        values.add(value);
        return (T) this;
    }

    public T lt(String column, Object value) {
        appender.append(column).append(" < ?");
        values.add(value);
        return (T) this;
    }

    public T le(String column, Object value) {
        appender.append(column).append(" <= ?");
        values.add(value);
        return (T) this;
    }

    public T between(String column, Object smallValue, Object bigValue) {
        appender.append(column).append(" BETWEEN ? AND ?");
        values.add(smallValue);
        values.add(bigValue);
        return (T) this;
    }

    public T notBetween(String column, Object smallValue, Object bigValue) {
        appender.append(column).append(" NOT BETWEEN ? AND ?");
        values.add(smallValue);
        values.add(bigValue);
        return (T) this;
    }

    public T eq(String column, Object value) {
        appender.append(column).append(" = ?");
        this.values.add(value);
        return (T) this;
    }

    public T notEq(String column, Object value) {
        appender.append(column).append(" <> ?");
        this.values.add(value);
        return (T) this;
    }

    public List getValues() {
        return values;
    }

}
    

    

    

            

    

            



    
    






    
© 2015 - 2024 Weber Informatics LLC | Privacy Policy