d05701ae8325001d102dbe85cb859e31

实训时做的物流系统

/******************************
*   author@ZhanLiangfei       *
*   class for book operate    *
******************************/
package com.lib.biz;

import java.util.Iterator;
import java.util.List;

import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionMessage;
import org.hibernate.HibernateException;
import org.hibernate.Query;

import com.lib.persistence.hibernate.home.BookHome;
import com.lib.persistence.hibernate.home.BookpreHome;
import com.lib.persistence.hibernate.pojo.AcceptTable;
import com.lib.persistence.hibernate.pojo.Book;
import com.lib.persistence.util.HibernateUtil;

public class BookOperate {


	public static List FindAllBook(){
		/*遍历数据库内的所有图书信息*/
		List list = BookHome.getInstance().findAllBook();
		return list;
	}
	
	/**
	 * 书目信息插入数据库
	 */
	public static ActionErrors BookAdd(Book book){
		/*图书编目信息插入操作*/
		ActionErrors errors = new ActionErrors();
		try {
			HibernateUtil.currentSession().beginTransaction();
			BookHome.getInstance().persist(book);
			HibernateUtil.currentSession().getTransaction().commit();
		} catch (HibernateException e) {
			HibernateUtil.currentSession().getTransaction().rollback();
			errors.add("book", new ActionMessage("bookadd.database.failed"));
		}
		return errors;
	}
	
	public static ActionErrors BookUpdate(Book book){
		/*图书编目信息更新操作*/
		ActionErrors errors = new ActionErrors();
		try {
			HibernateUtil.currentSession().beginTransaction();
			BookHome.getInstance().attachDirty(book);
			HibernateUtil.currentSession().getTransaction().commit();
		} catch (HibernateException e) {
			HibernateUtil.currentSession().getTransaction().rollback();
			errors.add("book", new ActionMessage("bookupdate.database.failed"));
		}
		return errors;
	}
	
	public static List FindBook(String sql){
		/*按图示IBBN查找图书*/
		HibernateUtil.currentSession().beginTransaction();
		Query query = HibernateUtil.currentSession().createQuery(sql);
		List list = query.list();
		return list;
	}
	
	public static ActionErrors BookDel(Book book){
		/*删除图书编目信息*/
		ActionErrors errors = new ActionErrors();
		try {
			HibernateUtil.currentSession().beginTransaction();
			BookHome.getInstance().delete(book);
			HibernateUtil.currentSession().getTransaction().commit();	
		} catch (Exception e) {
			HibernateUtil.currentSession().getTransaction().rollback();
			errors.add("book", new ActionMessage("bookdel.database.failed"));		}
		return errors;
	}
	
	public static List FindBookBlur(String filed,String value){
		/*模糊搜索 */
		String HQL ="from Book where "+filed+" like :value order by isbn desc";
		Query query = HibernateUtil.currentSession().createQuery(HQL);
        query.setString("value", "%"+value+"%");
        List list = query.list();
        return list;
	}
	
	public static List FindCheckNum(){
		/*检索所有的验收批次*/
		String HQL ="from AcceptTable";
		Query query = HibernateUtil.currentSession().createQuery(HQL);
        List list = query.list();
        return list;
	}
	
	public static List FindBookByAcceptNum(int checkNum){
		/*按验收批次查找图书*/
		List list = null;
        List listT = BookpreHome.getInstance().FindByCheckNum(checkNum);
        Iterator it = listT.iterator();
        while (it.hasNext()) {
			AcceptTable accept = (AcceptTable) it.next();
			System.out.println(accept.getAcceptNum());
			list.add(accept);	
		}
        return list;
	}
	public static void main(String[] args) {
		List list = FindBookByAcceptNum(6);
	}
}