hotelmanageframe.java~23~

Java+SQL2000宾馆管理系统,可实现简单的管理操作。

      String query = "SELECT * FROM hotel ";
      operInfoTextArea.append("\n发送的命令: " +
                              connect.nativeSQL(query)
                              + "\n");
      ResultSet rs = statement.executeQuery(query);
      findemptyroom(rs);
      operInfoTextArea.append("\n查询成功\n");
      statement.close();

    }
    catch (SQLException sqlex) {
      sqlex.printStackTrace();
      operInfoTextArea.append(sqlex.toString());
    }

  }

  void findemptyroom(ResultSet r) {
    String emptyroom = "";
    int j = 0;
    ArrayList fullList = new ArrayList(15);
    try {
      while (r.next()) {
        String roomNo = r.getString("room");
        fullList.add(roomNo);
      }
      if (fullList.contains("201") == false) {
        emptyroom += "201(单人房) ";
        j++;
        if (j % 3 == 0) emptyroom += "\n";
      }
      if (fullList.contains("202") == false) {
        emptyroom += "202(单人房) ";
        j++;
        if (j % 3 == 0) emptyroom += "\n";
      }
      if (fullList.contains("203") == false) {
        emptyroom += "203(单人房) ";
        j++;
        if (j % 3 == 0) emptyroom += "\n";
      }
      if (fullList.contains("204") == false) {
        emptyroom += "204(单人房) ";
        j++;
        if (j % 3 == 0) emptyroom += "\n";
      }
      if (fullList.contains("205") == false) {
        emptyroom += "205(单人房) ";
        j++;
        if (j % 3 == 0) emptyroom += "\n";
      }
      if (fullList.contains("206") == false) {
        emptyroom += "206(单人房) ";
        j++;
        if (j % 3 == 0) emptyroom += "\n";
      }
      if (fullList.contains("301") == false) {
        emptyroom += "301(单人房) ";
        j++;
        if (j % 3 == 0) emptyroom += "\n";
      }
      if (fullList.contains("302") == false) {
        emptyroom += "302(单人房) ";
        j++;
        if (j % 3 == 0) emptyroom += "\n";
      }
      if (fullList.contains("303") == false) {
        emptyroom += "303(单人房) ";
        j++;
        if (j % 3 == 0) emptyroom += "\n";
      }
      if (fullList.contains("304") == false) {
        emptyroom += "304(单人房) ";
        j++;
        if (j % 3 == 0) emptyroom += "\n";
      }
      if (fullList.contains("305") == false) {
        emptyroom += "305(单人房) ";
        j++;
        if (j % 3 == 0) emptyroom += "\n";
      }
      if (fullList.contains("306") == false) {
        emptyroom += "306(单人房) ";
        j++;
        if (j % 3 == 0) emptyroom += "\n";
      }
      if (fullList.contains("401") == false) {
        emptyroom += "401(双人房) ";
        j++;
        if (j % 3 == 0) emptyroom += "\n";
      }
      if (fullList.contains("402") == false) {
        emptyroom += "402(双人房) ";
        j++;
        if (j % 3 == 0) emptyroom += "\n";
      }
      if (fullList.contains("403") == false) {
        emptyroom += "403(双人房) ";
        j++;
        if (j % 3 == 0) emptyroom += "\n";
      }
      if (fullList.contains("404") == false) {
        emptyroom += "404(双人房) ";
        j++;
        if (j % 3 == 0) emptyroom += "\n";
      }
      if (fullList.contains("501") == false) {
        emptyroom += "501(双人房) ";
        j++;
        if (j % 3 == 0) emptyroom += "\n";
      }
      if (fullList.contains("502") == false) {
        emptyroom += "502(双人房) ";
        j++;
        if (j % 3 == 0) emptyroom += "\n";
      }
      if (fullList.contains("503") == false) {
        emptyroom += "503(双人房) ";
        j++;
        if (j % 3 == 0) emptyroom += "\n";
      }
      if (fullList.contains("504") == false) {
        emptyroom += "504(双人房) ";
        j++;
        if (j % 3 == 0) emptyroom += "\n";
      }
      operInfoTextArea.setText("");
      operInfoTextArea.setText("以下房间为空:\n" + emptyroom);

    }
    catch (SQLException sqlex) {
      sqlex.printStackTrace();
      operInfoTextArea.append(sqlex.toString());
    }

  }

  /**该方法是年龄范围的合法性检验*/
  boolean judgeAge() {
    int age;
    try {
      age = Integer.parseInt(ageTextField.getText());
    }
    catch (Exception e) {
      return false;
    }
    //数字范围在1至100的返回值是true
    if ( (age >= 1) && (age <= 100))
      return true;
    else {
      ageTextField.setText("");
      message("年龄范围必须在1至100之间！");
      return false;
    }
  }

  boolean judgeRoomNum() {
    int roomNum = Integer.parseInt(roomTextField.getText());
    if (roomNum >= 201 && roomNum <= 206)return true;
    else if (roomNum >= 301 && roomNum <= 306)return true;
    else if (roomNum >= 401 && roomNum <= 404)return true;
    else if (roomNum >= 501 && roomNum <= 504)return true;
    else {
      roomTextField.setText("");
      message("房间号必须在201-206、301-306、401-404、501-504之间！");
      return false;
    }
  }

  boolean judgeName() {
    if (!nameTextField.getText().equals("") &&
        nameTextField.getText().length() <= 8)
      return true;
    else {
      message("必须输入姓名，且长度不能超过8");
      return false;
    }
  }

  boolean judgeIdnum() {
    if (idTextField.getText().length() == 18) {
      String front1 = idTextField.getText().substring(0, 4);
      String front2 = idTextField.getText().substring(4, 8);
      String front3 = idTextField.getText().substring(8, 12);
      String front4 = idTextField.getText().substring(12, 16);
      String back = idTextField.getText().substring(16,
          idTextField.getText().length());
      if (idnum(front1) && idnum(front2) && idnum(front3) && idnum(front4) &&
          idnum(back))
        return true;
      else {
        message("身份证号必须为18位的数字，请重新输入！");
        idTextField.setText("");
        return false;
      }
    }
    else {
      message("身份证号必须为18位的数字,请重新输入!");
      idTextField.setText("");
      return false;
    }
  }

  boolean idnum(String t) {
    try {
      Integer.parseInt(t);
    }
    catch (Exception e) {
      return false;
    }
    return true;

  }

  boolean judgeSex() {
    if (!sexComboBox.getSelectedItem().equals(""))
      return true;
    else {
      message("请选择性别");
      return false;
    }
  }

  void message(String t) {
    JOptionPane.showMessageDialog(null, t);
  }

  void helpMenuItem_actionPerformed(ActionEvent e) {
    JTextArea t = new JTextArea(4,60);
    t.setLineWrap(true);
    t.setEditable(false);
    JScrollPane p = new JScrollPane(t);
    t.setText("本程序为宾馆管理系统，使用前在SQL Server中新建一个数据库表，字段名分别为“name,sex,age,idnumber,room,in_date”，并且全为字符型。在完成以上操作后，请用户在要运行程序的计算机上安装odbc数据源。然后，用户就可以运行程序了！");
    JOptionPane.showMessageDialog(null, p, "使用帮助",
                                  JOptionPane.INFORMATION_MESSAGE);

  }

  public static void main(String[] args) {
    try {
      UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName());
    }
    catch (Exception e) {
      e.printStackTrace();
    }
    HotelManageFrame frame = new HotelManageFrame();

    Dimension d = Toolkit.getDefaultToolkit().getScreenSize();
    frame.setSize( (int) d.getWidth(), 650); //窗口最大化
    frame.setLocation( (d.width - frame.getSize().width) / 2,
                      (d.height - frame.getSize().height) / 2);
    frame.show();
  }
}

class HotelManageFrame_addGuestButton_actionAdapter
    implements java.awt.event.ActionListener {
  HotelManageFrame adaptee;

  HotelManageFrame_addGuestButton_actionAdapter(HotelManageFrame adaptee) {
    this.adaptee = adaptee;
  }

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

}

class HotelManageFrame_guestQueryButton_actionAdapter
    implements java.awt.event.ActionListener {
  HotelManageFrame adaptee;

  HotelManageFrame_guestQueryButton_actionAdapter(HotelManageFrame adaptee) {
    this.adaptee = adaptee;
  }

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

class HotelManageFrame_clearButton_actionAdapter
    implements java.awt.event.ActionListener {
  HotelManageFrame adaptee;

  HotelManageFrame_clearButton_actionAdapter(HotelManageFrame adaptee) {
    this.adaptee = adaptee;
  }

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

class HotelManageFrame_deleteGuestButton_actionAdapter
    implements java.awt.event.ActionListener {
  HotelManageFrame adaptee;

  HotelManageFrame_deleteGuestButton_actionAdapter(HotelManageFrame adaptee) {
    this.adaptee = adaptee;
  }

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

class HotelManageFrame_aboutMenuItem_actionAdapter
    implements java.awt.event.ActionListener {
  HotelManageFrame adaptee;

  HotelManageFrame_aboutMenuItem_actionAdapter(HotelManageFrame adaptee) {
    this.adaptee = adaptee;
  }

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

class HotelManageFrame_emptyRoomSearchButton_actionAdapter
    implements java.awt.event.ActionListener {
  HotelManageFrame adaptee;

  HotelManageFrame_emptyRoomSearchButton_actionAdapter(HotelManageFrame adaptee) {
    this.adaptee = adaptee;
  }

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

class HotelManageFrame_helpMenuItem_actionAdapter
    implements java.awt.event.ActionListener {
  HotelManageFrame adaptee;

  HotelManageFrame_helpMenuItem_actionAdapter(HotelManageFrame adaptee) {
    this.adaptee = adaptee;
  }

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