goodstypedao.java

老牌java开发的物流管理系统 详细的我也没有怎么看 好像是恒基的

package com.wl.dao;
/**
 * @author tianxiaoshun
 */
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

import com.wl.dbconnection.DBManager;
import com.wl.entity.GoodsType;

public class GoodsTypeDAO {
   DBManager dbmanager=new DBManager();
   boolean flage;
	/**
	 * 封装插入数据方法
	 * @param commcate
	 * @return boolean
 	 */
   public boolean insertCommcate(GoodsType commcate){
	  flage=dbmanager.openDB();
	  if(flage){
		  try{
		  dbmanager.ps=dbmanager.conn.prepareStatement("insert into Commcatetable values(?,?)");  
		  dbmanager.ps.setString(1,commcate.getCommodityId());
		  dbmanager.ps.setString(2, commcate.getCommodityName());
		  dbmanager.ps.executeUpdate();
		  }
		  catch(Exception e){
			  return false;
		  }
		  finally{
			  dbmanager.closeDB();
		  }
	   return true;
	  }
	  else{
		  return false;
	  }
	  }
   /**
    * 封装查询所有商品分类表信息
    * @return list
    */
	public List<GoodsType> selectCommcate(){
		List<GoodsType> list=new ArrayList<GoodsType>();
		flage=dbmanager.openDB();
		GoodsType commcate;
     if(flage){
    	 try{
    		 dbmanager.ps=dbmanager.conn.prepareStatement("select * from Commcatetable");
    		 ResultSet  st=dbmanager.ps.executeQuery();
    		 while(st.next()){
    			 commcate=new GoodsType(st.getInt(1),st.getString(2),st.getString(3));
    			 list.add(commcate);
    		 }
    	 }
    	 catch(Exception e){
    		 System.out.print("数据库连接失败！");
    	 }
    	 finally
    	 {
    		 dbmanager.closeDB();
    	 }
    	 
     }
     else
     {
    	 System.out.print("数据库打开失败！");
     }
     return list;
	}
	/**
	 * 根据商品分类名称查询商品分类信息（袁新锋修改 2009.2.11）
	 * @param name
	 * @return list
	 */
	public GoodsType selectCommcateByName(String name){
		flage=dbmanager.openDB();
		GoodsType goodstype=null;
     if(flage){
    	 try{
    		 dbmanager.ps=dbmanager.conn.prepareStatement("select * from commcatetable where CommodityName=?");
    		 dbmanager.ps.setString(1, name);
    		 ResultSet  st=dbmanager.ps.executeQuery();
    		 while(st.next()){
    			 goodstype=new GoodsType(st.getInt(1),st.getString(2),st.getString(3));
    		 }
    	 }
    	 catch(Exception e){
    		 System.out.print("数据库连接失败！");
    	 }
    	 finally
    	 {
    		 dbmanager.closeDB();
    	 }
    	 
     }
     else
     {
    	 System.out.print("数据库打开失败！");
     }
     return goodstype;
	}
	/**
	 * 
	 * @param id
	 * @return
	 */
	public GoodsType selectCommcateById(int id){
		flage=dbmanager.openDB();
		GoodsType goodstype=null;
     if(flage){
    	 try{
    		 dbmanager.ps=dbmanager.conn.prepareStatement("select * from commcatetable where id=?");
    		 dbmanager.ps.setInt(1, id);
    		 ResultSet  st=dbmanager.ps.executeQuery();
    		 while(st.next()){
    			 goodstype=new GoodsType(st.getInt(1),st.getString(2),st.getString(3));
    		 }
    	 }
    	 catch(Exception e){
    		 System.out.print("数据库连接失败！");
    	 }
    	 finally
    	 {
    		 dbmanager.closeDB();
    	 }
    	 
     }
     else
     {
    	 System.out.print("数据库打开失败！");
     }
     return goodstype;
	}
}