package org.tarena.dang.dao.impl;
import java.sql.SQLException;
import java.util.List;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.stereotype.Repository;
import org.tarena.dang.dao.BaseDAO;
import org.tarena.dang.dao.ProductDAO;
import org.tarena.dang.entity.Book;
import org.tarena.dang.entity.Category;
import org.tarena.dang.entity.Item;
import org.tarena.dang.entity.Product;
@Repository("productDAO")
public class HibernateProductDAO extends BaseDAO
implements ProductDAO {
@SuppressWarnings("unchecked")
public List<Product> findHotNewBook(final int size) {
List<Product> list = (List<Product>) this.getHibernateTemplate().execute(
new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException,
SQLException {
String hql ="from Product " +
"order by add_time desc ";
Query query = session.createQuery(hql);
query.setFirstResult(1);
query.setMaxResults(8);
return query.list();
}
});
return list;
}
@SuppressWarnings("unchecked")
public List<Book> findRecommendBook() {
List<Book> list = (List<Book>) this.getHibernateTemplate().execute(
new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException,
SQLException {
String hql="from Book order by rand()";
Query query = session.createQuery(hql);
query.setFirstResult(1);
query.setMaxResults(2);
return query.list();
}
});
return list;
}
@SuppressWarnings("unchecked")
public List<Book> findBooksByCatId(final int cid, final int page, final int pageSize) {
List<Book> list = (List<Book>) this.getHibernateTemplate().execute(
new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException,
SQLException {
String hql = "select c.books from Category c where c.id=?";
Query query = session.createQuery(hql);
query.setInteger(0, cid);
query.setFirstResult((page-1)*pageSize);
query.setMaxResults(pageSize);
return query.list();
}
});
return list;
}
@SuppressWarnings("unchecked")
public List<Book> findBooksByCatId(final int cid) {
String hql = "select c.books from Category c where c.id=?";
Object[] params = {cid};
List<Book> list = this.getHibernateTemplate().find(hql, params);
System.out.println(list.size());
return list;
}
@SuppressWarnings("unchecked")
public int findNumByCat_id(final int catId,int pageSize) {
List<Category> list =
(List<Category>) this.getHibernateTemplate().execute(
new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException,
SQLException {
Query query = session.createQuery("from Category where id=?");
query.setInteger(0, catId);
return query.list();
}
});
int totalRows =list.get(0).getPnum();
//计算总页数
//根据totalRows和pageSize计算总页数totalPages
if(totalRows == 0){
return 1;//没有记录认为1页
}else if(totalRows%pageSize == 0){
return totalRows/pageSize;
}else{
return totalRows/pageSize+1;
}
}
public Product findById(int id) {
Product pro =(Product) this.getHibernateTemplate().get(Product.class, id);
return pro;
}
@SuppressWarnings("unchecked")
public List<Product> findHotBook(final int size) {
List<Product> list = (List<Product>) this.getHibernateTemplate().execute(
new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException,
SQLException {
String hql="from Product p join fetch p.items i group by p.id order by sum(i.productNum)";
//String hql="from Item i join fetch i.product p group by p.id order by sum(i.productNum)";
Query query = session.createQuery(hql);
query.setFirstResult(1);
query.setMaxResults(size);
return query.list();
}
});
return list;
}
@SuppressWarnings("unchecked")
public List<Item> find(final int size) {
List<Item> list = (List<Item>) this.getHibernateTemplate().execute(
new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException,
SQLException {
String hql="from Product p join fetch p.items i group by p.id order by sum(i.productNum)";
Query query = session.createQuery(hql);
query.setFirstResult(1);
query.setMaxResults(size);
return query.list();
}
});
return list;
}
}
当当网全套源码(附带邮箱验证功能)
4星 · 超过85%的资源 需积分: 50 93 浏览量
2014-03-18
10:52:13
上传
评论 9
收藏 16.44MB ZIP 举报 
当当网全套源码(附带邮箱验证功能) （520个子文件） 
CartServiceImpl.class 5KB HibernateProductDAO.class 4KB Product.class 4KB BookListAction.class 3KB Book.class 3KB ImageUtil.class 3KB SimpleMailSender.class 3KB Teat.class 3KB Category.class 3KB MailSenderInfo.class 3KB LoginAction.class 3KB User.class 3KB Order.class 3KB DBUtil.class 2KB RegisterAction.class 2KB CookieUtil.class 2KB MyAuthenticator.class 2KB ModfiyQtyAction.class 2KB Item.class 2KB BaseAction.class 2KB CheckEmailCodeAction.class 2KB EncryptUtil.class 2KB ListCartAction.class 2KB UserDAOImPl.class 2KB VerifyCodeAction.class 2KB CartFactory.class 2KB AddCartAction.class 2KB HibernateCategoryDAO.class 2KB HibernateProductDAO$3.class 2KB FindNewBookAction.class 1KB FindHotBookAction.class 1KB CheckEmailAction.class 1KB UserDAOImPl$2.class 1KB HibernateProductDAO$5.class 1KB HibernateProductDAO$6.class 1KB HibernateProductDAO$1.class 1KB UserDAOImPl$1.class 1KB HibernateProductDAO$2.class 1KB HibernateProductDAO$4.class 1KB RecoveryProductAction.class 1KB CategoryAction.class 1KB DeleteProductAction.class 1KB FindRecommendBookAction.class 1KB CheckVerifyCodeAction.class 1KB CartItem.class 1KB VerifyUtil.class 811B ProductDAO.class 733B BaseDAO.class 635B CartService.class 592B ExitAction.class 576B Constant.class 513B UserDAO.class 373B CategoryDAO.class 273B .classpath 3KB book.css 24KB second.css 20KB register_login.css 14KB book_head090107.css 13KB login.css 13KB list.css 10KB shopping_vehicle.css 9KB shopping_head.css 5KB booksaleslist.css 5KB page_bottom.css 3KB public_footer.css 2KB research.css 2KB secBook_Show.css 1KB navi.css 1KB pubsug090107.css 555B Thumbs.db 48KB Thumbs.db 38KB Thumbs.db 29KB Thumbs.db 19KB Thumbs.db 16KB Thumbs.db 10KB Thumbs.db 8KB Thumbs.db 7KB Thumbs.db 6KB Thumbs.db 6KB Thumbs.db 6KB Thumbs.db 5KB
ancz081216_button05.gif 25KB xssj_banner.gif 8KB d_introduce.gif 5KB cheap4.gif 4KB cheap3.gif 4KB cheap2.gif 4KB cheap1.gif 3KB logo.gif 3KB logo.gif 3KB window_loading.gif 2KB book_logo.gif 2KB back_window.gif 2KB title_bg.gif 2KB pic_myshopping.gif 2KB butt_balance.gif 2KB ddb_1.gif 2KB label3.gif 1KB book_dangdang.gif 1KB bang.gif 1KB共 520 条
- 1
- 2
- 3
- 4
- 5
- 6
Defonds
- 粉丝: 7094
- 资源: 428
- 1
- 2
前往页