goodsmanager.java

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

package com.logistic.business;


import java.sql.ResultSet;
import java.sql.Statement;
import com.logistic.data.DataConnect;
import com.logistic.dao.IGoodsDAO;
import com.logistic.model.GoodsInfo;
import java.util.Vector;
public class GoodsManager implements IGoodsDAO {

	DataConnect dc=new DataConnect();
	Statement   stat=null;
	ResultSet   rs=null;

 //添加商品信息	
 public int AddGoods(String goodsid,String goodsname,String goodscateid,
		 String goodssupplyid,String goodsabc,String goodsprovince,String goodscity,
		 String goodsstockid,float goodsprice,int goodsstocknum, String goodsorderdate,String goodsstockindate,String goodsunit,String goodsstockregion,String typeid){
    int flag=-10;
    try{
    	
    	String id=goodsid;
    	String name=goodsname;
    	String cateid=goodscateid;
    	String supplyid=goodssupplyid;
    	String abc=goodsabc;
    	String province=goodsprovince;
    	String city=goodscity;
    	String stockid=goodsstockid;
    	float price=goodsprice;
    	int   stocknum=goodsstocknum;
    	String   orderdate=goodsorderdate;
    	String   stockindate=goodsstockindate;
    	String unit=goodsunit;
    	String stockregion=goodsstockregion;
    	String goodstypeid=typeid;
    	
		System.out.print("GoodsManager");
		System.out.print(orderdate.toString());
		System.out.print(name);
    	String	sqls="insert into goodsinfotable(GoodsId,GoodsName,GoodsCateId,GoodsSupplyId,GoodsABC,GoodsProvince,GoodsCity,GoodsStockId,GoodsPrice,GoodsStockNumber,GoodsOrderDate,GoodsStockInDate,GoodsUnit,StockRegionId,TypeId)values" +
    			     "('"+id+"','"+name+"','"+cateid+"','"+supplyid+"','"+abc+"'," +"'"+province+"','"+city+"','"+stockid+"','"+price+"','"+stocknum+"','"+orderdate+"','"+stockindate+"','"+unit+"','"+stockregion+"','"+goodstypeid+"')";
	    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;
   }

 //取得商品信息列表
 public Vector GoodsSearch(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 GoodsInfo(rs.getString("GoodsId"),rs.getString("GoodsName"),rs.getString("GoodsCateId"),rs.getString("GoodsSupplyId"),rs.getString("GoodsABC"),
						  rs.getString("GoodsProvince"),rs.getString("GoodsCity"),rs.getString("GoodsStockId"),rs.getFloat("GoodsPrice"),rs.getInt("GoodsStockNumber"),
						  rs.getString("GoodsOrderDate"),rs.getString("GoodsStockInDate"),rs.getString("GoodsUnit"),rs.getString("StockRegionId"),rs.getString("TypeId")));
			}while(rs.next()&&i<pgb.getCurrentPageRowsCount());
			
		 }else{
			 
			 System.out.println("商品数据为空!");
		 }
			
		}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
		
		return items;
	 
 }
 
 //根据商品编号删除商品信息
 public int DelGoods(String goodsid){
		
		String delegoods="delete from goodsinfotable where Goodsid="+goodsid;
		
		int flag=0;
		
		try{
			flag=dc.updata(delegoods);
			if(flag>0){
				System.out.println("商品数据删除成功，商品编号:"+goodsid);
			   }else{
				System.out.println("商品数据删除失败，商品编号:"+goodsid);
			         }
		}catch(Exception ex){
				ex.printStackTrace();
			}finally{dc.close();}
			
	    return flag;
		}

 public int ModifyGoods(String goodsid,String goodsname,String goodscateid,
		 String goodssupplyid,String goodsabc,String goodsprovince,String goodscity,
		 String goodsstockid,float goodsprice,int goodsstocknum, String goodsorderdate,String goodsstockindate,String goodsunit,String goodsstockregion,String typeid){
    int flag=-10;
    try{
    	
    	String id=goodsid;
    	String name=goodsname;
    	String cateid=goodscateid;
    	String supplyid=goodssupplyid;
    	String abc=goodsabc;
    	String province=goodsprovince;
    	String city=goodscity;
    	String stockid=goodsstockid;
    	float price=goodsprice;
    	int   stocknum=goodsstocknum;
    	String orderdate=goodsorderdate;
    	String stockindate=goodsstockindate;
    	String unit=goodsunit;
    	String stockregion=goodsstockregion;
    	String goodstypeid=typeid;
    	
    	String	strsql="update goodsinfotable set GoodsName='"+name+"',GoodsCateId='"+cateid+"',GoodsSupplyId='"+supplyid+"',GoodsABC='"+abc+"',GoodsProvince='"+province+"',GoodsCity='"+city+"',GoodsStockId='"+stockid+"',"+
    			     "GoodsPrice='"+price+"',GoodsStockNumber='"+stocknum+"',GoodsOrderDate='"+orderdate+"',GoodsStockInDate='"+unit+"',StockRegionId='"+stockregion+"',TypeId='"+goodstypeid+"'where GoodsId="+id;
	   
    	flag=dc.updata(strsql);
		if(flag>0){
			System.out.print("编号="+id+"的商品信息更新成功!");
		}else{
			
			System.out.print("编号="+id+"的商品信息更新失败!");
		}
		
	   }catch(Exception ex){flag=-1; ex.printStackTrace();}finally{dc.close();}
	 return flag;
   }

 public GoodsInfo GoodsSearchById(String goodsid){
	 
	 String strsql="select * from goodsinfotable where GoodsId="+goodsid;
	 GoodsInfo gi=new GoodsInfo();
	 try{
		 stat=dc.getStmtread();
		 rs  =stat.executeQuery(strsql);
		 while(rs.next()){
			 
			 gi.setGoodsid(rs.getString("GoodsId"));
			 gi.setGoodsname(rs.getString("GoodsName"));
			 gi.setGoodscateid(rs.getString("GoodsCateId"));
			 gi.setGoodssupplyid(rs.getString("GoodsSupplyId"));
			 gi.setGoodsabc(rs.getString("GoodsABC"));
			 gi.setGoodsprovince(rs.getString("GoodsProvince"));
			 gi.setGoodscity(rs.getString("GoodsCity"));
			 gi.setGoodsstockid(rs.getString("GoodsStockId"));
			 gi.setGoodsprice(rs.getFloat("GoodsPrice"));
			 gi.setGoodsstocknumber(rs.getInt("GoodsStockNumber"));
			 gi.setGoodsorderdate(rs.getString("GoodsOrderDate"));
			 gi.setGoodsstockindate(rs.getString("GoodsStockInDate"));
			 gi.setGoodsunit(rs.getString("GoodsUnit"));
			 gi.setStockregionid(rs.getString("StockRegionId"));
			 gi.setTypeid(rs.getString("TypeId"));
		 }
		 
	 }catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
  return gi; 
 }
 
}