studentsituation.java

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

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

public class StudentSituation extends JPanel implements ActionListener
{ 
                            
  JTextField 学号,姓名,专业,年级,出生;                 
  JRadioButton 男,女;
 // Student 学生;
  ButtonGroup group=null;
  JButton 录入,重置;

                                        
  public StudentSituation()
  {
	 
  
   学号=new JTextField(10);
   姓名=new JTextField(10);
   专业=new JTextField(10);
   年级=new JTextField(10);
   出生=new JTextField(10);
   group=new ButtonGroup();
   男=new JRadioButton("男",true);
   女=new JRadioButton("女",false);
   group.add(男);
   group.add(女);
   录入=new JButton("录入");
   重置=new JButton("重置");
   录入.addActionListener(this);
   重置.addActionListener(this);
   Box box1=Box.createHorizontalBox();              
   box1.add(new JLabel("学号:",JLabel.CENTER));
   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);
   setLayout(new BorderLayout());
   add(pCenter,BorderLayout.CENTER);
   JPanel pSouth=new JPanel();
   pSouth.add(录入);
   pSouth.add(重置);
   add(pSouth,BorderLayout.SOUTH);
   validate();
  }
 public void actionPerformed(ActionEvent e)
  {  
	 
	 if(e.getSource()==录入)
      {
        String number="";
        number=学号.getText().trim();
        
         if(number.length()>0)
            
         {   String nu="";    //System.out.print("sql");
        	 Connection con;
             Statement sql; 
              ResultSet rs;
        	 try{  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
     	     catch(ClassNotFoundException e2)
	           {System.out.print("找不到驱动");}
     	   // System.out.print("sql");
        	 try {  con=DriverManager.getConnection("jdbc:odbc:sun","","");
                   sql=con.createStatement();
                  // System.out.print(sql);
            	 rs=sql.executeQuery("SELECT 学号 FROM student");
            	 
            	 while(rs.next())
            	 {  
            	  nu=rs.getString("学号");
                //System.out.print(number);
                if(nu.equals(number))
                    break;	
                else if(number==null)
                	break;}
              if(nu.equals(number))//基本信息表.containsKey(number))          
                 {
                   String warning="该生基本信息已存在,请到修改页面修改!";
                    
                   JOptionPane.showMessageDialog(this,warning,"警告",JOptionPane.WARNING_MESSAGE);
                 }
              else
                 {  
                   String m="基本信息将被录入!";
                   int ok=JOptionPane.showConfirmDialog(this,m,"确认",JOptionPane.YES_NO_OPTION,
                                                 JOptionPane.INFORMATION_MESSAGE);
                  if(ok==JOptionPane.YES_OPTION)
                    {
                     String name=姓名.getText().trim();
                     String discipling=专业.getText();
                     String grade=年级.getText();
                     String borth=出生.getText();
                     String sex=null;
                        if(男.isSelected())
                           { sex=男.getText(); }
                        else
                           { sex=女.getText(); }

                     try{
                        if(姓名.getText().trim()!="")
                        { String s1="'"+number+"','"+name+"','"+sex+"','"+discipling+"','"+grade+"','"+borth+"'";    
                         String temp="INSERT INTO student VALUES("+ s1+")";
                    	  
                    	  sql.executeUpdate(temp); 
                           学号.setText(null);
                           姓名.setText(null);                                
                           专业.setText(null);
                           年级.setText(null);
                           出生.setText(null);
                          }
                        else if(姓名.getText().trim()==null) {
                        	 String warning="必须要输入姓名";
                             JOptionPane.showMessageDialog(this,warning,"警告",JOptionPane.WARNING_MESSAGE);
                             }
                        }
                       catch(Exception ee)
                          { 
                           System.out.println(ee);
                          }
                     
                     }
                  
                } 
            	
                 con.close();   }              
            catch(SQLException ee) { System.out.print("wrong");}
          } 
      }
    else if(e.getSource()==重置)
      { 
        学号.setText(null);
        姓名.setText(null);
        专业.setText(null);
        年级.setText(null);
        出生.setText(null);
        
      }
  }
}