一个基于struts2+hibernate3.2的校园购物网

package com.rzpt.util; import java.io.Serializable; import java.util.Collection; import java.util.List; import java.util.Map; import org.hibernate.Criteria; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.Transaction; import org.hibernate.cfg.Configuration; import org.hibernate.criterion.Restrictions; final public class HibernateUtil { public static final int EQ = 0;// 等于 public static final int GT = 1;// 大于 public static final int LT = 2;// 小于 public static final int GE = 3;// 大于等于 public static final int LE = 4;// 小于等于 private static SessionFactory factory; private static Session session; static { Configuration cfg = new Configuration(); cfg.configure(); factory = cfg.buildSessionFactory(); } private HibernateUtil() { } public static SessionFactory getSessionFactory() { return factory; } public static Session getSession() { session = factory.openSession(); return session; } public static void save(Object object) { try { getSession(); Transaction t = session.beginTransaction(); session.save(object); t.commit(); } finally { if (session != null) session.close(); } } public static Object get(Class clazz, Serializable id) { try { getSession(); return session.get(clazz, id); } finally { if (session != null) session.close(); } } public static Object getAll(Class clazz) { try { getSession(); Criteria cri = session.createCriteria(clazz); List list = cri.list(); return list; } finally { if (session != null) session.close(); } } public static void update(Object object) { try { getSession(); Transaction t = session.beginTransaction(); session.update(object); t.commit(); } finally { if (session != null) session.close(); } } public static void delete(Object object) { try { getSession(); Transaction t = session.beginTransaction(); session.delete(object); t.commit(); } finally { if (session != null) session.close(); } } public static List query(Class clazz, String propertyName, Serializable value) { try { getSession(); Criteria cri = session.createCriteria(clazz); cri.add(Restrictions.eq(propertyName, value)); List list = cri.list(); return list; } finally { if (session != null) session.close(); } } public static List query(Class clazz, String propertyName, Serializable value, int type) { try { getSession(); Criteria cri = session.createCriteria(clazz); switch (type) { case EQ: cri.add(Restrictions.eq(propertyName, value)); break; case GT: cri.add(Restrictions.gt(propertyName, value)); break; case LT: cri.add(Restrictions.lt(propertyName, value)); break; case LE: cri.add(Restrictions.le(propertyName, value)); break; case GE: cri.add(Restrictions.ge(propertyName, value)); break; } List list = cri.list(); return list; } finally { if (session != null) session.close(); } } public static List queryByPagination(Class clazz, String propertyName, Serializable value, int type, int start, int count) { try { getSession(); Criteria cri = session.createCriteria(clazz); switch (type) { case EQ: cri.add(Restrictions.eq(propertyName, value)); break; case GT: cri.add(Restrictions.gt(propertyName, value)); break; case LT: cri.add(Restrictions.lt(propertyName, value)); break; case LE: cri.add(Restrictions.le(propertyName, value)); break; case GE: cri.add(Restrictions.ge(propertyName, value)); break; } cri.setFirstResult(start); cri.setMaxResults(count); List list = cri.list(); return list; } finally { if (session != null) session.close(); } } public static List query(Class clazz, Map map) { try { getSession(); Criteria cri = session.createCriteria(clazz); cri.add(Restrictions.allEq(map)); List list = cri.list(); return list; } finally { if (session != null) session.close(); } } public static List query(Class clazz, Collection<Condition> conditions) { try { getSession(); Criteria cri = session.createCriteria(clazz); for (Condition condition : conditions) { switch (condition.getType()) { case EQ: cri.add(Restrictions.eq(condition.getPropertiyName(), condition.getValue())); break; case GT: cri.add(Restrictions.gt(condition.getPropertiyName(), condition.getValue())); break; case LT: cri.add(Restrictions.lt(condition.getPropertiyName(), condition.getValue())); break; case LE: cri.add(Restrictions.le(condition.getPropertiyName(), condition.getValue())); break; case GE: cri.add(Restrictions.ge(condition.getPropertiyName(), condition.getValue())); break; } } List list = cri.list(); return list; } finally { if (session != null) session.close(); } } public static List queryByPagination(Class clazz, int start, int count) { try { getSession(); Criteria cri = session.createCriteria(clazz); cri.setFirstResult(start); cri.setMaxResults(count); List list = cri.list(); return list; } finally { if (session != null) session.close(); } } public static List queryByPagination(Class clazz, Map map, int start, int count) { try { getSession(); Criteria cri = session.createCriteria(clazz); cri.add(Restrictions.allEq(map)); cri.setFirstResult(start); cri.setMaxResults(count); List list = cri.list(); return list; } finally { if (session != null) session.close(); } } public static List query(String hql) { try { getSession(); Query query = session.createQuery(hql); List list = query.list(); return list; } finally { if (session != null) session.close(); } } public static List queryByPagination(Class clazz, Map map, Collection<Condition> conditions, int start, int count) { try { getSession(); Criteria cri = session.createCriteria(clazz); for (Condition condition : conditions) { switch (condition.getType()) { case EQ: cri.add(Restrictions.eq(condition.getPropertiyName(), condition.getValue())); break; case GT: cri.add(Restrictions.gt(condition.getPropertiyName(), condition.getValue())); break; case LT: cri.add(Restrictions.lt(condition.getPropertiyName(), condition.getValue())); break; case LE: cri.add(Restrictions.le(condition.getPropertiyName(), condition.getValue())); break; case GE: cri.add(Restrictions.ge(condition.getPropertiyName(), condition.getValue())); break; } } cri.setFirstResult(start); cri.setMaxResults(count); List list = cri.list(); return list; } finally { if (session != null) session.close(); } } }