CRUD的共公代码

package cn.itcast.oa.base;import java.util.List;import cn.itcast.oa.domain.PageBean;import cn.itcast.oa.util.QueryHelper;/** * CRUD的Dao的接口 *  * @author  * @version V1.0 */public interface DaoSupport<T> {/** * 保存实体 *  * @param entity */void save(T entity);/** * 删除实体 *  * @param id */void delete(Long id);/** * 更新实体 *  * @param entity */void update(T entity);/** * 根据id查询 *  * @param id * @return */T getById(Long id);/** * 按id查询 *  * @param id * @return */List<T> getByIds(Long[] ids);/** * 查询所有 *  * @return */List<T> findAll();/** * 公共的查询分页信息的方法 *  * @param pageNum *            当前页（默认：第1页） * @param pageSize *            每页显示多少条（默认：每页显示10条） * @param hql *            查询数据列表的HQL * @param paramenters *            参数列表,与HQL中占位符参数一一对应 * @return 分页信息 */@DeprecatedPageBean getPageBean(int pageNum, int pageSize, String hql, List<Object> parameters);/** * 公共的查询分页信息的方法(最终版) *  * @param pageNum *            当前页（默认：第1页） * @param pageSize *            每页显示多少条（默认：每页显示10条） * @param queryHelper *            查询HQL与参数列表 * @return 分页信息 */PageBean getPageBean(int pageNum, int pageSize, QueryHelper queryHelper);}

package cn.itcast.oa.base;import java.lang.reflect.ParameterizedType;import java.util.Collections;import java.util.List;import javax.annotation.Resource;import org.hibernate.Query;import org.hibernate.Session;import org.hibernate.SessionFactory;import org.springframework.transaction.annotation.Transactional;import cn.itcast.oa.domain.PageBean;import cn.itcast.oa.util.QueryHelper;/** * CRUD的Dao的实现类 *  * @author * @version V1.0 */// @Transactional("txManager")注解可以被继承// @Transactional("txManager")注解对父类中声明的方法无效@Transactional("txManager")@SuppressWarnings({ "unchecked", "rawtypes" })public class DaoSupportImpl<T> implements DaoSupport<T> {@Resourceprivate SessionFactory sessionFactory;private Class<T> clazz;// 这是一个问题public DaoSupportImpl() {// 使用反射技术得到T的真实类型ParameterizedType pt = (ParameterizedType) this.getClass().getGenericSuperclass();// 获取当前new的对象的泛型的父类类型this.clazz = (Class<T>) pt.getActualTypeArguments()[0];// 获取第一个类型参数的真实类型System.out.println("clazz ---> " + clazz);}/** * 获取当前可用的Session *  * @return */protected Session getSession() {return sessionFactory.getCurrentSession();}@Transactionalpublic void save(T entity) {getSession().save(entity);}public void delete(Long id) {Object obj = getById(id);if (obj != null) {getSession().delete(obj);}}public void update(T entity) {getSession().update(entity);}public T getById(Long id) {if (id == null) {return null;} else {return (T) getSession().get(clazz, id);}}public List<T> getByIds(Long[] ids) {if (ids == null || ids.length == 0) {return Collections.EMPTY_LIST;} else {return getSession().createQuery(//"from " + clazz.getSimpleName() + " where id in (:ids)")//.setParameterList("ids", ids)//.list();}}public List<T> findAll() {return getSession().createQuery(//"from " + clazz.getSimpleName())//.list();}// 公共的查询分页信息的方法@Deprecatedpublic PageBean getPageBean(int pageNum, int pageSize, String hql, List<Object> parameters) {System.out.println("------> DaoSupporImpl.getPageBean()");// 查询本页的数据列表Query listQuery = getSession().createQuery(hql);// 创建查询对象if (parameters != null) {// 设置参数for (int i = 0; i < parameters.size(); i++) {listQuery.setParameter(i, parameters.get(i));}}listQuery.setFirstResult((pageNum - 1) * pageSize);//listQuery.setMaxResults(pageSize);//List list = listQuery.list();// 执行查询// 查询总记录数量Query countQuery = getSession().createQuery("select count(*) " + hql);if (parameters != null) {// 设置参数for (int i = 0; i < parameters.size(); i++) {countQuery.setParameter(i, parameters.get(i));}}Long count = (Long) countQuery.uniqueResult();// 执行查询return new PageBean(pageNum, pageSize, count.intValue(), list);}// 公共的查询分页信息的方法(最终版)public PageBean getPageBean(int pageNum, int pageSize, QueryHelper queryHelper) {System.out.println("------> DaoSupporImpl.getPageBean(int pageNum, int pageSize, QueryHelper queryHelper)");List<Object> parameters = queryHelper.getParameters();// 查询本页的数据列表Query listQuery = getSession().createQuery(queryHelper.getListQueryHql());// 创建查询对象if (parameters != null) {// 设置参数for (int i = 0; i < parameters.size(); i++) {listQuery.setParameter(i, parameters.get(i));}}listQuery.setFirstResult((pageNum - 1) * pageSize);//listQuery.setMaxResults(pageSize);//List list = listQuery.list();// 执行查询// 查询总记录数量Query countQuery = getSession().createQuery(queryHelper.getCountQueryHql());if (parameters != null) {// 设置参数for (int i = 0; i < parameters.size(); i++) {countQuery.setParameter(i, parameters.get(i));}}Long count = (Long) countQuery.uniqueResult();// 执行查询return new PageBean(pageNum, pageSize, count.intValue(), list);}}

Action公共代码

package cn.itcast.oa.base;import java.lang.reflect.ParameterizedType;import javax.annotation.Resource;import cn.itcast.oa.domain.User;import cn.itcast.oa.service.DepartmentService;import cn.itcast.oa.service.ForumService;import cn.itcast.oa.service.PrivilegeService;import cn.itcast.oa.service.ReplyService;import cn.itcast.oa.service.RoleService;import cn.itcast.oa.service.TopicService;import cn.itcast.oa.service.UserService;import com.opensymphony.xwork2.ActionContext;import com.opensymphony.xwork2.ActionSupport;import com.opensymphony.xwork2.ModelDriven;/** * 公共实例声明Action类 *  * @author 风清杨 * @version V1.0 */@SuppressWarnings("serial")public abstract class BaseAction<T> extends ActionSupport implements ModelDriven<T> {/** * 获了当前登录的用户 *  * @return */protected User getCurrentUser() {return (User) ActionContext.getContext().getSession().get("user");}// ===========Service实例的声明===========@Resourceprotected DepartmentService departmentService;@Resourceprotected RoleService roleService;@Resourceprotected UserService userService;@Resourceprotected PrivilegeService privilegeService;@Resourceprotected ForumService forumService;@Resourceprotected TopicService topicService;@Resourceprotected ReplyService replyService;// ===========ModelDriven的支持===========protected T model;@SuppressWarnings("unchecked")public BaseAction() {// 通过反射获取model的真实类型ParameterizedType pt = (ParameterizedType) this.getClass().getGenericSuperclass();Class<T> clazz = (Class<T>) pt.getActualTypeArguments()[0];// 通过返射创建model的实例try {model = clazz.newInstance();} catch (Exception e) {throw new RuntimeException();}}public T getModel() {return model;}// ========= 分页用的参数 =========/** 当前页（默认：第1页） */protected int pageNum = 1;;/** 每页显示多少条（默认：每页显示10条） */protected int pageSize = 10;// ---public int getPageNum() {return pageNum;}public void setPageNum(int pageNum) {this.pageNum = pageNum;}public int getPageSize() {return pageSize;}public void setPageSize(int pageSize) {this.pageSize = pageSize;}}