query.java

java房产管理系统

    if (sql.indexOf("BuildInfo") != -1) {
      linkID.clear();
      model.setColumnCount(0);
      model.setRowCount(0);
      model.addColumn("ID");
      model.addColumn("坐落");
      model.addColumn("建成年代");
      model.addColumn("占地面积");
      model.addColumn("使用面积");
    }
    else if (sql.indexOf("HouseInfo") != -1) {
      linkID.clear();
      model.setColumnCount(0);
      model.setRowCount(0);
      model.addColumn("ID");
      model.addColumn("坐落");
      model.addColumn("房间号");
      model.addColumn("建筑面积");
      model.addColumn("阳台面积");
    }
    else if (sql.indexOf("OwnerInfo") != -1) {
      linkID.clear();
      model.setColumnCount(0);
      model.setRowCount(0);
      model.addColumn("ID");
      model.addColumn("姓名");
      model.addColumn("性别");
      model.addColumn("出生年月");
      model.addColumn("参加工作时间");
      model.addColumn("工作单位");
    }
    else if (sql.indexOf("FamilyInfo") != -1) {
      linkID.clear();
      model.setColumnCount(0);
      model.setRowCount(0);
      model.addColumn("ID");
      model.addColumn("房主姓名");
      model.addColumn("家属姓名");
      model.addColumn("性别");
      model.addColumn("与房主关系");
      model.addColumn("出生年月");
      model.addColumn("参加工作时间");
    }
    try {
      ResultSet rs = db.getResult(sql);
      if (rs.first()) {
        rs.beforeFirst();
        while (rs.next()) {
          //根据不同的查询信息加载相应的信息
          if (sql.indexOf("BuildInfo") != -1) {
            tempvector = new Vector(1, 1);
            tempvector.add(rs.getString("ID"));
            linkID.add(rs.getString("ID"));
            tempvector.add(rs.getString("Location"));
            tempvector.add(rs.getString("Time"));
            tempvector.add(rs.getString("Area"));
            tempvector.add(rs.getString("UseArea"));
            model.addRow(tempvector);
          }
          else if (sql.indexOf("HouseInfo") != -1) {
            tempvector = new Vector(1, 1);
            tempvector.add(rs.getString("ID"));
            linkID.add(rs.getString("ID"));
            tempvector.add(db.getByField("BuildInfo", "Location",
                                         "ID='" + rs.getString("BuildID") + "'"));
            tempvector.add(rs.getString("Name"));
            tempvector.add(rs.getString("Area"));
            tempvector.add(rs.getString("YTArea"));
            model.addRow(tempvector);
          }
          else if (sql.indexOf("OwnerInfo") != -1) {
            tempvector = new Vector(1, 1);
            tempvector.add(rs.getString("ID"));
            linkID.add(rs.getString("ID"));
            tempvector.add(rs.getString("Name"));
            tempvector.add(db.getByField("Gender", "DESCRIPTION",
                                         "CODE='" + rs.getString("Gender") +
                                         "'"));
            tempvector.add(rs.getString("Birthday"));
            tempvector.add(rs.getString("WorkTime"));
            tempvector.add(rs.getString("Org"));
            model.addRow(tempvector);
          }
          else if (sql.indexOf("FamilyInfo") != -1) {
            tempvector = new Vector(1, 1);
            tempvector.add(rs.getString("ID"));
            linkID.add(rs.getString("ID"));
            tempvector.add(db.getByField("OwnerInfo", "Name",
                                         "ID='" + rs.getString("OwnerID") + "'"));
            tempvector.add(rs.getString("Name"));
            tempvector.add(db.getByField("Gender", "DESCRIPTION",
                                         "CODE='" + rs.getString("Gender") +
                                         "'"));
            tempvector.add(db.getByField("Relation", "DESCRIPTION",
                                         "CODE='" + rs.getString("Relation") +
                                         "'"));
            tempvector.add(rs.getString("Birthday"));
            tempvector.add(rs.getString("WorkTime"));
            model.addRow(tempvector);
          }
        }
      }
      else {
        CommonDialog.showDialog(CommonDialog.OK, "房产管理系统", "没有符合条件的记录！");
        rs.close();
      }
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }
//数据表列表框响应事件
  void cboTable_actionPerformed(ActionEvent e) {
    if (isInitTable) {
      return;
    }
    int index = cboTable.getSelectedIndex();
    curTable = linkTable.get(index).toString();
    isInitItem = true;
    cboItem.removeAllItems();
    linkItem.clear(); //不清空时会出问题
    for (int i = 0; i < sItems.length; i++) {
      if (sItems[i][0].equals(curTable)) {
        cboItem.addItem(sItems[i][2]);
        Hashtable tmp = new Hashtable();
        tmp.put("item", sItems[i][1]);
        tmp.put("code", sItems[i][3]);
        linkItem.add(tmp);
      }
    }
    cboItem.setSelectedItem(null);
    isInitItem = false;
  }

//查询项列表框响应事件
  void cboItem_actionPerformed(ActionEvent e) {
    if (isInitItem) {
      return;
    }
    int index = cboItem.getSelectedIndex();
    curItem = ( (Hashtable) linkItem.get(index)).get("item").toString();
    String code = ( (Hashtable) linkItem.get(index)).get("code").toString();
    cboValue.removeAllItems();
    linkCode.clear();
    if (!code.equals("")) {
      System.out.println(code);
      vecCode = db.getCode(code);
      for (int i = 0; i < vecCode.size(); i++) {
        cboValue.addItem( ( (String[]) vecCode.elementAt(i))[1]);
        linkCode.add( ( (String[]) vecCode.elementAt(i))[0]);
      }
      cboValue.setSelectedItem(null);
    }
  }

//查看按钮响应事件
  void btnView_actionPerformed(ActionEvent e) {
    String curID = new String();
    if (tblResult.getSelectedRow() < 0) {
      CommonDialog.showDialog(CommonDialog.OK, "房产管理系统", "请选择要查看的记录！");
      return;
    }
    else {
      curID = linkID.get(tblResult.getSelectedRow()).toString();
    }
    loadForm(curID);
  }

//查看记录信息
  void loadForm(String ID) {
    //根据不同的查询项加载不同的窗体
    if (curTable.equals("BuildInfo")) {
      BuildInfo buildInfo = new BuildInfo(ID);
      Dimension dlgSize = buildInfo.getPreferredSize();
      Dimension frmSize = getSize();
      Point loc = getLocation();
      buildInfo.setLocation( (frmSize.width - dlgSize.width) / 2 + loc.x,
                            (frmSize.height - dlgSize.height) / 2 + loc.y);
      buildInfo.pack();
      buildInfo.show();
    }
    else if (curTable.equals("HouseInfo")) {
      HouseInfo houseInfo = new HouseInfo(ID);
      Dimension dlgSize = houseInfo.getPreferredSize();
      Dimension frmSize = getSize();
      Point loc = getLocation();
      houseInfo.setLocation( (frmSize.width - dlgSize.width) / 2 + loc.x,
                            (frmSize.height - dlgSize.height) / 2 + loc.y);
      houseInfo.pack();
      houseInfo.show();
    }
    else if (curTable.equals("OwnerInfo")) {
      OwnerInfo ownerInfo = new OwnerInfo(ID);
      Dimension dlgSize = ownerInfo.getPreferredSize();
      Dimension frmSize = getSize();
      Point loc = getLocation();
      ownerInfo.setLocation( (frmSize.width - dlgSize.width) / 2 + loc.x,
                            (frmSize.height - dlgSize.height) / 2 + loc.y);
      ownerInfo.pack();
      ownerInfo.show();
    }
    else if (curTable.equals("FamilyInfo")) {
      FamilyInfo familyInfo = new FamilyInfo(ID);
      Dimension dlgSize = familyInfo.getPreferredSize();
      Dimension frmSize = getSize();
      Point loc = getLocation();
      familyInfo.setLocation( (frmSize.width - dlgSize.width) / 2 + loc.x,
                             (frmSize.height - dlgSize.height) / 2 + loc.y);
      familyInfo.pack();
      familyInfo.show();
    }
  }

  void btnExit_actionPerformed(ActionEvent e) {
    this.dispose();
  }

}

class Query_btnExit_actionAdapter
    implements java.awt.event.ActionListener {
  Query adaptee;

  Query_btnExit_actionAdapter(Query adaptee) {
    this.adaptee = adaptee;
  }

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

class Query_btnQuery_actionAdapter
    implements java.awt.event.ActionListener {
  Query adaptee;

  Query_btnQuery_actionAdapter(Query adaptee) {
    this.adaptee = adaptee;
  }

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

class Query_cboTable_actionAdapter
    implements java.awt.event.ActionListener {
  Query adaptee;

  Query_cboTable_actionAdapter(Query adaptee) {
    this.adaptee = adaptee;
  }

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

class Query_cboItem_actionAdapter
    implements java.awt.event.ActionListener {
  Query adaptee;

  Query_cboItem_actionAdapter(Query adaptee) {
    this.adaptee = adaptee;
  }

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

class Query_btnView_actionAdapter
    implements java.awt.event.ActionListener {
  Query adaptee;

  Query_btnView_actionAdapter(Query adaptee) {
    this.adaptee = adaptee;
  }

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