org.eweb4j.orm.dao.select.DivPageDAOImpl Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of eweb4j-all Show documentation
easy web framework for java, full-stack
The newest version!
package org.eweb4j.orm.dao.select;

import java.sql.Connection;
import java.util.List;

import javax.sql.DataSource;

import org.eweb4j.orm.dao.DAOException;
import org.eweb4j.orm.jdbc.JdbcUtil;
import org.eweb4j.orm.sql.SqlFactory;

public class DivPageDAOImpl implements DivPageDAO {
	private DataSource ds;
	private String dbType;

	public DivPageDAOImpl(DataSource ds, String dbType) {
		this.ds = ds;
		this.dbType = dbType;
	}

	public  T nextOne(T t) throws DAOException {
		if (t != null) {
			@SuppressWarnings("unchecked")
			Class clazz = (Class) t.getClass();
			Connection con = null;
			try {
				con = ds.getConnection();
				List list = JdbcUtil.getList(con, clazz, SqlFactory.getSelectSql(t, dbType).nextOne());
				return list != null && !list.isEmpty() ? list.get(0) : null;
			} catch (Exception e) {
				throw new DAOException("nextOne exception ", e);
			}
		}
		return null;
	}

	public  T nextOne(Class clazz, String column, int value)
			throws DAOException {
		if (clazz != null) {
			Connection con = null;
			try {
				con = ds.getConnection();
				List list = JdbcUtil.getList(con, clazz,SqlFactory.getSelectSql(clazz.newInstance(), dbType).nextOne(column, value));
				return list != null && !list.isEmpty() ? list.get(0) : null;
			} catch (Exception e) {
				throw new DAOException("nextOne exception ", e);
			}
		}
		return null;
	}

	public  T preOne(T t) throws DAOException {
		if (t != null) {
			Connection con = null;
			try {
				con = ds.getConnection();
				@SuppressWarnings("unchecked")
				List list = JdbcUtil.getList(con, (Class) t.getClass(),SqlFactory.getSelectSql(t, dbType).preOne());
				return list != null && !list.isEmpty() ? list.get(0) : null;
			} catch (Exception e) {
				throw new DAOException("preOne exception ", e);
			}
		}
		return null;
	}

	public  T preOne(Class clazz, String column, int value)
			throws DAOException {
		if (clazz != null) {
			Connection con = null;
			try {
				con = ds.getConnection();
				List list = JdbcUtil.getList(con, clazz,SqlFactory.getSelectSql(clazz.newInstance(), dbType).preOne(column, value));
				return list != null && !list.isEmpty() ? list.get(0) : null;
			} catch (Exception e) {

				throw new DAOException("preOne exception ", e);
			}
		}
		return null;
	}

	public  List divPageByWhere(Class clazz, int currPage,
			int numPerPage, String orderField, int orderType, String condition,
			Object[] args) throws DAOException {
		List list = null;
		Connection con = null;
		if (clazz != null) {
			try {
				con = ds.getConnection();
				String sql = SqlFactory.getSelectSql(clazz.newInstance(),
						dbType).divPage(currPage, numPerPage, orderField,
						orderType, condition);
				list = JdbcUtil.getListWithArgs(con, clazz, sql, args);
			} catch (Exception e) {
				throw new DAOException("divPageByWhere exception ", e);
			}
		}
		return list;
	}

	public  List divPage(Class clazz, int currPage, int numPerPage,
			String orderField, int orderType) throws DAOException {
		return this.divPageByWhere(clazz, currPage, numPerPage, orderField,
				orderType, null, null);
	}

	public  List divPage(Class clazz, int currPage, int numPerPage,
			int orderType) throws DAOException {
		return this.divPageByWhere(clazz, currPage, numPerPage, null,
				orderType, null, null);
	}

	public  List divPageByWhere(Class clazz, int currPage,
			int numPerPage, int orderType, String condition, Object[] args)
			throws DAOException {
		return this.divPageByWhere(clazz, currPage, numPerPage, null,
				orderType, condition, args);
	}

	public  List divPage(Class clazz, int currPage, int numPerPage)
			throws DAOException {
		return this.divPageByWhere(clazz, currPage, numPerPage, null, -1, null,
				null);
	}

	public  List divPageByWhere(Class clazz, int currPage,
			int numPerPage, String condition, Object[] args)
			throws DAOException {
		return this.divPageByWhere(clazz, currPage, numPerPage, null, -1,
				condition, args);
	}

	public  List divPageByFieldIsValue(Class clazz, String[] fields,
			String[] values, String orderField, int orderType, int currPage,
			int numPerPage, boolean isOR) throws DAOException {
		List list = null;
		if (clazz != null) {
			Connection con = null;
			try {
				con = ds.getConnection();
				String sql = SqlFactory.getSelectSql(clazz.newInstance(),
						dbType).selectWhere(fields, values, -2, false, false,
						isOR, orderField, orderType, currPage, numPerPage);
				list = JdbcUtil.getList(con, clazz, sql);
			} catch (Exception e) {
				throw new DAOException("divPageByFieldIsValue exception ", e);
			}
		}
		return list;
	}

	public  List divPageByFieldNotIsValue(Class clazz,
			String[] fields, String[] values, String orderField, int orderType,
			int currPage, int numPerPage, boolean isOR) throws DAOException {
		List list = null;
		if (clazz != null) {
			Connection con = null;
			try {
				con = ds.getConnection();
				String sql = SqlFactory.getSelectSql(clazz.newInstance(),
						dbType).selectWhere(fields, values, -2, false, true,
						isOR, orderField, orderType, currPage, numPerPage);
				list = JdbcUtil.getList(con, clazz, sql);
			} catch (Exception e) {
				throw new DAOException("divPageByFieldNotIsValue exception ", e);
			}
		}
		return list;
	}

	public  List divPageByFieldIsValue(T t, String[] fields,
			String orderField, int orderType, int currPage, int numPerPage,
			boolean isOR) throws DAOException {
		List list = null;
		if (t != null) {
			Connection con = null;
			@SuppressWarnings("unchecked")
			Class clazz = (Class) t.getClass();
			try {
				con = ds.getConnection();
				String sql = SqlFactory.getSelectSql(t, dbType).selectWhere(
						fields, null, -2, false, false, isOR, orderField,
						orderType, currPage, numPerPage);
				list = JdbcUtil.getList(con, clazz, sql);
			} catch (Exception e) {
				throw new DAOException("divPageByFieldIsValue exception ", e);
			}
		}
		return list;
	}

	public  List divPageByFieldNotIsValue(T t, String[] fields,
			String orderField, int orderType, int currPage, int numPerPage,
			boolean isOR) throws DAOException {
		List list = null;
		if (t != null) {
			@SuppressWarnings("unchecked")
			Class clazz = (Class) t.getClass();
			Connection con = null;
			try {
				con = ds.getConnection();
				String sql = SqlFactory.getSelectSql(t, dbType).selectWhere(
						fields, null, -2, false, true, isOR, orderField,
						orderType, currPage, numPerPage);
				list = JdbcUtil.getList(con, clazz, sql);
			} catch (Exception e) {
				throw new DAOException("divPageByFieldNotIsValue exception ", e);
			}
		}
		return list;
	}

	public  List divPageByFieldIsValue(Class clazz, String[] fields,
			String[] values, int orderType, int currPage, int numPerPage,
			boolean isOR) throws DAOException {
		return this.divPageByFieldIsValue(clazz, fields, values, null,
				orderType, currPage, numPerPage, isOR);
	}

	public  List divPageByFieldNotIsValue(Class clazz,
			String[] fields, String[] values, int orderType, int currPage,
			int numPerPage, boolean isOR) throws DAOException {
		return this.divPageByFieldNotIsValue(clazz, fields, values, null,
				orderType, currPage, numPerPage, isOR);
	}

	public  List divPageByFieldIsValues(T t, String[] fields,
			int orderType, int currPage, int numPerPage, boolean isOR)
			throws DAOException {
		List list = null;
		if (t != null) {
			@SuppressWarnings("unchecked")
			Class clazz = (Class) t.getClass();
			Connection con = null;
			try {
				con = ds.getConnection();
				String sql = SqlFactory.getSelectSql(t, dbType).selectWhere(
						fields, null, -2, false, false, isOR, null, orderType,
						currPage, numPerPage);
				list = JdbcUtil.getList(con, clazz, sql);
			} catch (Exception e) {
				throw new DAOException("divPageByFieldIsValues exception", e);
			}
		}
		return list;
	}

	public  List divPageByFieldNotIsValues(T t, String[] fields,
			int orderType, int currPage, int numPerPage, boolean isOR)
			throws DAOException {
		List list = null;
		if (t != null) {
			@SuppressWarnings("unchecked")
			Class clazz = (Class) t.getClass();
			Connection con = null;
			try {
				con = ds.getConnection();
				String sql = SqlFactory.getSelectSql(t, dbType).selectWhere(
						fields, null, -2, false, true, isOR, null, orderType,
						currPage, numPerPage);
				list = JdbcUtil.getList(con, clazz, sql);
			} catch (Exception e) {
				throw new DAOException("divPageByFieldNotIsValues exception ",
						e);
			}
		}
		return list;
	}

	public  List divPageByFieldIsValue(Class clazz, String[] fields,
			String[] values, int currPage, int numPerPage, boolean isOR)
			throws DAOException {
		return this.divPageByFieldIsValue(clazz, fields, values, null, -1,
				currPage, numPerPage, isOR);
	}

	public  List divPageByFieldNotIsValue(Class clazz,
			String[] fields, String[] values, int currPage, int numPerPage,
			boolean isOR) throws DAOException {
		return this.divPageByFieldNotIsValue(clazz, fields, values, null, -1,
				currPage, numPerPage, isOR);
	}

	public  List divPageByFieldIsValue(T t, String[] fields,
			int currPage, int numPerPage, boolean isOR) throws DAOException {
		return this.divPageByFieldIsValue(t, fields, null, -1, currPage,
				numPerPage, isOR);
	}

	public  List divPageByFieldNotIsValue(T t, String[] fields,
			int currPage, int numPerPage, boolean isOR) throws DAOException {
		return this.divPageByFieldNotIsValue(t, fields, null, -1, currPage,
				numPerPage, isOR);
	}

	public  List divPageByFieldLikeValue(Class clazz, String[] fields,
			String[] values, int likeType, String orderField, int orderType,
			int currPage, int numPerPage, boolean isOR) throws DAOException {
		List list = null;
		if (clazz != null) {
			Connection con = null;
			try {
				con = ds.getConnection();
				String sql = SqlFactory.getSelectSql(clazz.newInstance(),
						dbType).selectWhere(fields, values, likeType, true,
						false, isOR, orderField, orderType, currPage,
						numPerPage);
				list = JdbcUtil.getList(con, clazz, sql);
			} catch (Exception e) {
				throw new DAOException("divPageByFieldLikeValue exception ", e);
			}
		}
		return list;
	}

	public  List divPageByFieldNotLikeValue(Class clazz,
			String[] fields, String[] values, int likeType, String orderField,
			int orderType, int currPage, int numPerPage, boolean isOR)
			throws DAOException {
		List list = null;
		if (clazz != null) {
			Connection con = null;
			try {
				con = ds.getConnection();
				String sql = SqlFactory.getSelectSql(clazz.newInstance(),
						dbType)
						.selectWhere(fields, values, likeType, true, true,
								isOR, orderField, orderType, currPage,
								numPerPage);
				list = JdbcUtil.getList(con, clazz, sql);
			} catch (Exception e) {

				throw new DAOException("divPageByFieldNotLikeValue exception ",
						e);
			}
		}
		return list;
	}

	public  List divPageByFieldLikeValue(T t, String[] fields,
			int likeType, String orderField, int orderType, int currPage,
			int numPerPage, boolean isOR) throws DAOException {
		List list = null;
		if (t != null) {
			Connection con = null;
			@SuppressWarnings("unchecked")
			Class clazz = (Class) t.getClass();
			try {
				con = ds.getConnection();
				String sql = SqlFactory.getSelectSql(t, dbType).selectWhere(
						fields, null, likeType, true, false, isOR, orderField,
						orderType, currPage, numPerPage);
				list = JdbcUtil.getList(con, clazz, sql);
			} catch (Exception e) {
				throw new DAOException("divPageByFieldLikeValue exception", e);
			}
		}
		return list;
	}

	public  List divPageByFieldNotLikeValue(T t, String[] fields,
			int likeType, String orderField, int orderType, int currPage,
			int numPerPage, boolean isOR) throws DAOException {
		List list = null;
		if (t != null) {
			Connection con = null;
			@SuppressWarnings("unchecked")
			Class clazz = (Class) t.getClass();
			try {
				con = ds.getConnection();
				String sql = SqlFactory.getSelectSql(t, dbType).selectWhere(
						fields, null, likeType, true, true, isOR, orderField,
						orderType, currPage, numPerPage);
				list = JdbcUtil.getList(con, clazz, sql);
			} catch (Exception e) {
				throw new DAOException("", e);
			}
		}
		return list;
	}

	public  List divPageByFieldLikeValue(Class clazz, String[] fields,
			String[] values, int likeType, int orderType, int currPage,
			int numPerPage, boolean isOR) throws DAOException {
		return this.divPageByFieldLikeValue(clazz, fields, values, likeType,
				null, orderType, currPage, numPerPage, isOR);
	}

	public  List divPageByFieldNotLikeValue(Class clazz,
			String[] fields, String[] values, int likeType, int orderType,
			int currPage, int numPerPage, boolean isOR) throws DAOException {
		return this.divPageByFieldNotLikeValue(clazz, fields, values, likeType,
				null, orderType, currPage, numPerPage, isOR);
	}

	public  List divPageByFieldLikeValue(T t, String[] fields,
			int likeType, int orderType, int currPage, int numPerPage,
			boolean isOR) throws DAOException {
		return this.divPageByFieldLikeValue(t, fields, likeType, null,
				orderType, currPage, numPerPage, isOR);
	}

	public  List divPageByFieldNotLikeValue(T t, String[] fields,
			int likeType, int orderType, int currPage, int numPerPage,
			boolean isOR) throws DAOException {
		return this.divPageByFieldNotLikeValue(t, fields, likeType, null,
				orderType, currPage, numPerPage, isOR);
	}

	public  List divPageByFieldLikeValue(Class clazz, String[] fields,
			String[] values, int likeType, int currPage, int numPerPage,
			boolean isOR) throws DAOException {
		return this.divPageByFieldLikeValue(clazz, fields, values, likeType,
				-1, currPage, numPerPage, isOR);
	}

	public  List divPageByFieldNotLikeValue(Class clazz,
			String[] fields, String[] values, int likeType, int currPage,
			int numPerPage, boolean isOR) throws DAOException {
		return this.divPageByFieldNotLikeValue(clazz, fields, values, likeType,
				-1, currPage, numPerPage, isOR);
	}

	public String getDbType() {
		return dbType;
	}

	public void setDbType(String dbType) {
		this.dbType = dbType;
	}

	public DataSource getDs() {
		return ds;
	}

	public void setDs(DataSource ds) {
		this.ds = ds;
	}
}