searchforname.java

完成课程设计

package 客房管理;

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

public class SearchForName extends JFrame implements ActionListener 
{
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	JRadioButton jrbName,jrbNo;
	ButtonGroup changle;
	JLabel lName;
	JTextField tName;
	JButton bBack,bSearch;
	JPanel panel;
	JTable table;
	Container container;
	Object a[][];
	Object colname[]={"姓名","性别","工作单位","客房号","入住时间"};
	
	public SearchForName()
	{
		super("按名字查");
		a=new Object[3][5];
		table=new JTable(a,colname);
		setSize(50,50);
		setVisible(true);
		
		lName=new JLabel("输入：");
		tName=new JTextField(8);
		
		jrbName=new JRadioButton("按名字查找");
		jrbName.addActionListener(this);
		jrbNo=new JRadioButton("按房号查找");
		jrbNo.addActionListener(this);
		
		bBack=new JButton("返回");
		bBack.addActionListener(this);
		bSearch=new JButton("查找");
		bSearch.addActionListener(this);
		
		changle=new ButtonGroup();
		changle.add(jrbName);
		changle.add(jrbNo);
		
		panel=new JPanel();
		panel.add(lName);
		panel.add(tName);
		panel.add(jrbName);
		panel.add(jrbNo);
		panel.add(bSearch);
		panel.add(bBack);
		
		container=getContentPane();
		container.add(panel,BorderLayout.SOUTH);
		container.add(new JScrollPane(table),BorderLayout.CENTER);
		setBounds(400,200,600,400);
	}
	
	public void actionPerformed(ActionEvent ae)
	{
		if(ae.getSource()==bBack)
		{
			dispose();
		}
		else if(ae.getSource()==bSearch && jrbName.isSelected())
		{
			if(tName.getText().equals(""))
			{
				JOptionPane.showMessageDialog(null,"请输入名字!","提示",JOptionPane.INFORMATION_MESSAGE);
			}
			else
			{
				int i=0;
				Connection conn;
				Statement stat;
				ResultSet rs;
				try
				{
					Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
					conn=DriverManager.getConnection("jdbc:odbc:客房管理","sa","");
					stat=conn.createStatement();
					rs=stat.executeQuery("select 姓名,性别,工作单位,客房编号,入住时间 from 客人信息 " +
							"where 姓名="+"'"+tName.getText()+"'");
					if(rs.next())
					{
						
						a[i][0]=rs.getString("姓名");
						a[i][1]=rs.getString("性别");
						a[i][2]=rs.getString("工作单位");
						a[i][3]=rs.getString("客房编号");
						a[i][4]=rs.getString("入住时间");
						i++;
						this.setVisible(false);
						this.setVisible(true);
					}
					else
						JOptionPane.showMessageDialog(null,"没有此信息!","提示",JOptionPane.ERROR_MESSAGE);
				
				}
				catch(Exception e)
				{
					JOptionPane.showMessageDialog(null,"连接失败!","提示",JOptionPane.ERROR_MESSAGE);
				}
			}
		}
		else if(ae.getSource()==bSearch && jrbNo.isSelected())
		{
			int i=0;
			Connection conn;
			Statement stat;
			ResultSet rs;
			try
			{
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				conn=DriverManager.getConnection("jdbc:odbc:客房管理","sa","");
				stat=conn.createStatement();
				rs=stat.executeQuery("select 姓名,性别,工作单位,客房编号,入住时间 from 客人信息 " +
						"where 客房编号="+"'"+tName.getText()+"'");
				if(rs.next())
				{
					
					a[i][0]=rs.getString("姓名");
					a[i][1]=rs.getString("性别");
					a[i][2]=rs.getString("工作单位");
					a[i][3]=rs.getString("客房编号");
					a[i][4]=rs.getString("入住时间");
					i++;
					this.setVisible(false);
					this.setVisible(true);
				}
				else
					JOptionPane.showMessageDialog(null,"没有此信息!","提示",JOptionPane.ERROR_MESSAGE);
			
			}
			catch(Exception e)
			{
				JOptionPane.showMessageDialog(null,"连接失败!","提示",JOptionPane.ERROR_MESSAGE);
			}
		}
		
	}
	/*public static void main(String[] args) 
	{
			new SearchForName();
	}*/

}