bookdao.java

webWork+Spring+Hibernate整合开发网络书城,通过这个项目

package org.thj.bookstore.dao.impl;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.thj.bookstore.dao.BaseDAO;
import org.thj.bookstore.dao.IBookDAO;
import org.thj.bookstore.vo.Book;

public class BookDAO extends BaseDAO implements IBookDAO {

	public List getBookByCatalogid(Integer catalogid, int currentPage, int pageSize) {
		
		Session session = getSession();
		Query query = session.createQuery("from Book b where b.catalog.catalogid=?");
		query.setParameter(0,catalogid);
		int startRow = (currentPage - 1) * pageSize;
		query.setFirstResult(startRow);
		query.setMaxResults(pageSize);
		List books = query.list();
		session.close();
		return books;
	}

	public int getTotalByCatalogid(Integer catalogid) {
		
		Session session = getSession();
		Query query = session.createQuery("from Book b where b.catalog.catalogid=?");
		query.setParameter(0,catalogid);
		List books = query.list();
		int totalSize = books.size();
		session.close();
		return totalSize;
	}

	public Book getBookById(Integer bookid) {
		
		Session session = getSession();
		Book book = (Book)session.get(Book.class,bookid);
		session.close();
		return book;
	}

	

	/*public List getBookByCatalogid(Integer catalogid) {
		
		Session session = getSession();
		String hql = "from Book b where b.catalog.catalogid=?";
		Query query = session.createQuery(hql);
		query.setParameter(0,catalogid);
		List books = query.list();
		session.close();
		return books;
	}*/

}