package com.wl.dao;

import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

import com.wl.dbconnection.DBManager;
import com.wl.entity.StockRegionInfo;
/**
 * 商品所在區域表封裝方法
 * @author tian xiaoshun
 *
 */
public class StockRegionInfoDAO {
	DBManager db = new DBManager();
	boolean flag;
	ResultSet rs = null; 
	/**
	 * 查村所有商品所在區域
	 * @return
	 */
 public List<StockRegionInfo> selectAllStrockRegionInfo(){
      List<StockRegionInfo>  list= new ArrayList<StockRegionInfo>();
      flag=db.openDB();
      if(flag){
    	  try{
    	  db.ps=db.conn.prepareStatement("select * from stockregioninfotable");
    	  rs=db.ps.executeQuery();
    	  while(rs.next()){
    		  StockRegionInfo stockregioninfo=new StockRegionInfo(rs.getInt(1),rs.getString(2),rs.getString(3));
    		  list.add(stockregioninfo);
    	  }
    	  }
    	 catch(Exception e){
    		System.out.print("出錯了！");  
    	  }
    	  finally{
    		 db.closeDB();
    	  }
    }
      else{
    	  System.out.print("數據庫打開失??！");
      }
      return list;
 }
 /**
  * 封裝按名字查詢商品所在區域信息！
  * @param StockRegionName
  * @return
  */
 public StockRegionInfo selectStockRegionInfoByName(String stockRegionName){
		flag=db.openDB();
		StockRegionInfo stockRegioninfo=null;
		if(flag){
		 try{
			 db.ps=db.conn.prepareStatement("select * from stockregioninfotable where stockregionname=?");
			 db.ps.setString(1,stockRegionName);
			 rs=db.ps.executeQuery();
			 while(rs.next()){
				 stockRegioninfo=new StockRegionInfo(rs.getInt(1),rs.getString(2),rs.getString(3));
			 }
			 }
		 catch(Exception e){
			 System.out.print("查詢出錯了！");
		 }
		 finally{
			db.closeDB(); 
		 }
		}
		else{
			System.out.print("數據庫打開失敗");
		}
		return stockRegioninfo;
	}
 /**
  * 封裝按id查詢商品所在區域信息！
  * @param id
  * @return
  */
 public StockRegionInfo selectStockRegionInfoById(int id){
		flag=db.openDB();
		StockRegionInfo stockRegioninfo=null;
		if(flag){
		 try{
			 db.ps=db.conn.prepareStatement("select * from stockregioninfotable where id=?");
			 db.ps.setInt(1,id);
			 rs=db.ps.executeQuery();
			 while(rs.next()){
				 stockRegioninfo=new StockRegionInfo(rs.getInt(1),rs.getString(2),rs.getString(3));
			 }
			 }
		 catch(Exception e){
			 System.out.print("查詢出錯了！");
		 }
		 finally{
			db.closeDB(); 
		 }
		}
		else{
			System.out.print("數據庫打開失敗");
		}
		return stockRegioninfo;
	}

 public static void main(String[] args){
	 StockRegionInfoDAO mm=new StockRegionInfoDAO();
	 System.out.print(mm.selectStockRegionInfoById(1));
  }
}