registerhotelclick.java

这是我我完成的java的课程设计,是一个宾馆管理系统

import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.GridLayout;
import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.beans.PropertyVetoException;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JDesktopPane;
import javax.swing.JFrame;
import javax.swing.JInternalFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JTextField;
import javax.swing.event.AncestorEvent;
import javax.swing.event.AncestorListener;

public class RegisterHotelClick extends DBAccess implements ActionListener{
		JFrame fm=new JFrame("登记预定");
		JPanel p1=new JPanel();
		JLabel lb1;
		JLabel lb2;
		JLabel lb3;JComboBox cb2,cb1;
		JLabel lb4;JTextField tf2,tf1;
		JLabel lb5;JTextField tf3;
		JLabel lb6;JTextField tf4;
		JLabel lb7;JTextField tf5;
		JLabel lb8;JTextField tf6;
		JLabel lb9;JTextField tf7;
		JLabel lb10;JTextField tf8;
		RegisterHotelClick() {
			super();
		}
		private void Run(){	
			p1.removeAll();
			Dimension screen = Toolkit.getDefaultToolkit().getScreenSize(); 
			fm.setSize(300, 450);
			fm.setLocation( 
				(screen.width - fm.getWidth()) / 2, 
				(screen.height - fm.getHeight()) / 2);
			fm.setVisible(true);
			p1.setLayout(null);
			String date[]={"预定客房","登记入住"};
			 lb1=new JLabel("请选择服务:");	 cb1=new JComboBox(date);
			 lb2=new JLabel("姓名:"); tf1=new JTextField();
			String date２[]={"男","女"};
			 lb3=new JLabel("性别:"); cb2=new JComboBox(date２);
			 lb4=new JLabel("年龄:"); tf2=new JTextField();
			 lb5=new JLabel("生日:"); tf3=new JTextField();
			 lb6=new JLabel("藉贯:"); tf4=new JTextField();
			 lb7=new JLabel("工作单位:"); tf5=new JTextField();
			 lb8=new JLabel("联系电话:"); tf6=new JTextField();
			 lb9=new JLabel("身份证号码:"); tf7=new JTextField();
			 lb10=new JLabel("登记房号:"); tf8=new JTextField();
			lb1.setBounds(30, 20, 80, 20);
			cb1.setBounds(125, 20, 80, 20);
			lb2.setBounds(70, 50, 40, 20);
			tf1.setBounds(125, 50, 80, 20);
			lb3.setBounds(70,80,40,20);
			cb2.setBounds(125, 80, 40, 20);
			lb4.setBounds(70, 110, 40, 20);
			tf2.setBounds(125, 110, 40, 20);
			lb5.setBounds(70, 140, 40, 20);
			tf3.setBounds(125, 140, 80, 20);
			lb6.setBounds(70, 170, 40, 20);
			tf4.setBounds(125, 170, 120, 20);
			lb7.setBounds(40, 200, 80, 20);
			tf5.setBounds(125, 200, 120, 20);
			
			lb8.setBounds(40, 230, 80, 20);
			tf6.setBounds(125, 230, 80, 20);
			lb9.setBounds(30, 260, 80, 20);
			tf7.setBounds(125, 260, 120, 20);
			lb10.setBounds(40, 290, 80, 20);
			tf8.setBounds(125, 290, 40, 20);
			JButton bt1=new JButton("确定操作");
			JButton bt2=new JButton("取消操作");
			bt1.setBounds(40, 350, 100, 30);
			bt2.setBounds(150, 350, 100, 30);
			p1.add(lb1);p1.add(cb1);
			p1.add(lb2);p1.add(tf1);
			p1.add(lb3);p1.add(cb2);
			p1.add(lb4);p1.add(tf2);
			p1.add(lb5);p1.add(tf3);
			p1.add(lb6);p1.add(tf4);
			p1.add(lb7);p1.add(tf5);
			p1.add(lb8);p1.add(tf6);
			p1.add(lb9);p1.add(tf7);
			p1.add(lb10);p1.add(tf8);
			p1.add(bt1);
			p1.add(bt2);
			bt1.addActionListener(new ActionListener(){
				public void actionPerformed(ActionEvent arg0) {
					try {
						setValue();
					} catch (SQLException e) {
						// TODO Auto-generated catch block
						e.printStackTrace();
					}
				}				
			});
			
			bt2.addActionListener(new ActionListener(){

				public void actionPerformed(ActionEvent arg0) {
					fm.dispose();				
				}				
			});
			fm.add(p1);
		}
		public void actionPerformed(ActionEvent arg0) {
			Run();	
			fm.setVisible(true);
		}
		public void setValue() throws SQLException{
			String sql=null;
			String strAge=null;
			if(tf1.getText().trim().equalsIgnoreCase(""))			
			{
				javax.swing.JOptionPane.showMessageDialog(fm, "姓名不能为空");return;
			}
				
	
			if(tf7.getText().trim().equalsIgnoreCase("")){
				javax.swing.JOptionPane.showMessageDialog(fm, "身份证号码不能为空");return;
			}
			
			if(tf8.getText().trim().equalsIgnoreCase("")){
				javax.swing.JOptionPane.showMessageDialog(fm, "房间号码不能为空");return;
			}
								
			if(cb1.getSelectedIndex()==0){   //处理预定客房
				if(getValue("select * from Room where RoomNum='"+tf8.getText().trim()+"'","Status").trim().equals("预定") 
						|| getValue("select * from Room where RoomNum='"+tf8.getText().trim()+"'","Status").trim().equals("有客")){
					javax.swing.JOptionPane.showMessageDialog(fm, "该客房已经入住，请选择其他客房");
					return ;
				}	
				sql="insert into Customer(姓名,性别,年龄,生日,藉贯,工作单位,联系电话,身份证号码,登记房号,用户状态)" +
						"values('";
				if(cb2.getSelectedIndex()==0)
					strAge="男";
				else
					strAge="女";
				sql=sql+tf1.getText().trim()+"','"+strAge+"','"+tf2.getText().trim()+"','"+tf3.getText().trim()+"','" +
					tf4.getText().toString()+"','"+tf5.getText().trim()+"','"+tf6.getText().trim()+"','"+tf7.getText().trim()+"','"+tf8.getText().trim()+"','预定')";
				st.executeUpdate(sql);
				st.executeUpdate("update Customer set 预定时间=getdate()  where 姓名='"+tf1.getText().trim()+"'");
				st.executeUpdate("update Room set Status='预定'  where RoomNum='"+tf8.getText().trim()+"'");
				javax.swing.JOptionPane.showMessageDialog(fm, "旅客 "+tf1.getText().trim()+",您已经预定"+tf8.getText().trim()+"号房间。欢迎您入住本店！！");
				fm.dispose();
			}		
			
			
			if(cb1.getSelectedIndex()==1){   //处理登记入住
				if(getValue("select * from Room where RoomNum='"+tf8.getText().trim()+"'","Status").trim().equals("预定") 
						|| getValue("select * from Room where RoomNum='"+tf8.getText().trim()+"'","Status").trim().equals("有客")){
					javax.swing.JOptionPane.showMessageDialog(fm, "该客房已经入住，请选择其他客房");
					return ;
				}
				
				sql="insert into Customer(姓名,性别,年龄,生日,藉贯,工作单位,联系电话,身份证号码,登记房号,用户状态)" +
						"values('";
				if(cb2.getSelectedIndex()==0)
					strAge="男";
				else
					strAge="女";
				sql=sql+tf1.getText().trim()+"','"+strAge+"','"+tf2.getText().trim()+"','"+tf3.getText().trim()+"','" +
					tf4.getText().toString()+"','"+tf5.getText().trim()+"','"+tf6.getText().trim()+"','"+tf7.getText().trim()+"','"+tf8.getText().trim()+"','入住')";
				st.executeUpdate(sql);
				st.executeUpdate("update Customer set 入住时间=getdate()  where 姓名='"+tf1.getText().trim()+"'");
				st.executeUpdate("update Room set Status='有客'  where RoomNum='"+tf8.getText().trim()+"'");
				javax.swing.JOptionPane.showMessageDialog(fm, "旅客 "+tf1.getText().trim()+",您已经登记入住"+tf8.getText().trim()+"号房间。欢迎您入住本店！！");
				fm.dispose();
			}				
		}
}