student.java

学生管理系统.对学生信息管理的一个应用软件！

import java .awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.WindowConstants;
class studentButton extends JFrame implements ActionListener
{  Button inforButton,courseButton,markButton,repasswordButton;
   
   studentButton(String s)
   {   super(s);
       setLayout(new FlowLayout());
	   inforButton=new Button("基本信息");
       courseButton=new Button("课程");
       markButton=new Button("成绩");
       repasswordButton=new Button("修改密码");
       add(inforButton);
       add(courseButton);
       add(markButton);
       add(repasswordButton);
       inforButton.addActionListener(this);
       courseButton.addActionListener(this);
       markButton.addActionListener(this);
       repasswordButton.addActionListener(this);
       this.setDefaultCloseOperation(WindowConstants.EXIT_ON_CLOSE);
       setBounds(120,120,300,300);
       setVisible(true);
       validate();
    }
   public void actionPerformed(ActionEvent e)
   {   if(e.getSource()==inforButton) 
      {
	    studentMess win=new studentMess("学生信息");
	    Connection con=null;
        Statement sql=null;
        ResultSet rs=null;
            try {   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                 }
            catch ( ClassNotFoundException ee )
                {   System.out.print( " " + ee);
                }
            try
                {    con=DriverManager.getConnection("jdbc:odbc:sun","","");
 	                  sql=con.createStatement();
 	                  rs=sql.executeQuery("SELECT * FROM 学生个人信息表");
 	                  while(rs.next())
 	                 {   String no =rs.getString(1);
 	                     String name =rs.getString(2);
 	                     String sex =rs.getString(3);
 	                     String deparment =rs.getString(4);
 	                     String banji =rs.getString(5);
 	                     String birthday =rs.getString(6);
	                     String nativeplace =rs.getString(7);
 	                     win.text1.setText(no);
 	                     win.text2.setText(name);
 	                     win.text3.setText(sex);
 	                     win.text4.setText(deparment);
	                     win.text5.setText(banji);
	                     win.text6.setText(birthday);
	                     win.text7.setText(nativeplace);
 	                  }
 	                     con.close();
                }
             catch( SQLException  cc)
                {
 	                  System.out.println("mmmmmmmm");
                }
      }
      else if(e.getSource()==courseButton)
      {
    	  courseText1 win=new courseText1("课程表") ;
    	  Connection con=null;
          Statement sql=null;
          ResultSet rs=null;
        try {   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            }
        catch ( ClassNotFoundException ee )
           {   System.out.print( " " + ee);
           }
        try
          {    con=DriverManager.getConnection("jdbc:odbc:sun","","");
   	        sql=con.createStatement();
   	        rs=sql.executeQuery("SELECT * FROM 课程信息表");
   	        while(rs.next())
   	        {   String courseno =rs.getString(1);
   	            String course =rs.getString(2);
   	            String teacher =rs.getString(3);
   	            win.text1.append("课程编号:"+courseno+"  ");
   	            win.text1.append("课程名:"+course+"  ");
   	            win.text1.append("教师:"+teacher+"\n");
   	        }
   	        con.close();
          }
        catch( SQLException  cc)
              {
   	        System.out.println("mmmmmmmm");
              }
      }
      else if(e.getSource()==markButton)
      {
    	  markText1 win=new markText1("成绩表");
    	  Connection con=null;
          Statement sql=null;
          ResultSet rs=null;
          try {   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
               }
          catch ( ClassNotFoundException ee )
              {   System.out.print( " " + ee );
              }
          try
             {    con=DriverManager.getConnection("jdbc:odbc:sun","","");
      	        sql=con.createStatement();
      	        rs=sql.executeQuery("SELECT * FROM 成绩信息表");
      	        while(rs.next())
      	        {   String no =rs.getString(1);
      	            String name =rs.getString(2);
      	            String english =rs.getString(3);
      	            String datastruction=rs.getString(4);
      	            String managerial=rs.getString(5);
      	            win.text1.append("学号:"+no+"  ");
      	            win.text1.append("姓名:"+name+"  ");
      	            win.text1.append("英语:"+english+"  ");
      	            win.text1.append("数据结构:"+datastruction+"  ");
      	            win.text1.append("管理学:"+managerial+"\n");
      	       
      	        }
      	        con.close();
             }
           catch( SQLException  cc)
                 {
      	        System.out.println("mmmmmmmm");
                 }
      }
      else
      {
    	  studentPassword win=new studentPassword("修改密码");
      }
   }
	
}

/*public class Student
{   public static void main(String args[])
 {   studentButton stu=new studentButton("学生信息界面");
	
   }
	
}*/