30a82cf0e04f001d1594abca140770d0

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

import java.awt.*;
import java.sql.*;
import java.awt.event.*;
import java.util.*;
import javax.swing.*;
class markText1 extends JFrame implements ActionListener
{   TextArea text1;
    Label label1,label2,label3;
    Button buttonSure;
    markText1(String s) 
    { super(s);
      setLayout(new FlowLayout());
      text1=new TextArea(10,33);
      buttonSure=new Button("确定");
      label1 =new Label("学号");
      add(label1);
      label2 =new Label("姓名");
      add(label2);
      label3 =new Label("课程名");
      add(label3);
      add(text1);
      add(buttonSure); 
      this.setDefaultCloseOperation(WindowConstants.DISPOSE_ON_CLOSE);

      text1.setEditable(false);
      buttonSure.addActionListener(this);
      setBounds(100,100,350,300);
      setVisible(true);
      validate();
    }
    
    public void actionPerformed(ActionEvent e) 
    {   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);
    	            text1.append("学号"+no);
    	            text1.append("姓名"+name);
    	            text1.append("英语"+english);
    	            text1.append("数据结构"+datastruction);
    	            text1.append("管理学"+managerial);
    	            text1.append("              ");
    	            System.out.println();
    	       
    	        }
    	        con.close();
           }
         catch( SQLException  cc)
               {
    	        System.out.println("mmmmmmmm");
               }
       }
}
/*public class markText
{   public static void main(String args[])
    { markText1 win=new markText1("成绩表");
    }
} */