BaseDao
package cn.htj.bos.dao.base;
import java.io.Serializable;
import java.util.List;
import org.hibernate.criterion.DetachedCriteria;
import cn.ljq.bos.utils.PageBean;
public interface BaseDao<T> {
public void save(T entity);
public void update(T entity);
public void delete(T entity);
public void saveOrUpdate(T entity);
public T findById(Serializable id);
public List<T> findAll();
// 通用更新方法
public void executeUpdate(String queryName, Object... args);
// 通用分页方法
public void pageQuery(PageBean pageBean);
// 通用条件查询
public List<T> findByCriteria(DetachedCriteria detachedCriteria);
}
BaseDaoImpl
package cn.htj.bos.dao.base;
import java.io.Serializable;
import java.lang.reflect.ParameterizedType;
import java.lang.reflect.Type;
import java.util.List;
import javax.annotation.Resource;
import org.hibernate.Query;
import org.hibernate.SessionFactory;
import org.hibernate.criterion.DetachedCriteria;
import org.hibernate.criterion.Projections;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import cn.ljq.bos.utils.PageBean;
public class BaseDaoImpl<T> extends HibernateDaoSupport implements BaseDao<T> {
private Class<T> entityClass;
@Resource
public void setMySessionFactory(SessionFactory sessionFactory){
super.setSessionFactory(sessionFactory);
}
public BaseDaoImpl() {
Type genericSuperclass = this.getClass().getGenericSuperclass();
if(genericSuperclass instanceof ParameterizedType){
ParameterizedType pt = (ParameterizedType) genericSuperclass;
entityClass = (Class<T>) pt.getActualTypeArguments()[0];
}
}
@Override
public void save(T entity) {
this.getHibernateTemplate().save(entity);
}
@Override
public void update(T entity) {
this.getHibernateTemplate().update(entity);
}
@Override
public void delete(T entity) {
this.getHibernateTemplate().delete(entity);
}
@Override
public T findById(Serializable id) {
return this.getHibernateTemplate().get(entityClass, id);
}
@Override
public List<T> findAll() {
String hql = "from " + entityClass.getSimpleName();
return this.getHibernateTemplate().find(hql);
}
/**
* 通用更新方法
*/
@Override
public void executeUpdate(String queryName, Object... args) {
//根据配置文件中的配置的sql语句,获得Query对象
Query query = this.getSession().getNamedQuery(queryName);
int i=0;
for (Object arg : args) {
query.setParameter(i++, arg);
}
query.executeUpdate();
}
/**
* 通用分页查询方法
*/
@Override
public void pageQuery(PageBean pageBean) {
int currentPage = pageBean.getCurrentPage();
int pageSize = pageBean.getPageSize();
DetachedCriteria detachedCriteria = pageBean.getDetachedCriteria();
// 查询出List数据集合(即rows)设置回pageBean
//总数据量----select count(*) from bc_staff
//改变Hibernate框架发出的sql形式
detachedCriteria.setProjection(Projections.rowCount());//select count(*) from bc_staff
List<Long> list = this.getHibernateTemplate().findByCriteria(detachedCriteria);
Long total = list.get(0);
pageBean.setTotal(total.intValue());//设置总数据量
detachedCriteria.setProjection(null);//修改sql的形式为select * from ....
//重置表和类的映射关系
detachedCriteria.setResultTransformer(DetachedCriteria.ROOT_ENTITY);
//当前页展示的数据集合
int firstResult = (currentPage - 1) * pageSize;
int maxResults = pageSize;
List rows = this.getHibernateTemplate().findByCriteria(detachedCriteria, firstResult, maxResults);
pageBean.setRows(rows);
}
@Override
public void saveOrUpdate(T entity) {
this.getHibernateTemplate().saveOrUpdate(entity);
}
// 通用条件查询方法
@Override
public List<T> findByCriteria(DetachedCriteria detachedCriteria) {
return this.getHibernateTemplate().findByCriteria(detachedCriteria);
}
}
然后,实现具体的Dao,例如UserDao
public interface UserDao extends BaseDao<User> {
}
public class UserDaoImpl extends BaseDaoImpl<User> implements UserDao {
}
BaseAction
package cn.htj.bos.web.action.base;
import java.io.IOException;
import java.lang.reflect.ParameterizedType;
import java.lang.reflect.Type;
import java.util.List;
import org.apache.struts2.ServletActionContext;
import org.hibernate.criterion.DetachedCriteria;
import org.springframework.beans.factory.annotation.Autowired;
import com.opensymphony.xwork2.ActionSupport;
import com.opensymphony.xwork2.ModelDriven;
import cn.itcast.crm.domain.CustomerService;
import cn.ljq.bos.utils.PageBean;
import net.sf.json.JSONArray;
import net.sf.json.JSONObject;
import net.sf.json.JsonConfig;
public class BaseAction<T> extends ActionSupport implements ModelDriven<T> {
@Autowired
protected CustomerService customerService;
//-->重构分页
// protected int page;
// protected int rows;
public void setPage(int page) {
pageBean.setCurrentPage(page);
}
public void setRows(int rows) {
pageBean.setPageSize(rows);
}
protected PageBean pageBean = new PageBean();
protected DetachedCriteria detachedCriteria = null;
public void writePageBean2Json(PageBean pageBean, String[] excludes) throws IOException{
JsonConfig jsonCfg = new JsonConfig();
jsonCfg.setExcludes(excludes);
JSONObject jsonObject = JSONObject.fromObject(pageBean, jsonCfg);
String json = jsonObject.toString();
ServletActionContext.getResponse().setContentType("text/json;charset=UTF-8");
ServletActionContext.getResponse().getWriter().write(json);
}
//<--重构分页
protected T model;
//在构造方法中,动态获得T的类型,利用反射实例化
public BaseAction() {
Type genericSuperclass = this.getClass().getGenericSuperclass();
if(genericSuperclass instanceof ParameterizedType){
ParameterizedType pt = (ParameterizedType) genericSuperclass;
Class clz = (Class) pt.getActualTypeArguments()[0];
detachedCriteria = DetachedCriteria.forClass(clz);
pageBean.setDetachedCriteria(detachedCriteria);
try {
model = (T) clz.newInstance();
} catch (Exception e) {
throw new RuntimeException("反射实例化异常了。。。");
}
}
}
@Override
public T getModel() {
return model;
}
public void writeList2Json(List list, String[] excludes) throws IOException{
JsonConfig jsonConfig = new JsonConfig();
jsonConfig.setExcludes(excludes);
JSONArray jsonArray = JSONArray.fromObject(list, jsonConfig);
String json = jsonArray.toString();
ServletActionContext.getResponse().setContentType("text/json;charset=UTF-8");
ServletActionContext.getResponse().getWriter().write(json);
}
public void writeObject2Json(Object obj, String[] excludes) throws IOException{
JsonConfig jsonCfg = new JsonConfig();
jsonCfg.setExcludes(excludes);
JSONObject jsonObject = JSONObject.fromObject(obj, jsonCfg);
String json = jsonObject.toString();
ServletActionContext.getResponse().setContentType("text/json;charset=UTF-8");
ServletActionContext.getResponse().getWriter().write(json);
}
}
实现具体的Action类,例如UserAction
public class UserAction extends BaseAction<User> {
}