20ddd1620d47001c1623b88abf704101

尚学堂Java148班的spring的所有源码

package com.bjsxt.drp.business.itemmgr.manager;

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

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

import com.bjsxt.drp.business.itemmgr.model.Item;
import com.bjsxt.drp.business.util.HibernateUtils;
import com.bjsxt.drp.business.util.PageModel;

public interface ItemManager {

	/**
	 * 添加物料
	 * @param item
	 */
	public void addItem(Item item) {
		Session session = null; 
		try {
			session = HibernateUtils.getSession();
			session.beginTransaction();
			session.save(item);
			session.getTransaction().commit();
		}catch(Exception e) {
			e.printStackTrace();
			session.getTransaction().rollback();
		}finally {
			HibernateUtils.closeSession(session);
		}
	}

	/**
	 * 修改物料
	 * @param item
	 */
	public void modifyItem(Item item) {
		Session session = null; 
		try {
			session = HibernateUtils.getSession();
			session.beginTransaction();
			session.update(item);
			session.getTransaction().commit();
		}catch(Exception e) {
			e.printStackTrace();
			session.getTransaction().rollback();
		}finally {
			HibernateUtils.closeSession(session);
		}
	}

	/**
	 * 删除物料
	 * @param itemNoList 物料代码数组
	 */
	public void deleteItemById(String[] itemNoList) {
		Session session = null; 
		try {
			session = HibernateUtils.getSession();
			session.beginTransaction();
			for (int i =0; i < itemNoList.length; i++) {
				Item item = new Item();
				item.setItemNo(itemNoList[i]);
				session.delete(item);
			}
			session.getTransaction().commit();
		}catch(Exception e) {
			e.printStackTrace();
			session.getTransaction().rollback();
		}finally {
			HibernateUtils.closeSession(session);
		}
	}
	
	/**
	 * 查询物料信息
	 * 
	 * @param pageNo 第一页
	 * @param pageSize 每页显示多少条
	 * @param queryStr 查询条件
	 * @return Item对象集合
	 */
	public PageModel findAllItem(int pageNo, int pageSize, String queryStr) {
		Session session = null; 
		PageModel pageModel = new PageModel();
		try {
			session = HibernateUtils.getSession();
			List itemList = new ArrayList();
			Query itemQuery = null;
			if (queryStr == null || "".equals(queryStr)) {
				itemQuery = session.createQuery("from Item a order by a.itemNo");
			}else {
				itemQuery = session.createQuery("from Item a where a.itemNo like ? or a.itemName like ? order by a.itemNo")
							  	   .setParameter(0, "%" + queryStr)
	                               .setParameter(1, "%" + queryStr);
			}
			//设置分页
			itemList = itemQuery.setFirstResult(((pageNo -1) * pageSize))
            		            .setMaxResults(pageSize)
            		            .list();
			pageModel.setPageNo(pageNo);
			pageModel.setPageSize(pageSize);
			pageModel.setList(itemList);
			pageModel.setTotalRecords(getTotalRecord(session, queryStr));
		}catch(Exception e) {
			e.printStackTrace();
		}finally {
			HibernateUtils.closeSession(session);
		}
		return pageModel;
	}

	/**
	 * 根据Id查询物料
	 * @param item
	 */
	public Item findItemById(String itemNo) {
		Session session = null; 
		Item item = new Item();
		try {
			session = HibernateUtils.getSession();
			item = (Item)session.get(Item.class, itemNo);
		}catch(Exception e) {
			e.printStackTrace();
		}finally {
			HibernateUtils.closeSession(session);
		}
		return item;
	}
	
	/**
	 * 取得总记录数
	 * 
	 * @param session
	 * @param queryStr
	 * @return
	 */
	private int getTotalRecord(Session session, String queryStr) {
		Query itemQuery = null;
		if (queryStr == null || "".equals(queryStr)) {
			itemQuery = session.createQuery("select count(*) from Item a");
		}else {
			itemQuery = session.createQuery("select count(*) from Item a where a.itemNo like ? or a.itemName like ?")
						  	   .setParameter(0, "%" + queryStr)
                               .setParameter(1, "%" + queryStr);
		}
		Long totalRecord = (Long)itemQuery.uniqueResult();
		return totalRecord.intValue();
	}
}