new_login.java

JAVA开发的酒店管理系统

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

public class new_login extends JFrame{
	JLabel room_num,people_name,people_num,days,money,time,room_type;
	JTextField jtroom_num,jtpeople_name,jtpeople_num,jtdays,jtmoney;
	JButton clear,add,cancel;
	JComboBox jroom_type=new JComboBox();//房间类型
	Integer all_money=0;
	private db_manager db= new db_manager();

private void make_GUI(){
	jroom_type.addItem("");
	jroom_type.addItem("普通单/100");jroom_type.addItem("普通双/150");
	jroom_type.addItem("单人标/150");jroom_type.addItem("双人标/200");
	jroom_type.addItem("夜间房/70");
	room_num=new JLabel("房间号码",JLabel.RIGHT);
	people_name=new JLabel("客户姓名",JLabel.RIGHT);
	people_num=new JLabel("客户人数",JLabel.RIGHT);
	days=new JLabel("需住天数",JLabel.RIGHT);
	room_type=new JLabel("房间类型",JLabel.RIGHT);
	money=new JLabel("需付费用",JLabel.RIGHT);
	
	jtroom_num = new JTextField(10);
	jtpeople_name= new JTextField(10);
	jtpeople_num= new JTextField(10);
	jtdays= new JTextField(10);
	jtmoney= new JTextField(10);
	jtmoney.setEditable(false);

		
	clear = new JButton("清空");
	add = new JButton("添加");
	cancel = new JButton("取消");
	
	Container cp=getContentPane();
	JPanel jp1=new JPanel();
	JPanel jp2=new JPanel();
   jp1.setLayout(new GridLayout(8,10,20,15));
   jp2.setLayout(new FlowLayout());
   
   jp1.add(room_num); jp1.add(jtroom_num);
   jp1.add(people_name);jp1.add(jtpeople_name);
   jp1.add(people_num);jp1.add(jtpeople_num);
   jp1.add(days);jp1.add(jtdays);
   jp1.add(room_type);jp1.add(jroom_type);
   jp1.add(money); jp1.add(jtmoney);
   jp2.add(clear);
   jp2.add(add);
   jp2.add(cancel);
   
  cp.add(jp1,BorderLayout.CENTER);
		cp.add(new JLabel("                "),BorderLayout.EAST);
		cp.add(jp2,BorderLayout.SOUTH);
		
}

private void new_login_action(){
	jroom_type.addActionListener(new ActionListener(){
      	public void actionPerformed(ActionEvent e){
      		
      		if(jtdays.getText().toString().trim().equals("")){JOptionPane.showMessageDialog(null,"请先输入住宿天数");
            return ;
      	         }
      	     
      	   String ssday=jtdays.getText().trim();
	    String regexdays = "^\\d+$";
    	Pattern pdays=Pattern.compile(regexdays);
	   Matcher mday=pdays.matcher(ssday);
	  boolean flagedays=mday.find();
	  if(flagedays == false )
        {
            JOptionPane.showMessageDialog(null,"住宿天数只能是数字");
            return  ;
        
      	       	
      	       	
      	       	
      	       	}  
      		 else {
      		 	
      	
      		 if(jroom_type.getSelectedItem().toString().trim().equals("普通单/100")) {

	       all_money=(Integer.parseInt(jtdays.getText().trim()))*100;
	       jtmoney.setText(all_money.toString());
		      }
		     if(jroom_type.getSelectedItem().toString().trim().equals("普通双/150")) {

	       all_money=(Integer.parseInt(jtdays.getText().trim()))*150;
	       jtmoney.setText(all_money.toString());
		      }
		      
		    if(jroom_type.getSelectedItem().toString().trim().equals("单人标/150")) {

	       all_money=(Integer.parseInt(jtdays.getText().trim()))*150;
	       jtmoney.setText(all_money.toString());
		      }
		    if(jroom_type.getSelectedItem().toString().trim().equals("双人标/200")) {

	       all_money=(Integer.parseInt(jtdays.getText().trim()))*200;
	       jtmoney.setText(all_money.toString());
		      }  
		      
		     if(jroom_type.getSelectedItem().toString().trim().equals("夜间房/70")) {

	       all_money=(Integer.parseInt(jtdays.getText().trim()))*70;
	       jtmoney.setText(all_money.toString());
		      }    
		      
		      
			 }
      		 
		
		
			
      	}
      });
	
	
	
	
clear.addActionListener(new ActionListener(){
	public void actionPerformed(ActionEvent e){
	jtroom_num.setText("");	
	jtpeople_name.setText("");
	jtpeople_num.setText("");
	jtdays.setText("");
	jtmoney.setText("");	
	}
});

add.addActionListener(new ActionListener(){
	public void actionPerformed(ActionEvent e){
	String sql;
	if(jtroom_num.getText().trim().equals("")){
       JOptionPane.showMessageDialog(null,"房间号码不能为空！");
	  return;
		}
        String s=jtroom_num.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(jtroom_num.getText().trim())>50||Double.valueOf(jtroom_num.getText().trim())<1){
       JOptionPane.showMessageDialog(null,"没有此房间号");
	  return;
		}
	if(jtpeople_name.getText().trim().equals("")){
	  JOptionPane.showMessageDialog(null,"客户姓名不能为空！");
	  return;
	}
	if(jtpeople_num.getText().trim().equals("")){
      JOptionPane.showMessageDialog(null,"客户人数不能为空！");
	  return;
		}
	String spnum=jtpeople_num.getText().trim();
	    String pregex = "^\\d+$";
    	Pattern pp=Pattern.compile(pregex);
	   Matcher mm=pp.matcher(spnum);
	  boolean fflage=mm.find();
	  if(fflage == false )
        {
            JOptionPane.showMessageDialog(null,"客户人数只能是数字");
            return  ;
        }	
		if(jtdays.getText().trim().equals("")){
     JOptionPane.showMessageDialog(null,"住宿天数不能为空！");
	  return;	}
	   String sday=jtdays.getText().trim();
	    String regexday = "^\\d+$";
    	Pattern pday=Pattern.compile(regexday);
	   Matcher mday=pday.matcher(sday);
	  boolean flageday=mday.find();
	  if(flageday == false )
        {
            JOptionPane.showMessageDialog(null,"住宿天数只能是数字");
            return  ;
        } 
	  
	  
	  if(jroom_type.getSelectedItem().toString().trim().equals("")){
     JOptionPane.showMessageDialog(null,"房间类型不能为空！");
	  return;	}
	if(jtmoney.getText().trim().equals("")){
     JOptionPane.showMessageDialog(null,"所需付钱不能为空！");
	  return;         
		}
      
      
  
      

		
	 
	    String sqll;
		sqll="insert into history(room_num,people_name,people_num,this_days,room_type,this_money) values ('";
	
		sqll+=Integer.parseInt(jtroom_num.getText().trim())+"','";
	   sqll+=jtpeople_name.getText().trim()+"','";
	   sqll+=jtpeople_num.getText().trim()+"','";
		sqll+=jtdays.getText().trim()+"','";
		sqll+=jroom_type.getSelectedItem().toString().trim()+"','";
		sqll+=jtmoney.getText().trim()+"')";

        
		
		
		
	    sql="insert into people(room_num,people_name,people_num,this_days,room_type,this_money) values   ('"; 
		sql=sql+Integer.parseInt(jtroom_num.getText().trim())+"','";
		sql=sql+jtpeople_name.getText().trim()+"','";
		sql=sql+jtpeople_num.getText().trim()+"','";
		sql=sql+jtdays.getText().trim()+"','";
		sql=sql+jroom_type.getSelectedItem().toString().trim()+"','";
		sql=sql+jtmoney.getText().trim()+"')";	
		if(db.executeSql(sql)&&db.executeSql(sqll)){//
	
		JOptionPane.showMessageDialog(null,"登记成功！");	}
		else{
	
		JOptionPane.showMessageDialog(null,"登记失败"+"\n"+"此房间已经满了"+"\n"+"请查询后重新登记");return;	}
		
	}	
});
cancel.addActionListener(new ActionListener(){
	public void actionPerformed(ActionEvent e){
	exit();	
	}
});

}
   public void exit(){
		this.dispose();
            }
	
   new_login(){
	super("新客户登记");
	make_GUI();
	new_login_action();
	addWindowListener(new WinLis());
}	
    class WinLis extends WindowAdapter
{
	 public void windowClosing(WindowEvent e)
	 {
	        exit();
	               	}
                   }
		
	/*
public static void main(String[] args){
    new_login addnew=new new_login();
    addnew.setBounds(200,120,400,350);
     addnew.validate();
     addnew.setVisible(true);
	}*/
}