cpmec.java~4~

对项目

package zhaobiao.db;


import java.util.*;
import java.sql.*;
import zhaobiao.db.*;
import zhaobiao.date.*;


/**
 * <p>Title: 招标管理信息系统</p>
 * <p>Description: 招标管理信息系统的前台设计</p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: 北京王者无敌</p>
 * @author csk
 * @version 1.0
 */

public class Cpmec {

  public Cpmec() {
  }
  /**  根据项目id获得该项目对象
   *
   *
   */
  public Project getProject(long project_id)
  {
    Project pj=new Project();
    db=DBConnectionManager.getInstance();
    con=db.getConnection("idb");
    String sql="select *from project where project_id=?";
    try {
      ps=con.prepareStatement(sql);
      ps.setLong(1,project_id);
      rs=ps.executeQuery();
      if(rs.next())
      {
        pj.setProject_id(rs.getLong("project_id"));
        pj.setProject_name(rs.getString("project_name"));
        pj.setProject_time(rs.getString("project_time"));
        pj.setProject_company(rs.getString("project_company"));
        pj.setProject_cost(rs.getString("project_cost"));
        pj.setProject_content(rs.getString("project_content"));
      }
    }
    catch (SQLException ex) {
      freeCon();
      ex.printStackTrace();
    }
    freeCon();
    return pj;
  }
  /**  根据类别的id获得该类别对象
   *
   *
   */
  public Type getType(long type_id)
  {
    Type type=new Type();
    db=DBConnectionManager.getInstance();
    con=db.getConnection("idb");
    String sql="select *from type where type_id=?";
    try {
      ps=con.prepareStatement(sql);
      ps.setLong(1,type_id);
      rs=ps.executeQuery();
      if(rs.next())
      {
        type.setType_id(rs.getLong("type_id"));
        type.setType_name(rs.getString("type_name"));
        type.setType_content(rs.getString("type_content"));

      }
    }
    catch (SQLException ex) {
      ex.printStackTrace();
      freeCon();
    }
    freeCon();
    return type;
  }

  /**根据产品id获得该产品对象
   *
   *
   */
  public Product getProduct(long product_id)
  {
    Product pd=new Product();
    db=DBConnectionManager.getInstance();
    con=db.getConnection("idb");
    String sql="select *from product where product_id=?";
    try {
      ps=con.prepareStatement(sql);
      ps.setLong(1,product_id);
      rs=ps.executeQuery();
      if(rs.next())
      {
        pd.setProduct_id(rs.getLong("product_id"));
        pd.setProduct_name(rs.getString("product_name"));
        pd.setType_id(rs.getLong("type_id"));
        pd.setProduct_content(rs.getString("product_content"));

      }
    }
    catch (SQLException ex) {
      freeCon();
      ex.printStackTrace();
    }
    freeCon();
    return pd;

  }

  public Maker getMaker(long maker_id)
  {
    Maker mk=new Maker();
    db=DBConnectionManager.getInstance();
    con=db.getConnection("idb");
    String sql="select *from maker where maker_id=?";
    try {
      ps=con.prepareStatement(sql);
      ps.setLong(1,maker_id);
      rs=ps.executeQuery();
      if(rs.next())
      {
        mk.setMaker_id(rs.getLong("maker_id"));
        mk.setMaker_name(rs.getString("maker_name"));
        mk.setMaker_address(rs.getString("maker_address"));
        mk.setMaker_cr_address(rs.getString("maker_cr_address"));
        mk.setMaker_cr_time(rs.getString("maker_cr_time"));
        mk.setMaker_cr_address(rs.getString("maker_cr_address"));
        mk.setMaker_cr_cost(rs.getString("maker_cr_cost"));
        mk.setMaker_fr_name(rs.getString("maker_fr_name"));
        mk.setMaker_fr_position(rs.getString("maker_fr_position"));
        mk.setMaker_attribute(rs.getString("maker_attribute"));
        mk.setMaker_relation(rs.getString("maker_relation"));
        mk.setMaker_db_content(rs.getString("maker_db_content"));
      }
    }
    catch (SQLException ex) {
      freeCon();
      ex.printStackTrace();
    }
    freeCon();
    return mk;
  }

  /** 根据ppmid获得该PPM对象
    *@param PPM_id  (long)
    *
    */
   public  PPM getPPM(long id)
   {
     PPM ppm=new PPM();
     db=DBConnectionManager.getInstance();
     con=db.getConnection("idb");
     String sql="select *from ppm where id=?";
     try {
       ps=con.prepareStatement(sql);
       ps.setLong(1,id);
       rs=ps.executeQuery();
       if(rs.next())
       {
         boolean isok=false;
         ppm.setId(id);
         ppm.setProject_id(rs.getLong("project_id"));
         ppm.setProduct_id(rs.getLong("product_id"));
         ppm.setMaker_id(rs.getLong("maker_id"));
         if(rs.getLong("zhongbiao")==1)
           isok=true;
         ppm.setZhongbiao(isok);

         ppm.setPrice_id(rs.getLong("[price_id"));

       }
     }
     catch (SQLException ex) {
       freeCon();
       ex.printStackTrace();
     }
     freeCon();
     return ppm;

  }

  /**
   * 释放数据库资源<p>
   *PreparedStatement和ResultSep将关闭，Connection返回给连接池
   * @param      无
   * @repurn     无
   * @exception  SQLException
   *
   */
  public void freeCon(){
    try {
      if (rs!=null)
        rs.close() ;
      if (ps!=null)
        ps.close() ;
    }
    catch (SQLException ex) {
    }
    if (db!=null)
      db.freeConnection("idb",con) ;
  }
  private DBConnectionManager db;
  private Connection con=null;
  private ResultSet rs=null;
  private PreparedStatement ps=null;
}