readerdao.java

图书管理系统

package com.dao;

import java.util.List;
import java.util.Map;

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

import com.bean.BackBook;
import com.bean.BorrowBook;
import com.bean.Operator;
import com.bean.Reader;
import com.common.HibernateSessionFactory;
import com.common.HibernateTransaction;

public class ReaderDao {
	
	public List findReader(Integer id, String name, String cardid){
		Session session = HibernateSessionFactory.getSession();
		String sql = "from Reader where 1=1";
		if(id!=null)
			sql += " and id=:id";
		if(name!=null&&name.length()!=0)
			sql += " and name=:name";
		if(cardid!=null)
			sql += " and cardid=:cardid";
		Query query = session.createQuery(sql);
		if(id!=null)
			query.setInteger("id", id);
		if(name!=null&&name.length()!=0)
			query.setString("name", name);
		if(cardid!=null)
			query.setString("cardid", cardid);
		if(query.list().isEmpty())
			return null;
		return query.list();
	}
	
	public List findReaderBorrow(Integer readerid, Integer bookid, Integer id){
		Session session = HibernateSessionFactory.getSession();
		String sql = "from BorrowBook where 1=1";
		if(id!=null)
			sql += " and id=:id";
		if(readerid!=null)
			sql += " and readerid=:readerid";
		if(bookid!=null)
			sql += " and bookid=:bookid";
		Query query = session.createQuery(sql);
		if(id!=null)
			query.setInteger("id", id);
		if(readerid!=null)
			query.setInteger("readerid", readerid);
		if(bookid!=null)
			query.setInteger("bookid", bookid);
		if(query.list().isEmpty())
			return null;
		return query.list();
	}
	
	public List findBorrowRecord(Integer readerid, Integer cardid){
		Session session = HibernateSessionFactory.getSession();
		String sql = "from Reader where 1=1";
		if(readerid!=null)
			sql += " and readerid=:readerid";
		if(cardid!=null)
			sql += " and cardid=:cardid";
		Query query = session.createQuery(sql);
		if(readerid!=null)
			query.setInteger("readerid", readerid);
		if(cardid!=null)
			query.setInteger("cardid", cardid);
		if(query.list().isEmpty())
			return null;
		return query.list();
	}
	
	public void addBorrowRecord(BorrowBook borrowBook){
		Session session = HibernateSessionFactory.getSession();
		session.saveOrUpdate(borrowBook);
		session.flush();
	}
	
	public void addBackRecord(BackBook backBook){
		Session session = HibernateSessionFactory.getSession();
		session.save(backBook);
		session.flush();
//		session.clear();
	}
	
	public List findBackRecord(Integer readerid, Integer bookid){
		Session session = HibernateSessionFactory.getSession();
		String sql = "from BackRecord where 1=1";
		if(readerid!=null)
			sql += " and readerid=:readerid";
		if(bookid!=null)
			sql += " and bookid=:bookid";
		Query query = session.createQuery(sql);
		if(readerid!=null)
			query.setInteger("readerid", readerid);
		if(bookid!=null)
			query.setInteger("bookid", bookid);
		if(query.list().isEmpty())
			return null;
		return query.list();		
	}
	
	public void saveOrUpdateReader(Reader reader){
		Session session = HibernateSessionFactory.getSession();
		session.saveOrUpdate(reader);
	}
	
	public void saveOrUpdateOperator(Operator operator){
		Session session = HibernateSessionFactory.getSession();
		session.saveOrUpdate(operator);
	}
	
	public void deleteOperator(Operator operator){
		Session session = HibernateSessionFactory.getSession();
		session.delete(operator);
	}
	
	public List<Operator> findOpertor(Integer id, String cardid, String userName, String passWord){
		Session session = HibernateSessionFactory.getSession();
		String sql = "from Operator where 1=1";
		if(id!=null)
			sql += " and id=:id";
		if(cardid!=null&&cardid.length()!=0)
			sql += " and cardid=:cardid";
		if(userName!=null&&userName.length()!=0)
			sql += " and username=:username";
		if(passWord!=null&&passWord.length()!=0)
			sql += " and password=:password";
		Query query = session.createQuery(sql);
		if(id!=null)
			query.setInteger("id", id);
		if(cardid!=null&&cardid.length()!=0)
			query.setString("cardid", cardid);
		if(userName!=null&&userName.length()!=0)
			query.setString("username", userName);
		if(passWord!=null&&passWord.length()!=0)
			query.setString("password", passWord);
		if(query.list().isEmpty())
			return null;
		return query.list();
	}
	
	public static void main(String[] args){
		ReaderDao dao = new ReaderDao();
		Operator op = new Operator();
		Reader reader = new Reader();
		reader.setName("tom");
		reader.setCardid("321312312312");
//		op.setId(1);
		op.setName("admin");
		op.setUserName("admin");
		op.setPassWord("admin");
		op.setPosition("administer");
		op.setCardid("430611198607175017");
		HibernateTransaction tran = new HibernateTransaction();
		tran.beginTransaction();
	//	dao.addOperator(op);
		tran.commit();
	}
	
}