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

    • com.bixuebihui.db.DbImpl Maven / Gradle / Ivy

    Go to download

    a fast small database connection pool and a active record flavor mini framework

    There is a newer version: 1.15.8.3
    Show newest version
    package com.bixuebihui.db;

import com.bixuebihui.DbException;
import com.bixuebihui.jdbc.BaseDao;
import com.bixuebihui.jdbc.SqlFilter;
import com.bixuebihui.jdbc.SqlGroup;
import com.bixuebihui.jdbc.SqlSort;
import com.bixuebihui.jdbc.entity.CountObject;
import com.bixuebihui.jdbc.entity.CountValue;
import com.bixuebihui.query.Paging;
import org.apache.commons.lang3.NotImplementedException;
import org.apache.commons.lang3.tuple.Pair;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Collection;
import java.util.List;
import java.util.Set;
import java.util.function.Function;

import static java.util.Collections.emptySet;

/**
 * This simplified implementation is for test only.
 * change this template use File | Settings | File Templates.
 *
 * @author xingwx
 * @version $Id: $Id
 */
public class DbImpl extends BaseDao implements ActiveRecord,
		SimpleStatement {

	/**
	 * NOTE that: class field make this class can't use in spring as singleton!
	 */
	SqlSort orderStack = new SqlSort();
	SqlHelper filterStack = new SqlHelper();
	SqlLimit limit;
	String resultFields;


	@Override
	public Set getResultFieldsSet() {
		return ActiveRecord.toFieldsSet(resultFields);
	}

	/**
	 * {@inheritDoc}
	 */
	@Override
	public ActiveRecord in(String field, Object[] values) {
		filterStack.in(field, values);
		return this;
	}

	@Override
	public ActiveRecord in(String field, List values) {
		filterStack.in(field, values);
		return this;
	}

	@Override
	public ActiveRecord in(String field, SqlString sqlString) {
		filterStack.in(field, sqlString);
		return this;
	}

	@Override
	public ActiveRecord notIn(String field, Object[] values) {
		filterStack.notIn(field, values);
		return this;
	}

	@Override
	public ActiveRecord notIn(String field, List values) {
		filterStack.notIn(field, values);
		return this;
	}

	@Override
	public ActiveRecord notIn(String field, SqlString sqlString) {
		filterStack.notIn(field, sqlString);
		return this;
	}

	@Override
	public ActiveRecord emptyStringAsNullCondition() {
		filterStack.setAcceptEmptyStringAsNullObjectInCondition(true);
		return this;
	}

	@Override
	public ActiveRecord keepNullForNumberField() {
		return this;
	}

	/** {@inheritDoc} */
	@Override
	public ActiveRecord in(String field, Object values) {
		if(values instanceof Collection) {
			filterStack.in(field, (Collection) values);
		} else if(values instanceof SqlString) {
			filterStack.in(field, (SqlString)values);
		}
		return this;
	}

	@Override
	public ActiveRecord in(Pair fields, List> values) {
		filterStack.in("(" + fields.getLeft() + "," + fields.getRight() + ")",
				values); //TODO tobe fix params!
		return this;

	}


	/** {@inheritDoc} */
	@Override
	public ActiveRecord like(String field, String value) {
		filterStack.like(field, value);
		return this;
	}

	/** {@inheritDoc} */
	@Override
	public ActiveRecord startWith(String field, String value) {
		filterStack.startWith(field, value);
		return this;
	}


	/** {@inheritDoc} */
	@Override
	public ActiveRecord eq(String field, Object value) {
		filterStack.eq(field, value);
		return this;
	}

	/**
	 * **重要事项**：不同的数据库对 BETWEEN...AND 操作符的处理方式是有差异的。
	 * 某些数据库会列出介于 "Adams" 和 "Carter" 之间的人，
	 * 但不包括 "Adams" 和 "Carter" ；某些数据库会列出介于 "Adams" 和 "Carter"
	 * 之间并包括 "Adams" 和 "Carter" 的人；而另一些数据库会列出介于 "Adams" 和 "Carter" 之间的人，
	 * 包括 "Adams" ，但不包括 "Carter" 。
	 * In MySQL string values are not case-sensitive. The actual value in the
	 * column doesn’t have to match the value you specify in the BETWEEN condition.
	 * For example, if you specify the letter range D-G and there is a book whose name equals “dune”
	 * (first letter is in lowercase), the name of this book will also be retrieved.
	 * 
    
	 * General Guidelines
	 * In a MySQL BETWEEN operator, the lower limit must be specified before the upper limit.
	 * ```
	 * SELECT bookName, bookPrice
	 * FROM books
	 * WHERE  bookPrice BETWEEN 80 AND 20
	 * ```
	 * -- No error will be generated and no rows will be returned either.
	 * 
    
	 * The MySQL BETWEEN operator is inclusive. For example, when you use
	 * the MySQL BETWEEN operator to retrieve the books whose price is in
	 * the range between 50 and 90, the result retrieves all of these books,
	 * including those whose price equals 50 or 90.
	 * 
    
	 * SELECT bookID, bookName, bookPrice
	 * FROM books
	 * WHERE  bookPrice BETWEEN 50 AND 90
	 * -- All books whose price is in the range of 50 and 90
	 * -- Including those whose price equals 50 or 90
	 *
	 * 所以，请检查你的数据库是如何处理 BETWEEN....AND 操作符的！
	 *
	 * @param field a {@link java.lang.String} object.
	 * @param leftValue a {@link java.lang.Object} object.
	 * @param rightValue a {@link java.lang.Object} object.
	 * @return a {@link com.bixuebihui.db.ActiveRecord} object.
	 */
	@Override
	public ActiveRecord between(String field, Object leftValue, Object rightValue) {
		filterStack.between(field, leftValue, rightValue);
		return this;
	}

	@Override
	public ActiveRecord notBetween(String field, Object leftValue, Object rightValue) {
		filterStack.notBetween(field, leftValue, rightValue);
		return this;
	}

	/** {@inheritDoc} */
	@Override
	public ActiveRecord ne(String field, Object value) {
		filterStack.ne(field, value);
		return this;
	}


	/** {@inheritDoc} */
	@Override
	public ActiveRecord eq(String[] fields, Object[] value)
			throws SQLException {
		filterStack.eq(fields, value);
		return this;
	}


	/** {@inheritDoc} */
	@Override
	public ActiveRecord greaterThan(String field, Object value) {
		filterStack.greaterThan(field, value);
		return this;
	}

	@Override
	public ActiveRecord gt(String field, Object value) {
		return null;
	}

	/** {@inheritDoc} */
	@Override
	public ActiveRecord smallerThan(String field, Object value) {
		filterStack.smallerThan(field, value);
		return this;
	}

	@Override
	public ActiveRecord lt(String field, Object value) {
		return null;
	}

	@Override
	public ActiveRecord isNull(String field) {
		filterStack.isNull(field);
		return this;
	}

	@Override
	public ActiveRecord isNotNull(String field) {
		filterStack.isNotNull(field);
		return this;
	}

	protected ActiveRecord order(String field, int order) {
		orderStack.addSort(field, order == ORDER_DESC ? "desc" : "asc");
		return this;
	}

	/** {@inheritDoc} */
	@Override
	public ActiveRecord limit(int begin, int num) {
		limit = new SqlLimit(begin, num);
		return this;
	}


	/** {@inheritDoc} */
	@Override
	public boolean insertAndReferences(T entity) {
		return false;

	}

	/** {@inheritDoc} */
	@Override
	public boolean insert(List entities) {
		return false;
	}

	/** {@inheritDoc} */
	@Override
	public boolean insertOrUpdate(T entity) {
		V key = getId(entity);
		T obj =selectByKey(key);
		if(obj==null) {
			return insert(entity);
		}else{
			return updateByKey(entity);
		}
	}

	/** {@inheritDoc} */
	@Override
	public boolean insertOrUpdate(List entity) {
		return false;
	}

	/** {@inheritDoc} */
	@Override
	public T findByKey(V id) {
		return selectByKey(id);
	}

	/** {@inheritDoc} */
	@Override
	public List findAllByKeys(V[] ids) {
		return selectByKeys(ids);
	}

	/** {@inheritDoc} */
	@Override
	public boolean update(T entity) throws SQLException {
		return updateByKey(entity);
	}

	/** {@inheritDoc} */
	@Override
	public boolean updateAndReferences(T entity) {
		return false; // To change body of implemented methods use File |
		// Settings | File Templates.
	}

	/** {@inheritDoc} */
	@Override
	public boolean update(List entities) {
		return false;
	}

	/**
	 * {@inheritDoc}
	 */
	@Override
	public boolean delete(T entity) {
		return deleteByKey(getId(entity));
	}


	/**
	 * {@inheritDoc}
	 */
	@Override
	public List findAll() {
		try {
			SqlPocket p = this.getSql();
			String where = p.getCondition().toString();
			Object[] params = p.getParams().toArray();
			return select(where, params, parseOrder(), limit.getBegin(),
					limit.getEnd());
		} finally {
			clear();
		}
	}

	@Override
	public Pair> findAllWithCount() throws DbException {
		return null;
	}

	@Override
	public  List findAll(Class clz) {
		SqlPocket p = this.getSql();
		String where = p.getCondition().toString();
		Object[] params = p.getParams().toArray();
		String select = "select " + resultFields + " from " + getTableName() + " ";
		return select(select, where, parseOrder(), params, limit.getBegin(),
				limit.getEnd(), clz);
	}

	private void clear() {
		this.filterStack.clear();
		this.orderStack.clear();
	}

	/**
	 * {@inheritDoc}
	 */
	@Override
	public int countAll() {
		try {
			SqlPocket p = this.getSql();
			String where = p.getCondition().toString();
			Object[] params = p.getParams().toArray();
			return countWhere(where, params);
		} finally {
			clear();
		}

	}

	/**
	 * {@inheritDoc}
	 */
	@Override
	public T find() {
		try {
			SqlPocket p = this.getSql();
			String where = p.getCondition().toString();
			Object[] params = p.getParams().toArray();
			List res = select(where, params, parseOrder(),
					SqlLimit.LIMIT_ONE.getBegin(), SqlLimit.LIMIT_ONE.getEnd());
			if (res.size() > 0) {
				return res.get(0);
			}
			return null;
		} finally {
			clear();
		}

	}

	/**
	 * {@inheritDoc}
	 */
	@Override
	public boolean delete() {
		try {
			SqlPocket p = this.getSql();
			String where = p.getCondition().toString();
			Object[] params = p.getParams().toArray();
			if (where.length() < 10) {
				return false;
			}
			String sql = "delete from " + this.getTableName() + " " + where;
			return 0 < this.getDbHelper().executeNoQuery(sql, params);
		} finally {
			clear();
		}

	}

	/**
	 * {@inheritDoc}
	 */
	@Override
	public String get(String field) {
		try {
			field = SqlFilter.transactSQLInjection(field);
			SqlPocket p = this.getSql();
			String where = p.getCondition().toString();
			Object[] params = p.getParams().toArray();
			String sql = "select " + field + " from " + this.getTableName()
					+ " " + where;
			Object obj = this.getDbHelper().executeScalar(sql, params);
			return obj == null ? null : obj.toString();
		} finally {
			clear();
		}
	}

	/**
	 * {@inheritDoc}
	 */
	@Override
	public SqlPocket getSql()  {
		return filterStack.build();
	}

	private String parseOrder() {
		return this.orderStack.toString();
	}

	// from basedao


	/** {@inheritDoc} */
	@Override
	public boolean updateByKey(T info)  {
		throw new NotImplementedException();
	}

	/** {@inheritDoc} */
	@Override
	public boolean insertDummy() {
		throw new NotImplementedException();
	}

	/** {@inheritDoc} */
	@Override
	public V getId(T info) {
		return null;
	}

	/** {@inheritDoc} */
	@Override
	public void setId(T info, V id) {
		throw new UnsupportedOperationException();
	}

	/** {@inheritDoc} */
	@Override
	public V getNextKey() {
		return null;
	}

	@Override
	protected void setIdLong(T info, long id) {

	}

	/** {@inheritDoc} */
	@Override
	public String getTableName() {
		return null;
	}

	/**
	 * {@inheritDoc}
	 */
	@Override
	public String getKeyName() {
		return null;
	}

	/** {@inheritDoc} */
	@Override
	public boolean insert(T entity) {
		throw new NotImplementedException();
	}


	/** {@inheritDoc} */
	@Override
	public List getVector(String field) {
		throw new NotImplementedException();
	}


	/** {@inheritDoc} */
	@Override
	public List getLongVector(String field) {
		throw new NotImplementedException();
	}


	/** {@inheritDoc} */
	@Override
	public Record last() {
		return null;
	}

	@Override
	public ActiveRecord greaterOrEqualThan(String field, Object value) {
		return null;
	}

	@Override
	public ActiveRecord ge(String field, Object value) {
		return null;
	}

	@Override
	public ActiveRecord smallerOrEqualThan(String field, Object value) {
		return null;
	}

	@Override
	public ActiveRecord le(String field, Object value) {
		return null;
	}

	@Override
	public ActiveRecord wildcard(String field, String[] value) {
		throw new NotImplementedException();
	}


	/** {@inheritDoc} */
	@Override
	public SqlHelper getCondStack() {
	    return null;
	}


	/** {@inheritDoc} */
	@Override
	public ActiveRecord or(SqlHelper andStack) {
		return null;
	}


	/** {@inheritDoc} */
	@Override
	public ActiveRecord asc(String field) {
		return null;
	}

	@Override
	public ActiveRecord and(SqlHelper andStack) {
		return null;
	}

	@Override
	public ActiveRecord not(SqlHelper notStack) {
		return null;
	}

	@Override
	public ActiveRecord orderByIn(String field, Object[] in) {
		return null;
	}


	/**
	 * {@inheritDoc}
	 */
	@Override
	public ActiveRecord desc(String field) {
		return null;
	}


	/** {@inheritDoc} */
	@Override
	public List getStringVector(String field) {
		return null;
	}


	/** {@inheritDoc} */
	@Override
	public ActiveRecord alias(String shortName) {
		return null;
	}

	@Override
	public ActiveRecord tableName(String partitionTableName) {
		return null;
	}


	/**
	 * {@inheritDoc}
	 */
	@Override
	public ActiveRecord fields(String... fields) {
		this.resultFields = fields.length==1 ? fields[0] : String.join(",", fields);
		return this;
	}


	/** {@inheritDoc} */
	@Override
	public ActiveRecord join(String joinClause) {
		return null;
	}

	@Override
	public ActiveRecord groupBy(String... fields) {
		return null;
	}

	@Override
	public ActiveRecord having(HavingConditon fieldProcessor) {
		return null;
	}

	@Override
	public  ActiveRecord query(Paging searchBean) {
		return query(searchBean, emptySet());
	}

	@Override
	public ActiveRecord coreSqlInterceptor(Function coreSqlInterceptor) {
		return null;
	}


	/** {@inheritDoc} */
	@Override
	public CountValue countValue(String field, GroupFunction fun) {
		throw new NotImplementedException();
	}


	/** {@inheritDoc} */
	@Override
	public CountValue countSum(String field) {
		return countValue(field, GroupFunction.SUM);
	}

	/**
	 * {@inheritDoc}
	 */
	@Override
	public boolean exists() {
		throw new NotImplementedException();
	}


	/**
	 * {@inheritDoc}
	 */
	@Override
	public int inc(String field) {
		try {
			SqlPocket sqlPocket = this.getSql();
			String whereClause = sqlPocket.getCondition().toString();
			Object[] params = sqlPocket.getParams().toArray();

			return getDbHelper().executeNoQuery("update " + getTableName() + " set " + field + "=" + field + "+1 " + whereClause, params);
		} finally {
			clear();
		}
	}


	/**
	 * {@inheritDoc}
	 */
	@Override
	public int update(String[] fields, Object[] values) {
		throw new NotImplementedException();
	}

	/** {@inheritDoc} */
	@Override
	public int update(String fields, Object values) {
		throw new NotImplementedException();
	}


	/** {@inheritDoc} */
	@Override
	public  CountObject countObject(String field, GroupFunction fun, Class objectType)
			 {
		throw new NotImplementedException();
	}

	@Override
	public  List> countList(String returnField, String[] groupByFields, String having, GroupFunction fun, Class objectType) {
		throw new NotImplementedException();
	}

	@Override
	public T mapRow(ResultSet rs, int index, Set fields)  {
		throw new NotImplementedException();
	}

	@Override
	public ActiveRecord filterInterceptor(Function filterInterceptor) {
		return null;
	}

	@Override
	public ActiveRecord havingInterceptor(Function havingInterceptor) {
		return null;
	}

	@Override
	public ActiveRecord sortInterceptor(Function sortInterceptor) {
		return null;
	}

	@Override
	public ActiveRecord groupInterceptor(Function groupInterceptor) {
		return null;
	}

	@Override
	public ActiveRecord paramsInterceptor(Function, List> groupInterceptor) {
		return null;
	}
}
    
    
    
    

    




    
    
    © 2015 - 2024 Weber Informatics LLC | Privacy Policy