30aba2cef24f001d1594abca140770d0

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

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 studentMess extends JFrame implements ActionListener
{   Button button1,button2;
    TextField text1,text2,text3,text4,text5,text6,text7;
    Label label1,label2,label3,label4,label5,label6,label7;
    studentMess(String s)
    {
    	super(s);
    	setLayout(new FlowLayout());
 	    button1=new Button("修改");
        button2=new Button("确定");
        label1 =new Label("学号");
        text1=new TextField(10);
        add(label1);
        add(text1);
        label2 =new Label("姓名");
        text2=new TextField(10);
        add(label2);
        add(text2);
        label3 =new Label("性别");
        text3=new TextField(10);
        add(label3);
        add(text3);
        label4 =new Label("系别");
        text4=new TextField(10);
        add(label4);
        add(text4);
        label5 =new Label("班级");
        text5=new TextField(6);
        add(label5);
        add(text5);
        label6 =new Label("出生年月");
        text6=new TextField(10);
        add(label6);
        add(text6);
        label7 =new Label("籍贯");
        text7=new TextField(10);
        add(label7);
        add(text7);
        add(button1);
        add(button2);
        button1.addActionListener(this);
        button2.addActionListener(this);
        text1.addActionListener(this);
        text2.addActionListener(this);
        text3.addActionListener(this);
        text4.addActionListener(this);
        text5.addActionListener(this);
        text6.addActionListener(this);
        text7.addActionListener(this);
        this.setDefaultCloseOperation(WindowConstants.DISPOSE_ON_CLOSE);
        setBounds(120,120,300,300);
        setVisible(true);
  	    validate();
    }
    public void actionPerformed(ActionEvent e)
    {
    	 Connection con=null;
         Statement sql=null;
         ResultSet rs=null;
         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 sex =rs.getString(3);
  	                     String deparment =rs.getString(4);
  	                     String banji =rs.getString(5);
  	                     String birthday =rs.getString(6);
	                     String nativeplace =rs.getString(7);
  	                     text1.setText(no);
  	                     text2.setText(name);
  	                     text3.setText(sex);
  	                     text4.setText(deparment);
	                     text5.setText(banji);
	                     text6.setText(birthday);
	                     text7.setText(nativeplace);
  	                  }
  	                     con.close();
                 }
              catch( SQLException  cc)
             {
  	                 System.out.println("mmmmmmmm");
             }
      }
 	   
    }
}	

/*public class studentMessage
{  public static void main(String args[])
   {  studentMess win=new studentMess("学生信息管理系统") ;
   }
}*/