105b0610a950001d1dc6bad43998f314

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

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;
class Win3 extends JFrame implements ActionListener
{
  JToolBar tool;
  JButton button1,button2,button3,button4,button5;

  Win3(String s)
	{
      super(s);
	  setBounds(100,100,400,300);
	  tool=new JToolBar();
	  button1=new JButton("系统管理");
	  button2=new JButton("学生管理");
	  button3=new JButton("课程管理");
	  button4=new JButton("成绩管理");
	  button5=new JButton("查询");
	  button1.addActionListener(this);
      button2.addActionListener(this);
      button3.addActionListener(this);
      button4.addActionListener(this);
      button5.addActionListener(this);
      
	  tool.add(button1);
	  tool.add(button2);
	  tool.add(button3);
	  tool.add(button4);
	  tool.add(button5);
	  
      this.add(tool,BorderLayout.NORTH);
      this.setDefaultCloseOperation(WindowConstants.EXIT_ON_CLOSE);
      setVisible(true);
	  validate();
	}
  public void actionPerformed(ActionEvent e)
  {   if(e.getSource()==button1)
      {
	     managerWindow win=new managerWindow("系统管理");
      }
      else if(e.getSource()==button2)
      {
    	  studentMess1 win=new studentMess1("学生信息"); 
      }	  
      else if(e.getSource()==button3)
      {
    	  courseMess2 win=new courseMess2("课程信息");
      }	
      else if(e.getSource()==button4)
      {
    	  Connection con=null;
          Statement sql=null;
          ResultSet rs=null;
    	  markMess2 win=new markMess2("分数信息");
    	  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 mansgerial=rs.getString(5);
            	  win.text.append("学号:"+no);
            	  win.text.append("\n姓名："+name);
            	  win.text.append("\nenglish"+english);
            	  win.text.append("\ndatastruction"+datastruction);
            	  win.text.append("\nmansgerial"+mansgerial+"\n\n\n\n\n");
              }
              con.close();
    	  }
    	  catch( SQLException  cc)
    	  {
    		  System.out.println(cc);
    	  }
      }	
      else 
      {
    	  searchWindow win=new searchWindow("查询");
      }
  }
}
  /*public class ManagerWindows
{
	public static void main (String args[])
	{ Win3 win=new Win3("管理员信息界面");}
}*/