itemmanager.java

java大型企业DRP系统源码带sql数据库

package com.bjsxt.drp.basedata.manager;

import java.sql.Connection;

import com.bjsxt.drp.basedata.factory.ItemDaoFactory;
import com.bjsxt.drp.basedata.factory.impl.ItemDao4MySqlFactory;
import com.bjsxt.drp.basedata.model.Item;
import com.bjsxt.drp.util.DB;
import com.bjsxt.drp.util.PageModel;

/**
 * 用户管理类，这个类中可以调用多个DAO，ItemManager把接口提供给Jsp及UI使用
 * @author Administrator
 *
 */
public class ItemManager {
	
	private static ItemManager instance = new ItemManager();
	
	private ItemDaoFactory itemDaoFactory;
	
	private ItemManager() {
		this.itemDaoFactory = new ItemDao4MySqlFactory();
	}
	
	public static ItemManager getInstance() {
		return instance;
	}
	
	/**
	 * 添加物料，调用Dao实现类
	 * @param item
	 */
	public void addItem(Item item) {
		Connection conn = null;
		try {
			conn = DB.getConn();
			this.itemDaoFactory.createItemDao().addItem(conn, item);
		}finally {
			DB.closeConn(conn);
		}
	}

	/**
	 * 修改物料，调用Dao实现类
	 * @param item
	 */
	public void modifyItem(Item item) {
		Connection conn = null;
		try {
			conn = DB.getConn();
			this.itemDaoFactory.createItemDao().modifyItem(conn, item);
		}finally {
			DB.closeConn(conn);
		}
		
	}

	/**
	 * 删除物料，调用Dao实现类
	 * @param item
	 */
	public void deleteItemById(String itemNo) {
		Connection conn = null;
		try {
			conn = DB.getConn();
			this.itemDaoFactory.createItemDao().deleteItemById(conn, itemNo);
		}finally {
			DB.closeConn(conn);
		}
	}

	/**
	 * 查询所有的物料，调用Dao实现类
	 * @param item
	 */
	public PageModel findAllItem(int pageNo, int pageSize) {
		Connection conn = null;
		PageModel pageModel = null;
		try {
			conn = DB.getConn();
			pageModel = this.itemDaoFactory.createItemDao().findAllItem(pageNo, pageSize);
		}finally {
			DB.closeConn(conn);
		}
		return pageModel;
	}

	/**
	 * 根据Id查询物料，调用Dao实现类
	 * @param item
	 */
	public Item findItemById(String itemNo) {
		Connection conn = null;
		Item item = null;
		try {
			conn = DB.getConn();
			item = this.itemDaoFactory.createItemDao().findItemById(itemNo);
		}finally {
			DB.closeConn(conn);
		}
		return item;

	}
}