00040b52ed4f001d1594abca140770d0

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

import java .awt.*;
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.*;
class searchWindow2 extends JFrame implements ActionListener
{  Button button1,button2,button3,button4,button5;
   TextArea  text1;
   searchWindow2(String s)
   {   super(s);
       setLayout(new FlowLayout());
	   button1=new Button("大学英语");
	   button2=new Button("数据结构");
	   button3=new Button("管理学");
	   //button4=new Button("专业英语");
	   button5=new Button("重置");
	   text1=new TextArea(10,15);
	   text1.setEditable(false);
	   add(button1);
	   add(button2);
	   add(button3);
	  // add(button4);
	   add(text1);
	   add(button5);
	   button1.addActionListener(this);
	   button2.addActionListener(this);
	   button3.addActionListener(this);
	 //  button4.addActionListener(this);
	   button5.addActionListener(this);
	   this.setDefaultCloseOperation(WindowConstants.DISPOSE_ON_CLOSE);
       setBounds(150,150,300,300);
       setVisible(true);
       validate();
    }
   public void actionPerformed(ActionEvent e)
   {   
	   Connection con=null;
        Statement sql=null;
        ResultSet rs=null;
        if(e.getSource()==button1)
        {      	
           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);
	           
	                   text1.append("学号"+no+"  ");
	    	           text1.append("姓名"+name+"  ");
	    	           text1.append("英语"+english+"\n");
	               }
	                   con.close();
               }
          catch( SQLException  cc)
              {
	              System.out.println("mmmmmmmm");
               }
        }
        
        
        else if(e.getSource()==button2)
        {      	
            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 datastruction =rs.getString(3);
 	           
 	                   text1.append("学号"+no+"  ");
 	    	           text1.append("姓名"+name+"  ");
 	    	           text1.append("数据结构"+datastruction+"\n");
 	               }
 	                   con.close();
                }
           catch( SQLException  cc)
               {
 	              System.out.println("mmmmmmmm");
                }
         }	
        
        else if(e.getSource()==button3)
        {      	
            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 managerial =rs.getString(3);
 	           
 	                   text1.append("学号"+no+"  ");
 	    	           text1.append("姓名"+name+"  ");
 	    	           text1.append("管理学"+managerial+"\n");
 	               }
 	                   con.close();
                }
           catch( SQLException  cc)
               {
 	              System.out.println("mmmmmmmm");
                }
         }	
        
        
        else 
         {      	
             text1.setText(null);
          }	
   }
}

/*public class searchMarch
{   public static void main(String args[])
  { searchWindow2 win=new searchWindow2("分数查询");
	
   }
}*/