stockinmanager.java

基于J2EE的网络物流系统 用户操作： 1． 录入出库商品信息 2． 查询出库单信息 3． 录入入库商品信息 4． 查询入库单信息 5． 查询商品位置信息 6． 查询商品信息 7． 查

package com.logistic.business;


import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Vector;
import com.logistic.business.PageAble;
import com.logistic.data.DataConnect;
import com.logistic.dao.IStockInDAO;
import com.logistic.model.StockInInfo;

public class StockInManager implements IStockInDAO{

	DataConnect dc=new DataConnect();
	Statement   stat=null;
	ResultSet   rs=null;
	
	//添加入库单数据的AddStockIn方法
	public int AddStockIn(String stockinid,String stockindate,String chargeid,String goodsid,int goodsinnum,String typeid,String commodityid,String stockinmemo){
		
		int flag=-10;
	try{	
		String inid=stockinid;
		String   indate=stockindate;
		String chid=chargeid;
		String gid=goodsid;
		int   innum=goodsinnum;
		String tid=typeid;
		String comid=commodityid;
		String inmemo=stockinmemo;
		
		String sqls="insert into stockininfotable(StockInId,StockInDate,ChargeId,GoodsId,GoodsInNumber,TypeId,CommodityId,GoodsInMemo)values" +
				  "('"+inid+"','"+indate+"','"+chid+"','"+gid+"','"+innum+"','"+tid+"','"+comid+"','"+inmemo+"')";
		flag=0;
		
		flag=dc.updata(sqls);
		if(flag>0){
			System.out.print("入库单数据插入成功!");
		}else{
			
			 System.out.print("入库单数据插入失败!");
		    }
		}catch(Exception ex){
			flag=-1;
			
			ex.printStackTrace();
			
		}finally{dc.close();}
		
		return flag;
	}
	
	//得到入库单数据的集合的StockInSearch方法
	public Vector StockInSearch(String strsql,int page){
		
		Vector items=new Vector();
		try{
			stat=dc.getStmtread();
			rs  =stat.executeQuery(strsql);
		 if(rs.next()){
			PageAble pgb=new PageAble(rs);
			pgb.setPagesize(5);
			pgb.setCurrentpage(1);
			pgb.gotoPage(page);
			rs.absolute(pgb.getRowscount());
			int i=0;
			do{
				
				items.add(new StockInInfo(rs.getString("StockInId"),rs.getString("StockInDate"),rs.getString("ChargeId"),rs.getString("GoodsId"),
						  rs.getInt("GoodsInNumber"),rs.getString("TypeId"),rs.getString("CommodityId"),rs.getString("GoodsInMemo")));
				
			   }while(rs.next()&&i<pgb.getCurrentPageRowsCount());
		 }else{
			 
			 System.out.println("出库单数据为空!");
		 }
			
		}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
		
		return items;
	}
	
	//删除指定编号的入库单数据的DelStockIn方法
	public int DelStockIn(String stockinid){
		
		String strsql="delete from stockininfotable where StockInId="+stockinid;
	
		int flag=0;
		try{
			
			flag=dc.updata(strsql);
			if(flag>0){
				System.out.print("编号为:"+stockinid+"入库单信息删除成功");
			  }else{
				System.out.print("编号为:"+stockinid+"入库单信息删除失败"); 
			  }
			
		}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
		
		return flag;
	}

	public int ModifyStockIn(String stockinid,String stockindate,String chargeid,String goodsid,int goodsinnum,String typeid,String commodityid,String stockinmemo){
		
	  int flag=-10;
	  try{
		  
		  String sinid=stockinid;
		  String sindate=stockindate;
		  String cid=chargeid;
		  String gid=goodsid;
		  int    gnum=goodsinnum;
		  String tid=typeid;
		  String commid=commodityid;
		  String smemo=stockinmemo;
		  
		  String strsql="update stockininfotable set StockInDate='"+sindate+"',ChargeId='"+cid+"',GoodsId='"+gid+"',GoodsInNumber='"+gnum+"',TypeId='"+tid+"',CommodityId='"+commid+"',GoodsInMemo='"+smemo+"' where StockInId="+sinid;
		  flag=dc.updata(strsql);
		  if(flag>0){
			  System.out.println("编号="+sinid+"的入库单信息更新成功!");
		  }else{
			  System.out.println("编号="+sinid+"的入库单信息更新失败!");
		  }
		  
	  }catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
	return flag;
	}

	public StockInInfo StockInSearchById(String stockinid){
		
		String strsql="select * from stockininfotable where StockInId="+stockinid;
		StockInInfo sii=new StockInInfo();
		try{
			stat=dc.getStmtread();
			rs  =stat.executeQuery(strsql);
			while(rs.next()){
				
				sii.setStockinid(rs.getString("StockInId"));
				sii.setStockindate(rs.getString("StockInDate"));
				sii.setCharegid(rs.getString("ChargeId"));
				sii.setGoodsid(rs.getString("GoodsId"));
				sii.setGoodsinnumber(rs.getInt("GoodsInNumber"));
				sii.setTypeid(rs.getString("TypeId"));
				sii.setCommodityid(rs.getString("CommodityId"));
				sii.setGoodsinmemo(rs.getString("GoodsInMemo"));
			}
			
		}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
	return sii;	
	}
}