history_search.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 history_search extends JFrame{
	JButton jb,jb2,jb3;
	TextArea text;
	JTextField jt;
	db_manager db=new db_manager();
	ResultSet rs;
String sql;
 history_search(){
		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("清空");
	    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(jb);
		cp.add(jp,BorderLayout.NORTH);
		cp.add(jp2,BorderLayout.CENTER);
		setSize(500,400);
		setVisible(true);
		history_action();	
		addWindowListener(new WinLis());
		validate();
	}
      public void exit(){
		this.dispose();
            }
    private void history_action(){
    	sql="select * from people ";
    	
    	jb.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
		exit();
		
			}
		});
		jb3.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
		text.setText("");
		jt.setText("");
		
			}
		});
		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(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 history where room_num='"+jt.getText().trim()+"'");
			
			while(rs.next()){
		    text.append("\t"+"\t"+"ID："+rs.getString("id")+"\n");
		 text.append("\t"+"\t"+"房间号码："+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"+"需付的钱："+rs.getString("room_type")+"\n");
		 text.append("\t"+"\t"+"需付的钱："+rs.getString("this_money")+"\n");
		 text.append("\t"+"\t"+"入住的时间："+rs.getString("this_time")+"\n");
		 text.append("\n");
		 }
	//	if(rs.next()) JOptionPane.showMessageDialog(null,"此房间空着");
			rs.close();
			stmt.close();
			con.close();
		}catch(Exception q){q.printStackTrace();
		}
			
			}
		});
    	
    }
	class WinLis extends WindowAdapter
	{
		public void windowClosing(WindowEvent e)
		{
			exit();
		}
	}
	
	

/*

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