bookdaoimp.java

用STRUTS ,HIBERNATE, SPRING 三种框架整合做的实战项目

package com.ghy.dao.book;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.ghy.data.book.Book;
import com.ghy.data.book.BookCategory;

public class BookDaoImp extends HibernateDaoSupport implements BookDaoIfc {
	public static int MAXRESULTS = 3;
	
	public void saveCate(BookCategory bookCategory)
	{
		getHibernateTemplate().save(bookCategory);
	}
	public List findCategory(String name) {
		// TODO Auto-generated method stub
		if(name.equals("all"))
			return getHibernateTemplate().find("from BookCategory");
		else
		return getHibernateTemplate().find("from BookCategory bookCate where bookCate.categoryName = ?",name);
	}
	public List findBooks() {
		// TODO Auto-generated method stub
		List list = getHibernateTemplate().find("from Book");
		return list;
	}
	public int findBookCount(String cateId) {
		List list = null;
		if (cateId.equals("all")) {
			list = getHibernateTemplate().find("from Book");
		} else {

			list = getHibernateTemplate().find(
					"from Book book where book.category=?", cateId);
		}
		return list.size();
	}
	public int findBookCountByKey(String bookText, String bookList) {
		// TODO Auto-generated method stub
		List list = getHibernateTemplate().find(
				"from Book book where book." + bookList + " like ?",
				"%" + bookText + "%");
		return list.size();

	}
	public List findBookByCategoryId(String cateId, int i) {
		// TODO Auto-generated method stub
		Session session = getSession();
		List bookList = null;
		Query query = null;
		if (cateId.equals("all")) {
			query = session.createQuery("from Book b order by b.id asc");
			query.setFirstResult(i * MAXRESULTS);
			query.setMaxResults(MAXRESULTS);
		} else {
			query = session
					.createQuery("from Book b where b.category = :cateId order by b.id asc");
			query.setFirstResult(i * MAXRESULTS);
			query.setMaxResults(MAXRESULTS);
			query.setString("cateId", cateId);
		}
		bookList = query.list();
		return bookList;
	}
	public List findBookByKey(String bookText, String bookList, int i) {
		// TODO Auto-generated method stub
		Session session = getSession();
		List list = null;
		Query query = null ;
		String str = null;
		if (bookList.equals("name"))
			str = " from Book b where b.name like :bookText ";
		if (bookList.equals("author"))
			str = " from Book b where b.author like :bookText ";
		query = session.createQuery(str);
		query.setString("bookText", "%" + bookText + "%");
		query.setFirstResult(i * MAXRESULTS);
		query.setMaxResults(MAXRESULTS);
		list = query.list();
		return list;
	}
	public Book findBookById(String id) {
		// TODO Auto-generated method stub
		return (Book)getHibernateTemplate().find("from Book b where b.id = ?", id).get(0);
	}
	
	

}