java学生成绩管理系统源码

1、word范文文件addmessage.java代码：importjava.awt.*;importjava.awt.event.*;importjava.sql.*;importjava.util.*;importjavax.swing.*;importjavax.swing.table.*;classaddmessageextendsJFrameimplementsActionListenerJTextFieldt1,t2,t3,t4,t5;JTabletable;JButtonbut1;JLabellab1,lab2,lab3,lab4,lab5;JPanelp1;addmessage()

2、super(增加)；setBounds(350,100,470,400);setLayout(newGridLayout(1,1,10,10)；p1=newJPanel()；lab1=newJLabel(学号);t1=newJTextField(10);lab2=newJLabel(姓名)；t2=newJTextField(10);lab3=newJLabel(课程名);t3=newJTextField(10);lab4=newJLabel(状态)；t4=newJTextField(10);lab5=newJLabel(成绩)；t5=newJTextField(10);butl=newJBut

3、ton(添加)；but1.addActionListener(this);p1.add(lab1);p1.add(t1);p1.add(lab2);p1.add(t2);p1.add(lab3);p1.add(t3);p1.add(lab4);p1.add(t4);p1.add(lab5);p1.add(t5);p1.add(but1);add(p1);setVisible(true);publicvoidactionPerformed(ActionEvente)inti=0;Stringsql1=null,sql2=null,update=null;Stringurl=jdbc:mysql:

4、/localhost:3306/学生成绩系统；Connectioncon;Statementstmt;tryClass.forName(org.gjt.mm.mysql.Driver);catch(java.lang.ClassNotFoundExceptione1)System.err.println(ClassNotFoundException:+e1.getMessage();if(e.getSource()=but1)/添加trycon=DriverManager.getConnection(url,root,123);stmt=con.createStatement();sql1=I

5、NSERTINTO学生成绩表VALUES(+t1.getText()+,+t2.getText()+,+t3.getText()+,+t4.getText()+,+t5.getText()+);Stringnum1=t1.getText();Stringnum2=t1.getText();Stringsele=select*from学生成绩表where学号=+numl+and课程名=+num2+;ResultSetrs=stmt.executeQuery(sele);if(rs.next()JOptionPane.showMessageDialog(this,已有该条记录，请核实！);else

6、stmt.executeUpdate(sqll);JOptionPane.showMessageDialog(this,添加成功!);tl.setText();t2.setText();t3.setText();t4.setText();t5.setText();stmt.close();con.close();catch(SQLExceptionex)System.err.println(SQLException:+ex.getMessage();文件deletemessage.java代码importjava.awt.*;importjava.awt.event.*;importjava.

7、sql.*;importjava.util.*;importjavax.swing.*;importjavax.swing.table.*;classdeletemessageextendsJFrameimplementsActionListenerJTextFieldt1,t2,t3;JTabletable;JButtonbut1;JLabellab1,lab2,lab3;JPanelp1;deletemessage()super(删除);setBounds(350,100,470,400);setLayout(newGridLayout(1,1,10,10);p1=newJPanel();

8、lab1=newJLabel(学号);t1=newJTextField(10);lab2=newJLabel(姓名)；t2=newJTextField(10);lab3=newJLabel(课程名);t3=newJTextField(10);but1=newJButton(删除);but1.addActionListener(this);p1.add(lab1);p1.add(t1);p1.add(lab2);p1.add(t2);p1.add(lab3);p1.add(t3);p1.add(but1);add(p1);setVisible(true);publicvoidactionPerf

9、ormed(ActionEvente)Stringsql1=null,sql2=null;Stringurl=jdbc:mysql:/localhost:3306/学生成绩系统；Connectioncon;Statementstmt;tryClass.forName(org.gjt.mm.mysql.Driver);catch(java.lang.ClassNotFoundExceptione1)System.err.println(ClassNotFoundException:+e1.getMessage();if(e.getSource()=but1)/删除tryStringnum1=t1

10、.getText();Stringnum2=t2.getText();Stringnum3=t3.getText();sql2=deletefrom学生成绩表where学号=+num1+and课程名=+num3+;con=DriverManager.getConnection(url,root,123);stmt=con.createStatement();sql1=select*from学生成绩表where学号=+num1+and姓名=+num2+and课程名=+num3+;ResultSetrs=stmt.executeQuery(sql1);if(rs.next()stmt.execut

11、eUpdate(sql2);JOptionPane.showMessageDialog(this,删除成功!);elseJOptionPane.showMessageDialog(this,没有此条记录!请重新输入);t1.setText();stmt.close();con.close();catch(SQLExceptionex)System.err.println(SQLException:+ex.getMessage();文件entry.java代码importjava.awt.*;importjava.awt.event.*;importjava.sql.*;importjavax.

12、swing.*;classentryextendsJFrameimplementsActionListenerintflag=1;Stringuser,pass;JPanelpa;JLabellab1,lab2;JTextFieldtf1;JPasswordFieldtf2;JButtonbtu1,btu2;JPanelpa1,pa2,pa4;entry()super(学生成绩管系统);setBounds(400,200,400,300);GridBagLayoutgbL=newGridBagLayout();GridBagConstraintsgbc=newGridBagConstraint

13、s();setLayout(gbL);gbc.fill=GridBagConstraints.HORIZONTAL;gbc.anchor=GridBagConstraints.CENTER;lab1=newJLabel(请输入帐号”)；lab2=newJLabel(请输入密码”)；tf2=newJPasswordField(10)；tf2.setEchoChar(*)；tf1=newJTextField(10)；tf1.addActionListener(this)；pa1=newJPanel()；pa1.add(lab1)；pa1.add(tf1)；gbc.gridx=1；gbc.gridy

14、=1；gbc.insets=newInsets(2,5,0,5)；gbL.setConstraints(pa1,gbc)；add(pa1)；tf2.addActionListener(this)；pa2=newJPanel()；pa2.add(lab2)；pa2.add(tf2)；gbc.gridx=1；gbc.gridy=2；gbc.insets=newInsets(2,5,2,5)；gbL.setConstraints(pa2,gbc)；add(pa2)；btul=newJButton(确定)；btu1.addActionListener(this);btu2=newJButton(退出)

15、;btu2.addActionListener(this)；pa4=newJPanel();pa4.add(btu1);pa4.add(btu2);gbc.gridx=1;gbc.gridy=4;gbc.insets=newInsets(2,5,2,5);gbL.setConstraints(pa4,gbc);add(pa4);publicvoidactionPerformed(ActionEvente)loginsurels;if(e.getSource()=btu1)user=tf1.getText();pass=tf2.getText();tryls=newloginsure(user,

16、pass);this.setVisible(false);catch(SQLExceptione1)e1.printStackTrace();catch(ClassNotFoundExceptione1)e1.printStackTrace();if(e.getSource()=btu2)dispose();System.exit(0);classloginsureinti=0;throwsStringname=null,pwd=null,ustype=null;publicloginsure(Strings,Stringa)SQLException,ClassNotFoundExceptio

17、nStringdriver=org.gjt.mm.mysql.Driver;Class.forName(driver);StringURL=jdbc:mysql:/localhost:3306/学生成绩系统；Connectionconn=DriverManager.getConnection(URL,root,123);Statementstmt=conn.createStatement();ResultSetrs=stmt.executeQuery(select*from用户管表);while(rs.next()name=rs.getString(用户名).trim();pwd=rs.get

18、String(密码).trim();ustype=rs.getString(权限组).trim();if(s.equals(name)&a.equals(pwd)i=1;if(ustype.trim().equals(管员)teachertea=newteacher();tea.setVisible(true);if(ustype.trim().equals(学生)studentstu=newstudent(name);stu.setVisible(true);if(i=0)JOptionPane.showMessageDialog(null,用户名或者密码错误,警告,JOptionPane.

19、WARNING_MESSAGE);stmt.close();conn.close();文件inquiry.java代码importjava.awt.*;importjava.awt.event.*;importjava.sql.*;importjava.util.*;importjavax.swing.*;importjavax.swing.table.*;classinquiryextendsJFrameimplementsActionListenerJTextFieldt1;JTabletable;JButtonbut1;JLabellab1;JPanelp1;JTabletable1=n

20、ull;DefaultTableModeldemod1=null;Stringn=课程名，状态，成绩;Stringdata=newString00;StringNo;inquiry(Stringno)super(成绩);No=no;setBounds(350，100，470，400);p1=newJPanel();lab1=newJLabel(课程名);tl=newJTextField(10);but1=newJButton(查询成绩”);but1.addActionListener(this);p1.add(lab1);p1.add(t1);p1.add(but1);demod1=newDe

21、faultTableModel(data，n);table1=newJTable(demod1);JScrollPanes1=newJScrollPane(table1);p1.add(s1);add(p1);setVisible(true);publicvoidactionPerformed(ActionEvente)inti=0;Stringsql1;Stringurl=jdbc:mysql:/localhost:3306/学生成绩系统；Connectioncon;Statementstmt;tryClass.forName(org.gjt.mm.mysql.Driver);catch(j

22、ava.lang.ClassNotFoundExceptione1)System.err.println(ClassNotFoundException:+e1.getMessage();if(e.getSource()=but1)tryStringnum=t1.getText();sqll=select*from学生成绩表where学号=+No+;if(!num.equals()sqll=select*from学生成绩表where课程名=+num+and学号=+No+;con=DriverManager.getConnection(url,root,123);stmt=con.createSt

23、atement();ResultSetrs=stmt.executeQuery(sql1);removeAllRecord();while(rs.next()Vectordata=newVector();data.addElement(rs.getString(3);data.addElement(rs.getString(4);data.addElement(rs.getString(5);demod1.addRow(data);i=1;if(i=0)JOptionPane.showMessageDialog(this,没有此课程!请重新输入);table1.revalidate();t1.

24、setText();stmt.close();con.close();catch(SQLExceptionex)System.err.println(SQLException:+ex.getMessage();publicvoidremoveAllRecord()/将界面上的所有记录清空introwcount;while(true)/删除所有存在的rowcount=demod1.getRowCount()-1;if(rowcount=0)demod1.removeRow(rowcount);demod1.setRowCount(rowcount);elsebreak;文件main.java代码

25、importjava.awt.*;importjava.awt.event.*;importjava.sql.*;importjava.util.*;importjavax.swing.*;publicclassmainpublicstaticvoidmain(Stringargs)entryent=newentry();ent.setVisible(true);ent.setResizable(false);文件record.java代码importjava.awt.*;importjava.awt.event.*;importjava.sql.*;importjava.util.*;imp

26、ortjavax.swing.*;importjavax.swing.table.*;classrecordextendsJFrameimplementsActionListenerJTextFieldt1;TextAreat;JButtonbut1;JLabelL1;JPanelp1;JTabletable1=null;DefaultTableModeldemod1=null;Stringn=平均成绩，优秀，好，及格;Stringdata=newString00;publicrecord()super(统计);setBounds(350，30，470，610);setLayout(newGr

27、idLayout(1，1，10，10);p1=newJPanel();L1=newJLabel(课程名);but1=newJButton(查询);but1.addActionListener(this);t1=newJTextField(10);p1.add(L1);p1.add(t1);p1.add(but1);demod1=newDefaultTableModel(data，n);table1=newJTable(demod1);JScrollPanes1=newJScrollPane(table1);p1.add(s1);add(p1);setVisible(true);publicvo

28、idactionPerformed(ActionEvente)inti=0;Stringsql1;Stringsql2;Stringurl=jdbc:mysql:/localhost:3306/学生成绩系统；Connectioncon;Statementstmt;tryClass.forName(org.gjt.mm.mysql.Driver);catch(java.lang.ClassNotFoundExceptione1)System.err.println(ClassNotFoundException:+e1.getMessage();if(e.getSource()=but1)tryS

29、tringnum1=t1.getText();if(num1.equals()JOptionPane.showMessageDialog(this,学号能为空,请输入学号！，JOptionPane.WARNING_MESSAGE);elsesql1=select*from学生成绩表where学号=+num1+;sqll=selectavg(成绩)from学生成绩表where课程名=+numl+;sql2=selectcount(*)from学生成绩表where课程名=+numl+and成绩=90;con=DriverManager.getConnection(url，root，l23);stm

30、t=con.createStatement();ResultSetrs=stmt.executeQuery(sqll);removeAllRecord();while(rs.next()Vectordata=newVector();data.addElement(rs.getInt(l);/*data.addElement(rs.getString(3);data.addElement(rs.getString(4);data.addElement(rs.getString(5);*/demodl.addRow(data);i=l;rs=stmt.executeQuery(sql2);whil

31、e(rs.next()intn=rs.getInt(l);System.out.println(n);if(i=0)JOptionPane.showMessageDialog(this，没有此条记录!请重新输入);tablel.revalidate();tl.setText();stmt.close();con.close();catch(SQLExceptionex)System.err.println(SQLException:+ex.getMessage();publicvoidremoveAllRecord()/将界面上的所有记录清空introwcount;while(true)/删除

32、所有存在的rowcount=demod1.getRowCount()-1;if(rowcount=0)demod1.removeRow(rowcount);demod1.setRowCount(rowcount);elsebreak;文件revise.java代码importjava.awt.*;importjava.awt.event.*;importjava.sql.*;importjava.util.*;importjavax.swing.*;importjavax.swing.table.*;classreviseextendsJFrameimplementsActionListene

33、rJTextFieldt1,t2,t3,t4,t5;JTabletable;JButtonbut1;JLabellab1,lab2,lab3,lab4,lab5;JPanelp1;intn=0;revise()super(修改”)；setBounds(350,100,470,400);setLayout(newGridLayout(1,1,10,10)；p1=newJPanel()；lab1=newJLabel(学号);tl=newJTextField(10);lab2=newJLabel(姓名)；t2=newJTextField(10);lab3=newJLabel(课程名);t3=newJ

34、TextField(10);lab4=newJLabel(状态)；t4=newJTextField(10);lab5=newJLabel(成绩)；t5=newJTextField(10);but1=newJButton(修改);but1.addActionListener(this);p1.add(lab1);p1.add(t1);p1.add(lab2);p1.add(t2);p1.add(lab3);p1.add(t3);p1.add(lab4);p1.add(t4);p1.add(lab5);p1.add(t5);p1.add(but1);add(p1);setVisible(true)

35、;publicvoidactionPerformed(ActionEvente)Stringsql1=null,update=null;Stringurl=jdbc:mysql:/localhost:3306/学生成绩系统；Connectioncon;Statementstmt;tryClass.forName(org.gjt.mm.mysql.Driver);catch(java.lang.ClassNotFoundExceptione1)System.err.println(ClassNotFoundException:+e1.getMessage();if(e.getSource()=b

36、ut1)/修改tryStringnum1=t3.getText();Stringnum2=t1.getText();/Stringnum3=t5.getText();n=Integer.valueOf(t5.getText().intValue();System.out.print(n);con=DriverManager.getConnection(url,root,123);stmt=con.createStatement();sql1=select*from学生成绩表where学号=+num2+and课程名=+num1+;update=update学生成绩表set课程名=+t3.getT

37、ext()+,状态=+t4.getText()+,成绩=+n+where学号=+num2+;ResultSetrs=stmt.executeQuery(sql1);if(rs.next()stmt.executeUpdate(update);JOptionPane.showMessageDialog(this,修改成功!);elseJOptionPane.showMessageDialog(this,没有此条记录!请重新输入);t1.setText();t2.setText();t3.setText();t4.setText();t5.setText();stmt.close();con.cl

38、ose();catch(SQLExceptionex)System.err.println(SQLException:+ex.getMessage();文件student.java代码importjava.awt.*;importjava.awt.event.*;importjava.sql.*;importjava.util.*;importjavax.swing.*;classstudentextendsJFrameimplementsActionListenerinquirycho;JMenuBarmb;JMenum1;JMenuItemmt1,mt2;StringNo;Iconicon

39、;JLabellab;student(Stringno)super(学生)；icon=newImageIcon(123.jpg);lab=newJLabel(icon);add(lab);No=no;setBounds(130,10,800,500);JMenuBarmb=newJMenuBar();setJMenuBar(mb);m1=newJMenu(操作);mt1=newJMenuItem(查询成绩”)；mt2=newJMenuItem(退出);m1.add(mt1);mt1.addActionListener(this);m1.addSeparator();m1.add(mt2);mt

40、2.addActionListener(this);m1.addActionListener(this);mb.add(m1);publicvoidactionPerformed(ActionEvente)if(e.getSource()=mt1)cho=newinquiry(No);if(e.getSource()=mt2)dispose();文件teacher.java代码importjava.awt.*;importjava.awt.event.*;importjava.sql.*;importjava.util.*;importjavax.swing.*;classteacherext

41、endsJFrameimplementsActionListeneraddmessageadd;deletemessagedelete;revisere;useruse;recordrec;MenuBarmb;Menum1;MenuItemmt1,mt2,mt3,mt4,mt5,mt6;Iconicon;JLabellab;teacher()super(管员);setBounds(130,10,800,500);MenuBarmb=newMenuBar();setMenuBar(mb);m1=newMenu(操作);mt1=newMenuItem(增加)；mt2=newMenuItem(删除)

42、；mt3=newMenuItem(修改)；mt4=newMenuItem(查询)；mt5=newMenuItem(统计)；mt6=newMenuItem(退出)；icon=newImageIcon(123.jpg)；lab=newJLabel(icon)；add(lab)；mt1.addActionListener(this)；m1.add(mt1)；mt2.addActionListener(this)；m1.add(mt2)；mt3.addActionListener(this)；m1.add(mt3)；mt4.addActionListener(this)；m1.add(mt4)；mt5

43、.addActionListener(this)；m1.add(mt5)；m1.addSeparator()；mt6.addActionListener(this);m1.add(mt6);m1.addActionListener(this);mb.add(m1);publicvoidactionPerformed(ActionEvente)if(e.getSource()=mt1)add=newaddmessage();if(e.getSource()=mt2)delete=newdeletemessage();if(e.getSource()=mt3)re=newrevise();if(e

44、.getSource()=mt4)use=newuser();if(e.getSource()=mt5)rec=newrecord();if(e.getSource()=mt6)dispose();文件user.java代码importjava.awt.*;importjava.awt.event.*;importjava.sql.*;importjava.util.*;importjavax.swing.*;importjavax.swing.table.*;classuserextendsJFrameimplementsActionListenerJTextFieldt1,t2;TextA

45、reat;JButtonbut1;JLabelL1,L2;JPanelp1;JTabletable1=null;DefaultTableModeldemod1=null;Stringn=姓名,课程名，状态，成绩;Stringdata=newString00;publicuser()super(查询);setBounds(350，30，470，610);setLayout(newGridLayout(1，1，10，10);p1=newJPanel();L1=newJLabel(学号);L2=newJLabel(课程名);but1=newJButton(查询);but1.addActionListener(this);t1=newJTextField(10);t2=newJTextField(10);p1.add(L1);p1.add(t1);p1.add(L2);p1.add(t2);p1.add(but1);demod1=newDefaultTableModel(data，n);table1=newJTable(demod1);JScrollPanes1=newJScrollPane(table1);p1.add(s1);add(p1);setVisible(true);publicvoidactionPe