SpringMVC开发框架+示例源码+lib包

package dev.spring.mvc.base; import java.io.Serializable; import java.lang.reflect.Field; import java.lang.reflect.ParameterizedType; import java.lang.reflect.Type; import java.util.List; import java.util.Map; import javax.annotation.Resource; import javax.persistence.Id; import org.apache.commons.lang3.StringUtils; import org.apache.log4j.Logger; import org.hibernate.Criteria; import org.hibernate.HibernateException; import org.hibernate.Query; import org.hibernate.SessionFactory; import org.hibernate.criterion.Example; import org.springframework.transaction.annotation.Propagation; import org.springframework.transaction.annotation.Transactional; import dev.spring.mvc.common.enums.EOrderMode; import dev.spring.mvc.common.util.HqlUtils; import dev.spring.mvc.common.util.QueryBuilderUtils; import dev.spring.mvc.entity.vo.Pager; import dev.spring.mvc.entity.vo.QueryBuilder; @Transactional public class BaseDao<T extends Serializable> { @Resource protected SessionFactory sessionFactory; // 当前泛型类 @SuppressWarnings("rawtypes") private Class entityClass = null; // 当前主键名称 private String pkname = null; private String HQL_LIST_ALL = null; private String HQL_COUNT_ALL = null; private Logger log = Logger.getLogger(BaseDao.class); @SuppressWarnings("rawtypes") public Class getEntityClass() { return entityClass; } @SuppressWarnings("rawtypes") public void setEntityClass(Class entityClass) { this.entityClass = entityClass; } public BaseDao() { init(); } @SuppressWarnings("rawtypes") private void init() { try { // 获取当前泛型类 Type type = this.getClass().getGenericSuperclass(); if (type.toString().indexOf("BaseDao") != -1) { ParameterizedType type1 = (ParameterizedType) type; Type[] types = type1.getActualTypeArguments(); setEntityClass((Class) types[0]); } else { type = ((Class) type).getGenericSuperclass(); ParameterizedType type1 = (ParameterizedType) type; Type[] types = type1.getActualTypeArguments(); setEntityClass((Class) types[0]); } getPkname(); HQL_LIST_ALL = "from " + this.entityClass.getSimpleName() + " order by " + pkname + " asc"; HQL_COUNT_ALL = "select count(*) from " + this.entityClass.getSimpleName(); } catch (Exception er) { log.error("", er); } } /** * 获取主键名称 * * @return */ public String getPkname() throws Exception { Field[] fields = this.entityClass.getDeclaredFields();// 反射类字段 for (Field field : fields) { if (field.isAnnotationPresent(Id.class)) { this.pkname = field.getName(); break; } } return pkname; } /** * 保存实例 * * @param t * @throws HibernateException */ @Transactional(propagation = Propagation.REQUIRED) public Serializable save(T t) throws Exception { if (t != null) return sessionFactory.getCurrentSession().save(t); return null; } /** * 修改实例 * * @param t * @throws HibernateException */ @Transactional(propagation = Propagation.REQUIRED) public boolean update(T t) throws Exception { if (t != null) { sessionFactory.getCurrentSession().update(t); return true; } return false; } /** * 删除实例 * * @param t * @throws HibernateException */ @Transactional(propagation = Propagation.REQUIRED) public boolean delete(T t) throws Exception { if (t != null) { sessionFactory.getCurrentSession().delete(t); return true; } return false; } /** * 根据主键ID,删除实例 * * @param id * @return * @throws Exception */ @Transactional(propagation = Propagation.REQUIRED) public boolean deleteById(Serializable id) throws Exception { T t = this.find(id); if (t != null) { return this.delete(t); } return false; } /** * 获取实例 * * @param id * @throws HibernateException */ @Transactional(propagation = Propagation.REQUIRED) @SuppressWarnings("unchecked") public T find(Serializable id) throws Exception { if (id != null) { return (T) sessionFactory.getCurrentSession().get(getEntityClass(), id); } return null; } /** * 查询全部 * * @throws HibernateException */ @SuppressWarnings("unchecked") @Transactional(propagation = Propagation.REQUIRED) public List<T> findAll() throws Exception { Query query = sessionFactory.getCurrentSession().createQuery( HQL_LIST_ALL); if (query != null) return query.list(); return null; } /** * 查询总数 * * @throws HibernateException */ @Transactional(propagation = Propagation.REQUIRED) public Integer findTotalRow() throws Exception { Query query = sessionFactory.getCurrentSession().createQuery( HQL_COUNT_ALL); if (query != null) { List<?> list = query.list(); if (list != null && !list.isEmpty()) { return ((Integer) list.get(0)).intValue(); } } return null; } /** * 按条件查询总记录数 * * @param countHql * @param map * @return * @throws Exception */ @Transactional(propagation = Propagation.REQUIRED) public Long findTotalRow(String countHql, final Object... objects) throws Exception { if (StringUtils.isNotBlank(countHql)) { Query query = sessionFactory.getCurrentSession().createQuery( countHql); if (query != null) { if (objects != null) { for (int i = 0; i < objects.length; i++) { query.setParameter(i, objects[i]); } } return (Long) query.list().get(0); } } return null; } /** * 按条件查询总记录数 * * @param countHql * @param params * @return * @throws Exception */ @Transactional(propagation = Propagation.REQUIRED) public Long findTotalRow(String countHql, final Map<String, Object> params) throws Exception { if (StringUtils.isNotBlank(countHql)) { Query query = sessionFactory.getCurrentSession().createQuery( countHql); if (query != null) { if (params != null && params.keySet() != null) { for (String colName : params.keySet()) { query.setParameter(colName, params.get(colName)); } } return (Long) query.list().get(0); } } return null; } /** * QBC查询 * * @param criteria * @throws HibernateException */ @SuppressWarnings("unchecked") @Transactional(propagation = Propagation.REQUIRED) public List<T> findByCriteria(Criteria criteria) throws Exception { if (criteria != null) { Criteria ct = sessionFactory.getCurrentSession().createCriteria( getEntityClass()); return ct.list(); } return null; } /** * QBE查询 * * @param t * @throws HibernateException */ @SuppressWarnings("unchecked") @Transactional(propagation = Propagation.REQUIRED) public List<T> findByExample(T t) throws Exception { if (t != null) { Example example = Example.create(t); Criteria criteria = sessionFactory.getCurrentSession() .createCriteria(getEntityClass()); criteria.add(example); return criteria.list(); } return null; } /** * HQL查询 * * @param hql * @param objects * @throws HibernateException */ @SuppressWarnings("unchecked") @Transactional(propagation = Propagation.REQUIRED) public List<T> findByHql(String hql, final Object... objects) throws Exception { if (StringUtils.isNotBlank(hql)) { Query query = sessionFactory.getCurrentSession().createQuery(hql); if (query != null) { for (int i = 0; i < objects.length; i++) { query.setParameter(i, objects[i]); } return (List<T>) query.list(); } } return null; } /** * SQL查询 * * @param hql * @param objects * @throws HibernateException */ @SuppressWarnings("unchecked") @Transactional(pro