student.java.bak

一个好的学生成绩管理系统

/**
 * 本应用程序是一个简单的学生成绩管理信息系统程序
 * 
 * @author  03442-22 03442-14 03442-21
 * @version 1.0, 2005/07/1
 */
import java.awt.*;
import java.io.*;
import java.sql.*;
import javax.swing.*;
import java.awt.event.*;
/**
 * 公共class类，类名Student  
 */
public class Student {
	public static  Monitor mymonitor = new Monitor();
     	public static JLabel welcome,usename1,password1;
	public static TextField usename2,password2;
	public static JButton enter1,close1;
     	public static JFrame Enterfrm;
        public static void main(String []args){
        	Student myke=new Student();
        	} 
	 
          //创建类名的构造方法	  
	public Student(){
           //////////////////登陆窗体布局////////////
		Enterfrm=new JFrame("登陆窗体"); 
         	Toolkit kit = Toolkit.getDefaultToolkit();
		Dimension screenSize = kit.getScreenSize();
		int screenWidth = screenSize.width;
		int screenHeight = screenSize.height;
	   	welcome=new JLabel("欢迎进入本学生成绩管理系统");
         	welcome.setFont(new Font("宋体",Font.BOLD,22));
		usename1=new  JLabel("用户名:");password1=new  JLabel("密  码:");
         	usename2=new  TextField(12); password2=new  TextField(12);
         	enter1=new  JButton ("确定");close1=new  JButton ("退出");
		JPanel p1 = new JPanel(); JPanel p2 = new JPanel();
		JPanel p3 = new JPanel();JPanel p4 = new JPanel();
		JPanel p5 = new JPanel();password2.setEchoChar('*');
		p4.add(usename1); p4.add(usename2); p4.add(enter1);
		p5.add(password1); p5.add(password2); p5.add(close1);
		p3.setLayout(new GridLayout(2,1));p2.add("Center",welcome);
		p3.add(p4);  p3.add(p5); p1.add(p2); p1.add(p3);
		p1.setLayout(new GridLayout(2,1));	
        	Container k = Enterfrm.getContentPane(); k.add(p1);           
	      	Enterfrm.setSize(screenWidth / 3,screenHeight / 3);
		Enterfrm.setLocation(280,300);
		Enterfrm.addWindowListener(new WindowAdapter() {
	        public void windowClosing(WindowEvent e) { System.exit(0);  }});
	        Enterfrm.show();
		////////////////////////////////////////////	
              // 注册按钮的事件监听器
		enter1.addActionListener(mymonitor);
                close1.addActionListener(mymonitor);       
     		}
} 
class Monitor implements ActionListener{
        public String un1="gaoxiushi",pw1="05";
	public String un2="baoqi",pw2="1";
        public String un3="1",pw3="1";       
	public void actionPerformed(ActionEvent e){
		if (e.getSource() == Student.enter1){	
			if((Student.usename2.getText().equals(un1)&& Student.password2.getText().equals(pw1))
			||(Student.usename2.getText().equals(un2)&& Student.password2.getText().equals(pw2))
                        ||(Student.usename2.getText().equals(un3)&& Student.password2.getText().equals(pw3))){
				mainfrm mf=new mainfrm();
				Student.Enterfrm.setVisible(false);
				}
			else{
			JOptionPane.showMessageDialog(null,"对不起您的输入有误，请重新输入！"); 
			Student.usename2.setText("");Student.password2.setText("");
			}
		}
                if (e.getSource() == Student.close1){
                	System.exit(0);
                	}

	}
}
	  
		////////////////主窗体///////////////////  
class mainfrm implements ActionListener{
	public static JMenu TeacherMenu,StudentMenu,MarkMenu,HelpMenu;
        public static JMenuItem TMfind,TMedit, TMdelete, SMfind,SMedit, SMdelete,
				             MMfind,MMedit,MMalter,MMid, HMabout;
        public static JFrame mainf;
	public static JLabel room;
	public mainfrm(){
		mainf= new JFrame("主窗体"); JMenuBar myMenuBar = new JMenuBar();  //创建菜单栏  
            	TeacherMenu = new JMenu("教师管理");TMfind=new JMenuItem("查询记录");TMfind.addActionListener(this);
	        TMedit=new JMenuItem("录入记录");TMedit.addActionListener(this);
	        TMdelete=new JMenuItem("删除记录"); TMdelete.addActionListener(this);
            	StudentMenu=new JMenu("学生管理");SMfind=new JMenuItem("查询记录");SMfind.addActionListener(this);
		SMedit=new JMenuItem("录入记录");  SMedit.addActionListener(this);
		SMdelete=new JMenuItem("删除记录");SMdelete.addActionListener(this); 
		MarkMenu=new JMenu(" 成绩管理"); MMfind=new JMenuItem("成绩查询");MMfind.addActionListener(this);
		MMedit=new JMenuItem("成绩录入");MMedit.addActionListener(this);
		MMalter=new JMenuItem("修改"); MMalter.addActionListener(this);MMid=new JMenuItem("图片");
		MMid.addActionListener(this);
		HelpMenu=new JMenu("帮助");HMabout=new JMenuItem("关于");HMabout.addActionListener(this);
              //将菜单栏添加到主窗体的框架中
                mainf.setJMenuBar(myMenuBar); 
              	myMenuBar.add(TeacherMenu);myMenuBar.add(StudentMenu);
              	myMenuBar.add(MarkMenu);myMenuBar.add(HelpMenu);              
		TeacherMenu.add(TMfind);TeacherMenu.add(TMedit);TeacherMenu.add(TMdelete);
              	StudentMenu.add(SMfind); StudentMenu.add(SMedit);StudentMenu.add(SMdelete);
		MarkMenu.add(MMedit); MarkMenu.add(MMfind);MarkMenu.add(MMalter);MarkMenu.add(MMid);
              	HelpMenu.add(HMabout);
       
             	JPanel pa1=new JPanel(); pa1.setLayout(new GridLayout(2,1));JPanel pa2=new JPanel();
		JPanel pa3=new JPanel();room=new JLabel("学生成绩管理信息系统");
              	room.setFont(new Font("宋体",Font.BOLD,35));
              	//获得框架的内容层板
	        mainf.getContentPane().add(pa1, BorderLayout.CENTER);pa1.add(pa3);pa1.add(pa2);pa2.add(room);
		mainf.setSize(400, 400);
		mainf.setLocation(300, 300 );mainf.setResizable(false);
	        mainf.addWindowListener(new WindowAdapter(){
	        	public void windowClosing(WindowEvent e){
	        		System.exit(0); 
	                	}
	                });
		mainf.show();
	}
	  
	public void actionPerformed(ActionEvent e){
		if ((e.getSource() == mainfrm .TMfind)||(e.getSource() == mainfrm .TMedit)||
		(e.getSource() == mainfrm .TMdelete)){
			teafrm1 tf1 = new teafrm1();
			}
          	if ((e.getSource() == mainfrm.SMfind)||(e.getSource() == mainfrm .SMdelete)){
          		stufrm1 sf1= new stufrm1();
          		}
		if (e.getSource() == mainfrm .SMedit){
			stufrm2 sf2=new stufrm2();
			}		      
          	if (e.getSource() == mainfrm .MMfind){
          		markfrm1 mf1=new markfrm1();
          		}
          	if ((e.getSource() == mainfrm .MMalter)||(e.getSource() == mainfrm .MMedit)){
          		markfrm2 mf2=new markfrm2();
          		}
		if (e.getSource() == mainfrm .MMid){
			markfrm3 mf3=new markfrm3();
			}  
          	if (e.getSource() == mainfrm .HMabout){
          		AboutFrm af1=new AboutFrm();
          		}
    	   
		}
}

/////////查询、录入、删除教师记录窗体/////////////////
class teafrm1   implements ActionListener{ //throws IOException
	String id,name,sex,department,phone;
	Connection conn;
        ResultSet rs;
        Statement st;
        public  JFrame teaf;
        public  JPanel p1,p2,p3,p4,p5,p6,p7,p8;
	public  JLabel NumL,nameL,sexL,departmentL,phoneL;
        public  JTextField tf,Num,nameT,sexT,departmentT,phoneT;
        public  JButton search,closeT,delete,insert;			
        public teafrm1(){//窗体布局
        	teaf= new JFrame ("查询、录入、删除教师记录");teaf.setSize(360,360); teaf.setResizable(false);
	        id = new String(); name = new String(); sex = new String();
                department = new String();phone = new String();
               	NumL = new JLabel("教师号："); nameL = new JLabel("姓 名：");
               	sexL = new JLabel("性 别：");departmentL = new JLabel("部 门：");
	        phoneL = new JLabel("电 话："); 
               	tf=new JTextField(16);Num = new JTextField(20);nameT = new JTextField(20);
               	sexT = new JTextField(20);departmentT = new JTextField(20);phoneT=new JTextField(20);
	        p1=new JPanel(); p2 = new JPanel(); p3 = new JPanel();p4 = new JPanel();
		p5 = new JPanel();p6 = new JPanel(); p7 = new JPanel(); p8 = new JPanel();
		delete = new JButton("删除"); search = new JButton("查找");
		insert=new JButton("录入"); closeT=new JButton("退出");
		p2.add(search); p2.add(tf);	p3.add(NumL);p3.add(Num);
		p4.add(nameL);p4.add(nameT);    p5.add(sexL);p5.add(sexT);
		p6.add(departmentL);p6.add(departmentT);  p7.add(phoneL);p7.add(phoneT);
		p8.add(insert);p8.add(delete);p8.add(closeT);
		p1.setLayout(new GridLayout(7,1));
		p1.add(p2);p1.add(p3);p1.add(p4);p1.add(p5);p1.add(p6);p1.add(p7);p1.add(p8);



          	Container c=teaf.getContentPane(); c.add(p1);        
           
		teaf.addWindowListener(new WindowAdapter(){
			public void windowClosing(WindowEvent e){
				System.exit(0);
				}
			});;
           	teaf.setLocation(200,200); teaf.show();
                search.addActionListener(this);
                closeT.addActionListener(this);
                delete.addActionListener(this);
		insert.addActionListener(this);
		conDB();
		}
    //以下是连接数据库
	public void conDB(){
		try{		//加载数据库驱动
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
    		catch(ClassNotFoundException e){
    			JOptionPane.showMessageDialog(null,"数据库加载失败！");
    			}
      		try{		// 连接数据库
          	conn = DriverManager.getConnection("jdbc:odbc:studb");
           	st = conn.createStatement();
       		}
      		catch(SQLException e){
      			JOptionPane.showMessageDialog(null,"数据库连接失败！"); 
      			}
  	} 
      //以下是关闭数据库
	public void closeDB(){
		try{
		st.close();  conn.close();
		}
        	catch(SQLException e ){
        		JOptionPane.showMessageDialog(null,"数据库关闭失败！");
         		}
     	}
      //以下是针对数据库的各种操作
 	public void actionPerformed(ActionEvent e){
             //以下执行查询教师记录操作
 		if(e.getSource()==search){
 			try{    
             		String id=tf.getText();
          		String strSQL = "select teanum,teaname,sex,department,phone"+" from teacher where teanum= '"+id+"' ";
             		ResultSet  rs = st.executeQuery(strSQL);
             		int count = 0;
             		while(rs.next()){
             			id = rs.getString("teanum");name = rs.getString("teaname");
                 		sex = rs.getString("sex");department = rs.getString("department");
                 		phone = rs.getString("phone"); ++count;
               			}
             	if(count==0)
                JOptionPane.showMessageDialog(null,"对不起，没有您要查找的教师！");
             	else{
             	Num.setText(id); nameT.setText(name);sexT.setText(sex);
                departmentT.setText(department);phoneT.setText(phone);
                }
    	}
       	catch(SQLException ex){
       		Num.setText(ex.getMessage()); nameT.setText(ex.getMessage());
          	sexT.setText(ex.getMessage());departmentT.setText(ex.getMessage());
          	phoneT.setText(ex.getMessage());
        	}     
      	}
           // 删除教师记录操作
      	if(e.getSource()==delete){
      		String id = Num.getText();
          	String strSQL = "delete teanum,teaname,sex,department,phone"+" from teacher where teanum= '"+id+"' ";
         	try{
         	st.executeUpdate(strSQL);
         	}
         	catch(Exception exx){
         		JOptionPane.showMessageDialog(null,"521工作室通知您：出错了！");
             	return;
           	}
            	JOptionPane.showMessageDialog(null,"删除成功！");
             	tf.setText(""); Num.setText(""); nameT.setText("");
             	sexT.setText("");departmentT.setText("");phoneT.setText(""); 
	     	}
          //录入教师记录操作
      	if(e.getSource()==insert)  
      	if((Num.getText().trim()).equals("") || (nameT.getText().trim()).equals("") || (sexT.getText().trim()).equals("") || (departmentT.getText().trim()).equals("") ||(phoneT.getText().trim()).equals(""))
      	JOptionPane.showMessageDialog(null,"请输入信息再点击提交添加！");
        else{
        id = Num.getText();name = nameT.getText();sex = sexT.getText();
        department = departmentT.getText(); phone = phoneT.getText();      
        String strSQL = "insert into teacher ( teanum,teaname,sex,department,phone)values( '"+ id + "','" + name + "','" + sex + "','" + department + "','" + phone + "')"; 
        try{
        st.executeUpdate(strSQL);
        }
        catch(Exception exx){
        	JOptionPane.showMessageDialog(null,"数据库中已经存在您要添加的教师的教师号！");
             	return;
           	}
           	JOptionPane.showMessageDialog(null,"恭喜您，添加成功了！");
		Num.setText(""); nameT.setText("");sexT.setText("");
            	departmentT.setText("");phoneT.setText("");
         	}

      	if(e.getSource()==closeT){
      		closeDB(); teaf.dispose();
      		} 
	}