All Downloads are FREE. Search and download functionalities are using the official Maven repository.
  • Log In
  • Register

    • cn.coder.jdbc.support.JSql Maven / Gradle / Ivy

    There is a newer version: 0.0.9
    Show newest version
    package cn.coder.jdbc.support;

import java.util.ArrayList;
import java.util.List;

/**
 * 复杂SQL构造类
 * 
 * @author YYDF 2019-07-29
 */
public final class JSql {

	private final List temps;
	private final List args;

	private JSql(String[] sqls, Object[] array) {
		args = new ArrayList<>();
		temps = new ArrayList<>(sqls.length);
		for (String sql : sqls) {
			temps.add(new StringBuilder(sql));
		}
		for (Object obj : array) {
			args.add(obj);
		}
	}

	public static JSql create(String fetchSql, Object... args) {
		if (notEmpty(fetchSql))
			return new JSql(new String[] { fetchSql }, args);
		throw new NullPointerException("Args 'fetchSql' can not be null");
	}

	public static JSql create(String fetchSql, String countSql, Object... args) {
		if (notEmpty(fetchSql) && notEmpty(countSql))
			return new JSql(new String[] { fetchSql, countSql }, args);
		throw new NullPointerException("Args 'fetchSql' and 'countSql' can not be null");
	}

	public JSql flike(Object arg, String field) {
		return like(arg, " AND " + field + " LIKE ?");
	}

	public JSql like(Object arg, String condition) {
		return like(arg, condition, 1);
	}

	public JSql like(Object arg, String condition, int num) {
		if (notEmpty(arg)) {
			arg = "%" + arg.toString() + "%";
			for (StringBuilder sql : temps) {
				sql.append(condition);
			}
			for (int i = 0; i < num; i++) {
				args.add(arg);
			}
		}
		return this;
	}

	public void eq(String condition) {
		for (StringBuilder sql : temps) {
			sql.append(condition);
		}
	}

	public JSql feq(Object arg, String filed) {
		return eq(arg, " AND " + filed + " = ?");
	}

	public JSql eq(Object arg, String condition) {
		return eq(arg, condition, 1);
	}

	public JSql eq(Object arg, String condition, int num) {
		if (notEmpty(arg)) {
			for (StringBuilder sql : temps) {
				sql.append(condition);
			}
			for (int i = 0; i < num; i++) {
				args.add(arg);
			}
		}
		return this;
	}

	public JSql fbetween(Object start, Object end, String field) {
		return between(start, end, " AND " + field + " BETWEEN ? AND ?", 1);
	}

	public JSql between(Object start, Object end, String condition) {
		return between(start, end, condition, 1);
	}

	public JSql between(Object start, Object end, String condition, int num) {
		if (notEmpty(start) && notEmpty(end)) {
			for (StringBuilder sql : temps) {
				sql.append(condition);
			}
			for (int i = 0; i < num; i++) {
				args.add(start);
				args.add(end);
			}
		}
		return this;
	}

	private static boolean notEmpty(Object arg) {
		return arg != null && arg.toString().length() > 0;
	}

	public String getSql(int index) {
		if (temps.size() > index)
			return temps.get(index).toString();
		throw new IndexOutOfBoundsException("Can not found the index '" + index + "'");
	}

	public Object[] getArgs() {
		return this.args.toArray();
	}

}
    
    
    
    

    




    
    
    © 2015 - 2025 Weber Informatics LLC | Privacy Policy