voidroom.java

完成课程设计

package 客房管理;

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

public class VoidRoom extends JFrame implements ActionListener
{
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	Object a[][];
	Object colname[]={"类别","编号"};
	JTable table;
	JButton bBack,bSearch;
	Container container;
	JPanel panel;
	
	public VoidRoom()
	{
		super("查空房");
		a=new Object[20][2];
		table=new JTable(a,colname);
		setSize(50,50);
		
		bBack=new JButton("返回");
		bBack.addActionListener(this);
		bSearch=new JButton("查找");
		bSearch.addActionListener(this);
		
		panel=new JPanel();
		panel.add(bBack);
		panel.add(bSearch);
		
		container=getContentPane();
		container.add(panel,BorderLayout.SOUTH);
		container.add(new JScrollPane(table),BorderLayout.CENTER);
		setBounds(380,200,500,400);
		setVisible(true);
	}
	public void actionPerformed(ActionEvent ae)
	{
		if(ae.getSource()==bBack)
		{
			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 客房类别.类别=客房编号.类别 where 编号 not in " +
						"(select distinct 编号 from 客房编号 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 VoidRoom();
	}*/

}