queryroomframe.java~1~

酒店管理系统后台数据库存储过程

    JButton btnreturn = new JButton();
    JLabel lblRoomIntro = new JLabel();
    JLabel lblRemark = new JLabel();
    JLabel lblRoomType = new JLabel();
    JLabel lblRoomStandpri = new JLabel();
    JLabel lblRoomRebate = new JLabel();
    JLabel lblOnUse = new JLabel();
    JLabel lblPlace = new JLabel();
    GridLayout gridLayout1 = new  GridLayout(8,1);
    TitledBorder titledBorder2 = new TitledBorder("");
    TitledBorder titledBorder3 = new TitledBorder("");
    TitledBorder titledBorder4 = new TitledBorder("");
    TitledBorder titledBorder5 = new TitledBorder("");
    TitledBorder titledBorder6 = new TitledBorder("");

    //该方法用于得到用户的查询类型
    public int getRdoOption()
    {   int flag =0;
        if(this.rdoEnable.isSelected())
        {                         //查询可用房
        }
        else if(this.rdoUseing.isSelected())
        {
            return  flag = 1 ;    //查询住客房
        }
        else if(this.rdoCleaning.isSelected())
        {
            return  flag = 2;     //查询打扫房
        }
        else if (this.rdoRepair.isSelected())
        {
            return flag = 3;     //查询修理房
        }
        else if(this.rdoAll.isSelected())
        {
            return flag = 4;     //查询全部客房
        }

         return  flag;
    }
            //树结构的节点选择改变时的事件
        public void roomTree_valueChanged(TreeSelectionEvent e) {
            try
            {
              DefaultMutableTreeNode node =  (DefaultMutableTreeNode)roomTree.getLastSelectedPathComponent();
              String nameNo = "";
              if(node==null)
              {
                     JOptionPane.showMessageDialog(this,"，不能选择空房间，请重新选择房间号！","提示",JOptionPane.INFORMATION_MESSAGE);
                     return ;
              }
             else
             {
                    //查询数据在显示区域显示该房间的详细信息
                    nameNo = node.toString();
                    this.lblRoomNo.setText("房间号："+nameNo);
                    String sql = "select * from roomstatus where roomNo = '"+nameNo+"'";
                    //查询用户选择的树节点的房间号
                    rs = dbo.returnQuery(sql);
                    while(rs.next())
                    {
                        //显示查询的房间信息

                      this.lblRoomNo.setText("     房 间 号："+rs.getString(1) );
                      this.lblRoomType.setText("     房间类型："+rs.getString(2));
                      this.lblRoomStandpri.setText("     标 准 价："+rs.getInt(3));
                      this.lblRoomRebate.setText("     折 扣 价："+rs.getInt(4));
                      this.lblOnUse.setText("     客房状态："+rs.getInt(5));
                      this.lblPlace.setText("     客房位置："+rs.getString(6));
                      this.lblRoomIntro.setText("     客房介绍："+rs.getString(7));
                      this.lblRemark.setText("     备   注："+rs.getString(8));
                    }

              }
           }catch(Exception ex)
           {
               ex.printStackTrace();
           }
    }

    //该方法用于增加树的节点
    public void addTreeCode(String roomNo)
    {
         //添加豪华间叶子
        if(roomNo.charAt(0)=='A')
        {
            DefaultMutableTreeNode lux = new DefaultMutableTreeNode(roomNo);
            luxury.add(lux);
        }
        //添加标准间叶子
        if(roomNo.charAt(0)=='B')
        {
           DefaultMutableTreeNode stan = new DefaultMutableTreeNode(roomNo);
           standard.add(stan);

        }
        //添加普通间叶子
       if(roomNo.charAt(0)=='C')
       {
            DefaultMutableTreeNode com = new DefaultMutableTreeNode(roomNo);
           commen.add(com);
       }

    }

    //查询按钮事件
    public void btnQuery_actionPerformed(ActionEvent e) {
               int status = getRdoOption();
               String sql = "";
              //判断查询类型
               if(status==4)
               {
                    sql ="select RoomNo from roomstatus";
                  //  System.out.println("查询全部");
               }
               else if(status ==0)
               {
                   sql ="select RoomNo from roomstatus where onuse ='"+status +"'";
                  // System.out.println("查询可用房");
               }else if( status == 1)
               {
                    sql ="select RoomNo from roomstatus where onuse ='"+status +"'";
                   // System.out.println("查询住客房");
               }
               else if (status == 2)
               {
                    sql ="select RoomNo from roomstatus where onuse ='"+status +"'";
                //  System.out.println("查询打扫房");
               }
               else if (status == 3)
              {
                   sql ="select RoomNo from roomstatus where onuse ='"+status +"'";
                 //  System.out.println("查询修理房");
              }

               try {
                   rs = dbo.returnQuery(sql);
                   while (rs.next()) {
                       //把查询的数据添加到树节点
                     addTreeCode(rs.getString(1));
                    }
               } catch (SQLException ex) {
                   ex.printStackTrace();
               }

    }

    public void btnRefresh_actionPerformed(ActionEvent e) {
        //重新建一个窗体
       QueryRoomFrame queryRoom  = new QueryRoomFrame();
       queryRoom.setBounds(200,200,700,550);
       queryRoom.setVisible(true);

       //关闭结果集
        if(rs!=null)
        {
          try {
               rs.close();
          } catch (SQLException ex) {
               ex.printStackTrace();
           }
       }
        //关闭当前窗体
          this.dispose();

    }

    public void btnreturn_actionPerformed(ActionEvent e) {
        this.dispose();
    }


}


class QueryRoomFrame_btnreturn_actionAdapter implements ActionListener {
    private QueryRoomFrame adaptee;
    QueryRoomFrame_btnreturn_actionAdapter(QueryRoomFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class QueryRoomFrame_btnRefresh_actionAdapter implements ActionListener {
    private QueryRoomFrame adaptee;
    QueryRoomFrame_btnRefresh_actionAdapter(QueryRoomFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class QueryRoomFrame_btnQuery_actionAdapter implements ActionListener {
    private QueryRoomFrame adaptee;
    QueryRoomFrame_btnQuery_actionAdapter(QueryRoomFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class QueryRoomFrame_roomTree_treeSelectionAdapter implements
        TreeSelectionListener {
    private QueryRoomFrame adaptee;
    QueryRoomFrame_roomTree_treeSelectionAdapter(QueryRoomFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void valueChanged(TreeSelectionEvent e) {
        adaptee.roomTree_valueChanged(e);
    }
}