java学生成绩管理系统代码

1、JAVA学生成绩管理系统代码importjavax.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.sql.*;importjavax.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.awt.event.*;importjavax.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.sql.*;importjavax.swing.table.JTableHeader;importjavax.

2、swing.*;importjava.awt.*;importjava.awt.event.*;importjava.sql.*;importjavax.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.sql.*;importjavax.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.sql.*;importjavax.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.sql.*;impo

3、rtjavax.swing.table.DefaultTableModel;importjavax.swing.table.JTableHeader;importjavax.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.sql.*;classAddFormextendsJFrameimplementsActionListenerJLabellabName=newJLabel("学号:");JLabellabDate=newJLabel("出生日期:");JLabellabScore=

4、newJLabel("成绩:");JTextFieldtxtName=newJTextField(20);JTextFieldtxtDate=newJTextField(18);JTextFieldtxtScore=newJTextField(20);JButtonbtnOk=newJButton("确定");JButtonbtnClear=newJButton("清空");JPanelpan=newJPanel();JPanelpan1=newJPanel();JPanelpan2=newJPanel();JPanelpan3=ne

5、wJPanel();JPanelpan4=newJPanel();Connectioncnn;Statementstm;ResultSetrs;AddForm()super("添加数据");setSize(400,300);setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);pan.setBorder(BorderFactory.createEtchedBorder();pan1.add(labName);pan1.add(txtName);pan2.add(labDate);pan2.add(txtDate);pan3.ad

6、d(labScore);pan3.add(txtScore);pan4.add(btnOk);pan4.add(btnClear);pan.setLayout(newGridLayout(3,1);pan.add(pan1);pan.add(pan2);pan.add(pan3);getContentPane().add(pan,"Center");getContentPane().add(pan4,"South");btnOk.addActionListener(this);btnClear.addActionListener(this);setVis

7、ible(true);txtName.requestFocus();publicvoidactionPerformed(ActionEventae)if(ae.getSource()=btnClear)txtName.setText("");txtDate.setText("");txtScore.setText("");txtName.requestFocus();elseif(ae.getSource()=btnOk)StringstrName=txtName.getText();StringstrDate=txtDate.get

8、Text();StringstrScore=txtScore.getText();if(strName.equals("")","警告JOptionPane.showMessageDialog(this,"学号不能为空?",JOptionPane.ERROR_MESSAGE);elseif(strDate.equals("")JOptionPane.showMessageDialog(this,"出生日期不能为空?","警告",JOptionPane.ERROR_MESSAG

9、E);elsJOptionPane.showMessageDialog(this,"成绩不能为空?","警告",JOptionPane.ERROR_MESSAGE);elsetryClass.forName("sun.jdbc.odbc.JdbcOdbcDriver");catch(ClassNotFoundExceptionex)ex.printStackTrace();trycnn=DriverManager.getConnection("Jdbc:Odbc:MyDB");stm=cnn.createState

10、ment();catch(SQLExceptionex)ex.printStackTrace();tryrs=stm.executeQuery("select*from成绩表where学号='"+strName+"'");if(rs.next()JOptionPane.showMessageDialog(this,"对不起，该成绩信息已存在?");else/否则插入记录/System.out.println("insertinto成绩表values('"+strName+"'

11、;,#"+strDate+"#,"+strScore+")");stm.executeUpdate("insertinto成绩表values('"+strName+"','"+strDate+"',"+strScore+")");JOptionPane.showMessageDialog(null,"记录已经成功添加?");/断开连接stm.close();cnn.close();catch(SQLExceptio

12、nex)System.out.println("SQLException:"+ex.getMessage();publicstaticvoidmain(Stringargs)newAddForm();classBrowseFormextendsJFrameStringstr="学号","出生日期","成绩"Objectdata;JTabletable;JTableHeaderhead;JScrollPanejsp;Connectionconn;Statementstmt;ResultSetrs;BrowseForm

13、()super("浏览数据");setSize(400,300);inti=0,j=0;introw;tryClass.forName("sun.jdbc.odbc.JdbcOdbcDriver");conn=DriverManager.getConnection("jdbc:odbc:MyDB",):stmt=conn.createStatement();rs=stmt.executeQuery("selectCOUNT(*)asafrom成绩表");rs.next();row=rs.getInt("a

14、");rs.close();data=newObjectrow3;rs=stmt.executeQuery("select*from成绩表");while(rs.next()dataij+=rs.getString("学号");dataij+=rs.getDate("出生日期");dataij=newInteger(rs.getInt("成绩");i+;j=0;table=newJTable(data,str);head=table.getTableHeader();jsp=newJScrollPane(

15、table);getContentPane().add(head,"North");getContentPane().add(jsp,"Center");rs.close();stmt.close();catch(Exceptione)e.printStackTrace();setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);setVisible(true);publicstaticvoidmain(Stringargs)newBrowseForm();classDeleteFormextendsJFram

16、eimplementsActionListenerJLabellabName=newJLabel("学号:");JLabellabDate=newJLabel("出生日期:");JLabellabScore=newJLabel("成绩:");JTextFieldtxtName=newJTextField(20);JTextFieldtxtDate=newJTextField(18);JTextFieldtxtScore=newJTextField(20);JButtonbtnDel=newJButton("删除")

17、;JButtonbtnCancel=newJButton("取消");JButtonbtnQuery=newJButton("查询");JPanelpan=newJPanel();JPanelpan1=newJPanel();JPanelpan2=newJPanel();JPanelpan3=newJPanel();JPanelpan4=newJPanel();Connectioncnn;Statementstm;ResultSetrs;DeleteForm()super("删除数据");setSize(400,300);setDef

18、aultCloseOperation(JFrame.DISPOSE_ON_CLOSE);pan.setBorder(BorderFactory.createEtchedBorder();pan1.add(labName);pan1.add(txtName);pan2.add(labDate);pan2.add(txtDate);pan3.add(labScore);pan3.add(txtScore);pan4.add(btnQuery);pan4.add(btnDel);pan4.add(btnCancel);pan.setLayout(newGridLayout(3,1);pan.add(

19、pan1);pan.add(pan2);pan.add(pan3);getContentPane().add(pan,"Center");getContentPane().add(pan4,"South");btnQuery.addActionListener(this);btnDel.addActionListener(this);btnCancel.addActionListener(this);btnDel.setEnabled(false);txtDate.setEditable(false);txtScore.setEditable(false

20、);setVisible(true);txtName.requestFocus();publicvoidactionPerformed(ActionEventae)/*if(ae.getSource()=btnCancel)tryif(stm!=null)stm.close();if(cnn!=null)cnn.close();catch(SQLExceptionex)ex.printStackTrace();this.dispose();elseif(ae.getSource()=btnQuery)tryClass.forName("sun.jdbc.odbc.JdbcOdbcDr

21、iver");cnn=DriverManager.getConnection("jdbc:odbc:MyDB","","");stm=cnn.createStatement();rs=stm.executeQuery("select*from成绩表where学号='"+txtName.getText()+"'");if(rs.next()txtName.setText(rs.getString("学号");txtDate.setText(rs.get

22、Date("出生日期").toString();txtScore.setText(newInteger(rs.getInt("成绩").toString();btnDel.setEnabled(true);elseJOptionbtnDel.setEnabled(false);txtName.setText("");txtScore.setText("");txtDate.setText("");catch(Exceptione)e.printStackTrace();elseif(ae.get

23、Source()=btnDel)tryif(JOptionPane.YES_OPTION=JOptionPane.showConfirmDialog(this,"确定要删除该记录,","信息",JOptionPane.YES_NO_OPTION)stm.executeUpdate("deletefrom成绩表where学号='"+txtName.getText()+"'");btnDel.setEnabled(false);txtName.setText("");txtScore

24、.setText("");txtDate.setText("");catch(SQLExceptionex)ex.printStackTrace();*/publicstaticvoidmain(Stringargs)newDeleteForm();classLoginFormextendsJFrameimplementsActionListenerJLabellabName=newJLabel("姓名");JLabellabPwd=newJLabel("密码");JTextFieldtxtName=newJTex

25、tField(20);JPasswordFieldtxtPwd=newJPasswordField(20);JButtonbtnOk=newJButton("确定");JButtonbtnCancel=newJButton("取消");JPanelpan=newJPanel();JPanelpan1=newJPanel();JPanelpan2=newJPanel();JPanelpan3=newJPanel();JPanelpan4=newJPanel();Connectioncnn;Statementstm;ResultSetrs;LoginForm

26、()super("用户登录");setSize(300,200);setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);pan.setBorder(BorderFactory.createTitledBorder("登录");pan.setLayout(newGridLayout(2,1);pan1.add(labName);pan1.add(txtName);pan2.add(labPwd);pan2.add(txtPwd);pan.add(pan1);pan.add(pan2);pan3.add(btnO

27、k);pan3.add(btnCancel);pan4.add(pan);getContentPane().add(pan4,"Center");getContentPane().add(pan3,"South");txtName.addActionListener(this);txtPwd.addActionListener(this);btnOk.addActionListener(this);btnCancel.addActionListener(this);setVisible(true);tryClass.forName("sun.j

28、dbc.odbc.JdbcOdbcDriver");catch(ClassNotFoundExceptionex)ex.printStackTrace();trycnn=DriverManager.getConnection("Jdbc:Odbc:MyDB");stm=cnn.createStatement();catch(SQLExceptionex)ex.printStackTrace();txtName.requestFocus();publicvoidactionPerformed(ActionEventae)if(ae.getSource()=txtNa

29、me)txtPwd.requestFocus();elseif(ae.getSource()=txtPwd)btnOk.requestFocus();elstxtName.setText("");txtPwd.setText("");txtName.requestFocus();elseif(ae.getSource()=btnOk)Stringstr="select*from用户表where用户名='"+txtName.getText()+"'and密码='"+newString(txtP

30、wd.getPassword()+"'"tryrs=stm.executeQuery(str);catch(SQLExceptionex)ex.printStackTrace();tryif(rs.next()JOptionPane.showMessageDialog(this,"验证通过!","信息",JOptionPane.INFORMATION_MESSAGE);rs.close();stm.close();cnn.close();newMainForm().setVisible(true);this.dispose()

31、;elseJOptionPane.showMessageDialog(this,"用户名或密码不正确!","信息",JOptionPane.INFORMATION_MESSAGE);catch(SQLExceptionex)ex.printStackTrace();publicstaticvoidmain(Stringargs)newLoginForm();classModifyFormextendsJFrameimplementsActionListenerJLabellabName=newJLabel("学号:");JLabell

32、abDate=newJLabel("出生日期:");JLabellabScore=newJLabel("成绩:");JTextFieldtxtName=newJTextField(20);JTextFieldtxtDate=newJTextField(18);JTextFieldtxtScore=newJTextField(20);JButtonbtnModify=newJButton("修改");JButtonbtnCancel=newJButton("取消");JButtonbtnQuery=newJButto

33、n("查询");JPanelpan=newJPanel();JPanelpan1=newJPanel();JPanelpan2=newJPanel();JPanelpan3=newJPanel();JPanelpan4=newJPanel();Connectioncnn;Statementstm;ResultSetrs;ModifyForm()super("修改数据");setSize(400,300);setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);pan.setBorder(BorderFactor

34、y.createEtchedBorder();pan1.add(labName);pan1.add(txtName);pan2.add(labDate);pan2.add(txtDate);pan3.add(labScore);pan3.add(txtScore);pan4.add(btnQuery);pan4.add(btnModify);pan4.add(btnCancel);pan.setLayout(newGridLayout(3,1);pan.add(pan1);pan.add(pan2);pan.add(pan3);getContentPane().add(pan,"Ce

35、nter");getContentPane().add(pan4,"South");btnQuery.addActionListener(this);btnModify.addActionListener(this);btnCancel.addActionListener(this);btnModify.setEnabled(false);txtDate.setEditable(false);txtScore.setEditable(false);setVisible(true);txtName.requestFocus();publicvoidactionPer

36、formed(ActionEventae)if(ae.getSource()=btnCancel)tryif(sstm.close();if(cnn!=null)cnn.close();catch(SQLExceptionex)ex.printStackTrace();this.dispose();elseif(ae.getSource()=btnQuery)tryClass.forName("sun.jdbc.odbc.JdbcOdbcDriver");cnn=DriverManager.getConnection("jdbc:odbc:MyDB",&

37、quot;","");stm=cnn.createStatement();rs=stm.executeQuery("select*from='"+txtName.getText()+"'");if(rs.next()txtName.setText(rs.getString("学号");成绩表 where 学号成绩 ").toString();txtScore.setText(newInteger(rs.getInt(txtDate.setText(rs.getDate("

38、;出生日期").toString();btnModify.setEnabled(true);txtDate.setEditable(true);txtScore.setEditable(true);elseJOptionPane.showMessageDialog(this,"不存在该记录?");btnModify.setEnabled(false);txtName.setText("");txtScore.setText("");txtDate.setText("");txtDate.setEditab

39、le(false);txtScore.setEditable(false);catch(Exceptione)e.printStackTrace();elseif(ae.getSource()=btnModify)trySystem.out.println("Update=#"+txtDate.getText()+"#,='"+txtName.getText()+"'");stm.executeUpdate("Update=#"+txtDate.getText()+"#,成绩表 set 出

40、生日期成绩 ="+txtScore.getText()+ where成绩表 set 出生日期学号学号成绩="+txtScore.getText()+where='"+txtName.getText()+"'");JOptionPane.showMessageDialog(this,"记录修改完毕?");btnModify.setEnabled(false);txtName.setText("");txtScore.setText("");txtDate.setText(

41、"");txtDate.setEditable(false);txtScore.setEditable(false);stm.close();cnn.close();catch(Exceptione)e.printStackTrace();publicstaticvoidmain(Stringargs)newModifyForm();classNumberQueryFormextendsJFrameimplementsActionListenerJLabellabName=newJLabel("学号:");JLabellabDate=newJLabel(

42、"出生日期:");JLabellabScore=newJLabel("成绩:");JTextFieldtxtName=newJTextField(20);JTextFieldtxtDate=newJTextField(18);JTextFieldtxtScore=newJTextField(20);JButtonbtnCancel=newJButton("取消");JButtonbtnQuery=newJButton("查询");JPanelpan=newJPanel();JPanelpan1=newJPanel(

43、);JPanelpan2=newJPanel();JPanelpan3=newJPanel()JPanelpan4=newJPanel();Connectioncnn;Statementstm;ResultSetrs;NumberQueryForm()super("按学号查询");setSize(400,300);setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);pan.setBorder(BorderFactory.createEtchedBorder();pan1.add(labName);pan1.add(txtNam

44、e);pan2.add(labDate);pan2.add(txtDate);pan3.add(labScore);pan3.add(txtScore);pan4.add(btnQuery);pan4.add(btnCancel);pan.setLayout(newGridLayout(3,1);pan.add(pan1);pan.add(pan2);pan.add(pan3);getContentPane().add(pan,"Center");getContentPane().add(pan4,"South");btnQuery.addActionL

45、istener(this);btnCancel.addActionListener(this);txtDate.setEditable(false);txtScore.setEditable(false);setVisible(true);txtName.requestFocus();publicvoidactionPerformed(ActionEventae)if(ae.getSource()=btnCancel)tryif(stm!=null)stm.close();if(cnn!=null)cnn.close();catch(SQLExceptionex)ex.printStackTr

46、ace();this.dispose();elseif(ae.getSource()=btnQuery)tryClass.forName("sun.jdbc.odbc.JdbcOdbcDriver");cnn=DriverManager.getConnection("jdbc:odbc:MyDB","","");stm=cnn.createStatement();rs=stm.executeQuery("select*from成绩表where学号='"+txtName.getText()

47、+"'");if(rs.next()txtName.setText(rs.getString("学号");txtScore.setText(newInteger(rs.getInt("成绩").toString();txtDate.setText(rs.getDate("出生日期").toString();elseJOptionPane.showMessageDialog(this,"不存在该记录?");txtName.setText("");txtScore.set

48、Text("");txtDate.setText("");txtName.requestFocus();catch(Exceptione)e.printStackTrace();publicstaticvoidmain(Stringargs)newNumberQueryForm();classScoreQueryFormextendsJFrameimplementsActionListenerJLabellabScore=newJLabel("请输入成绩:");JTextFieldtxtScore=newJTextField(10);

49、JButtonbtnQuery=newJButton("查询");JPanelpan1=newJPanel();JPanelpan2=newJPanel();Stringstr="学号","出生日期","成绩"Objectdata=newObject103;JTabletable=newJTable(data,str);JTableHeaderhead=table.getTableHeader();JScrollPanejsp=newJScrollPane(table);Connectionconn;Stateme

50、ntstmt;ResultSetrs;Scosuper("按成绩查询");setSize(400,300);pan1.add(labScore);pan1.add(txtScore);pan1.add(btnQuery);getContentPane().add(pan1,"North");table=newJTable(data,str);pan2.setLayout(newBorderLayout();head=table.getTableHeader();jsp=newJScrollPane(table);pan2.add(head,"N

51、orth");pan2.add(jsp,"Center");getContentPane().add(pan2,"Center");btnQuery.addActionListener(this);setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);setVisible(true);publicvoidactionPerformed(ActionEventae)if(ae.getSource()=btnQuery)inti,j,row;tryClass.forName("sun.jdbc

52、.odbc.JdbcOdbcDriver");conn=DriverManager.getConnection("jdbc:odbc:MyDB","","");stmt=conn.createStatement();rs=stmt.executeQuery("selectCOUNT(*)asrowcountfrom成绩表where成绩="+txtScore.getText();rs.next();row=rs.getInt("rowcount");rs.close();data=new

53、Objectrow3;rs=stmt.executeQuery("select*from成绩表where成绩="+txtScore.getText();i=0;j=0;while(rs.next()dataij+=rs.getString("学号");dataij+=rs.getDate("出生日期");dataij=newInteger(rs.getInt("成绩");i+;j=0;pan2.removeAll();getContentPane().remove(pan2);table=newJTable(dat

54、a,str);pan2.setLayout(newBorderLayout();head=table.getTableHeader();jsp=newJScrollPane(table);pan2.add(head,"North");pan2.add(jsp,"Center");getContentPane().add(pan2,"Center");this.validate();rs.close();stmt.close();conn.close();catch(Exceptione)e.printStackTrace();publicstaticvoidmain(Stringargs)newScoreQueryForm();classMyPanelextendsJPanelImageimg=Toolkit.getDefaultToolkit().getImage("c:/a.jpg");publicvoidpaint(Graphicsg)g.drawImage(img,0,