book_select.java

利用javaEE开发而实现图书的购买的一个系统

package org.yangkang.bookshop.dao.impl;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.yangkang.bookshop.dao.BaseDao;
import org.yangkang.bookshop.dao.Ibook;
import org.yangkang.bookshop.vo.Book;
import org.yangkang.bookshop.vo.Catalog;


public class Book_select extends BaseDao implements Ibook {	
	private ArrayList<Integer> catalogId_arr;
	private HashMap<Integer,String> map = new HashMap<Integer,String>();
	@SuppressWarnings("unchecked")
	public ArrayList<Book> getBook(Integer catalogId) {
		String hql = "from Book b where b.catalog.catalogId=?";
		System.out.println("图书类别catalog.catalogId"+catalogId);
		Session session = getSession();
		Query query = session.createQuery(hql);
		query.setParameter(0, catalogId);
		ArrayList book_arr = (ArrayList)query.list();	
		Book book = (Book)book_arr.get(0);
		System.out.println("杨康康康book.getPicture()"+book.getPicture());
		session.close();	
		return book_arr;
	}

	@SuppressWarnings("unchecked")
	public HashMap<Integer,String> getAllCatalogIdAndname() {
		String hql = "from Catalog c";
		Session session = getSession();
		Query query = session.createQuery(hql);
		List list = query.list(); 
		java.util.Iterator iter = list.iterator();
		while(iter.hasNext()){
			@SuppressWarnings("unused")
			Object ob = (Object)iter.next();
			Catalog catalog = (Catalog)ob;
			String catalogname = catalog.getCatalogname();
			System.out.println("catalogname"+catalogname);
			Integer catalogId = catalog.getCatalogId();
			System.out.println("catalogId"+catalogId);
			map.put(catalogId,catalogname);
//			catalogname_arr.add(catalogname);	
//			catalogId_arr.add(catalogId);
		}
		session.close();
		return map;
	}

	@SuppressWarnings("unchecked")
	public List getAllCatalog() {
		String hql = "from Catalog c";
		Session session = getSession();
		Query query = session.createQuery(hql);
		List list = query.list();				
		session.close();
		return list;
	}

	public ArrayList<Integer> getCatalogId_arr() {
		return catalogId_arr;
	}

	public void setCatalogId_arr(ArrayList<Integer> catalogId_arr) {
		this.catalogId_arr = catalogId_arr;
	}

	@SuppressWarnings("unchecked")
	public ArrayList<Book> getPage_Book(Integer catalogId, int pagesize,
			int currentpage) {
		String hql = "from Book b where b.catalog.catalogId=?";
		Session session = getSession();
		try{			
			Query query = session.createQuery(hql);
			query.setParameter(0, catalogId);
			int startrow = (currentpage-1)*pagesize;		
			query.setFirstResult(startrow);
			query.setMaxResults(pagesize);
			ArrayList<Book> books = (ArrayList<Book>)query.list();
			return books;
		}
		catch(Exception e){
			e.printStackTrace();
			return null;
		}
		finally{
			session.close();
		}
	}

	public Book getBookBybookId(Integer bookId) {
		String hql = "from Book b where bookId=?";
		Session session = getSession();
		Query query = session.createQuery(hql);
		query.setParameter(0, bookId);
		List list = query.list();
		if(list.size()!=0){
			Book book = (Book)list.get(0);
			session.close();
			return book;
		}
		session.close();
		return null;
	}

	public Book updateBook(Book book) {		
		Session session = getSession();
		Transaction tx = session.beginTransaction();
		session.update(book);
		tx.commit();
		session.close();
		return book;
	}

}