frame1.java

用JAVA 编写的宾馆管理系统

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