fullroom.java

完成课程设计

package 客房管理;

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

public class FullRoom extends JFrame implements ActionListener
{
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	//定义
	Object a[] [];
	Object conlname[]={"类别","房号"};
	JTable table;
	JButton bReturn,bSearch;
	Container container;
	JProgressBar pbar;
	JPanel panel1;
	
	public FullRoom()
	{
		//表格属性
		super("查已住或已定房");
		a=new Object[20][2];
		table=new JTable(a,conlname);
		setSize(50,50);
		//按钮添加
		bReturn=new JButton("返回");
		bReturn.addActionListener(this);
		bSearch=new JButton("查找");
		bSearch.addActionListener(this);
		
		panel1=new JPanel();
		panel1.add(bReturn);
		panel1.add(bSearch);
		
		//窗体布局
		container=getContentPane();
		container.add(panel1,BorderLayout.SOUTH);
		container.add(new JScrollPane(table),BorderLayout.CENTER);
		setBounds(400,200,500,400);
		setVisible(true);
	}
	
	//按钮事件
	public void actionPerformed(ActionEvent ae)
	{
		//返回按钮
		if(ae.getSource()==bReturn)
		{
			dispose();
		}
		//查找按钮
		else if(ae.getSource()==bSearch)
		{
			Connection conn;
			Statement stat;
			ResultSet rs;
			try
			{
				int i=0;
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				conn=DriverManager.getConnection("jdbc:odbc:客房管理","sa","");
				stat=conn.createStatement();
				rs=stat.executeQuery("select distinct 名称,编号 from 客房编号 join 客人信息 on 编号=客人信息.客房编号 join 客房类别 on 客房类别.类别=客房编号.类别 " +
						"where 编号=客人信息.客房编号 and 离店时间 is null");
				while(rs.next())
				{
					a[i][0]=rs.getString("名称");
					a[i][1]=rs.getString("编号");
					i++;
					this.setVisible(false);
					this.setVisible(true);
				}
			}
			catch(Exception e)
			{
				JOptionPane.showMessageDialog(null,"连接失败!","提示",JOptionPane.ERROR_MESSAGE);
			}
			
		}
	}
	
	/*public static void main(String[] args) 
	{
			new FullRoom();
	}*/

}