frame1.java~3~

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

        displaydetail(rs);
        //jTextArea1.append( "\n查询成功\n" );
        statement.close();
      }
      else
        jTextArea1.setText(
            "请输入要删除的房客姓名");
    }
    catch (SQLException sqlex) {
      sqlex.printStackTrace();
      jTextArea1.append(sqlex.toString());
    }

  }

  void displaydetail(ResultSet rs) {
    try {
      Calendar cal = Calendar.getInstance();
      String c = cal.get(Calendar.YEAR) + "-" + (cal.get(Calendar.MONTH) + 1) +
          "-" + cal.get(Calendar.DATE);
      boolean morerows = false;

      //y

      if (rs.next()) {

        jTextField2.setText(rs.getString(1));
        jComboBox1.setSelectedItem(rs.getString(2));
        jTextField4.setText(rs.getString(3));
        jTextField5.setText(rs.getString(4));
        jTextField6.setText(rs.getString(5));
        String temp = rs.getString(6);
        Countdays count = new Countdays(temp, c);
        jTextField1.setText(" " + price_eachday * count.getdays());
        if (rs.next()) morerows = true;
        if (!morerows) {
          String command = "DELETE FROM hotel2 WHERE name LIKE" +
              "'" + jTextField2.getText() + "'";
          delete(command);
        }

      }
      else
        jTextArea1.append("\n没找到记录\n");

      if (morerows) {
        rs.beforeFirst();
        //message(" 您要删除的人的姓名不止一个，请在信息栏中查看，并填入他的房号，谢谢！");
        String p = "name" + "\t\t" + "room" + "\n";
        while (rs.next()) {
          String temp = rs.getString(6);
          Countdays count = new Countdays(temp, c);
          String money = " " + price_eachday * count.getdays();
          p = p + rs.getString(1) + "\t\t" + rs.getString(5) + "\n";

        }
        jTextArea1.setText(p);

        boolean judgeinput = false;
        String roomnum = "";
        String command = "";
        //while(judge_roomnum(roomnum))
        roomnum = JOptionPane.showInputDialog(
            " 您要删除的人的姓名不止一个，请在信息栏中查看，并在当前行填入他的具体房号，谢谢！");
        while (!judge_roomnum(roomnum)) {
          roomnum = JOptionPane.showInputDialog(
              "您输入的房号不合法，房号只能为1到100的数字，请您重新输入，谢谢！");
        }
        command = "DELETE FROM hotel2 WHERE name LIKE" + "'" +
            jTextField2.getText() + "'" + "AND room LIKE" + "'" + roomnum + "'";
        delete(command);

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

  void delete(String m) {
    try {
      Statement statement = connect.createStatement();

      //if ( !jTextField2.getText().equals( "" ) ) {
      String query = "";
      // if(morethanone==false)
      query = m;
      /*if(morethanone==true)
                        {
        boolean notblank=false;
        if(!jTextField6.getText().equals(" "))
          notblank=true;
        if(notblank)
          query = "DELETE FROM hotel2 WHERE name LIKE" + "'" + jTextField2.getText() + "'"+"AND room LIKE"+"'"+jTextField6.getText() + "'";

                        }*/

      jTextArea1.append("\n发送的命令:" + connect.nativeSQL(query) + "\n");

      int result = statement.executeUpdate(query);

      if (result == 1)
        jTextArea1.append("\n删除成功\n");
      else {
        jTextArea1.append("\n删除失败,请查看输入的房号是否正确。\n");
        jTextField2.setText("");
        jComboBox1.setSelectedIndex( -1);
        jTextField4.setText("");
        jTextField5.setText("");
        jTextField6.setText("");

      }
      // }
      //  else
      //  jTextArea1.append( "\n请您输入名子" );

      statement.close();
    }
    catch (SQLException sqlex) {
      sqlex.printStackTrace();
      jTextArea1.append(sqlex.toString());
    }

  }

  void jMenuItem1_actionPerformed(ActionEvent e) {
    JTextArea t = new JTextArea(10, 15);
    t.setLineWrap(true);
    t.setEditable(false);
    JScrollPane p = new JScrollPane(t);
    t.setText(
        "这是小弟近期一作品，请各位大侠指教！谁要是看着好就用吧，也没什么商业价值！我的QQ是：2410052。欢迎大家给我留言赐教，谢谢！");
    JOptionPane.showMessageDialog(null, p, "谢谢使用，请多提意见！",
                                  JOptionPane.INFORMATION_MESSAGE);

  }

  void jButton4_actionPerformed(ActionEvent e) {
    try {

      Statement statement = connect.createStatement(ResultSet.
          TYPE_SCROLL_INSENSITIVE,
          ResultSet.CONCUR_UPDATABLE);
      String query = "SELECT * FROM hotel2 ";
      jTextArea1.append("\n发送的命令: " +
                        connect.nativeSQL(query)
                        + "\n");
      ResultSet rs = statement.executeQuery(query);
      findemptyroom(rs);
      jTextArea1.append("\n查询成功\n");
      statement.close();

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

  }

  void findemptyroom(ResultSet r) {
    int m = 0;
    String emptyroom = " ";

    try {

      if (r.next()) {

        //r.beforeFirst();
        for (int j = 1; j <= 100; j++) {
          r.first();
          int full = 0;

          do {
            if (r.getString(5).equals(Integer.toString(j))) {
              full = 1;
              break;

            }

          }
          while (r.next());

          if (full == 1)continue;
          else {
            emptyroom = emptyroom + " " + j;
            if (++m % 5 == 0) emptyroom = emptyroom + "\n";
          }

        }
      }
      else {
        jTextArea1.setText("");
        jTextArea1.setText("1～100号房间全是空的，您随便选吧！");
      }

      jTextArea1.setText(emptyroom);
    }
    catch (SQLException sqlex) {
      sqlex.printStackTrace();
      jTextArea1.append(sqlex.toString());
    }

  }

  /**该方法是年龄范围的合法性检验*/
  boolean judge_age(String input) {
    int age;
    try {
      age = Integer.parseInt(input);
    }
    catch (Exception e) {
      return false;
    }
    //数字范围在18至60的返回值是true
    if ( (age >= 1) && (age <= 100))
      return true;
    else
      return false;
  }

  boolean judge_roomnum(String input) {
    int age;
    try {
      age = Integer.parseInt(input);
    }
    catch (Exception e) {
      return false;
    }

    if ( (age >= 1) && (age <= 100))
      return true;
    else

      return false;

  }

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

  boolean legal() {
    if (judge_age(jTextField4.getText()) && judge_roomnum(jTextField6.getText()))
      return true;
    else {
      message("房号和年龄必须在1到100之间，请重新输入！");
      jTextField4.setText("");
      jTextField6.setText("");
      return false;
    }
  }

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

  boolean idnum(String t) {

    try {
      Integer.parseInt(t);
    }
    catch (Exception e) {
      return false;
    }
    //数字范围在18至60的返回值是true

    return true;

  }

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

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

  void jMenuItem2_actionPerformed(ActionEvent e) {
    JTextArea t = new JTextArea(10, 15);
    t.setLineWrap(true);
    t.setEditable(false);
    JScrollPane p = new JScrollPane(t);
    t.setText("本程序为酒店客房管理系统，采用微软的Access数据库实现。因此，请用户在使用前先安装微软的office，以便程序使用其中的Access。在用户安装完office后，请新建一个Access表数据库，字段名分别为“ name,sex,age,idnumber,room ,in_date”，并且全为字符型。在完成以上操作后，请用户在要运行程序的计算机上安装odbc数据源（方法我就不细说了，好多java的书上有讲）。然后，用户就可以运行程序了！");
    JOptionPane.showMessageDialog(null, p, "谢谢使用，请多提意见！",
                                  JOptionPane.INFORMATION_MESSAGE);

  }

  public static void main(String args[]) {
    Frame1 app = new Frame1();
    app.addWindowListener(
        new WindowAdapter() {
      public void windowClosing(WindowEvent e) {
        System.exit(0);
      }

    }
    );
  }

}

class Frame1_jButton1_actionAdapter
    implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jButton1_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }

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

}

class Frame1_jButton3_actionAdapter
    implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jButton3_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }

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

class Frame1_jButton5_actionAdapter
    implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jButton5_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }

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

class Frame1_jButton2_actionAdapter
    implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jButton2_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }

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

class Frame1_jMenuItem1_actionAdapter
    implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jMenuItem1_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }

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

class Frame1_jButton4_actionAdapter
    implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jButton4_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }

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

class Frame1_jMenuItem2_actionAdapter
    implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jMenuItem2_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }

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