empty_select.java

JAVA开发的酒店管理系统

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.border.*;
import java.sql.*;
import java.util.regex.*;
public class empty_select extends JFrame{
	JButton jb,jb2,jb3,jb4;
	TextArea text;
	JTextField jt;
	db_manager db=new db_manager();
	ResultSet rs;
String sql;

 empty_select(){
		super("空房查询");
	
		Container cp=getContentPane();
		JLabel lab=new JLabel("房间号码");
		 jt=new JTextField(10);
		 text=new TextArea();
		 text.append("\t"+"\t"+"本店共有50间房间"+"\n");
		 text.append("\t"+"\t"+"具体是1 ~~50 号房间"+"\n");
			 

		 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(jb3);
		jp2.add(jb2);
	    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(){
    	sql="select * from people,room";
    	
    	jb.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
		exit();
		
			}
		});
		jb3.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
	    	jt.setText("");
	    	text.setText("\t"+"\t"+"本店共有50间房间"+"\n");
		   text.append("\t"+"\t"+"具体是1 ~~50 号房间"+"\n");
		
			}
		});
		jb2.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
				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"+rs.getString("room_num")+"\n");
	    	JOptionPane.showMessageDialog(null,"此房间已经满了");
				
	
		 }
		else 
		 JOptionPane.showMessageDialog(null,"此房间空着");
		 
	
			rs.close();
			stmt.close();
			con.close();
		}catch(Exception q){q.printStackTrace();
		}
			
			}
		});
		jb4.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
			text.append("\t"+"以下房间已经满了"+"\n");
			try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection conn=DriverManager.getConnection("jdbc:odbc:kehudata","","");
			Statement stmtt=conn.createStatement();
			ResultSet rss=stmtt.executeQuery("select * from people ");
			
			while (rss.next()){
			
			text.append("\t"+rss.getString("room_num")+"号房间"+"\t"+"\n");
	    	
				
	
		 }
		    rss.close();
			stmtt.close();
			conn.close();
		}catch(Exception q){q.printStackTrace();
		}
			
			}
		});
    	
    }
	class WinLis extends WindowAdapter
	{
		public void windowClosing(WindowEvent e)
		{
			exit();
		}
	}
 
/*

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