sercher.java

管理学生信息

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.util.*;
import java.sql.*;
class Sercher extends JFrame implements ActionListener//查询窗口
{
	//TextArea xianshi;
	TextField number;
	JButton ok,cancel;
	JRadioButton x,y,sn,kn,so,ko;//x表示模糊查询,y表示精确查询
	//sn表示按学生名查询,kn表示按课程名查询,so表示按学号查询,ko表示按课程号查询
	Sercher(){
		super("查询窗口");
		setSize(700,500);
		setVisible(true);
		setLayout(new GridLayout(5,1));
		
		JPanel p[]=new JPanel[5];
		
		p[0]=new JPanel();add(p[0]);

		p[1]=new JPanel();
		JLabel a=new JLabel("请输入查询内容:");
		number=new TextField(20);
		p[1].add(a);p[1].add(number);
		add(p[1]);

		p[2]=new JPanel();
		Label content=new Label("查询内容");
		ButtonGroup cd=new ButtonGroup();
		sn=new JRadioButton("学生姓名",true);
		so=new JRadioButton("学号");
		kn=new JRadioButton("课程名");
		ko=new JRadioButton("课程号");
		cd.add(sn);cd.add(so);cd.add(kn);cd.add(ko);
		p[2].add(content);p[2].add(sn);p[2].add(so);
		p[2].add(kn);p[2].add(ko);
		add(p[2]);

		p[3]=new JPanel();
		ButtonGroup condition=new ButtonGroup();
		x=new JRadioButton("模糊查询");
		y=new JRadioButton("精确查询",true);
		condition.add(x);
		condition.add(y);
		p[3].add(x);p[3].add(y);
		add(p[3]);

		p[4]=new JPanel();
		ok=new JButton("确定");
		cancel=new JButton("取消");
		p[4].add(cancel);
		p[4].add(ok);
		add(p[4]);

		ok.addActionListener(this);
		cancel.addActionListener(this);
		number.addActionListener(this);

		validate();
		setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
	}
	public void actionPerformed(ActionEvent e)
	{
		int flag=0;
		Display1 dis1;
		Display2 dis2;
		if(e.getSource()==ok||e.getSource()==number)
		{
			Connection con=null;
			Statement sm=null;
			String command=null;
			try{
	//DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver());
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				con=DriverManager.getConnection("jdbc:odbc:student");
			}catch(Exception ex){
			System.out.println(ex.getMessage());
			return;
			}
			ResultSet rs=null;
			try{
				sm=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                                      ResultSet.CONCUR_UPDATABLE);
				String str1=number.getText().trim();
				String str2,str3;
				if (sn.isSelected())
				{
					str3="st";
					str2="sname";
				}
				else
				{
					if(so.isSelected())
					{
						str3="st";
						str2="sno";
					}
					else
					{
						if(ko.isSelected())
						{
							flag=1;
							str3="ch";
							str2="cno";
						}
						else
						{
							flag=1;
							str3="ch";
							str2="cname";
						}
					}
				}
				String str4;
				if(x.isSelected())
					str4="where "+str2+" like "+"'%"+str1+"%'";
				else
					str4="where "+str2+"='"+str1+"'";
				command="select * from "+str3+" "+str4;
				rs=sm.executeQuery(command);
				if(rs.next())
				{
					rs.beforeFirst();
					if(flag==0)
						dis1=new Display1(rs);
					else
						dis2=new Display2(rs);
				}
				else
					JOptionPane.showMessageDialog(this,"查无此人!","warring",JOptionPane.WARNING_MESSAGE);
			}catch(Exception ey){
					JOptionPane.showMessageDialog(this,"请输入查询内容!","warring",JOptionPane.WARNING_MESSAGE);
			}
			try{
				rs.close();
				sm.close();
				con.close();
				dispose();
			}catch(Exception ez){}
			setVisible(true);
		}
		else
		{
			dispose();
			setVisible(false);
		}
	}
}