a0c77891f04f001d1594abca140770d0

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

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;
       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 name =rs.getString(5);
	            String sex =rs.getString(6);
  	            text1.append(+no);
  	            text2.append(+name);
  	            text3.append(+sex);
  	            text4.append(+deparment);
	            text5.append(+name);
	            text6.append(+sex);
  	        }
  	        con.close();
         }
       catch( SQLException  cc)
             {
  	        System.out.println("mmmmmmmm");
             }
      }
 	   
    }
	
}
/*public class studentMessage
{  public static void main(String args[])
   {  studentMess win=new studentMess("学生信息管理系统") ;
   }
}*/