com.quhaodian.data.core.BaseDaoImpl Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of hibernate_common Show documentation
Show all versions of hibernate_common Show documentation
discover_hibernate_common is a lib for hibernate
The newest version!
package com.quhaodian.data.core;
import com.quhaodian.data.page.Filter;
import com.quhaodian.data.page.Filter.Operator;
import com.quhaodian.data.page.Order;
import com.quhaodian.data.page.Order.Direction;
import com.quhaodian.data.page.Page;
import com.quhaodian.data.page.Pageable;
import org.hibernate.Criteria;
import org.hibernate.LockMode;
import org.hibernate.Session;
import org.hibernate.criterion.*;
import org.hibernate.hql.internal.ast.QueryTranslatorImpl;
import org.hibernate.internal.CriteriaImpl;
import org.hibernate.internal.SessionFactoryImpl;
import org.hibernate.metadata.ClassMetadata;
import org.hibernate.query.Query;
import org.hibernate.transform.ResultTransformer;
import org.hibernate.transform.Transformers;
import org.springframework.orm.hibernate5.support.HibernateDaoSupport;
import org.springframework.util.Assert;
import java.io.Serializable;
import java.util.ArrayList;
import java.util.Collections;
import java.util.List;
public abstract class BaseDaoImpl extends HibernateDaoSupport implements BaseDao {
@Override
public List list(Pageable pageable){
List result = null;
List filters = pageable.getFilters();
List orders = pageable.getOrders();
Finder finder = makeFinder(filters, orders);
result = find(finder);
return result;
}
@Override
public List filters(Filter... filters) {
List result = new ArrayList();
if (filters != null && filters.length > 0) {
List filterList = new ArrayList();
for (Filter item : filters) {
filterList.add(item);
}
result = find(makeFinder(filterList, null));
}
return result;
}
/**
* HIBERNATE 的 order 属性
*/
protected static final String ORDER_ENTRIES = "orderEntries";
/**
* 添加数据
*
* @param t
* @return
*/
@Override
public T add(T t) {
if (t == null) {
return null;
} else {
getHibernateTemplate().save(t);
}
return t;
}
/**
* 按属性统计记录数
*
* @param property
* @param value
* @return
*/
protected int countByProperty(String property, Object value) {
Assert.hasText(property, "不能为空");
Assert.notNull(value, "不能为空");
return ((Number) (createCriteria(Restrictions.eq(property, value)).setProjection(Projections.rowCount())
.uniqueResult())).intValue();
}
/**
* 获得Finder的记录总数
*
* @param finder
* @return
*/
@Override
public Long countQuery(Finder finder) {
Long result = 0L;
try {
Query query = getSessionFactory().getCurrentSession().createQuery(finder.getRowCountHql());
finder.setParamsToQuery(query);
if (finder.isCacheable()) {
query.setCacheable(true);
}
result = ((Number) query.iterate().next()).longValue();
} catch (Exception e) {
logger.error("" + e.getMessage(), e);
}
return result;
}
@Override
public Long countQuery(Filter... filters) {
Long result = 0L;
try {
if (filters != null && filters.length > 0) {
List filterList = new ArrayList();
for (Filter item : filters) {
filterList.add(item);
}
result = countQuery(makeFinder(filterList, null));
}
} catch (Exception e) {
logger.error("" + e.getMessage(), e);
}
return result;
}
/**
* 获得Finder的记录总数
*
* @param finder
* @return
*/
@Override
public int countQueryResult(Finder finder) {
int result = 0;
try {
Query query = getSessionFactory().getCurrentSession().createQuery(finder.getRowCountHql());
finder.setParamsToQuery(query);
if (finder.isCacheable()) {
query.setCacheable(true);
}
result = ((Number) query.iterate().next()).intValue();
} catch (Exception e) {
logger.error("" + e.getMessage(), e);
}
return result;
}
/**
* 获得Finder的记录总数
*
* @param finder
* @return
*/
@Override
public int countQuerySqlResult(Finder finder) {
Query query = getSessionFactory().getCurrentSession().createSQLQuery(finder.getRowCountHql());
finder.setParamsToQuery(query);
if (finder.isCacheable()) {
query.setCacheable(true);
}
List ls = query.list();
Object o = ls.get(0);
if (o instanceof Number) {
return ((Number) o).intValue();
} else {
return 0;
}
}
/**
* 根据Criterion条件创建Criteria,后续可进行更多处理,辅助函数.
*/
protected Criteria createCriteria(Criterion... criterions) {
Criteria criteria = getSession().createCriteria(getEntityClass());
for (Criterion c : criterions) {
criteria.add(c);
}
return criteria;
}
/**
* 根据查询函数与参数列表创建Query对象,后续可进行更多处理,辅助函数.
*/
protected Query createQuery(String queryString, Object... values) {
Assert.hasText(queryString);
Query queryObject = getSessionFactory().getCurrentSession().createQuery(queryString);
if (values != null) {
for (int i = 0; i < values.length; i++) {
queryObject.setParameter(i, values[i]);
}
}
return queryObject;
}
/*
* (non-Javadoc)
*
* @see com.mendao.data.core.BaseDao#delete(T)
*/
@Override
public T delete(T t) {
if (t == null) {
return null;
}
getHibernateTemplate().delete(t);
return t;
}
/**
* 通过HQL查询对象列表
*
* @param hql hql语句
* @param values 数量可变的参数
*/
@SuppressWarnings("unchecked")
@Override
public List find(String hql, Object... values) {
return createQuery(hql, values).list();
}
/**
* 通过Finder获得分页数据
*
* @param finder Finder对象
* @param pageNo 页码
* @param pageSize 每页条数
* @return
*/
@SuppressWarnings("unchecked")
@Override
public Pagination find(Finder finder, int pageNo, int pageSize) {
int totalCount = countQueryResult(finder);
Pagination p = new Pagination(pageNo, pageSize, totalCount);
if (totalCount < 1) {
p.setList(new ArrayList());
return p;
}
if (p.getPageNo() < pageNo) {
p.setList(new ArrayList());
return p;
}
Query query = getSessionFactory().getCurrentSession().createQuery(finder.getOrigHql());
finder.setParamsToQuery(query);
query.setFirstResult(p.getFirstResult());
query.setMaxResults(p.getPageSize());
if (finder.isCacheable()) {
query.setCacheable(true);
}
List list = query.list();
p.setList(list);
return p;
}
/**
* 通过Finder获得列表数据
*
* @param finder
* @return
*/
@SuppressWarnings("unchecked")
@Override
public List find(Finder finder) {
Query query = finder.createQuery(getSessionFactory().getCurrentSession());
List list = query.list();
return list;
}
/**
* 按Criterion查询列表数据.
*
* @param criterion 数量可变的Criterion.
*/
@SuppressWarnings("unchecked")
public List findByCriteria(Criterion... criterion) {
return createCriteria(criterion).list();
}
/**
* 通过Criteria获得分页数据
*
* @param crit
* @param pageNo
* @param pageSize
* @return
*/
@SuppressWarnings("unchecked")
@Override
public Pagination findByCriteria(Criteria crit, int pageNo, int pageSize) {
CriteriaImpl impl = (CriteriaImpl) crit;
// 先把Projection、ResultTransformer、OrderBy取出来,清空三者后再执行Count操作
Projection projection = impl.getProjection();
ResultTransformer transformer = impl.getResultTransformer();
List orderEntries;
try {
orderEntries = (List) MyBeanUtils.getFieldValue(impl, ORDER_ENTRIES);
MyBeanUtils.setFieldValue(impl, ORDER_ENTRIES, new ArrayList());
} catch (Exception e) {
throw new RuntimeException("cannot read/write 'orderEntries' from CriteriaImpl", e);
}
int totalCount = ((Number) crit.setProjection(Projections.rowCount()).uniqueResult()).intValue();
Pagination p = new Pagination(pageNo, pageSize, totalCount);
if (totalCount < 1) {
p.setList(new ArrayList());
return p;
}
// 将之前的Projection,ResultTransformer和OrderBy条件重新设回去
crit.setProjection(projection);
if (projection == null) {
crit.setResultTransformer(CriteriaSpecification.ROOT_ENTITY);
}
if (transformer != null) {
crit.setResultTransformer(transformer);
}
try {
MyBeanUtils.setFieldValue(impl, ORDER_ENTRIES, orderEntries);
} catch (Exception e) {
throw new RuntimeException("set 'orderEntries' to CriteriaImpl faild", e);
}
crit.setFirstResult(p.getFirstResult());
crit.setMaxResults(p.getPageSize());
p.setList(crit.list());
return p;
}
@Override
public Pagination findByPage(Pageable pageable) {
List filters = pageable.getFilters();
List orders = pageable.getOrders();
Finder finder = makeFinder(filters, orders);
Pagination page = find(finder, pageable.getPageNumber(), pageable.getPageSize());
return page;
}
/**
* 按属性查找对象列表
*/
@SuppressWarnings("unchecked")
@Override
public List findByProperty(String property, Object value) {
Assert.hasText(property);
return createCriteria(Restrictions.eq(property, value)).list();
}
@Override
public T findOne(Finder finder) {
T entity = null;
List list = find(finder);
if (list != null && list.size() > 0) {
entity = (T) list.get(0);
}
return entity;
}
@Override
public Pagination findSql(Finder finder, int pageNo, int pageSize, Class otoclass) {
int totalCount = countQuerySqlResult(finder);
Pagination p = new Pagination(pageNo, pageSize, totalCount);
if (totalCount < 1) {
p.setList(new ArrayList());
return p;
}
if (p.getPageNo() < pageNo) {
p.setList(new ArrayList());
return p;
}
Query query = getSessionFactory().getCurrentSession().createSQLQuery(finder.getOrigHql());
finder.setParamsToQuery(query);
query.setFirstResult(p.getFirstResult());
query.setMaxResults(p.getPageSize());
query.setResultTransformer(Transformers.aliasToBean(otoclass));
if (finder.isCacheable()) {
query.setCacheable(true);
}
List list = query.list();
p.setList(list);
return p;
}
/**
* 通过HQL查询唯一对象
*/
protected Object findUnique(String hql, Object... values) {
return createQuery(hql, values).uniqueResult();
}
/**
* 按属性查找唯一对象
*/
@SuppressWarnings("unchecked")
protected T findUniqueByProperty(String property, Object value) {
Assert.hasText(property,"不能为空");
Assert.notNull(value,"不能为空");
return (T) createCriteria(Restrictions.eq(property, value)).uniqueResult();
}
/**
* @param id
* @return 持久化对象
*/
protected T get(ID id) {
return get(id, false);
}
/**
* @param id 对象ID
* @param lock 是否锁定，使用LockMode.UPGRADE
* @return 持久化对象
*/
@SuppressWarnings("unchecked")
protected T get(ID id, boolean lock) {
T entity;
if (lock) {
entity = getSession().get(getEntityClass(), id, LockMode.UPGRADE);
} else {
entity = getSession().get(getEntityClass(), id);
}
return entity;
}
/**
* 获得Dao对于的实体类
*
* @return
*/
protected abstract Class getEntityClass();
/**
* @param filter
* @return
*/
private String getProperty(Filter filter) {
String result = filter.getProperty();
result = result.replaceAll("\\.", "");
return result;
}
protected Session getSession() {
return getSessionFactory().getCurrentSession();
}
@Override
public DTO hql(Finder finder) {
Query query = getSessionFactory().getCurrentSession().createQuery(finder.getOrigHql());
finder.setParamsToQuery(query);
if (finder.isCacheable()) {
query.setCacheable(true);
}
List ls = query.list();
Object o = ls.get(0);
DTO result = (DTO) o;
return result;
}
@Override
public List list(Integer first, Integer count, List filters, List orders) {
List result = null;
Finder finder = makeFinder(filters, orders);
finder.setFirstResult(first);
finder.setMaxResults(count);
result = find(finder);
return result;
}
@Override
public List listSQL(String sql, Class otoclass) {
List result = null;
Query query = getSessionFactory().getCurrentSession().createNativeQuery(sql);
query.setResultTransformer(Transformers.aliasToBean(otoclass));
result = query.list();
return result;
}
@Override
public List listSQL(String sql, Integer stat, Integer max, Class otoclass) {
List result = null;
Query query = getSessionFactory().getCurrentSession().createNativeQuery(sql);
query.setResultTransformer(Transformers.aliasToBean(otoclass));
query.setFirstResult(stat);
query.setMaxResults(max);
result = query.list();
return result;
}
/**
* @param filters
* @param orders
* @return
*/
protected Finder makeFinder(List filters, List orders) {
Finder finder = Finder.create();
finder.append("select distinct model from " + getEntityClass().getSimpleName());
if (filters==null||filters.isEmpty()){
finder.append(" model ");
}else {
finder.append(" model where ");
}
makerFilter(filters, finder);
makeOrder(orders, finder);
return finder;
}
/**
* @param orders
* @param finder
*/
private void makeOrder(List orders, Finder finder) {
if (orders != null && !orders.isEmpty()) {
finder.append(" order by ");
int num = 0;
int all = orders.size();
for (Order order : orders) {
num++;
finder.append(" model." + order.getProperty());
if (order.getDirection() == Direction.asc) {
finder.append(" asc ");
} else {
finder.append(" desc ");
}
if (num != all) {
finder.append(" , ");
}
}
}
}
/**
* @param filters
* @param finder
*/
private void makerFilter(List filters, Finder finder) {
if (filters != null) {
int i = 0;
for (Filter filter : filters) {
if (i == 0) {
finder.append(" model." + filter.getProperty());
} else {
finder.append(" " + filter.getCondition() + " model." + filter.getProperty());
}
String cname = filter.getPrefix() + getProperty(filter);
if (filter.getOperator() == Operator.eq) {
finder.append(" =:" + cname);
} else if (filter.getOperator() == Operator.ne) {
finder.append(" !=:" + cname);
} else if (filter.getOperator() == Operator.ge) {
finder.append(" >=:" + cname);
} else if (filter.getOperator() == Operator.gt) {
finder.append(" >:" + cname);
} else if (filter.getOperator() == Operator.le) {
finder.append(" <=:" + cname);
} else if (filter.getOperator() == Operator.lt) {
finder.append(" <:" + cname);
} else if (filter.getOperator() == Operator.like) {
finder.append(" like:" + cname);
} else if (filter.getOperator() == Operator.isNull) {
finder.append(" is null ");
} else if (filter.getOperator() == Operator.isNotNull) {
finder.append(" is not null ");
}
if (filter.getOperator() == Operator.like) {
finder.setParam(cname, "%" + filter.getValue() + "%");
} else if (filter.getOperator() == Operator.isNotNull || filter.getOperator() == Operator.isNull) {
//不用传递参数
} else {
finder.setParam(cname, filter.getValue());
}
i++;
}
}
}
@Override
public T merge(T t) {
getHibernateTemplate().merge(t);
return t;
}
@Override
public DTO oneSQL(String sql, Class otoclass) {
DTO result = null;
List results = listSQL(sql, 0, 2, otoclass);
if (results != null && !results.isEmpty()) {
result = results.get(0);
}
return result;
}
@Override
public Page page(Pageable pageable) {
Page result = null;
List filters = pageable.getFilters();
List orders = pageable.getOrders();
Finder finder = makeFinder(filters, orders);
Pagination page = find(finder, pageable.getPageNumber(), pageable.getPageSize());
result = new Page(page.getList(), page.getTotalCount(), pageable);
return result;
}
@Override
public String transHqlToSql(String hql) {
// 当hql为null或空时,直接返回null
if (hql == null || hql.equals("")) {
return null;
}
// 获取当前session
Session session = getSession();
// 得到session工厂实现类
SessionFactoryImpl sfi = (SessionFactoryImpl) session.getSessionFactory();
// 得到Query转换器实现类
QueryTranslatorImpl queryTranslator = new QueryTranslatorImpl(hql, hql, Collections.emptyMap(), sfi);
queryTranslator.compile(Collections.emptyMap(), false);
// 得到sql
return queryTranslator.getSQLString();
}
/*
* (non-Javadoc)
*
* @see com.mendao.data.core.BaseDao#update(T)
*/
@Override
public T update(T t) {
if (t == null) {
return null;
}
getHibernateTemplate().update(t);
return t;
}
/**
* 通过Updater更新对象
*
* @param updater
* @return
*/
@SuppressWarnings("unchecked")
public T updateByUpdater(Updater updater) {
ClassMetadata cm = getSessionFactory().getClassMetadata(getEntityClass());
T bean = updater.getBean();
T po = getSession().get(getEntityClass(), cm.getIdentifier(bean));
updaterCopyToPersistentObject(updater, po, cm);
return po;
}
/**
* 将更新对象拷贝至实体对象，并处理many-to-one的更新。
*
* @param updater
* @param po
*/
private void updaterCopyToPersistentObject(Updater updater, T po, ClassMetadata cm) {
String[] propNames = cm.getPropertyNames();
String identifierName = cm.getIdentifierPropertyName();
T bean = updater.getBean();
Object value;
for (String propName : propNames) {
if (propName.equals(identifierName)) {
continue;
}
try {
value = MyBeanUtils.getSimpleProperty(bean, propName);
if (!updater.isUpdate(propName, value)) {
continue;
}
cm.setPropertyValue(po, propName, value);
} catch (Exception e) {
throw new RuntimeException("copy property to persistent object failed: '" + propName + "'", e);
}
}
}
}