query.java~13~

java房产管理系统

        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();
    }

  }

  String createSql() {
    String sql = "";
    String value = "";
    String queryValue = "";
    sql = "select * from " + curTable + " where " + curItem + " " +
        linkOper.get(cboOper.getSelectedIndex());
    //代码值
    if (linkCode.size() > 0) {
      value = linkCode.get(cboValue.getSelectedIndex()).toString();
    } //特殊项
    else if (curItem.equals("BuildID")) {
      value = db.getByField("BuildInfo", "ID",
                            "Location='" +
                            cboValue.getEditor().getItem().toString() + "'");
    }
    else if (curItem.equals("OwnerID")) {
      value = db.getByField("OwnerInfo", "ID",
                            "Name='" +
                            cboValue.getEditor().getItem().toString() + "'");
    }
    else {
      value = cboValue.getEditor().getItem().toString();
    }
    System.out.println(value);
    //like操作
    if (linkOper.get(cboOper.getSelectedIndex()).equals("like")) {
      queryValue = " '%" + value + "%'";
    }
    else {
      queryValue = "'" + value + "'";
    }
    System.out.println(queryValue);
    sql += queryValue;
    System.out.println(sql);
    return sql;
  }

  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();
      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();
    }

  }
}

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);
  }
}