inquest.java

该源程序是自做的一个简单的学籍管理系统

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.util.*;
import java.sql.*;
public class Inquest extends JDialog implements ActionListener
{ 
                             
  JTextField 学号,姓名,专业,年级,出生;                 
  JRadioButton 男,女;
  JButton 查询;
  ButtonGroup group=null;
                                           
  public Inquest(JFrame f)
  {
   super(f,"查询对话框",false);                           

   学号=new JTextField(10);
   查询=new JButton("查询");
   学号.addActionListener(this);
   查询.addActionListener(this);
   姓名=new JTextField(10);
   姓名.setEditable(false);
   专业=new JTextField(10);
   专业.setEditable(false);
   年级=new JTextField(10);
   年级.setEditable(false);
   出生=new JTextField(10);
   出生.setEditable(false);
   男=new JRadioButton("男",false);
   女=new JRadioButton("女",false);
   group=new ButtonGroup();
   group.add(男);
   group.add(女);
   Box box1=Box.createHorizontalBox();              
   box1.add(new JLabel("输入要查询的学号:",JLabel.CENTER));
   box1.add(学号);
   box1.add(查询);
   Box box2=Box.createHorizontalBox();              
   box2.add(new JLabel("姓名:",JLabel.CENTER));
   box2.add(姓名);
   Box box3=Box.createHorizontalBox();              
   box3.add(new JLabel("性别:",JLabel.CENTER));
   box3.add(男);
   box3.add(女);
   Box box4=Box.createHorizontalBox();              
   box4.add(new JLabel("专业:",JLabel.CENTER));
   box4.add(专业);
   Box box5=Box.createHorizontalBox();              
   box5.add(new JLabel("年级:",JLabel.CENTER));
   box5.add(年级);
   Box box6=Box.createHorizontalBox();              
   box6.add(new JLabel("出生:",JLabel.CENTER));
   box6.add(出生);
   Box boxH=Box.createVerticalBox();              
   boxH.add(box1);
   boxH.add(box2);
   boxH.add(box3);
   boxH.add(box4);
   boxH.add(box5);
   boxH.add(box6);
   boxH.add(Box.createVerticalGlue());          
   JPanel pCenter=new JPanel();
   pCenter.add(boxH);
   Container con=getContentPane();
   con.add(pCenter,BorderLayout.CENTER);
   con.validate();
   setVisible(false);
   setBounds(100,200,360,270);
   addWindowListener(new WindowAdapter()
                    { public void windowClosing(WindowEvent e)
                       {
                         setVisible(false);
      	               }
                    });
  }
 public void actionPerformed(ActionEvent e)
  {    
     姓名.setText(null);
     专业.setText(null);
     年级.setText(null);
     出生.setText(null);
     
    if(e.getSource()==查询||e.getSource()==学号)
      {
         String number="",Grade1="",Disciping1="",Borth1="",Name1="",Sex1="",mu="";
         number=学号.getText();
        
         if(number.length()>0)
            {
        	 Connection con;
             Statement sql; 
             ResultSet rs,rs1;
      	  try{  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
   	      catch(ClassNotFoundException e2)
	              {System.out.print("找不到驱动");}
   	       try { con=DriverManager.getConnection("jdbc:odbc:sun","","");
                 sql=con.createStatement();
                 rs=sql.executeQuery("SELECT * FROM student");
                
          	 while(rs.next())
          	   { 
          	    mu=rs.getString(1);
          	    if(mu.equals(number))
          	     { Name1=rs.getString(2);
   	               Sex1=rs.getString(3);
    	               Disciping1=rs.getString(4);
    	               Grade1=rs.getString(5);
    	               Borth1=rs.getString(6);
          	    	break;
          	    }
          	    else continue;
                 }
              if(mu.equals(number))          
                 { 
                   姓名.setText(Name1);
                   专业.setText(Disciping1);
                   年级.setText(Grade1);
                   出生.setText(Borth1); 
                   if(Sex1.equals("男"))
                      {
                        男.setSelected(true);
                      }
                    else
                      {
                        女.setSelected(true);
                      }
   
                 }
              else
                 { 
                  String warning="该学号不存在!";
                  JOptionPane.showMessageDialog(this,warning,"警告",JOptionPane.WARNING_MESSAGE);
                 }
              con.close();
            }
   	       catch (SQLException e2){}
            }
      }
        else
            { 
              String warning="必须要输入学号!";
              JOptionPane.showMessageDialog(this,warning,"警告",JOptionPane.WARNING_MESSAGE);
            }
     
  }
}