package zhaobiao.db;

import java.util.*;
import java.sql.*;
import zhaobiao.db.*;
import zhaobiao.data.*;
/**
 * <p>Title: 招標管理信息系統</p>
 * <p>Description: 招標管理信息系統的前臺設計</p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: 招標信息管理系統</p>
 * @author csk
 * @version 1.0
 */

public class NewMaker {

  public NewMaker() {
  }

  /**添加廠商
   *@param Maker mk(廠商對象)
   *@return 無
   */
  public void addMaker(Maker mk)
  {
    db=DBConnectionManager.getInstance();//加上下面這兩句
    con=db.getConnection("idb");
    long maxid=0;
    try {
      PreparedStatement ps1 = con.prepareStatement("select max(maker_id) as id from maker");
      rs =ps1.executeQuery();
      if(rs.next() ){
        maxid = rs.getLong("id")+1 ;
      }
      else
        maxid=1;
      if(ps1!=null)
        ps1.close();
    }
    catch (SQLException ex) {
      ex.printStackTrace() ;
    }
    String sql="insert into maker(maker_id,maker_name,maker_address,maker_cr_time,"+
               "maker_cr_address,maker_cr_cost,maker_fr_name,maker_fr_position,"+
               "maker_attribute,maker_relation,maker_db_content)values(?,?,?,?,?,?,?,?,?,?,?)";
    try {
      ps=con.prepareStatement(sql);
      ps.setLong(1,maxid);
      ps.setString(2,mk.getMaker_name());
      ps.setString(3,mk.getMaker_address());
      ps.setString(4,mk.getMaker_cr_time());
      ps.setString(5,mk.getMaker_cr_address());
      ps.setString(6,mk.getMaker_cr_cost());
      ps.setString(7,mk.getMaker_fr_name());
      ps.setString(8,mk.getMaker_fr_position());
      ps.setString(9,mk.getMaker_attribute());
      ps.setString(10,mk.getMaker_relation());
      ps.setString(11,mk.getMaker_db_content());
      ps.executeUpdate();
    }
    catch (SQLException ex) {
      freeCon();
      ex.printStackTrace();
    }
    freeCon();
  }

  /**根據廠商的id刪除廠商，并且刪除procduct表中該廠商的所有產品信息。
   （其中在刪除該產品時會刪除ppm表中的所有與該產品相關的記錄，
   同時刪除ppm記錄時會刪除與ppm記錄對應的price記錄）
   *@param long mkid(廠商的id)
   * @return 無
   */
  public void delMaker(long mkid)
  {
    db=DBConnectionManager.getInstance();
    con=db.getConnection("idb");
  String sql="delete from maker where maker_id=?";
  try {
    ps=con.prepareStatement(sql);
    ps.setLong(1,mkid);
    ps.executeUpdate();
                                //刪除procduct表中該廠商的所有產品信息
    NewProduct newpd=new NewProduct();
    newpd.delProductMakerid(mkid);
    newpd.freeCon();

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

/** 更新一個廠商信息
 *@param Maker mk(廠商對象實例)
 * @return 無
 *
 */
public void updateMaker(Maker mk)
{
  db=DBConnectionManager.getInstance();
    con=db.getConnection("idb");
    String sql="update maker set maker_name=?,maker_address=?,maker_cr_time=?,"+
               "maker_cr_address=?,maker_cr_cost=?,maker_fr_name=?,maker_fr_position=?,"+
               "maker_attribute=?,maker_relation=?,maker_db_content=? where maker_id=?";
    try {
      ps=con.prepareStatement(sql);
      ps.setString(1,mk.getMaker_name());
      ps.setString(2,mk.getMaker_address());
      ps.setString(3,mk.getMaker_cr_time());
      ps.setString(4,mk.getMaker_cr_address());
      ps.setString(5,mk.getMaker_cr_cost());
      ps.setString(6,mk.getMaker_fr_name());
      ps.setString(7,mk.getMaker_fr_position());
      ps.setString(8,mk.getMaker_attribute());
      ps.setString(9,mk.getMaker_relation());
      ps.setString(10,mk.getMaker_db_content());
      ps.setLong(11,mk.getMaker_id());
      ps.executeUpdate();
    }
    catch (SQLException ex) {
      freeCon();
      ex.printStackTrace();
    }

   freeCon();
}


  public static void main(String[] args) {
    NewMaker newMaker1 = new NewMaker();
  }

  /**
  * 釋放數據庫資源<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 PreparedStatement ps=null;
  private DBConnectionManager db;
  private Connection con=null;
  private ResultSet rs=null;
}