stockregionmanager.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.data.DataConnect;
import com.logistic.dao.IStockRegionDAO;
import com.logistic.model.StockRegionInfo;

public class StockRegionManager implements IStockRegionDAO{
	
	DataConnect dc=new DataConnect();
	Statement   stat=null;
	ResultSet   rs=null;
		
		
	public int AddStockRegion(String stockregionid,String stockregionname){
		
		String id=stockregionid;
		String name=stockregionname;
		int flag=0;
		String strsql="insert into stockregioninfotable(StockRegionId,StockRegionName)" +
				      "values('"+id+"','"+name+"')";
	    try{
		flag=dc.updata(strsql);
		if(flag>0){
			System.out.print("商品在库位置信息保存成功!");
			}else{
				System.out.print("商品在库位置信息保存失败!");
				}
	   }catch(Exception ex){
		   flag=-1;
		   ex.printStackTrace();
	     }finally{dc.close();}
	     
	   return flag;
	}

	public Vector StockRegionSearch(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 StockRegionInfo(rs.getString("StockRegionId"),rs.getString("StockRegionName")));
			  
			   }while(rs.next()&&i<pgb.getCurrentPageRowsCount());
			
		}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
	
	  return items;	
	}

	public int DelStockRegion(String srid){
		
		String delstockregion="delete from stockregioninfotable where StockRegionId="+srid;
		
		int flag=0;
		
		try{
			flag=dc.updata(delstockregion);
			if(flag>0){
				System.out.println("编号为:"+srid+"商品库存位置信息删除成功!");
			   }else{
				System.out.println("编号为:"+srid+"商品库存位置信息删除失败!");
			         }
		    }catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
			
	    return flag;
	}
}