HibernateBaseDAO

HibernateBaseDAO接口

package com.iotek.homework.dao;

import java.io.Serializable;
import java.util.List;

/**
 * Created by Bo on 2017/4/9.
 */
public interface HibernateBaseDAO<T> {

    //添加
    void doCreate(T entity) throws Exception;

    //删除
    void doDelete(T entity) throws Exception;

    //修改
    void doUpdate(T entity) throws Exception;

    //查询
    List<T> doFind(String hql, Object...param) throws Exception;

    //根据主键ID查询
    T doFindById(Class<T> tClass, Serializable id) throws Exception;

    //分页查询
    List<T> queryPage(String hql, final int START_INDEX, final int PAGE_SIZE, Object...param) throws Exception;

    //用于分页查询的总行数
    List<Long> queryTotalRows(String hql, Object...param) throws Exception;
}

HibernateBaseDAOImpl实现类

package com.iotek.homework.dao;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.orm.hibernate4.HibernateCallback;
import org.springframework.orm.hibernate4.HibernateTemplate;

import java.io.Serializable;
import java.util.List;

/**
 * Created by Bo on 2017/4/9.
 */
public class HibernateBaseDAOImpl<T> implements HibernateBaseDAO<T> {

    @Autowired
    private HibernateTemplate hibernateTemplate;

    @Override
    public void doCreate(T entity) throws Exception {
        hibernateTemplate.save(entity);
    }

    @Override
    public void doDelete(T entity) throws Exception {
        hibernateTemplate.delete(entity);
    }

    @Override
    public void doUpdate(T entity) throws Exception {
        hibernateTemplate.update(entity);
    }

    @Override
    public List<T> doFind(String hql, Object... param) throws Exception {
        return (List<T>) hibernateTemplate.find(hql,param);
    }

    @Override
    public T doFindById(Class<T> tClass, Serializable id) throws Exception {
        return hibernateTemplate.get(tClass, id);
    }

    @Override
    public List<T> queryPage(String hql, int START_INDEX, int PAGE_SIZE, Object... param) throws Exception {
        return hibernateTemplate.execute(new HibernateCallback<List<T>>() {
            @Override
            public List<T> doInHibernate(Session session) throws HibernateException {
                Query query = session.createQuery(hql);
                if(param != null){
                    for(int i = 0 ; i < param.length ; i ++){
                        query.setParameter(i, param[i]);
                    }
                }
                query.setFirstResult(START_INDEX);
                query.setMaxResults(PAGE_SIZE);
                return query.list();
            }
        });
    }

    @Override
    public List<Long> queryTotalRows(String hql, Object...param) throws Exception {
        return (List<Long>) hibernateTemplate.find(hql,param);
    }
}

继承使用

public interface UserDAO extends HibernateBaseDAO<User>{}

public class UserDAOImpl extends HibernateBaseDAOImpl<User> implements UserDAO{}