function.java

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

package function;

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

public class Function{
	JFrame f;
	public Vector ver=new Vector();
	public Statement stmt;
	public PreparedStatement pstmt;
	public ResultSet rs;
	public void Function(){
	}
	
	public void SelectandUpdate(String a,String b){
		if(a=="查询信息"){
			try{
			    f=new JFrame("学生信息");	
				Vector columnNames=new Vector(4);
				columnNames.add("学号");
				columnNames.add("姓名");
				columnNames.add("性别");
				columnNames.add("年龄");
				pstmt=new Operate().con.prepareStatement("SELECT SNO,SNAME,SEX,AGE FROM STUDENT WHERE SNO=?");
				pstmt.setString(1,b);
				pstmt.executeQuery();//不知道是否是对的
				rs=pstmt.getResultSet(); //不知道是否是对的
				int rowcount=0;
				while(rs.next()){
					Vector vector=new Vector(4);
					vector.add(rs.getString("SNO"));
					vector.add(rs.getString("SNAME"));
					vector.add(rs.getString("SEX"));
					vector.add(rs.getInt("AGE"));
					ver.add(vector);
				}
				JTable table=new JTable(ver,columnNames);
				JPanel panel=new JPanel(new BorderLayout());
				panel.setPreferredSize(new Dimension(400,200));
				panel.add(table,BorderLayout.CENTER);
				f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
				f.setPreferredSize(new Dimension(400,200));
				f.setContentPane(panel);
				f.pack();
				f.setVisible(true);
				f.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
				rs.close();
				pstmt.close();
				
			}catch(Exception e){
				e.printStackTrace();
			}
		}
		else if(a=="成绩查询"){
			try{
				f=new JFrame("成绩信息");
				Vector columnNames=new Vector(5);
				columnNames.add("学号");
				columnNames.add("姓名");
				columnNames.add("课程名称");
				columnNames.add("学分");
				columnNames.add("成绩");
				pstmt=new Operate().con.prepareStatement("SELECT STUDENT.SNO,SNAME,COURSE.CNAME,CREDIT,SC.GRADE FROM STUDENT,SC,COURSE WHERE STUDENT.SNO=SC.SNO AND SC.CNO=COURSE.CNO AND STUDENT.SNO=?");

                pstmt.setString(1,b);
                pstmt.executeQuery();//不知道是否是对的
                rs=pstmt.getResultSet();//不知道是否是对的
				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(600,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();
				pstmt.close();
				//con.close();
			}catch(Exception e){
				e.printStackTrace();
			}
		}
		else{
			if(b=="学生信息查询"){
				int rowcount;
				try{
					f=new JFrame("学生信息查询");
					Vector columnNames=new Vector(6);
					columnNames.add("学号");
					columnNames.add("姓名");
					columnNames.add("性别");
					columnNames.add("年龄");
					columnNames.add("登陆名");
					columnNames.add("登陆密码");
					stmt=new Operate().con.createStatement();
					rs=stmt.executeQuery("SELECT *FROM STUDENT");
					while(rs.next()){
						Vector vector=new Vector(6);
						vector.add(rs.getString("SNO"));
						vector.add(rs.getString("SNAME"));
						vector.add(rs.getString("SEX"));
						vector.add(rs.getInt("AGE"));
						vector.add(rs.getString("USERNAME"));
						vector.add(rs.getString("PASSWORD"));
						ver.add(vector);
					}
					
					JTable table=new JTable(ver,columnNames);
					table.setPreferredScrollableViewportSize(new Dimension(600,200));
					JScrollPane pane=new JScrollPane(table);
					JPanel panel=new JPanel(new BorderLayout());
					panel.setPreferredSize(new Dimension(600,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();
				}
			}
			else if(b=="添加学生"){
				
				final Frame f1=new Frame("添加学生信息");
				Button btn=new Button("提交");
				Panel pan1=new Panel();
				Panel pan2=new Panel();
				Label[] lab=new Label[6];
				final TextField[] tf=new TextField[6];
				
				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("登陆口令");	
				pan1.setLayout(new GridLayout(6,2));
				for(int i=0;i<6;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[6];
							for(int i=0;i<6;i++){
								s[i]=tf[i].getText();
							}
							int m;
							m=Integer.parseInt(s[3]);
							stmt=new Operate().con.createStatement();
							stmt.executeUpdate("INSERT INTO STUDENT VALUES("+
							"'"+s[0]+"'"+","+"'"+s[1]+"'"+","+"'"+s[2]+"'"+","+m+","+"'"+s[4]+"'"+","+"'"+s[5]+"')");
							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(4);
					columnNames.add("操作员编号");
					columnNames.add("姓名");
					columnNames.add("性别");
					columnNames.add("年龄");
					stmt=new Operate().con.createStatement();
					rs=stmt.executeQuery("SELECT MNO,MNAME,MSEX,MAGE FROM MANAGER");
					while(rs.next()){
						Vector vector=new Vector(4);
						vector.add(rs.getString("MNO"));
						vector.add(rs.getString("MNAME"));
						vector.add(rs.getString("MSEX"));
						vector.add(rs.getString("MAGE"));
						ver.add(vector);
					}
					JTable table=new JTable(ver,columnNames);
				    table.setPreferredScrollableViewportSize(new Dimension(400,200));
					JScrollPane pane=new JScrollPane(table);
					JPanel panel=new JPanel(new BorderLayout());
					panel.setPreferredSize(new Dimension(400,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();
				}
			}
			else if(b=="添加操作员"){
				final Frame f1=new Frame("添加操作员");
				Button btn=new Button("提交");
				Panel pan1=new Panel();
				Panel pan2=new Panel();
				Label lab[]=new Label[6];
				final TextField tf[]=new TextField[6];
				
				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("登陆口令");
				pan1.setLayout(new GridLayout(6,2));
				for(int i=0;i<6;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[6];
							for(int i=0;i<6;i++){
								s[i]=tf[i].getText();
							}
							int a=Integer.parseInt(s[3]);
							stmt=new Operate().con.createStatement();
							stmt.executeUpdate("INSERT INTO MANAGER VALUES("+
							"'"+s[0]+"'"+","+"'"+s[1]+"'"+","+"'"+s[2]+"'"+","+a+","+"'"+s[4]+"'"+","+"'"+s[5]+"')");
							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);