0031cba0b050001d1dc6bad43998f314

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

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 MyPanel extends JPanel{
	JButton button1,button2,button3;
	JTextField text1,text2;
	JLabel label1,label2;
	MyPanel(){
		text1=new JTextField(15);
		text2=new JTextField(15);
 	    button1=new JButton("修改");
        //button2=new Button("确定");
        button2=new JButton("添加");
        button3=new JButton("删除");
        label1=new JLabel("请输入需要学号");
        label2=new JLabel("请输出需要修改的科目");
        add(label1);
        add(text1);
        add(label2);
        add(text2);
        add(button1);
        add(button2);
        add(button3);
	}
}
class markMess2 extends JFrame implements ActionListener
{   MyPanel panel1;
	JPanel panel;
    Label label1,label2,label3;
    TextArea text;
    Container con;
    markMess2(String s)
    {
    	super(s);
    	setLayout(new FlowLayout());
    	/*text=new TextArea();
        label1 =new Label("学号");
        add(label1);
        label2 =new Label("课程名");
        add(label2);
        label3 =new Label("分数");
        add(label3);
        add(text);*/
        panel.add(label1);
        panel.add(label2);
        panel.add(label3);
        panel.add(text);
        panel1.button1.addActionListener(this);
        panel1.button2.addActionListener(this);
        panel1.button3.addActionListener(this);
        con.add(panel,BorderLayout.NORTH);
        con.add(panel1,BorderLayout.SOUTH);
        this.setDefaultCloseOperation(WindowConstants.DISPOSE_ON_CLOSE);
        setBounds(120,120,300,300);
        setVisible(true);
  	    validate();
    }
    public void actionPerformed(ActionEvent e)
    {
 	   if(e.getSource()==panel1.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 no,bra,updatestr;
 			   no=panel1.text1.getText();  	
 			   bra=panel1.text2.getText();
 			   updatestr="UPDATE login SET  = '" + bra+ "' WHERE no='" + no + "'";
 			   System.out.println(updatestr);
 			   sql.executeUpdate(updatestr);
 			   con.close();
  			}catch(SQLException ee){
  				System.out.print(ee);
  			}
 	   }
    }
	
}
/*public class MmessageManage
{  public static void main(String args[])
{  markMess2 win=new markMess2("成绩管理") ;
 }
}*/