booksdao.java

图书管理系统

package com.dao;

import static com.common.BeanFactory.getBean;

import java.sql.Timestamp;
import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;

import com.bean.Book;
import com.bean.BorrowBook;
import com.bean.Operator;
import com.bean.Reader;
import com.bean.Type;
import com.common.HibernateSessionFactory;
import com.common.HibernateTransaction;

public class BooksDao {
	public void addBooks(Book book){
		Session session = HibernateSessionFactory.getSession();
		session.saveOrUpdate(book);
		session.flush();
	}
	
	public void addBorrowBooks(BorrowBook borrowBook){
		Session session = HibernateSessionFactory.getSession();	
		session.save(borrowBook);
	}
	
	public List findBackBooksRecord(Integer borrowbookid){
		Session session = HibernateSessionFactory.getSession();
		String sql = "from BackBook where 1=1";
		if(borrowbookid!=null&&borrowbookid!=0)
			sql += " and borrowbookid=:borrowbookid";
		Query query = session.createQuery(sql);
		if(borrowbookid!=null&&borrowbookid!=0)
			query.setInteger("borrowbookid", borrowbookid);
		if(query.list().isEmpty())
			return null;
		return query.list();
	}
	
	public void addBookType(Type bookType){
		Session session = HibernateSessionFactory.getSession();
		session.saveOrUpdate(bookType);
	}

	public List findBookType(Integer typeid, String typename){
		Session session = HibernateSessionFactory.getSession();
		String sql = "from Type where 1=1";
		if(typeid!=null&&typeid!=0)
			sql += " and id=:id";
		if(typename!=null&&typename.length()!=0)
			sql += " and name=:name";
		Query query = session.createQuery(sql);	
		if(typeid!=null&&typeid!=0)
			query.setInteger("id", typeid);
		if(typename!=null&&typename.length()!=0)
			query.setString("name", typename);
		if(query.list().isEmpty())
			return null;
		return query.list();
	}
	
	public List findBorrowBook(){
		Session session = HibernateSessionFactory.getSession();
		return null;
	}
	
	public List findBooks(Integer id, String name, Integer typeid){
		Session session = HibernateSessionFactory.getSession();
		String sql = "from Book where 1=1";
		if(id!=null&&id!=0)
			sql +=" and id=:id";
		if(name!=null&&name.length()!=0)
			sql += " and name=:name";
		if(typeid!=null&&typeid!=0)
			sql += " and typeid=:typeid";
		Query query = session.createQuery(sql);
		System.out.println(sql);
		if(id!=null&&id!=0)
			query.setInteger("id", id);
		if(name!=null&&name.length()!=0)
			query.setString("name", name);
		if(typeid!=null&&typeid!=0)
			query.setInteger("typeid", typeid);
		if(query.list().isEmpty())
			return null;
		return query.list();
	}
	
	public static void main(String[] args){
		BooksDao dao = (BooksDao)getBean("booksDao");
		Type bookType = new Type();
		Operator operator = new Operator();
		Reader reader = new Reader();
		reader.setIsvalidate("1");
		reader.setCardid("430611198609195019");
		reader.setMaxborrownum(6);
		reader.setName("梦如神机");
		reader.setProhibit("0");
		reader.setStartdate(new Timestamp(System.currentTimeMillis()));
		
		operator.setCardid("430611198607175017");
		operator.setName("王钟");
		operator.setPosition("黑山老妖");
//		Type bookType = (Type)((List)dao.findBookType("计算机")).get(0);
		bookType.setName("都市修真小说");
		Book book = new Book();
//		book.setId(1);
		book.setAuthor("梦如神机");
		book.setName("黑山老妖");
		book.setIsborrow("0");
		book.setMaxnumber(10);
		book.setPrice(55.5);
		book.setPublishing("人民出版社");
		book.setPurchase(new Timestamp(System.currentTimeMillis()));
		book.setType(bookType);
		
		BorrowBook borrowBook = new BorrowBook();
		borrowBook.setActualbacktimestamp(new Timestamp(System.currentTimeMillis()));
		borrowBook.setBook(book);
		borrowBook.setBorrowBooknumber(2);
		borrowBook.setBorrowdate(new Timestamp(System.currentTimeMillis()));
		borrowBook.setOperator(operator);
		borrowBook.setReader(reader);
		
		
		HibernateTransaction tran = new HibernateTransaction();
		tran.beginTransaction();
//		dao.addBookType(bookType);
//		dao.addBooks(book);
		dao.addBorrowBooks(borrowBook);
		tran.commit();
	}
}