orderchangeregisterclick.java

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

import java.awt.Dimension;
import java.awt.HeadlessException;
import java.awt.TextField;
import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import java.sql.SQLException;

import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JTextField;


public class OrderChangeRegisterClick extends DBAccess implements ActionListener{
	static  JFrame fm;
	static JLabel user;
	static JTextField usertype;
	static	JLabel pwd;
	static	 TextField password;
	static	JButton ok,cancel;
	OrderChangeRegisterClick(){
		super();
	}	
	public  void  show(){		
		fm  = new JFrame("预定转入住");
		fm.setSize(300, 180);
		fm.setLayout(null);
		fm.setAlwaysOnTop(true);
		fm.setResizable(false);		 
		user=new JLabel("请输入旅客姓名:");
		user.setBounds(40, 15, 100, 32);
		usertype=new JTextField(10);
		usertype.setBounds(150, 17, 70, 25);
		fm.add(user);fm.add(usertype);			 
		pwd=new JLabel("请输入您预定的房号:");
		pwd.setBounds(10, 40, 130, 47);
		password=new TextField(10);
		password.setBounds(150, 50, 70, 25);
		fm.add(pwd);
		fm.add(password);			 
		ok=new JButton("转入");
		cancel=new JButton("取消");			 
		ok.setBounds(50, 90, 70, 30);
		cancel.setBounds(155, 90, 70, 30);
		fm.add(cancel);
		fm.add(ok);
		fm.addWindowListener(new WindowAdapter(){
			public void windowClosing(WindowEvent e){
				fm.dispose();
			}			
		});
		cancel.addActionListener(new ActionListener(){		
			public void actionPerformed(ActionEvent arg0) {
				fm.dispose();				
			}			
		});
		ok.addActionListener(new ActionListener(){

			public void actionPerformed(ActionEvent arg0) {
				String name=usertype.getText().trim().toString();
				String roomnum=password.getText().trim().toString();
				try {
					String status=getValue("select * from Room where RoomNum='"+roomnum+"'","Status");
					System.out.println(status);
					if(status.trim().equalsIgnoreCase("预定"))
					{
						String status1=getValue("select * from Customer where 登记房号='"+roomnum+"'","姓名");
						System.out.println("in");
						if(status1.trim().equalsIgnoreCase(name))
						{						
							st.executeUpdate("update Customer set 入住时间=getdate()  where 姓名='"+name+"'");
							st.executeUpdate("update Customer set 用户状态='入住'  where 姓名='"+name+"'");
							st.executeUpdate("update Room set Status='有客'  where RoomNum='"+roomnum+"'");
							javax.swing.JOptionPane.showMessageDialog(fm, "旅客 "+name+",您已经正式入住"+roomnum+"号房间。欢迎您入住本店！！");
							fm.dispose();
						}
						else
						{							
							JOptionPane.showMessageDialog(fm, "您没有预定该房间");
							fm.dispose();
						}					
					}
					else
					{
						System.out.println("else");
						JOptionPane.showMessageDialog(fm, "您没有预定该房间");
						fm.dispose();
					}
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}			
		});
		 Dimension screen = Toolkit.getDefaultToolkit().getScreenSize(); 
			fm.setLocation( 
				(screen.width - fm.getWidth()) / 2, 
				(screen.height - fm.getHeight()) / 2);
		fm.setVisible(true);
	}
	public void actionPerformed(ActionEvent arg0) {
		show();
		
	}
}