10744a768b50001d1dc6bad43998f314

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

import java.awt.*;

import javax.swing.*;

import java.awt.event.*;
import java.sql.*;
class studentMess1 extends JFrame implements ActionListener
{   Button button1,button2,button3,button4;
    TextField text1,text2,text3,text4,text5,text6,text7;
    Label label1,label2,label3,label4,label5,label6,label7;
    studentMess1(String s)
    {
    	super(s);
    	setLayout(new FlowLayout());
 	    button1=new Button("修改");
        button2=new Button("确定");
        button3=new Button("添加");
        button4=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(20);
        add(label7);
        add(text7);
        
       
        add(button1);
        add(button2);
        add(button3);
        add(button4);
        button1.addActionListener(this);
        button2.addActionListener(this);
        button3.addActionListener(this);
        button4.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)
    {
    	if(e.getSource()==button1){
    		Connection con;
    		Statement sql;
    		ResultSet rs;
    		try{
    			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    		}catch(ClassNotFoundException k){
    			System.out.println(""+k);
    		}
    		try{
    			con=DriverManager.getConnection("jdbc:odbc:sun","","");
    	   	 	sql=con.createStatement();
    	   	 	String name,key,newkey,insertstr,recode;
    	   	 	name=text1.getText();
    	   	 	key=text2.getText();
    	   	 	newkey=text3.getText();
    	   	 	recode="("+"'"+name+"'"+","+"'"+key+")";
    	   	 	insertstr="INSERT INTO login VALUES"+recode;
    	   	 	sql.executeUpdate(insertstr);
    	   	 	con.close();
    		}catch(SQLException ee){
    			System.out.print(ee);
    		}
    	}
 	   
    }
	
}
/*public class SmessageManage
{  public static void main(String args[])
  {  studentMess1 win=new studentMess1("学生信息") ;
  }
}*/