ownerquery.java~70~

关于信息系统开发的事例．．．． 很好哦．．． 代码很简单

      model.addColumn("建筑面积");
      model.addColumn("阳台面积");
    }
    else if (sql.indexOf("OwnerInfo") != -1) {
      model.setColumnCount(0);
      model.setRowCount(0);
      model.addColumn("ID");
      model.addColumn("姓名");
      model.addColumn("性别");
      model.addColumn("出生年月");
      model.addColumn("参加工作时间");
      model.addColumn("工作单位");
    }
    else if (sql.indexOf("OwnerInfo") != -1) {
      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"));
            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"));
            tempvector.add(db.getByField("BuildId", "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"));
            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("OwnerInfo") != -1) {
            tempvector = new Vector(1, 1);
            tempvector.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) {
System.out.println(tblResult.getSelectedColumns()[0]);
  }

}

class OwnerQuery_btnExit_actionAdapter
    implements java.awt.event.ActionListener {
  OwnerQuery adaptee;

  OwnerQuery_btnExit_actionAdapter(OwnerQuery adaptee) {
    this.adaptee = adaptee;
  }

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

class OwnerQuery_btnQuery_actionAdapter
    implements java.awt.event.ActionListener {
  OwnerQuery adaptee;

  OwnerQuery_btnQuery_actionAdapter(OwnerQuery adaptee) {
    this.adaptee = adaptee;
  }

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

class OwnerQuery_cboTable_actionAdapter
    implements java.awt.event.ActionListener {
  OwnerQuery adaptee;

  OwnerQuery_cboTable_actionAdapter(OwnerQuery adaptee) {
    this.adaptee = adaptee;
  }

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

class OwnerQuery_cboItem_actionAdapter
    implements java.awt.event.ActionListener {
  OwnerQuery adaptee;

  OwnerQuery_cboItem_actionAdapter(OwnerQuery adaptee) {
    this.adaptee = adaptee;
  }

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

class OwnerQuery_btnView_actionAdapter implements java.awt.event.ActionListener {
  OwnerQuery adaptee;

  OwnerQuery_btnView_actionAdapter(OwnerQuery adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.btnView_actionPerformed(e);
  }
}