loginframe.java

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

//修改密码
class updatePassword implements ActionListener{
	JDialog jdl;
	JPasswordField oldPasswordField =new JPasswordField();//旧密码
	JPasswordField newPasswordField =new JPasswordField();//新密码
	JPasswordField confirmNewPasswordField =new JPasswordField();//确认新密码
	JButton confirm=new JButton("确定");
	JButton cancel= new JButton("取消");
	String uid="";
	int state;
	
	proceeSQL psql= new proceeSQL();
	
	updatePassword(JFrame f,String s,boolean b){
		jdl=new JDialog(f,s,b);  
        jdl.setSize(250,200); 
        jdl.setLocation(350,240); 
        jdl.setResizable(false);
         
        jdl.addWindowListener(new WindowAdapter()
        {public void windowClosing(WindowEvent e)
         {
            jdl.setVisible(false);
         }});
    	
    	jdl.add(new JLabel("旧密码：",JLabel.CENTER));
    	jdl.add(oldPasswordField);
    	jdl.add(new JLabel("新密码：",JLabel.CENTER));
    	jdl.add(newPasswordField);
    	jdl.add(new JLabel("确认密码：",JLabel.CENTER));
    	jdl.add(confirmNewPasswordField);
    	jdl.add(confirm);
    	jdl.add(cancel);
    	jdl.setLayout(new GridLayout(4,2,9,9));
    	confirm.addActionListener(this);
    	cancel.addActionListener(this);
	}
	
	public void setID(String id){
		uid=id;
	}
	
	public void setState(int mark){
		state=mark;
	}
	
   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;
    	}
    	
    	int bl=psql.checkUser(uid,oldPasswordField.getText(),state);
    	if(bl<0){
    	     	JOptionPane.showMessageDialog(null, "密码不对");
    			return;	
    	}

    	psql.UpdatePassWord(uid,newPass,state);
    	
       JOptionPane.showMessageDialog(null, "修改成功");
    	jdl.setVisible(false);
    	oldPasswordField.setText("");
    	newPasswordField.setText("");
    	confirmNewPasswordField.setText("");
   	}
   	
    else if(e.getSource()==cancel){
   		jdl.setVisible(false);
   	}
   	
   	}	
   	
   	void setDisplay(Boolean tf){
   	jdl.setVisible(tf);
   }
}

//修改用户信息
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();
   	 	
   	 		
   	 	}
   	 }
}

//用户界面
class framForCustomer implements ActionListener	
{
	updatePassword up;
	updateInfo ui;
	proceeSQL psql =new proceeSQL();
	JDialog jdl;
	JPanel contentPane_1,contentPane_2,contentPane_3,contentPane_4;
	JLabel idLabel = new JLabel("学号:",JLabel.CENTER);
	JLabel nameLabel = new JLabel("姓名:",JLabel.CENTER);
	JLabel sexLabel = new JLabel("姓别:",JLabel.CENTER);
	JLabel ageLabel = new JLabel("年龄:",JLabel.CENTER);
	JLabel classLabel = new JLabel("班级:",JLabel.CENTER);
	JLabel homeAddressLabel = new JLabel("家庭住址:",JLabel.CENTER);
	JLabel telNumLabel = new JLabel("电话号码:",JLabel.CENTER);
	
	TextField idField =new TextField("",4);
	TextField nameField =new TextField("",4);
	TextField sexField =new TextField("",4);
	TextField ageField =new TextField("",4);
	TextField classField =new TextField("",8);
	TextField homeAddressField =new TextField("",8);
	TextField telNumField =new TextField("",8);
    
    
    String cId="";
   	Object a[]=new Object[8];
    String cName="";String cSex="";String cClass="";String cAddtress="";String cphoneNum="";String cpassWord="";
    int cAge;
    

	JButton updateInfo = new JButton("修改信息");
	JButton JupdatePassword = new JButton("修改密码");
	JButton refresh = new JButton("刷新");
	JButton exitBtn = new JButton("退出");
    
    framForCustomer(JFrame f,String s,boolean b){
    	jdl = new JDialog(f,s,b);
    	up= new updatePassword(f,"用户密码修改",b);
    	ui= new updateInfo(f,"修改用户资料",b);
    	contentPane_1=new JPanel();
    	contentPane_2=new JPanel();
    	contentPane_3=new JPanel();
    	contentPane_4=new JPanel();
    	
    	jdl=new JDialog(f,s,b);  
        jdl.setSize(480,260); 
        jdl.setLocation(350,240); 
        jdl.setResizable(false);
         
        jdl.addWindowListener(new WindowAdapter()
        {public void windowClosing(WindowEvent e)
         {
            jdl.setVisible(false);
         }});
    	
    	contentPane_1.add(idLabel);
    	contentPane_1.add(idField);
    	contentPane_1.add(nameLabel);
    	contentPane_1.add(nameField);
    	contentPane_1.add(sexLabel);
    	contentPane_1.add(sexField);
    	contentPane_1.add(ageLabel);
    	contentPane_1.add(ageField);
    	contentPane_1.setLayout(new GridLayout(2,4,10,23));
        
        contentPane_2.add(classLabel);
        contentPane_2.add(classField);
    	contentPane_2.add(homeAddressLabel);
    	contentPane_2.add(homeAddressField);
    	contentPane_2.add(telNumLabel);
    	contentPane_2.add(telNumField);
    	contentPane_2.setLayout(new GridLayout(3,2,1,1));
    	contentPane_4.add(contentPane_1);
    	contentPane_4.add(contentPane_2);
    	contentPane_4.setLayout(new GridLayout(2,1,9,9));
    	
    	contentPane_3.add(updateInfo); 
	    contentPane_3.add(JupdatePassword);
	    contentPane_3.add(refresh);
	    contentPane_3.add(exitBtn);
	    contentPane_3.setLayout(new GridLayout(1,4,9,9));
	    
	 idField.setEditable(false);
	 nameField.setEditable(false);
	 sexField.setEditable(false);
     ageField.setEditable(false);
	 classField.setEditable(false);
	 homeAddressField.setEditable(false);
	 telNumField.setEditable(false);
	 
	 
	    updateInfo.addActionListener(this);
	    JupdatePassword.addActionListener(this);
	    refresh.addActionListener(this);
	    exitBtn.addActionListener(this);
	    
	    jdl.add(contentPane_4);
	    jdl.add(contentPane_3,BorderLayout.SOUTH);

    	
    }
    
    void setValue(String id,String name,String sex,String Classes,int age,String addtress,String phoneNum)
    {
    	a[0]=id;a[1]=name;a[2]=sex;a[3]=Classes;a[4]=age;a[5]=addtress;a[6]=phoneNum;
    	idField.setText(cId);
	    nameField.setText(String.valueOf(a[1]));
	    sexField.setText(String.valueOf(a[2]));
        ageField.setText(String.valueOf(a[3]));
	    classField.setText(String.valueOf(a[4]));
	    homeAddressField.setText(String.valueOf(a[5]));
	    telNumField.setText(String.valueOf(a[6]));
    }
    
    void setValueById(){
    	a[0]=cId;
    	
    	psql.OUTsetValue(a);
    	idField.setText(cId);
	    nameField.setText(String.valueOf(a[1]));
	    sexField.setText(String.valueOf(a[2]));
	    classField.setText(String.valueOf(a[3]));
        ageField.setText(String.valueOf(a[4]));	   
	    homeAddressField.setText(String.valueOf(a[5]));
	    telNumField.setText(String.valueOf(a[6]));
    }
    
    void setID(String id){
    	cId=id;
    	
    }
    
    
    void setDisplay(Boolean tf){
   	jdl.setVisible(tf);
   }
 	
	public void actionPerformed(ActionEvent e){
		if(e.getSource()==JupdatePassword){
			up.setID(cId);
			up.setState(1);
			up.setDisplay(true);
		}
		
		else if(e.getSource()==exitBtn){
			
		
			jdl.setVisible(false);
		}
		
		else if(e.getSource()==updateInfo){	
		    ui.setID(cId);
			ui.setDisplay(true);
		}
		
		else if(e.getSource()==refresh){
			setValueById();
		}
	}

}

//向数据库中加入信息
class Insert implements ActionListener,TextListener,ItemListener{
	
	JDialog jdl;
    JMenuBar Fmenubar;
    JMenu fileMenu,editMenu,helpMenu;
    JMenuItem item_receave,item_statist,Fitem_exit,item_save,item_open,item_show;
    JMenuItem item_clear,item_about;
    JPanel pnl;
    Choice choice;
    Choice Classes;
    JRadioButton jrb_male=new JRadioButton("男");
    JRadioButton jrb_female=new JRadioButton("女");    
    ButtonGroup sex= new ButtonGroup();
    TextField name,id,homeAddress,telNum;
   	JPasswordField newPasswordField =new JPasswordField();//新密码
	JPasswordField confirmNewPasswordField =new JPasswordField();//确认新密码
    JButton btn_receave,btn_statist;
       
     String iId="",iName="",iSex="",iClass="",iAddtress="",iphoneNum="",ipassWord="";
     String newPass="",conPass="";