function.java

java平台开发学生管理系统 功能较全

				f1.add(pan2,BorderLayout.SOUTH);
				
				lab[0]=new Label("要修改的学生的学号");
				lab[1]=new Label("新的学号");
				lab[2]=new Label("姓名");
				lab[3]=new Label("性别");
				lab[4]=new Label("年龄");
				lab[5]=new Label("新的登陆名");
				lab[6]=new Label("新的登陆口令");
				pan1.setLayout(new GridLayout(7,2));
				for(int i=0;i<7;i++){
					tf[i]=new TextField(20);
					pan1.add(lab[i]);
					pan1.add(tf[i]);
				}
				
				pan2.add(btn,new BorderLayout().CENTER);
				btn.addActionListener(new ActionListener(){
					public void actionPerformed(ActionEvent e){
						try{
							String s[]=new String[7];
							for(int i=0;i<7;i++){
								s[i]=tf[i].getText();
							}
							int a=Integer.parseInt(s[4]);
							stmt=new Operate().con.createStatement();
							stmt.executeUpdate("UPDATE STUDENT SET SNO"
							+"="+"'"+s[1]+"'"+","+"SNAME"+"="+"'"+s[2]+"'"+","+
							"SEX"+"="+"'"+s[3]+"'"+","+"AGE"+"="+a+","+"USERNAME"+"="+"'"+s[5]+"'"+","+
							"PASSWORD"+"="+"'"+s[6]+"'"+" WHERE SNO"+"="+"'"+s[0]+"'");
							popUp("操作成功");
							stmt.close();
							//con.close();
						}catch(Exception e1){
							e1.printStackTrace();
						}
					}
				}
				);
				f1.setSize(350,200);
				f1.setVisible(true);
				f1.addWindowListener(new WindowAdapter(){
					public void windowClosing(WindowEvent e){
						f1.dispose();
					}
				}
				);
			}
			else if(b=="修改操作员信息"){
				final Frame f1=new Frame("修改操作员信息");
				Label lab[]=new Label[7];
				final TextField tf[]=new TextField[7];
				Panel pan1=new Panel();
				Panel pan2=new Panel();
				Button btn=new Button("提交");
				f1.setLayout(new BorderLayout());
				f1.add(pan1,BorderLayout.CENTER);
				f1.add(pan2,BorderLayout.SOUTH);
				
				lab[0]=new Label("要修改的操作员编号");
				lab[1]=new Label("新的编号");
				lab[2]=new Label("姓名");
				lab[3]=new Label("性别");
				lab[4]=new Label("年龄");
				lab[5]=new Label("新的登陆名");
				lab[6]=new Label("新的登陆口令");
				
				pan1.setLayout(new GridLayout(7,2));
				for(int i=0;i<7;i++){
					tf[i]=new TextField(20);
					pan1.add(lab[i]);
					pan1.add(tf[i]);
				}
				
				pan2.add(btn,new BorderLayout().CENTER);
				btn.addActionListener(new ActionListener(){
					public void actionPerformed(ActionEvent e){
						try{
							String s[]=new String[7];
							for(int i=0;i<7;i++){
								s[i]=tf[i].getText();
							}
							int a=Integer.parseInt(s[4]);
							stmt=new Operate().con.createStatement();
							stmt.executeUpdate("UPDATE MANAGER SET MNO"
							+"="+"'"+s[1]+"'"+","+"MNAME"+"="+"'"+s[2]+"'"+","+"MSEX"+"="+"'"+s[3]+"'"+","+
							"MAGE"+"="+a+","+"USERNAME"+"="+"'"+s[5]+"'"+","+"PASSWORD"+"="+"'"+s[6]+"'"+
							" WHERE MNO"+"="+"'"+s[0]+"'");
							popUp("操作成功");
							stmt.close();
							//con.close();
						}catch(Exception e1){
							e1.printStackTrace();
						}
					}
				}
				);
				f1.setSize(350,200);
				f1.setVisible(true);
				f1.addWindowListener(new WindowAdapter(){
					public void windowClosing(WindowEvent e){
						f1.dispose();
					}
				}
				);
			}
			else if(b=="学生成绩查询"){
				try{
					
					f=new JFrame("学生成绩查询");
					Vector columnNames=new Vector(5);
					columnNames.add("学号");
					columnNames.add("姓名");
					columnNames.add("课程名称");
					columnNames.add("课程学分");
					columnNames.add("成绩");
					stmt=new Operate().con.createStatement();
					rs=stmt.executeQuery("SELECT STUDENT.SNO,SNAME,COURSE.CNAME,CREDIT,SC.GRADE FROM STUDENT,SC,COURSE WHERE STUDENT.SNO=SC.SNO AND SC.CNO=COURSE.CNO");
					while(rs.next()){
						Vector vector=new Vector(5);
						vector.add(rs.getString("SNO"));
						vector.add(rs.getString("SNAME"));
						vector.add(rs.getString("CNAME"));
						vector.add(rs.getInt("CREDIT"));
						vector.add(rs.getInt("GRADE"));
						ver.add(vector);
					}
					JTable table=new JTable(ver,columnNames);
					table.setPreferredScrollableViewportSize(new Dimension(500,200));
					JScrollPane pane=new JScrollPane(table);
					JPanel panel=new JPanel(new BorderLayout());
					panel.setPreferredSize(new Dimension(500,200));
					panel.add(pane,BorderLayout.CENTER);
					f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
					f.setContentPane(panel);
					f.pack();
					f.setVisible(true);
					f.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
					rs.close();
					stmt.close();
					//con.close();
				}catch(Exception e){
					e.printStackTrace();
				}
			}
		}
	}
	public void UpdatePassWord(final String a,final String b,String c){//A是旧口令，B 是学生或老师的编号，C 是判断依据
		if(c=="学生"){
			final Frame f1=new Frame("修改口令");
		    Label[] lab=new Label[3];
		    final TextField[] tf=new TextField[3];
		    Button btn=new Button("提交");
		    Panel pan1=new Panel();
		    Panel pan2=new Panel();
			
		    f1.setLayout(new BorderLayout());
		    f1.add(pan1,BorderLayout.CENTER);
		    f1.add(pan2,BorderLayout.SOUTH);
			
		    lab[0]=new Label("请输入旧口令");
		    lab[1]=new Label("请输入新口令");
		    lab[2]=new Label("再次输入新口令");
		    pan1.setLayout(new GridLayout(3,2));
		    for(int i=0;i<3;i++){
		    	tf[i]=new TextField(20);
			    pan1.add(lab[i]);
			    pan1.add(tf[i]);
		    }
		
		    pan2.add(btn,new BorderLayout().CENTER);
		    btn.addActionListener(new ActionListener(){
			    public void actionPerformed(ActionEvent e){
				    try{
				        String[] s=new String[3];
		       		    s[0]=tf[0].getText();
					    if(s[0].equals(a)){
						    s[1]=tf[1].getText().trim();
						    s[2]=tf[2].getText().trim();
						    if(s[1].equals(s[2])){
						    	pstmt=new Operate().con.prepareStatement("UPDATE STUDENT SET PASSWORD=? WHERE SNO=?");
							    pstmt.setString(1,s[1]);
							    pstmt.setString(2,b);
							    pstmt.executeUpdate();
							    pstmt.close();
							   // con.close();
							    popUp("修改成功");
						    }
						    else{
						    	popUp("两次输入口令不一致");
						    }
					    }
					    else{
						    popUp("口令错误");
					    }
				    }catch(Exception e1){
					    e1.printStackTrace();
				    }
			    }
		    }
		    );
		    f1.setSize(400,200);
		    f1.setVisible(true);
		    f1.addWindowListener(new WindowAdapter(){
				public void windowClosing(WindowEvent e){
					f1.dispose();
				}
			}
			);

	    }
	    else{
	    	final Frame f1=new Frame("修改口令");
		    Label[] lab=new Label[3];
		    final TextField[] tf=new TextField[3];
		    Button btn=new Button("提交");
		    Panel pan1=new Panel();
		    Panel pan2=new Panel();
			
		    f1.setLayout(new BorderLayout());
		    f1.add(pan1,BorderLayout.CENTER);
		    f1.add(pan2,BorderLayout.SOUTH);
			
			lab[0]=new Label("请输入旧口令");
		    lab[1]=new Label("请输入新口令");
		    lab[2]=new Label("再次输入新口令");
		    pan1.setLayout(new GridLayout(3,2));
		    for(int i=0;i<3;i++){
		    	tf[i]=new TextField(20);
			    pan1.add(lab[i]);
			    pan1.add(tf[i]);
		    }
		
		    pan2.add(btn,new BorderLayout().CENTER);
		    btn.addActionListener(new ActionListener(){
			    public void actionPerformed(ActionEvent e){
				    try{
				        String[] s=new String[3];
		       		    s[0]=tf[0].getText();
					    if(s[0].equals(a)){
						    s[1]=tf[1].getText();
						    s[2]=tf[2].getText();
						    if(s[1].equals(s[2])){
						    	pstmt=new Operate().con.prepareStatement("UPDATE MANAGER SET PASSWORD=? WHERE MNO=?");
							    pstmt.setString(1,s[1]);
							    pstmt.setString(2,b);
							    pstmt.executeUpdate();
							    pstmt.close();
							    //con.close();
							    popUp("修改成功");
						    }
						    else{
						    	popUp("两次输入口令不一致");
						    }
					    }
					    else{
						    popUp("口令错误");
					    }
				    }catch(Exception e1){
					    e1.printStackTrace();
				    }
			    }
		    }
		    );
		    f1.setSize(400,200);
		    f1.setVisible(true);
		    f1.addWindowListener(new WindowAdapter(){
				public void windowClosing(WindowEvent e){
					f1.dispose();
				}
			}
			);

	    }
	}
	public void  popUp(String a){
		final Frame f1=new Frame("错误");
		Label lab=new Label(a);
		Button btn=new Button("确定");
		Panel pan=new Panel();
		f1.setLayout(new BorderLayout());
		f1.add(pan,BorderLayout.CENTER);
		pan.setLayout(new GridLayout(2,1));
		pan.add(lab);
		pan.add(btn);
		btn.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
				f1.dispose();
			}
		}
		);
		f1.addWindowListener(new WindowAdapter(){
			public void windowClosing(WindowEvent e1){
				f1.dispose();
			}
		}
		);
		f1.setSize(150,100);
		f1.setVisible(true);
	}
}