customerdetail.java

学籍管理系统:利用JAVA的界面对MS SQL进行操作,实现了学生学籍管理系统基本功能:登陆,录入,查询,删除,修改,内置程序详细讲解.

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 javax.swing.table.*;
import java.sql.*;

 //显示信息
class CustomerDetail extends JPanel implements ActionListener,TextListener,ItemListener
 {      
     
     
    JPanel pnl;
    JPanel forAddCenter = new JPanel();
    JPanel forAddCenter_1 = new JPanel();
    JPanel forAddCenter_2 = new JPanel();
    JPanel forAddSouth = new JPanel();
    Choice choice;
    Choice domBuilding;
    JRadioButton jrb_male=new JRadioButton("男");
    JRadioButton jrb_female=new JRadioButton("女");    
    ButtonGroup sex= new ButtonGroup();
    public String tempId="";//保存学号
    Object StudentDetail[]=new Object[10];
    
    TextField name,id,postNum,domNum,homeAddress,telNum;
    JTextField changeName,changeId,changePostnum,changeDomnum,changeHomeaddress,changeTelnum,changeSex,changeAge,changeDombuilding;
   	JPasswordField newPasswordField =new JPasswordField();//新密码
	JPasswordField confirmNewPasswordField =new JPasswordField();//确认新密码
	
	JButton update = new JButton("修改");
	JButton confirm = new JButton("确认");
	JButton refresh = new JButton("刷新");
	JButton updatePassword=new JButton("修改密码");
	
	JLabel message = new JLabel("用户信息",JLabel.CENTER);
	
	
   proceeSQL psql = new proceeSQL();;  
     
   CustomerDetail(){
   	
   	super.setLayout(new BorderLayout(4,4));
   	choice = new Choice();
       for(int i=10;i<30;i++)
         choice.addItem(""+i);
      
         
     domBuilding = new Choice();
     for(int i=0;i<10;i++)
     domBuilding.addItem(""+(i+1));
          
     name=new TextField("",10);
     id=new TextField("",10);
     postNum=new TextField("",10);
     domNum = new TextField("",10);
     homeAddress=new TextField("",10);
     telNum=new TextField("",10);
     changeName=new JTextField("",10);
     changeId=new JTextField("",10);
     changePostnum=new JTextField("",10);
     changeDomnum=new JTextField("",10);
     changeHomeaddress=new JTextField("",10);
     changeTelnum=new JTextField("",10);
     changeSex=new JTextField("",10);
     changeAge=new JTextField("",10);
     changeDombuilding=new JTextField("",10);
     
     changeName.setEditable(false);
     changeId.setEditable(false);
     changePostnum.setEditable(false);
     changeDomnum.setEditable(false);
     changeHomeaddress.setEditable(false);
     changeTelnum.setEditable(false);
     changeSex.setEditable(false);
     changeAge.setEditable(false);
     changeDombuilding.setEditable(false);
   	

     pnl=new JPanel();
     

     sex.add(jrb_male);
     sex.add(jrb_female);
     pnl.add(jrb_male);
     pnl.add(jrb_female);
     choice.addItemListener(this);
     
     forAddCenter_2.add(new JLabel("姓名",JLabel.CENTER));
     forAddCenter_2.add(name);
     forAddCenter_2.add(new JLabel("姓别",JLabel.CENTER));
     forAddCenter_2.add(pnl);//替换
     forAddCenter_2.add(new JLabel("年龄",JLabel.CENTER));
     forAddCenter_2.add(choice);//替换
     forAddCenter_2.add(new JLabel("寝室楼",JLabel.CENTER));
     forAddCenter_2.add(domBuilding);//替换
     forAddCenter_2.add(new JLabel("房间号",JLabel.CENTER));
     forAddCenter_2.add(domNum);
     forAddCenter_2.add(new JLabel("邮政编码",JLabel.CENTER));
     forAddCenter_2.add(postNum);
     forAddCenter_2.add(new JLabel("家庭住址",JLabel.CENTER));
     forAddCenter_2.add(homeAddress);
     forAddCenter_2.add(new JLabel("电话号码",JLabel.CENTER)); 
     forAddCenter_2.add(telNum);
     forAddCenter_2.add(new JLabel("创建密码:",JLabel.CENTER));
     forAddCenter_2.add(newPasswordField);//隐藏
     forAddCenter_2.add(new JLabel("确认密码:",JLabel.CENTER));
     forAddCenter_2.add(confirmNewPasswordField);//隐藏
     forAddCenter_2.setLayout(new GridLayout(5,4,2,10));
     
     forAddCenter_1.add(new JLabel("帐号",JLabel.CENTER));
     forAddCenter_1.add(changeId);
     forAddCenter_1.add(new JLabel("姓名",JLabel.CENTER));
     forAddCenter_1.add(changeName);
     forAddCenter_1.add(new JLabel("姓别",JLabel.CENTER));
     forAddCenter_1.add(changeSex);//替换
     forAddCenter_1.add(new JLabel("年龄",JLabel.CENTER));
     forAddCenter_1.add(changeAge);//替换
     forAddCenter_1.add(new JLabel("寝室楼",JLabel.CENTER));
     forAddCenter_1.add(changeDombuilding);//替换
     forAddCenter_1.add(new JLabel("房间号",JLabel.CENTER));
     forAddCenter_1.add(changeDomnum);
     forAddCenter_1.add(new JLabel("邮政编码",JLabel.CENTER));
     forAddCenter_1.add(changePostnum);
     forAddCenter_1.add(new JLabel("家庭住址",JLabel.CENTER));
     forAddCenter_1.add(changeHomeaddress);
     forAddCenter_1.add(new JLabel("电话号码",JLabel.CENTER)); 
     forAddCenter_1.add(changeTelnum);
     forAddCenter_1.setLayout(new GridLayout(3,6,2,10));
     
    forAddSouth.setLayout(new FlowLayout(FlowLayout.RIGHT,6,6));
    forAddSouth.add(confirm);
    forAddSouth.add(update);
    forAddSouth.add(refresh);
    forAddSouth.add(updatePassword);
     
     confirm.setEnabled(false);
     
     name.addTextListener(this);
     id.addTextListener(this);
     postNum.addTextListener(this);
     domNum.addTextListener(this);
     homeAddress.addTextListener(this);
     telNum.addTextListener(this);
     choice.addItemListener(this);
     domBuilding.addItemListener(this);
     jrb_male.addItemListener(this);
     jrb_female.addItemListener(this);
         
     refresh.addActionListener(this);
     confirm.addActionListener(this);
     updatePassword.addActionListener(this);
     update.addActionListener(this);
     
     
     forAddCenter.setLayout(new FlowLayout(FlowLayout.LEFT,2,10));
     forAddCenter.add(forAddCenter_1);
     
     super.add(message,BorderLayout.NORTH);
     super.add(forAddCenter);
     super.add(forAddSouth,BorderLayout.SOUTH);
     
   }
   
    public void actionPerformed(ActionEvent e){
  	
   if(e.getSource()==confirm){
   		
    	String newPass=new String(newPasswordField.getPassword());
    	String conPass=new String(confirmNewPasswordField.getPassword());
    	if(!newPass.equals(conPass)){
    			JOptionPane.showMessageDialog(null, "密码不一致！");
    			return;
    	}
    	else if(!newPass.equals(""))
   	    {
   	    		StudentDetail[9]=newPass;
   	    	
   	    }
    	
    	psql.updateStudentDetail(StudentDetail);
    	reFresh();           	 	
    	
   	      }
   	 else if(e.getSource()==update){
   	 	   forAddCenter.setVisible(false);
   	 	   changePanel(true);
   	 	   forAddCenter.setVisible(true);
   	      }
   	      
   	 else if(e.getSource()==refresh){
   	 	  reFresh();
          }
    } 
     void reFresh(){
     	 forAddCenter.setVisible(false);
   	 	 changePanel(false);
   	 	 psql.SearchStudentDetailForCustormer(StudentDetail,tempId);
   	 	 setValueDisplay();
   	 	 forAddCenter.setVisible(true);
     }
     
     public void changePanel(boolean updateInfor){
     	if(updateInfor)
     	{
     		forAddCenter.remove(forAddCenter_1);
     		confirm.setEnabled(true);
     	//	forAddCenter_1.setVisible(false);
     	    forAddCenter.add(forAddCenter_2);
     	}
     	else {
     		forAddCenter.remove(forAddCenter_2);
     		confirm.setEnabled(false);
     	//	forAddCenter_1.setVisible(false);
     	//读取数据库
     	    forAddCenter.add(forAddCenter_1);
     	}
     	
     }
     
  public void setId(String id){
   	this.tempId=id;
   }

   public void setValueDisplay(){
   	 changeId.setText(String.valueOf(StudentDetail[0]));
   	 changeName.setText(String.valueOf(StudentDetail[1]));
   	 changeSex.setText(String.valueOf(StudentDetail[2]));
     changeAge.setText(String.valueOf(StudentDetail[3]));
     changeDombuilding.setText(String.valueOf(StudentDetail[4]));
     changeDomnum.setText(String.valueOf(StudentDetail[5]));   
     changePostnum.setText(String.valueOf(StudentDetail[6]));
     changeHomeaddress.setText(String.valueOf(StudentDetail[8]));
     changeTelnum.setText(String.valueOf(StudentDetail[7]));
     
     CustomerCourse.setIdAndName(String.valueOf(StudentDetail[0]),String.valueOf(StudentDetail[1]));
    
        
   }

     
   public void textValueChanged(TextEvent e){

    	if(e.getSource()==name){
        if(!name.getText().equals("")) 
    	StudentDetail[1] = name.getText();
    	}
    	
        else if(e.getSource()==homeAddress){
        if(!homeAddress.getText().equals(""))  
        StudentDetail[8] = homeAddress.getText();
        }
      
        else if(e.getSource()==telNum){
        if(!telNum.getText().equals("")) 
        StudentDetail[7] = telNum.getText();
        }   
        
        else if(e.getSource()==postNum){
        if(!postNum.getText().equals("")) 
        StudentDetail[6] = postNum.getText();
        }   
        
        else if(e.getSource()==domNum){
        if(!domNum.getText().equals("")) 
        StudentDetail[5] = domNum.getText();
        }   	
    }
     
    public void itemStateChanged(ItemEvent e){
	 	
   	 	if(e.getItemSelectable()==jrb_male){
   	 	StudentDetail[2] = "男";
   	 	}
   	 	
   	 	else if(e.getItemSelectable()==jrb_female){
   	 	StudentDetail[2] = "女";
   	 	}
   	 	
   	 	else if(e.getItemSelectable()==choice){
   	 		StudentDetail[3] = choice.getSelectedItem();  	 	
   	 	}
   	 	
   	 	
   	 	else if(e.getItemSelectable()==domBuilding){   	 	
   	 	StudentDetail[4] = domBuilding.getSelectedItem();
   	 	 	 	
   	 }
   	}
     
   
   }