ssh电子商务demo项目

package com.tarena.dangdang.dao.impl; import java.util.List; import org.hibernate.Query; import org.springframework.orm.hibernate3.support.HibernateDaoSupport; import com.tarena.dangdang.dao.Pagination; import com.tarena.dangdang.dao.ProductDao; import com.tarena.dangdang.entity.Book; import com.tarena.dangdang.entity.Product; public class ProductDaoImpl extends HibernateDaoSupport implements ProductDao { // private static final String S_CDESC = ""; private static final String CID_DEFUALT = "from Book b join fetch b.category c where c.id=? order by b.id"; private static final String PRICEASC = "from Book b join fetch b.category c where c.id=? order by b.dangPrice asc"; private static final String PRICEDESC = "from Book b join fetch b.category c where c.id=? order by b.dangPrice desc"; private static final String P_TASC = "from Book b join fetch b.category c where c.id=? order by b.publishTime asc"; private static final String P_TDESC = "from Book b join fetch b.category c where c.id=? order by b.publishTime desc"; private static final String A_TDESC = "from Book b join fetch b.category c where c.id=? order by b.addTime desc"; private static final String A_TASC = "from Book b join fetch b.category c where c.id=? order by b.addTime asc"; ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// private static final String PCID_DEFUALT = "from Book b join fetch b.category c where c.parentCategory.id=? order by b.id"; private static final String P_PRICEASC = "from Book b join fetch b.category c where c.parentCategory.id=? order by b.dangPrice asc"; private static final String P_PRICEDESC = "from Book b join fetch b.category c where c.parentCategory.id=? order by b.dangPrice desc"; private static final String P_P_TASC = "from Book b join fetch b.category c where c.parentCategory.id=? order by b.publishTime asc"; private static final String P_P_TDESC = "from Book b join fetch b.category c where c.parentCategory.id=? order by b.publishTime desc"; private static final String P_A_TDESC = "from Book b join fetch b.category c where c.parentCategory.id=? order by b.addTime desc"; private static final String P_A_TASC = "from Book b join fetch b.category c where c.parentCategory.id=? order by b.addTime asc"; @SuppressWarnings("unchecked") public List<Product> findByCategoryId(Integer cid, Pagination p) throws Exception { String hql = CID_DEFUALT; if (p.getType().equals("IDASC")) { System.out.println("根据ID升序"); hql = CID_DEFUALT; } else if (p.getType().equals("PRICEASC")) { System.out.println("根据价格升序"); hql = PRICEASC; } else if (p.getType().equals("PRICEDESC")) { System.out.println("根据价格降序"); hql = PRICEDESC; }else if(p.getType().equals("P_TDESC")) { System.out.println("根据出版时间降序"); hql = P_TDESC; }else if(p.getType().equals("P_TASC")) { System.out.println("根据出版时间升序"); hql = P_TASC; }else if(p.getType().equals("A_TDESC")) { System.out.println("根据上架时间降序"); hql = A_TDESC; }else if(p.getType().equals("A_TASC")) { System.out.println("根据上架时间升序"); hql = A_TASC; }else if(p.getType().equals("S_CDESC")) { System.out.println("根据上架时间降序"); hql = CID_DEFUALT; } Query q = this.getSession().createQuery(hql).setInteger(0, cid); q.setFirstResult((p.getPage() - 1) * p.getPageSize()); q.setMaxResults(p.getPageSize()); return q.setCacheable(true).list(); } public Number getCountByCategoryId(Integer cid, Pagination p) throws Exception { String hql = "select count(*) from Book b join b.category c where c.id=:id"; return (Number) this.getSession().createQuery(hql).setInteger("id", cid) .uniqueResult(); } private static final String PCID_DEFAULT = "from Book b join fetch b.category c where c.parentCategory.id=? order by b.id "; @SuppressWarnings("unchecked") public List<Product> findByParantCategoryId(Integer pcid, Pagination p) throws Exception { String hql = PCID_DEFUALT; if (p.getType().equals("IDASC")) { System.out.println("根据ID升序"); hql = PCID_DEFAULT; } else if (p.getType().equals("PRICEASC")) { System.out.println("根据价格升序"); hql = P_PRICEASC; } else if (p.getType().equals("PRICEDESC")) { System.out.println("根据价格降序"); hql = P_PRICEDESC; }else if(p.getType().equals("P_TDESC")) { System.out.println("根据出版时间降序"); hql = P_P_TDESC; }else if(p.getType().equals("P_TASC")) { System.out.println("根据出版时间升序"); hql = P_P_TASC; }else if(p.getType().equals("A_TDESC")) { hql = P_A_TDESC; }else if(p.getType().equals("A_TASC")) { hql = P_A_TASC; }else if(p.getType().equals("S_CDESC")) { hql = PCID_DEFAULT; } Query q = this.getSession().createQuery(hql).setInteger(0, pcid); q.setFirstResult((p.getPage() - 1) * p.getPageSize()); q.setMaxResults(p.getPageSize()); return q.setCacheable(true).list(); } public Number getCountByParentCategoryId(Integer pcid, Pagination p) throws Exception { String hql = "select count(*) from Book b join b.category c where c.parentCategory.id=:id"; return (Number) this.getSession().createQuery(hql).setInteger("id", pcid) .uniqueResult(); } public Product findProductById(Integer id) throws Exception { return (Product) this.getHibernateTemplate().get(Book.class, id); } }