findavalidroomclick.java

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

import java.awt.BorderLayout;
import java.awt.Color;
import java.awt.Component;
import java.awt.Dimension;
import java.awt.FlowLayout;
import java.awt.GridLayout;
import java.awt.LayoutManager;
import java.awt.TextField;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JDesktopPane;
import javax.swing.JDialog;
import javax.swing.JFrame;
import javax.swing.JInternalFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JTextArea;
import javax.swing.event.AncestorEvent;
import javax.swing.event.AncestorListener;

import sun.font.GlyphLayout;

public class FindAvalidRoomClick  extends DBAccess implements ActionListener{
	private	JFrame fm;
	public JPanel p1;
	private JLabel user;
	private JComboBox usertype;
	private JLabel pwd;
	private TextField password;
	private JButton ok,cancel;
	LoginInPage hotel;
	public 	JButton bt501;
	public 	JButton bt502;
	public 	JButton bt503;
	public 	JButton bt504;
	public 	JButton bt505;
	public 	JButton bt506;
	
	public 	JButton bt401;
	public 	JButton bt402;
	public 	JButton bt403;
	public 	JButton bt404;
	public 	JButton bt405;
	public 	JButton bt406;
	
	
	public 	JButton bt301;
	public 	JButton bt302;
	public 	JButton bt303;
	public 	JButton bt304;
	public 	JButton bt305;
	public 	JButton bt306;
	
	public 	JButton bt201;
	public 	JButton bt202;
	public 	JButton bt203;
	public 	JButton bt204;
	public 	JButton bt205;
	public 	JButton bt206;
	
	JComboBox cb1,cb2,cb3;
	public FindAvalidRoomClick (LoginInPage hotel){
		super();
		this.hotel=hotel;		
	}
	public JButton CreateButton(int roomNum) {
		String strStatus = null;
		JButton temp;
		try {
			strStatus = getValue("select * from Room where RoomNum="+roomNum,"Status");
		} catch (SQLException e) {
			e.printStackTrace();
		}
		if(strStatus.trim().equalsIgnoreCase("有客"))
		{
			temp=new JButton(roomNum+"(有客)",new ImageIcon("ICON/FRIEND.gif"));
			temp.setBorderPainted(false);
			temp.setVisible(false);
			return temp;			
		}
		else  if(strStatus.trim().equalsIgnoreCase("空闲"))
		{
			temp=new JButton(roomNum+"(空闲)",new ImageIcon("ICON/I_EXIT.gif"));
			temp.setBorderPainted(false);
			temp.setVisible(false);
			return temp;
		}
		temp=new JButton(roomNum+"(预定)",new ImageIcon("ICON/PHONE.gif"));
		temp.setBorderPainted(false);
		temp.setVisible(false);
		return temp;
	}
	void Run() throws SQLException{
		hotel.disable();
		fm=new JFrame("客房状态表");
		Dimension screen = hotel.getToolkit().getScreenSize(); 
		fm.setSize(920, 400);
		fm.setLocation( 
			(screen.width - fm.getWidth()) / 2, 
			(screen.height - fm.getHeight()) / 2); 
		fm.setLayout(null);
		 p1=new JPanel();		
		p1.setBounds(0, 0, 730, 500);
		p1.setLayout(null);
		{
			bt501=CreateButton(501);
			bt501.setBounds(10, 10, 110, 70);
			bt502=CreateButton(502);
			bt502.setBounds(130, 10, 110, 70);		
			bt503=CreateButton(503);
			bt503.setBounds(250, 10, 110, 70);		
			bt504=CreateButton(504);
			bt504.setBounds(370, 10, 110, 70);		
			bt505=CreateButton(505);
			bt505.setBounds(490, 10, 110, 70);		
			bt506=CreateButton(506);
			bt506.setBounds(610, 10, 110, 70);
			p1.add(bt501);
			p1.add(bt502);
			p1.add(bt503);
			p1.add(bt504);
			p1.add(bt505);
			p1.add(bt506);		
			bt401=CreateButton(401);
			bt401.setBounds(10, 100, 110, 70);		
			bt402=CreateButton(402);
			bt402.setBounds(130, 100, 110, 70);		
			bt403=CreateButton(403);
			bt403.setBounds(250, 100, 110, 70);		
			bt404=CreateButton(404);
			bt404.setBounds(370, 100, 110, 70);		
			bt405=CreateButton(405);
			bt405.setBounds(490, 100, 110, 70);		
			bt406=CreateButton(406);
			bt406.setBounds(610, 100, 110, 70);		
			p1.add(bt401);
			p1.add(bt402);
			p1.add(bt403);
			p1.add(bt404);
			p1.add(bt405);
			p1.add(bt406);		
			bt301=CreateButton(301);
			bt301.setBounds(10, 190, 110, 70);		
			bt302=CreateButton(302);
			bt302.setBounds(130, 190, 110, 70);		
			bt303=CreateButton(303);
			bt303.setBounds(250, 190, 110, 70);		
			bt304=CreateButton(304);
			bt304.setBounds(370, 190, 110, 70);		
			bt305=CreateButton(305);
			bt305.setBounds(490, 190, 110, 70);		
			bt306=CreateButton(306);
			bt306.setBounds(610, 190, 110, 70);		
			p1.add(bt301);
			p1.add(bt302);
			p1.add(bt303);
			p1.add(bt304);
			p1.add(bt305);
			p1.add(bt306);		
			bt201=CreateButton(201);
			bt201.setBounds(10, 280, 110, 70);		
			bt202=CreateButton(202);
			bt202.setBounds(130, 280, 110, 70);		
			bt203=CreateButton(203);
			bt203.setBounds(250, 280, 110, 70);		
			bt204=CreateButton(204);
			bt204.setBounds(370, 280, 110, 70);		
			bt205=CreateButton(205);
			bt205.setBounds(490, 280, 110, 70);		
			bt206=CreateButton(206);
			bt206.setBounds(610, 280, 110, 70);		
			p1.add(bt201);
			p1.add(bt202);
			p1.add(bt203);
			p1.add(bt204);
			p1.add(bt205);
			p1.add(bt206);
		}
		JButton bt1=new JButton("刷新");
		bt1.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent arg0)  {
				fm.dispose();
				hotel.enable();
				try {
					Run();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}			
		});
		JPanel p2=new JPanel();
		p2.setBounds(725, 10, 180, 380);
		p2.setLayout(new BorderLayout());
		fm.add(p2);
		fm.add(p1);
		fm.setResizable(false);
		fm.addWindowListener(new WindowAdapter(){
			public void windowClosing(WindowEvent e){
				hotel.enable();
				fm.setVisible(false);
			}
		});		
		JPanel p21=new JPanel();
		p21.setSize(180,130);
		JTextArea ta=new JTextArea();
		p21.setLayout(new GridLayout(3,2,5,5));
		
		JLabel lb1=new JLabel("请选择楼层：");
		String []data={"全部","二楼","三楼","四楼","五楼"};
		 cb1=new JComboBox(data);
		cb1.addItemListener(new ItemChange(this));
		String []data1={"全部","单间","标间"};
		JLabel lb2=new JLabel("客房类型:");
		 cb2=new JComboBox(data1);
		 cb2.addItemListener(new ItemChange(this));
		JLabel lb3=new JLabel("客房等级:");
		String []data2={"全部","普通","豪华"};
		 cb3=new JComboBox(data2);
		 cb3.addItemListener(new ItemChange(this));
		p21.add(lb1);p21.add(cb1);
		p21.add(lb2);p21.add(cb2);
		p21.add(lb3);p21.add(cb3);
		
		JPanel p22=new JPanel();
		p22.setLayout(new GridLayout(12,1,2,2));//GridLayout(11,1,2,2)
		bt501.addActionListener(new StatusButtonClick(p22,501,fm));
		bt502.addActionListener(new StatusButtonClick(p22,502,fm));
		bt503.addActionListener(new StatusButtonClick(p22,503,fm));
		bt504.addActionListener(new StatusButtonClick(p22,504,fm));
		bt505.addActionListener(new StatusButtonClick(p22,505,fm));
		bt506.addActionListener(new StatusButtonClick(p22,506,fm));
		
		bt401.addActionListener(new StatusButtonClick(p22,401,fm));
		bt402.addActionListener(new StatusButtonClick(p22,402,fm));
		bt403.addActionListener(new StatusButtonClick(p22,403,fm));
		bt404.addActionListener(new StatusButtonClick(p22,404,fm));
		bt405.addActionListener(new StatusButtonClick(p22,405,fm));
		bt406.addActionListener(new StatusButtonClick(p22,406,fm));
		
		bt301.addActionListener(new StatusButtonClick(p22,301,fm));
		bt302.addActionListener(new StatusButtonClick(p22,302,fm));
		bt303.addActionListener(new StatusButtonClick(p22,303,fm));
		bt304.addActionListener(new StatusButtonClick(p22,304,fm));
		bt305.addActionListener(new StatusButtonClick(p22,305,fm));
		bt306.addActionListener(new StatusButtonClick(p22,306,fm));
		
		bt202.addActionListener(new StatusButtonClick(p22,202,fm));
		bt203.addActionListener(new StatusButtonClick(p22,203,fm));
		bt204.addActionListener(new StatusButtonClick(p22,204,fm));
		bt205.addActionListener(new StatusButtonClick(p22,205,fm));
		bt206.addActionListener(new StatusButtonClick(p22,206,fm));
		p2.add(p21,"North");
		p2.add(p22,"Center");
		fm.setVisible(true);
	}
	public void actionPerformed(ActionEvent arg0){
		try {
			Run();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}	
}
class ItemChange extends DBAccess implements ItemListener{
	FindAvalidRoomClick fm;
	public ItemChange(FindAvalidRoomClick fm){
		super();
		this.fm=fm;		
	}
	public void itemStateChanged(ItemEvent arg0) {
		for(int i=0;i<=23;i++)
			fm.p1.getComponent(i).setVisible(false);		
		String cb1Str = null,cb2Str=null,cb3Str = null;
		int cb1index=fm.cb1.getSelectedIndex();
		int cb2index=fm.cb2.getSelectedIndex();
		int cb3index=fm.cb3.getSelectedIndex();	
		switch(cb1index){
		case 0:cb1Str=" in (2,3,4,5)" ;break;
		case 1:cb1Str="=2";break;
		case 2:cb1Str="=3";break;
		case 3:cb1Str="=4";break;
		case 4:cb1Str="=5";break;
		}		
		switch(cb2index){
		case 0:cb2Str=" in('单间','标间')";break;
		case 1:cb2Str="='单间'";break;
		case 2:cb2Str="='标间'";break;
		}
		switch(cb3index){
		case 0:cb3Str=" in('普通','豪华')";break;
		case 1:cb3Str="='普通'";break;
		case 2:cb3Str="='豪华'";break;
		}
		String sql="select RoomNum from Room where Status='空闲' and FlordNum "+cb1Str.trim().toString()+" and Type "+cb2Str+" and Degreed "+cb3Str;
		try {
			getValue(sql,"RoomNum");
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}		
	public  String getValue(String sql,String ziduan) throws SQLException{				
		ResultSet rs=st.executeQuery(sql);
		String btnName = null;
		 while (rs.next())
		   {
		    btnName=rs.getString(ziduan);    
		    int i=Integer.parseInt(btnName);
		    int btnIndex=(5-i/100)*6+(i%100-1);
		    System.out.println(i);
		    fm.p1.getComponent(btnIndex).setVisible(true);
		   }
		return null;	
	}
}