ResultSet rs = db.getResult(sql);
      if (rs.first()) {
        ID = rs.getString("ID");
      }
      else {
        rs.close();
      }
    }
    catch (Exception e) {
      e.printStackTrace();
    }
    return ID;
  }
//根據房主姓名得到房主ID
  //與房產坐落類似，住房信息表中住戶信息項存儲的是房主ID，所以在保存時首先要將房主姓名轉化為房主ID
  String getOwnerID(String owner) {
    String sql = "select * from OwnerInfo where name='" + owner + "'";
    String ID = new String();
    try {
      ResultSet rs = db.getResult(sql);
      if (rs.first()) {
        ID = rs.getString("ID");
      }
      else {
        //當用戶所填寫房主姓名在數據庫中不存在時，提示用戶首先增加該房主信息
        CommonDialog.showDialog(CommonDialog.OK, "房產管理系統", "當前住戶不存在，請先增加其基本信息！");
        rs.close();
        return "";
      }
    }
    catch (Exception e) {
      e.printStackTrace();
    }
    return ID;
  }

  void groupSetEnabled(boolean enabled) {
    txtArea.setEnabled(enabled);
    txtBuyPrice.setEnabled(enabled);
    txtRoomNum.setEnabled(enabled);
    txtBuyTime.setEnabled(enabled);
    txtHouseName.setEnabled(enabled);
    txtYTArea.setEnabled(enabled);
    txtOwner.setEnabled(enabled);
    cboHouseLocation.setEnabled(enabled);
    cboHeading.setEnabled(enabled);
    cboUseType.setEnabled(enabled);

  }

  void btnSetEnabled(boolean add, boolean edit, boolean delete, boolean save) {
    btnAdd.setEnabled(add);
    btnEdit.setEnabled(edit);
    btnDelete.setEnabled(delete);
    btnSave.setEnabled(save);
  }

  void clearData() {
    txtArea.setText("");
    txtBuyPrice.setText("");
    txtRoomNum.setText("");
    txtBuyTime.setText("");
    txtHouseName.setText("");
    txtYTArea.setText("");
    txtOwner.setText("");
    cboHouseLocation.setSelectedItem(null);
    cboHeading.setSelectedItem(null);
    cboUseType.setSelectedItem(null);
  }

  boolean checkData() {
    //坐落是否為空
    if (cboHouseLocation.getSelectedIndex() < 0) {
      CommonDialog.showDialog(CommonDialog.OK, "房產管理系統", "房屋坐落不能為空！");
      return false;
    }
    //房間號是否為空
    if (txtHouseName.getText().trim().equals("")) {
      CommonDialog.showDialog(CommonDialog.OK, "房產管理系統", "房間號不能為空！");
      txtHouseName.setFocusable(true);
      return false;
    }
    return true;
  }

  void btnSave_actionPerformed(ActionEvent e) {
    if (!checkData()) {
      return;
    }
    String sql = new String(); //數據庫操作語句
    String id = new String();  //住房ID
    String locationID = new String(); //坐落ID
    String name = new String(); //房間號
    String heading = new String();//朝向
    String roomNum = new String();//間數
    String useType = new String();//使用方式
    String buyTime = new String();//購買時間
    String buyPrice = new String();//購買價格
    String area = new String();//面積
    String ytArea = new String();//陽臺面積
    String ownerID = new String();//住戶ID
    //調用getLocationID函數根據坐落得到坐落ID
    locationID = getLocationID(cboHouseLocation.getSelectedItem().toString());
    //房主姓名不為空時，得到房主ID
    if (!txtOwner.getText().equals("")) {
      ownerID = getOwnerID(txtOwner.getText());
      //如果房主ID為空，即該房主信息在數據庫中不存在，跳出保存過程
      if (ownerID.equals("")) {
        return;
      }
    }
    if (cboHeading.getSelectedIndex() >= 0) { //朝向
      heading = db.CodeDesConvert("Heading", "",cboHeading.getSelectedItem().toString(), 0);
    }
    if (cboUseType.getSelectedIndex() >= 0) { //使用方式
      useType = db.CodeDesConvert("UseType", "",cboUseType.getSelectedItem().toString(), 0);
    }
    if (!txtRoomNum.getText().equals("")) { //間數
      roomNum = txtRoomNum.getText().trim();
    }
    if (!txtBuyPrice.getText().equals("")) { //購房價格
      buyPrice = txtBuyPrice.getText().trim();
    }
    if (!txtArea.getText().equals("")) { //面積
      area = txtArea.getText().trim();
    }
    if (!txtYTArea.getText().equals("")) { //使用面積
      ytArea = txtYTArea.getText().trim();
    }
    if (operType.equals("add")) {
      //得到新住房ID
      id = db.getID("HouseInfo","ID");
      setCurID(id);
      //生成插入語句
      sql = "insert into HouseInfo values('" + id + "','" + locationID + "','" +
          txtHouseName.getText() + "','" + heading + "','" + roomNum + "','" +
          useType + "','" + txtBuyTime.getText() + "','" + buyPrice +
          "','" + area + "','" + ytArea + "','" + ownerID + "')";
    }//生成更新語句
    else if (operType.equals("edit")) {
      sql = "update HouseInfo set BuildID='" + locationID + "',";
      sql = sql + " Name='" + txtHouseName.getText() + "',";
      sql = sql + " Heading='" + heading + "',";
      sql = sql + " Number='" + roomNum + "',";
      sql = sql + " UseType='" + useType + "',";
      sql = sql + " BuyTime='" + txtBuyTime.getText() + "',";
      sql = sql + " BuyPrice='" + buyPrice + "',";
      sql = sql + " Area='" + area + "',";
      sql = sql + " YTArea='" + ytArea + "',";
      sql = sql + " OwnerID='" + ownerID + "'";
      sql = sql + " where ID='" + curID + "'";
    }
    if (db.executeSql(sql)) {
      CommonDialog.showDialog(CommonDialog.OK, "房產管理系統", "新增住房信息成功！");
      groupSetEnabled(false);
      btnSetEnabled(true, true, true, false);
      setOperType("none");
    }
    else {
      CommonDialog.showDialog(CommonDialog.OK, "房產管理系統", "新增住房信息失?。?quot;);
    }
  }

  void btnEdit_actionPerformed(ActionEvent e) {
    groupSetEnabled(true);
    btnSetEnabled(true, true, true, true);
    setOperType("edit");

  }

  void btnDelete_actionPerformed(ActionEvent e) {
    if (!curID.equals("")) {
      int ir = CommonDialog.showDialog(3, "房產管理系統", "確定要刪除當前記錄嗎？");
      if (ir == 2) {
        return;
      }
      String sql = "delete from HouseInfo where ID='" + curID + "'";
      if (db.executeSql(sql)) {
        CommonDialog.showDialog(CommonDialog.OK, "房產管理系統", "刪除記錄成功！");
        clearData();
        groupSetEnabled(false);
        btnSetEnabled(true, false, false, false);
        setOperType("none");
      }
      else {
        CommonDialog.showDialog(CommonDialog.OK, "房產管理系統", "刪除記錄失敗，請重試！");
      }
    }
  }
}

class HouseInfo_txtArea_actionAdapter
    implements java.awt.event.ActionListener {
  HouseInfo adaptee;

  HouseInfo_txtArea_actionAdapter(HouseInfo adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.txtArea_actionPerformed(e);
  }
}

class HouseInfo_btnExit_actionAdapter
    implements java.awt.event.ActionListener {
  HouseInfo adaptee;

  HouseInfo_btnExit_actionAdapter(HouseInfo adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.btnExit_actionPerformed(e);
  }
}

class HouseInfo_btnAdd_actionAdapter
    implements java.awt.event.ActionListener {
  HouseInfo adaptee;

  HouseInfo_btnAdd_actionAdapter(HouseInfo adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.btnAdd_actionPerformed(e);
  }
}

class HouseInfo_btnSave_actionAdapter
    implements java.awt.event.ActionListener {
  HouseInfo adaptee;

  HouseInfo_btnSave_actionAdapter(HouseInfo adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.btnSave_actionPerformed(e);
  }
}

class HouseInfo_btnEdit_actionAdapter
    implements java.awt.event.ActionListener {
  HouseInfo adaptee;

  HouseInfo_btnEdit_actionAdapter(HouseInfo adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.btnEdit_actionPerformed(e);
  }
}

class HouseInfo_btnDelete_actionAdapter
    implements java.awt.event.ActionListener {
  HouseInfo adaptee;

  HouseInfo_btnDelete_actionAdapter(HouseInfo adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.btnDelete_actionPerformed(e);
  }
}