kehu_exit.java

JAVA开发的酒店管理系统

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
import javax.swing.border.*;
import java.util.regex.*;


public class kehu_exit extends JFrame{
   String this_money,this_room_num,sqll;
   	JButton jb,jb2,jb3,jb4;
	TextArea text;
	JTextField jt;
	db_manager db=new db_manager();
	ResultSet rs;
  private boolean flag=false;
  kehu_exit(){
		super("客户退房管理");
	
		Container cp=getContentPane();
		JLabel lab=new JLabel("房间号码");
		 jt=new JTextField(10);
		 text=new TextArea();
		text.setEditable(false);
		text.setBackground(Color.white);
		jb=new JButton("退出");
		jb2=new JButton("结帐");
		jb3=new JButton("退房");
		jb4=new JButton("清空");
	    JPanel jp=new JPanel();
	    JPanel jp2=new JPanel();
        jp.setBorder( new TitledBorder("输入房间号"));
    	jp.setLayout(new FlowLayout());
    	jp2.setBorder( new TitledBorder("所需费用"));
    	jp2.setLayout(new FlowLayout());
    	jp.add(lab);jp.add(jt);
		jp2.add(text);
		jp2.add(jb2);
		jp2.add(jb3);
	   jp2.add(jb4);
		jp2.add(jb);
		cp.add(jp,BorderLayout.NORTH);
		cp.add(jp2,BorderLayout.CENTER);
		setSize(500,400);
		setVisible(true);
		kehu_action();	
		addWindowListener(new WinLis());
		validate();
	}
      public void exit(){
		this.dispose();
            }
    private void kehu_action(){
    	
    	
    	jb.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
		exit();
		
			}
		});
		if(!flag) JOptionPane.showMessageDialog(null,"退房前请先结帐");
	      jb3.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
			String sql;
			
		   sqll="insert into all_money (room_num,all_money)values('"+this_room_num+"','"+this_money+"')";
		
	
		      if(jt.getText().trim().equals("")){
               JOptionPane.showMessageDialog(null,"房间号码不能为空！");
	           return;}
			if(!flag) JOptionPane.showMessageDialog(null,"请先结帐");
			else {sql="delete from people where room_num="+"'"+Integer.parseInt(jt.getText().trim())+"'";
			if(db.executeSql(sql)&&db.executeSql(sqll))//	
			 JOptionPane.showMessageDialog(null,"成功退房");
			 
	
		
			}}
		});
		jb2.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
				String endtime;
					String s=jt.getText().trim();
                  	String regex = "^\\d+$";
	               Pattern p=Pattern.compile(regex);
	               Matcher m=p.matcher(s);
	                boolean flage=m.find();
	               if(flage == false )
                        {
                       JOptionPane.showMessageDialog(null,"只能输入数字");
                         return  ;
                          }

				if(jt.getText().trim().equals("")){
               JOptionPane.showMessageDialog(null,"房间号码不能为空！");
	           return;}
	  			if(Double.valueOf(jt.getText().trim())>50||Double.valueOf(jt.getText().trim())<1){
               JOptionPane.showMessageDialog(null,"没有此房间号的房间");
	             return;}
				
		
			try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection con=DriverManager.getConnection("jdbc:odbc:kehudata","","");
			Statement stmt=con.createStatement();
			ResultSet rs=stmt.executeQuery("select * from people where room_num='"+Integer.parseInt(jt.getText().trim())+"'");
			if(rs.next()){
		 text.append("\t"+"\t"+"房间号码："+(this_room_num=rs.getString("room_num"))+"\n");
		 text.append("\t"+"\t"+"客人姓名："+rs.getString("people_name")+"\n");
		 text.append("\t"+"\t"+"客人数量："+rs.getString("people_num")+"\n");
		 text.append("\t"+"\t"+"需要住的天数："+rs.getString("this_days")+"\n");
		 text.append("\t"+"\t"+"需付的钱："+(this_money=rs.getString("this_money"))+"\n");
		 text.append("\t"+"\t"+"入住的时间："+(endtime=rs.getString("this_time"))+"\n");
	
		 
		 
        }
      
        
		 else JOptionPane.showMessageDialog(null,"此房间空着");
		 flag=true;
			rs.close();
			stmt.close();
			con.close();
		}catch(Exception q){q.printStackTrace();
		}
			
			}
		});
		jb4.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
	 jt.setText("");
	 text.setText("");
	 return;
		
			}
		});
    	
    }
	class WinLis extends WindowAdapter
	{
		public void windowClosing(WindowEvent e)
		{
			exit();
		}
	}
	
	
	
	

/*
	
	public static void main(String[] args){
		new kehu_exit();
	}*/
}