JAVA企业级项目通用权限框架.zip

package cn.imethan.common.hibernate; import java.io.Serializable; import java.util.ArrayList; import java.util.Collection; import java.util.List; import java.util.Map; import org.apache.commons.lang3.StringUtils; import org.hibernate.Criteria; 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.MatchMode; import org.hibernate.criterion.Order; import org.hibernate.criterion.Projection; import org.hibernate.criterion.Projections; import org.hibernate.criterion.Restrictions; import org.hibernate.internal.CriteriaImpl; import org.hibernate.transform.ResultTransformer; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.orm.hibernate4.HibernateTemplate; import org.springframework.util.Assert; import cn.imethan.common.hibernate.SearchFilter.MatchType; import cn.imethan.common.utils.ConvertUtil; import cn.imethan.common.utils.ReflectionUtil; /** * HibernateTemplateSupport.java * * DAO实现类继承该类，实现CRUD操作 * * @author Ethan Wong * @time 2015年8月29日下午10:39:57 */ public class HibernateTemplateSupport<T, P extends Serializable> implements CrudOperations<T,P> { @Autowired protected SessionFactory sessionFactory; @Autowired protected HibernateTemplate hibernateTemplate; protected Class<T> clazz;//实体类 public HibernateTemplateSupport() { clazz = ReflectionUtil.getClassGenricType(this.getClass(), 0); } /** * 获取session * * @return * * @author Ethan * @datetime 2015年8月31日 下午8:25:18 */ public Session getSession() { return hibernateTemplate.getSessionFactory().getCurrentSession(); } /** * 创建HQL查询 * @param hql * @return * * @author Ethan * @datetime 2015年8月31日 下午10:22:36 */ public Query createQuery(String hql){ return this.getSession().createQuery(hql); } // ------------------------------------------------------------------------- // 增加方法 // ------------------------------------------------------------------------- @Override public void save(T entity) { this.getSession().save(entity); } @Override public void saveOrUpdate(T entity) { this.getSession().saveOrUpdate(entity); } // ------------------------------------------------------------------------- // 删除方法 // ------------------------------------------------------------------------- @Override public void deleteById(P id) { this.hibernateTemplate.delete(this.getById(id)); } @Override public void delete(T entity) { Assert.isNull(entity, "不能删除entity为空的记录"); this.hibernateTemplate.delete(entity); } @Override public void deleteAll(){ String entityName = this.hibernateTemplate.getSessionFactory().getClassMetadata(this.clazz).getEntityName(); String DELETE_ALL = "delete from " + entityName; getSession().createQuery(DELETE_ALL); } // ------------------------------------------------------------------------- // 查询方法 // ------------------------------------------------------------------------- @Override public T getById(P id) { return (T) this.getSession().get(clazz, id); } @Override public List<T> getByIdList(Collection<P> ids, boolean isCache) { String idName = this.hibernateTemplate.getSessionFactory().getClassMetadata(this.clazz).getIdentifierPropertyName(); return getByCriterions(isCache, new Criterion[] { Restrictions.in(idName, ids) }); } @Override public List<T> getAll() { return this.hibernateTemplate.loadAll(clazz); } @Override public List<T> getByFilter(SearchFilter searchFilter, boolean isCache) { Criterion criterion = buildCriterionBySearchFilter(searchFilter.getPropertyName(), searchFilter.getPropertyClass(), searchFilter.getMatchValue(), searchFilter.getMatchType()); return getByCriterions(isCache, new Criterion[] { criterion }); } @Override public List<T> getByFilters(List<SearchFilter> searchFilters, boolean isCache) { List<Criterion> list = new ArrayList<Criterion>(); for (SearchFilter searchFilter : searchFilters) { Criterion criterion = buildCriterionBySearchFilter(searchFilter.getPropertyName(), searchFilter.getPropertyClass(), searchFilter.getMatchValue(), searchFilter.getMatchType()); list.add(criterion); } return getByCriterions(isCache, (Criterion[]) list.toArray(new Criterion[list.size()])); } @Override public List<T> getByFilterAndOrder(SearchFilter searchFilter, Order order, boolean isCache) { Criterion criterion = buildCriterionBySearchFilter(searchFilter.getPropertyName(), searchFilter.getPropertyClass(), searchFilter.getMatchValue(), searchFilter.getMatchType()); List<Order> orders = new ArrayList<Order>(); orders.add(order); return getByCriterionsAndOrders(isCache, new Criterion[] { criterion }, orders); } @Override public List<T> getByFilterAndOrders(SearchFilter searchFilter, List<Order> orders, boolean isCache) { Criterion criterion = buildCriterionBySearchFilter(searchFilter.getPropertyName(), searchFilter.getPropertyClass(), searchFilter.getMatchValue(), searchFilter.getMatchType()); return getByCriterionsAndOrders(isCache, new Criterion[] { criterion }, orders); } @Override public List<T> getByFiltersAndOrder(List<SearchFilter> searchFilters, Order order, boolean isCache) { List<Criterion> list = new ArrayList<Criterion>(); for (SearchFilter searchFilter : searchFilters) { Criterion criterion = buildCriterionBySearchFilter(searchFilter.getPropertyName(), searchFilter.getPropertyClass(), searchFilter.getMatchValue(), searchFilter.getMatchType()); list.add(criterion); } List<Order> orders = new ArrayList<Order>(); orders.add(order); return getByCriterionsAndOrders(isCache, (Criterion[]) list.toArray(new Criterion[list.size()]), orders); } @Override public List<T> getByFiltersAndOrders(List<SearchFilter> searchFilters, List<Order> orders, boolean isCache) { List<Criterion> list = new ArrayList<Criterion>(); for (SearchFilter searchFilter : searchFilters) { Criterion criterion = buildCriterionBySearchFilter(searchFilter.getPropertyName(), searchFilter.getPropertyClass(), searchFilter.getMatchValue(), searchFilter.getMatchType()); list.add(criterion); } return getByCriterionsAndOrders(isCache, (Criterion[]) list.toArray(new Criterion[list.size()]), orders); } @Override public Page<T> getPageByHql(Page<T> page, boolean isCache, String hql, Map<String, ?> values) { Assert.notNull(page, "page不能为空"); Query query = this.getSession().createQuery(hql).setProperties(values); long totalCount = countSqlResult(hql, isCache, values); page.setTotalCount(totalCount); if (isCache) { query.setCacheable(true); } page.setList(query.list()); return page; } @Override public Page<T> getPage(Page<T> page, boolean isCache) { return getPageByCriterions(page, isCache, new Criterion[0],null); } @Override public Page<T> getPageByFilter(Page<T> page,SearchFilter searchFilter, boolean isCache) { Criterion criterion = buildCriterionBySearchFilter(searchFilter.getPropertyName(), searchFilter.getPropertyClass(), searchFilter.getMatchValue(), searchFilter.getMatchType()); List<SearchFilter> searchFilters = new ArrayList<SearchFilter>(); searchFilters.add(searchFilter); return this.getPageByCriterions(page, isCache, new Criterion[] { criterion },searchFilters); } @Override public Page<T> getPageByFilterAndOrder(Page<T> page,SearchFilter searchFilter,Order order, boolean isCache) { Criterion criterion = buildCriterionBySearchFilter(searchFilter.getPropertyName(), searchFilter.getPropertyClass(), searchFilter.getMatchValue(), search