mis.rar_MyBeanUtils _hibernate @Finder_mis_springmvc_springmvc h

package com.mis.common.hibernate3; import static org.hibernate.EntityMode.POJO; import java.io.Serializable; import java.lang.reflect.ParameterizedType; import java.util.ArrayList; import java.util.List; import org.apache.commons.lang.StringUtils; import org.hibernate.Criteria; import org.hibernate.LockMode; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.criterion.CriteriaSpecification; import org.hibernate.criterion.Criterion; import org.hibernate.criterion.Example; import org.hibernate.criterion.MatchMode; import org.hibernate.criterion.Order; import org.hibernate.criterion.Projection; import org.hibernate.criterion.Projections; import org.hibernate.criterion.Restrictions; import org.hibernate.criterion.Example.PropertySelector; import org.hibernate.impl.CriteriaImpl; import org.hibernate.metadata.ClassMetadata; import org.hibernate.transform.ResultTransformer; import org.hibernate.type.Type; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Repository; import org.springframework.util.Assert; import com.mis.common.page.Pagination; import com.mis.common.utils.MyBeanUtils; /** * DAO基类。 * * 提供hql分页查询，example分页查询，拷贝更新等功能。 * @author 王韬 * * @param <T> */ @Repository public abstract class BaseDaoImpl<T extends Serializable> implements BaseDao<T> { protected Logger log = LoggerFactory.getLogger(getClass()); protected SessionFactory sessionFactory; @Autowired public void setSessionFactory(SessionFactory sessionFactory) { this.sessionFactory = sessionFactory; } protected Session getSession() { return sessionFactory.getCurrentSession(); } public T save(T entity) { Assert.notNull(entity); getSession().save(entity); return entity; } public Object update(Object entity) { Assert.notNull(entity); getSession().update(entity); return entity; } public Object saveOrUpdate(Object entity) { Assert.notNull(entity); getSession().saveOrUpdate(entity); return entity; } public Object merge(Object entity) { Assert.notNull(entity); return getSession().merge(entity); } public void delete(Object entity) { Assert.notNull(entity); getSession().delete(entity); } public T deleteById(Serializable id) { Assert.notNull(id); T entity = load(id); getSession().delete(entity); return entity; } public T load(Serializable id) { Assert.notNull(id); return load(id, false); } @SuppressWarnings("unchecked") public T get(Serializable id) { Assert.notNull(id); return (T) getSession().get(getPersistentClass(), id); } @SuppressWarnings("unchecked") public T load(Serializable id, boolean lock) { Assert.notNull(id); T entity = null; if (lock) { entity = (T) getSession().load(getPersistentClass(), id, LockMode.UPGRADE); } else { entity = (T) getSession().load(getPersistentClass(), id); } return entity; } public List<T> findAll() { return findByCriteria(); } @SuppressWarnings("unchecked") public List<T> findAll(OrderBy... orders) { Criteria crit = createCriteria(); if (orders != null) { for (OrderBy order : orders) { crit.addOrder(order.getOrder()); } } return crit.list(); } public Pagination findAll(int pageNo, int pageSize, OrderBy... orders) { Criteria crit = createCriteria(); return findByCriteria(crit, pageNo, pageSize, null, OrderBy .asOrders(orders)); } /** * 按HQL查询对象列表. * * @param hql * hql语句 * @param values * 数量可变的参数 */ @SuppressWarnings("unchecked") protected List find(String hql, Object... values) { return createQuery(hql, values).list(); } /** * 按HQL查询唯一对象. */ protected Object findUnique(String hql, Object... values) { return createQuery(hql, values).uniqueResult(); } /** * 按属性查找对象列表. */ @SuppressWarnings("unchecked") public List<T> findByProperty(String property, Object value) { Assert.hasText(property); return createCriteria(Restrictions.eq(property, value)).list(); } /** * 按属性查找唯一对象. */ @SuppressWarnings("unchecked") public T findUniqueByProperty(String property, Object value) { Assert.hasText(property); Assert.notNull(value); return (T) createCriteria(Restrictions.eq(property, value)) .uniqueResult(); } public int countByProperty(String property, Object value) { Assert.hasText(property); Assert.notNull(value); return ((Number) (createCriteria(Restrictions.eq(property, value)) .setProjection(Projections.rowCount()).uniqueResult())) .intValue(); } @SuppressWarnings("unchecked") protected 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; } Query query = getSession().createQuery(finder.getOrigHql()); finder.setParamsToQuery(query); query.setFirstResult(p.getFirstResult()); query.setMaxResults(p.getPageSize()); List list = query.list(); p.setList(list); return p; } @SuppressWarnings("unchecked") protected List find(Finder finder) { Query query = getSession().createQuery(finder.getOrigHql()); finder.setParamsToQuery(query); query.setFirstResult(finder.getFirstResult()); if (finder.getMaxResults() > 0) { query.setMaxResults(finder.getMaxResults()); } List list = query.list(); return list; } @SuppressWarnings("unchecked") public List<T> findByEgList(T eg, boolean anyWhere, Condition[] conds, String... exclude) { Criteria crit = getCritByEg(eg, anyWhere, conds, exclude); return crit.list(); } @SuppressWarnings("unchecked") public List<T> findByEgList(T eg, boolean anyWhere, Condition[] conds, int firstResult, int maxResult, String... exclude) { Criteria crit = getCritByEg(eg, anyWhere, conds, exclude); crit.setFirstResult(firstResult); crit.setMaxResults(maxResult); return crit.list(); } public Pagination findByEg(T eg, boolean anyWhere, Condition[] conds, int page, int pageSize, String... exclude) { Order[] orderArr = null; Condition[] condArr = null; if (conds != null && conds.length > 0) { List<Order> orderList = new ArrayList<Order>(); List<Condition> condList = new ArrayList<Condition>(); for (Condition c : conds) { if (c instanceof OrderBy) { orderList.add(((OrderBy) c).getOrder()); } else { condList.add(c); } } orderArr = new Order[orderList.size()]; condArr = new Condition[condList.size()]; orderArr = orderList.toArray(orderArr); condArr = condList.toArray(condArr); } Criteria crit = getCritByEg(eg, anyWhere, condArr, exclude); return findByCriteria(crit, page, pageSize, null, orderArr); } /** * 根据查询函数与参数列表创建Query对象,后续可进行更多处理,辅助函数. */ protected Query createQuery(String queryString, Object... values) { Assert.hasText(queryString); Query queryObject = getSession().createQuery(queryString); if (values != null) { for (int i = 0; i < values.length; i++) { queryObject.setParameter(i, values[i]); } } return queryObject; } /** * 按Criterion查询对象列表. * * @param criterion * 数量可变的Criterion. */ @SuppressWarnings("unchecked") protected List<T> findByCriteria(Criterion... criterion) { return createCriteria(criterion).list(); } @SuppressWarnings("unchecked") protected Pagination findByCriteria(Criteria crit, int pageNo,