基于JAVA的学生成绩管理系统源代码(1)(3)

add(p,BorderLayout.NORTH); add(show,BorderLayout.CENTER); setBounds(10,30,500,200); setVisible(true); validate(); addWindowListener(new WindowAdapter(){ public void windowClosing(WindowEvent e){ dispose(); } }); } public void actionPerformed(ActionEvent ee) { boolean boo=true; s=input.getText(); k=Integer.parseInt(s); String m,dir; try { Class.forName(\ }

catch(ClassNotFoundException eee) { System.out.println(\ }

try { con=DriverManager.getConnection(\

sql=con.createStatement();

rs=sql.executeQuery(\ while(rs.next())

{int number=rs.getInt(2);

String name=rs.getString(3);

String date=rs.getString(\ int math=rs.getInt(\ int english=rs.getInt(\ if(number==k){ show.setText(\你删除了:\ show.append(\学号：\ 姓名：\ 出生：\

数学 \英语 \

show.append(\ m=\ sql.executeUpdate(m); } }

con.close(); }

catch(SQLException e) { System.out.println(e); }

} }

第六部分修改： import java.awt.*;

import java.awt.event.*; import java.sql.*;

import javax.swing.JOptionPane;

public class xiugai extends Frame implements TextListener,ActionListener{ Button charu; TextField input1,input2,input3,input4,input5,input6; TextArea show; Panel p1,p2; int k,s1,j; Connection con; Statement sql; int sum=0; ResultSet rs; xiugai(){ p1=new Panel(); p2=new Panel(); charu= new Button(\修改\ input1= new TextField(10); input2= new TextField(10); input3= new TextField(10); input4= new TextField(10); input5= new TextField(10); input6= new TextField(10); show= new TextArea(6,43); p1.add(new Label(\请输入要修改的学号\ p1.add(new Label(\ p1.add(input1); p2.add(new Label(\请输入修改的数据\ p2.add(new Label(\ p2.add(input2); p2.add(new Label(\ p2.add(input3); p2.add(new Label(\ p2.add(input4); p2.add(new Label(\ p2.add(input5); p2.add(charu);

charu.addActionListener(this); show.addTextListener(this); show.setEditable(false); add(p1,BorderLayout.NORTH); add(p2,BorderLayout.CENTER); setBounds(10,30,1200,200); setVisible(true); validate(); addWindowListener(new WindowAdapter(){ public void windowClosing(WindowEvent e){ dispose(); } }); } public void actionPerformed(ActionEvent ee) { boolean boo=true; String s0,s1,s2,s3,s4,s5,insert1,recode,name,date; int m0,m1,m2,m3,number,math,english; s1=input1.getText(); m1=Integer.parseInt(s1); number=m1; s4=input4.getText(); m2=Integer.parseInt(s4); math=m2; s5=input5.getText(); m3=Integer.parseInt(s5); english=m3; try { Class.forName(\ }

catch(ClassNotFoundException eee) { System.out.println(\ }

try { con=DriverManager.getConnection(\

sql=con.createStatement();

recode=\+english+\

insert1=\TE chengjibiao SET math=\

WHERE number=\

sql.executeUpdate(insert1); } catch(SQLException e)

{ System.out.println(e); } } }

第七部分添加： import java.awt.*;

import java.awt.event.*; import java.sql.*;

import javax.swing.JOptionPane;

public class charu extends Frame implements TextListener,ActionListener{ Button charu; TextField input1,input2,input3,input4,input5,input6; TextArea show; int k,s1,j; Connection con; Statement sql; int sum=0; ResultSet rs; charu(){ Panel p=new Panel(); charu= new Button(\插入\ input1= new TextField(10); input2= new TextField(10); input3= new TextField(10); input4= new TextField(10); input5= new TextField(10); input6= new TextField(10); show= new TextArea(6,43); p.add(new Label(\请输入要插入的数据\ p.add(new Label(\ p.add(input6); p.add(new Label(\ p.add(input1); p.add(new Label(\ p.add(input2); p.add(new Label(\ p.add(input3); p.add(new Label(\ p.add(input4); p.add(new Label(\ p.add(input5); p.add(charu);

charu.addActionListener(this); show.addTextListener(this); show.setEditable(false); add(p,BorderLayout.NORTH); add(show,BorderLayout.CENTER); setBounds(10,30,1200,200); setVisible(true); validate(); addWindowListener(new WindowAdapter(){ public void windowClosing(WindowEvent e){ dispose(); } }); } public void actionPerformed(ActionEvent ee) { boolean boo=true; String s0,s1,s2,s3,s4,s5,insert1,recode,name,date; int m0,m1,m2,m3,number,math,english; s0=input5.getText(); m0=Integer.parseInt(s0); s1=input1.getText(); m1=Integer.parseInt(s1); number=m1; s2=input2.getText(); name=s2; s3=input3.getText(); date=s3; s4=input4.getText(); m2=Integer.parseInt(s4); math=m2; s5=input5.getText(); m3=Integer.parseInt(s5); english=m3; try { Class.forName(\ }

catch(ClassNotFoundException eee) { System.out.println(\ }

try { con=DriverManager.getConnection(\ sql=con.createStatement();

recode=\+english+\

insert1=\ALUES \ sql.executeUpdate(insert1); show.setText(\你插入了:\