Maven4MyEclipse 搭建ssh2+extjs项目(4)struts2.3.4+hibernate4.2.0+spri...

package com.jjee.dao; import java.io.Serializable; import java.util.List; import java.util.Map; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.criterion.Example; import org.hibernate.transform.Transformers; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Repository; /** * * @ClassName:BaseDao * @Description:dao 基类，包括增删改查 * @author:gaoFeng * @date:2013-2-27 下午2:31:42 */ @Repository public class ReadDao implements Serializable { @Autowired private SessionFactory sessionFactory; public Session getSession() { return sessionFactory.getCurrentSession(); } public List findBySql(String sql) { return getSession().createSQLQuery(sql).list(); } public <T> List<T> findByExceple(T t) { return getSession().createCriteria(t.getClass()).add(Example.create(t)) .list(); } /** * * @Description:直接就根据hql查询，这里的hql是调用者直接适配好的，方法内不做参数绑定 * @author:gaoFeng * @param:@param hql * @param:@return * @return: List * @date:2013-3-16 上午10:41:03 */ public List findByHql(String hql) { return getSession().createQuery(hql).list(); } /** * * @Description:直接就根据hql查询，这里的hql是调用者直接适配好的，方法内不做参数绑定,并分页 * @author:gaoFeng * @param:@param hql * @param:@param firstResult * @param:@param maxResult * @param:@return * @return: List * @date:2013-3-16 上午10:41:44 */ public List findByHqlLimit(String hql, final int firstResult, final int maxResult) { Query query = getSession().createQuery(hql); query.setFirstResult(firstResult); query.setMaxResults(maxResult); return query.list(); } /** * * @Description:根据hql和参数查询数据 * @author:gaoFeng * @param:@param hql * @param:@param params * @param:@return * @return: List * @date:2013-3-16 上午10:42:12 */ public List findByHql(String hql, Object[] params) { Query query = getSession().createQuery(hql); for (int i = 0; i < params.length; i++) { query.setParameter(i, params[i]); } return query.list(); } /** * * @Description:根据hql和参数查询数据并分页 * @author:gaoFeng * @param:@param hql * @param:@param params * @param:@param firstResult * @param:@param maxResult * @param:@return * @return: List * @date:2013-3-16 上午10:42:35 */ public List findByHqlLimit(String hql, Object[] params, final int firstResult, final int maxResult) { Query query = getSession().createQuery(hql); for (int i = 0; i < params.length; i++) { query.setParameter(i, params[i]); } query.setFirstResult(firstResult); query.setMaxResults(maxResult); return query.list(); } public Object findByHqlUniqueResult(String hql) { return getSession().createQuery(hql).uniqueResult(); } public <T> T get(Class<T> entityClass, Integer id) { return (T) getSession().get(entityClass, id); } public <T> List<T> findAll(String hql, Class<T> entityClass) { return findAll(hql, entityClass, new Object[] {}); } public <T> List<T> findAll(String hql, Class<T> entityClass, Object param) { return findAll(hql, entityClass, new Object[] { param }); } public <T> List<T> findAll(String hql, Class<T> entityClass, Object[] params) { Query query = getSession().createQuery(hql); for (int i = 0; i < params.length; i++) { query.setParameter(i, params[i]); } return (List<T>) query.list(); } public <T> List<T> findByPage(final String hql, Class<T> entityClass, final int firstResult, final int maxResult) { return findByPage(hql, entityClass, new Object[] {}, firstResult, maxResult); } public <T> List<T> findByPage(final String hql, Class<T> entityClass, final Object param, final int firstResult, final int maxResult) { return findByPage(hql, entityClass, new Object[] { param }, firstResult, maxResult); } public <T> List<T> findByPage(final String hql, Class<T> entityClass, final Object[] params, final int firstResult, final int maxResult) { Query query = getSession().createQuery(hql); for (int i = 0; i < params.length; i++) { query.setParameter(i, params[i]); } query.setFirstResult(firstResult); query.setMaxResults(maxResult); return (List<T>) query.list(); } }