updateinfo.java

学生学籍管理系统

package E4;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.util.Vector;
import java.io.File;
import java.io.*;
import java.util.StringTokenizer;
import java.sql.*;

 //修改用户信息
class updateInfo implements ActionListener,TextListener,ItemListener{

    JDialog jda;
    JPanel pnl;
    int t_Age[]=new int[20];
    Object a[]=new Object[8];
    Choice choice;
    Choice classes;
    JRadioButton jrb_male=new JRadioButton("男");
    JRadioButton jrb_female=new JRadioButton("女");    
    ButtonGroup sex= new ButtonGroup();
    TextField name,homeAddress,telNum;
    JButton btn_register,btn_back;
    
   	JPasswordField newPasswordField =new JPasswordField();//新密码
	JPasswordField confirmNewPasswordField =new JPasswordField();//确认新密码
    
    String cId="",cName="",cSex="",cClass="",cAddtress="",cphoneNum="",cPassWord="";
    int cAge;//连上数据库时，将数据库中的值赋给他们
    proceeSQL psql=new proceeSQL();
    
    
   updateInfo(JFrame f,String s,boolean b)
   {
   	  	
   	jda=new JDialog(f,s,b); 
    jda.setSize(320,330); 
    jda.setLocation(350,240); 
       
     jda.addWindowListener(new WindowAdapter()
      {public void windowClosing(WindowEvent e)
       {
          jda.setVisible(false);
       }});
       
             for(int i=10;i<30;i++)
       t_Age[i-10]=i;
       
     pnl=new JPanel();
     choice = new Choice();
     classes = new Choice();
     
     for(int i=0;i<4;i++)
     {
     	classes.addItem("计科"+(i+1)+"班");
     }
     
     for(int i=0;i<20;i++)
         choice.addItem(String.valueOf(t_Age[i])); 

     name=new TextField("",8);
     homeAddress=new TextField("",8);
     telNum=new TextField("",8);
     btn_register=new JButton("确认修改");
     btn_back=new JButton("返回"); 
     pnl=new JPanel();


     sex.add(jrb_male);
     sex.add(jrb_female);
     pnl.add(jrb_male);
     pnl.add(jrb_female);
     
     jrb_male.addItemListener(this);
     jrb_female.addItemListener(this);
     choice.addItemListener(this);
     classes.addItemListener(this);
     name.addTextListener(this);
     homeAddress.addTextListener(this);
     telNum.addTextListener(this);
          
     jda.add(new JLabel("姓名",JLabel.CENTER));
     jda.add(name);
     jda.add(new JLabel("姓别",JLabel.CENTER));
     jda.add(pnl);
     jda.add(new JLabel("班级",JLabel.CENTER));
     jda.add(classes);
     jda.add(new JLabel("年龄",JLabel.CENTER));
     jda.add(choice);
     jda.add(new JLabel("家庭住址",JLabel.CENTER));
     jda.add(homeAddress);
     jda.add(new JLabel("电话号码",JLabel.CENTER)); 
     jda.add(telNum);
     jda.add(new JLabel("创建密码:",JLabel.CENTER));
     jda.add(newPasswordField);
     jda.add(new JLabel("确认密码:",JLabel.CENTER));
     jda.add(confirmNewPasswordField);
     jda.add(btn_register);
     jda.add(btn_back);
     btn_register.addActionListener(this);
     btn_back.addActionListener(this);
     jda.setLayout(new GridLayout(9,2,20,9));
     jda.setResizable(false);
   }
   
   void setDisplay(Boolean tf){
   	jda.setVisible(tf);
   }
   
   //设定学号
   void setID(String ID){
   	this.cId=ID;
   	a[0]=cId;
   	psql.OUTsetValue(a);
   }
   
   public void actionPerformed(ActionEvent e){
   	
   	if(e.getSource()==btn_back){
   		jda.setVisible(false);
   	}
   	
   	else if(e.getSource()==btn_register){
   		
   		if(!String.valueOf(confirmNewPasswordField.getPassword()).equals(String.valueOf(newPasswordField.getPassword())))
   		{
   	            JOptionPane.showMessageDialog(null, "密码不一致！");
    			return;
   		}
   	    
   	    else if(!String.valueOf(confirmNewPasswordField.getPassword()).equals(""))
   	    {
   	    	a[7]=String.valueOf(confirmNewPasswordField.getPassword());
   	    	
   	    }
   	    	 	
   		psql.UpdateStudentDetail(String.valueOf(a[0]),String.valueOf(a[1]),String.valueOf(a[2]),String.valueOf(a[3]),
   		   Integer.parseInt(String.valueOf(a[4])),String.valueOf(a[5]),String.valueOf(a[6]),String.valueOf(a[7]));
      	//psql.UpdatePassWord(cId,cPassWord,1);//如果是数据库实验的话要设表的约束
      	JOptionPane.showMessageDialog(null, "操作成功!");
 		  		
   	}
   	
   	}
   	
    void setValue(String id,String name,String sex,String Class,int age,String addtress,String phoneNum)
    {
    	cId=id;cName=name;cSex=sex;cClass=Class;cAge=age;cAddtress=addtress;cphoneNum=phoneNum;
    }
    
        public void textValueChanged(TextEvent e){
    	
        if(e.getSource()==name){
        	if(!name.getText().equals(""))      	
    		   a[1] = name.getText();
    	}
    	
        else if(e.getSource()==homeAddress){
        	if(!homeAddress.getText().equals(""))
        	a[5]=homeAddress.getText();
        }
        
        else if(e.getSource()==telNum){
        	if(!telNum.getText().equals(""))
        	a[6]=telNum.getText();
        } 
        
	
	 }
	 
	 public void itemStateChanged(ItemEvent e){
   	 	if(e.getItemSelectable()==jrb_male){
   	         a[2]="男";
   	 	}
   	 	
   	 	else if(e.getItemSelectable()==jrb_female){
   	 		a[2]="女";
   	 	}
   	 	
   	 	else if(e.getItemSelectable()==choice){
   	 		a[4] = Integer.parseInt(choice.getSelectedItem());
   	 	}
   	 	
   	 	else if(e.getItemSelectable()==classes){
   	        a[3] = classes.getSelectedItem();
   	 	
   	 		
   	 	}
   	 }
}