goodscatemanager.java

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

package com.logistic.business;

import com.logistic.dao.IGoodsCateDAO;
import com.logistic.model.GoodsCateInfo;
import java.util.Vector;
import com.logistic.data.DataConnect;
import java.sql.Statement;
import java.sql.ResultSet;

public class GoodsCateManager implements IGoodsCateDAO{
	
	DataConnect dc=new DataConnect();
	Statement   stat=null;
	ResultSet   rs=null;
	
	public int AddGoodsCate(String goodscateid,String goodscatename){
		
		int flag=-10;
		try{
			
			String gcid=goodscateid;
			String gcname=goodscatename;
			String strsql="insert into commcatetable(CommodityId,CommodityName)values('"+gcid+"','"+gcname+"')";
			flag=dc.updata(strsql);
			if(flag>0){
				System.out.println("商品分类插入成功!");
			}else{
				System.out.println("商品分类插入失败!");
			}
			
		}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
		
	return flag;
	}

	public Vector GoodsCateSearch(String strsql,int page){
		
		Vector items=new Vector();
		try{
			
			stat=dc.getStmtread();
			rs=stat.executeQuery(strsql);
			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 GoodsCateInfo(rs.getString("CommodityId"),rs.getString("CommodityName")));
			  
			   }while(rs.next()&&i<pgb.getCurrentPageRowsCount());
	
			}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
			
		return items;
		
	}

    public int DelGoodsCate(String goodscateid){
    	
    	String strsql="delete from commcatetable where CommodityId="+goodscateid;
    	
    	int flag=-10;
    	try{
    		flag=dc.updata(strsql);
    		if(flag>0){
    			System.out.println("编号为"+goodscateid+"的商品分类删除成功!");
    		}else{
    			System.out.println("编号为"+goodscateid+"的商品分类删除失败!");
    		}
    	}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
    	
    	return flag;
    }
}