java学生成绩管理系统源码

1、word 范文文件 addmessage.java 代码:import java.awt.*;import java.awt.eve nt.*;import java.sql.*;import java.util.*;import javax.swi ng.*;import javax.swi ng.table.*;class addmessage exte nds JFrame impleme nts Actio nListe nerJTextField t1,t2,t3,t4, t5;JTable table;JButton but1;JLabel lab1,lab2,lab3,lab4,

2、lab5;JPanel p1;addmessage()super(”增加”)；setBou nds(350,100,470,400); setLayout(new GridLayout(1,1,10,10);p1= new JPa nel(); lab仁 new JLabel(lab2=new JLabel(lab3=new JLabel(lab4=new JLabel(lab5=new JLabel( but仁 new JButto n(学号);t1= new JTextField(10); 姓名);t2=new JTextField(10); 课程名);t3=new JTextField(

3、10);状态);t4=new JTextField(10);成绩);t5=new JTextField(10);添加”)；but1.addAct ion Liste ner(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);public void action Performed(Act ionEvent e) int

4、 i=0 ;String sql1= null,sql2=n ull,update=n ull;Stri ng url=jdbc:mysql:/localhost:3306/学生成绩系统;word 范文Connection con;Statement stmt;tryClass.forName(org.gjt.mm.mysql.Driver);catch(java .Ian g.ClassNotF oun dExcepti on e1)System.err.pri ntl n(ClassNotF oun dExcepti on:+e1.getMessage();if(e.getSource()

5、=but1)/添力口-trycon=DriverMa nager.getCo nn ectio n(url,root,123);stmt=c on .createStateme nt();sql1=INSERTINTO 学 生 成 绩 表(”+t1.getText()+,”+t2.getText()+,”+ t3.getText()+,”+t4.getText()+,”+t5.getText()+);String nu m 仁 t1.getText();String num2=t1.getText();String sele=select * from学生成绩表 where 学号=+nu m1

6、+ and=”+num2+”;ResultSet rs=stmt.executeQuery(sele);if(rs. next()JOptio nPa ne.showMessageDialog(this,已有该条记录，请核实! elsestmt.executeUpdate(sqll);JOptionPane.showMessageDialog(this,添加成功!);tl.setText(”);t2.setText();t3.setText();t4.setText();t5.setText();stmt.close();con. close();catch(SQLExcepti on ex)

7、System.err.pri ntln (SQLExceptio n:+ex.getMessage();VALUES课程名);word 范文文件 deletemessage.java 代码import java.awt.*;import java.awt.eve nt.*;import java.sql.*;import java.util.*;import javax.swi ng.*;import javax.swi ng.table.*;class deletemessage exte nds JFrame impleme nts Actio nListe nerJTextField t

8、1,t2,t3;JTable table;JButton but1;JLabel Iab1,lab2,lab3;JPanel p1;deletemessage()super(”删除”)；setBou nds(350,100,470,400); setLayout(new GridLayout(1,1,10,10);p1= new JPa nel(); lab仁 new JLabel(lab2=new JLabel(lab3=new JLabel( but仁 new JButto n(学号);t1= new JTextField(10); 姓名);t2=new JTextField(10); 课

9、程名);t3=new JTextField(10);删除);but1.addAct ion Liste ner(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);public void action Performed(Act ionEvent e) Stri ngsql1= null,sql2=null;Stri ng url=jdbc:mysql:/localhost:3306/ Connection con;

10、Statement stmt;tryClass.forName(org.gjt.mm.mysql.Driver);catch(java .Ian g.ClassNotF oun dExcepti on e1)System.err.pri ntl n(ClassNotF oun dExcepti on:+e1.getMessage();学生成绩系统;word 范文if(e.getSource()=but1) /删除-tryString nu m 仁 t1.getText();String num2=t2.getText();String num3=t3.getText();sql2=delete

11、from 学生 成绩表 where 学号=+num1+and课程名=+num3+;con=DriverMa nager.getCo nn ectio n(url,root,123);stmt=c on .createStateme nt();sql 仁select* from 学生成绩表=+nu m2+ and课程名=+num3+;ResultSet rs=stmt.executeQuery(sql1);if(rs. next()stmt.executeUpdate(sql2);JOpti onPan e.showMessageDialog(this,elseJOpti onPan e.sho

12、wMessageDialog(this,t1.setText();stmt.close();con. close();catch(SQLExcepti on ex)System.err.pri ntl n(SQLExceptio n:+ex.getMessage();where 学号=+num1+and 姓名没有此条记录！请重新输入);word 范文文件 entry.java 代码import java.awt.*;import java.awt.eve nt.*;import java.sql.*;import javax.swi ng.*;class en try exte nds JFr

13、ame impleme nts Actio nListe ner int flag=1;String user,pass;JPa nel pa;JLabel Iab1,lab2;JTextField tf1;JPasswordField tf2;JButton btu1,btu2;JPa nel pa1,pa2,pa4;en try()super(”学生成绩管理系统”)；setBou nds(400,200,400,300);GridBagLayout gbL=new GridBagLayout(); GridBagC on stra ints gbc =new GridBagC on str

14、aints(); setLayout(gbL);gbc.fill=GridBagCo nstrai nts.HORIZONTAL; gbc.a nchor=GridBagCo nstrai nts.CENTER; lab 仁new JLabel(请输入帐号);lab2=new JLabel(请输入密码);tf2=new JPasswordField(10);tf2.setEchoChar(*);tf 仁 new JTextField(10);tf1.addActio nListe ner(this);pa1= new JPa nel();pa1.add(lab1);pa1.add(tf1);g

15、bc.gridx=1;gbc.gridy=1;gbc.i nsets=new In sets(2,5,0,5);gbL.setC on stra in ts(pa1,gbc);add(pa1);tf2.addActio nListe ner(this);pa2=new JPa nel();pa2.add(lab2);pa2.add(tf2);gbc.gridx=1;gbc.gridy=2;gbc.i nsets=new In sets(2,5,2,5);gbL.setC on stra in ts(pa2,gbc);add(pa2);btu 仁 new JButton(”确定);btul.ad

16、dAct ion Liste ner(this);word 范文btu2=new JButton(退出);btu2.addAct ion Liste ner(this);pa4=new JPa nel();pa4.add(btu1);pa4.add(btu2);gbc.gridx=1;gbc.gridy=4;gbc.i nsets=new In sets(2,5,2,5);gbL.setC on stra in ts(pa4,gbc);add(pa4);public void action Performed(Act ionEvent e)logi nsure ls;if(e.getSourc

17、e()=btu1)user=tf1.getText();pass=tf2.getText();tryls=new log in sure(user,pass);this.setVisible(false);catch (SQLException e1)e1.pri ntStackTrace();catch (ClassNotFou ndException e1)e1.pri ntStackTrace();if(e.getSource()=btu2)dispose();System.exit(0);class logi nsureint i=0;String n ame=nu ll,pwd=n

18、ull, ustype=n ull;publiclog in sure(Stri ngs,Stri nga)SQLExcepti on, ClassNotF oun dExcepti onString driver =org.gjt.mm.mysql.Driver;Class.forName(driver);String URL = jdbc:mysql:/localhost:3306/学生成绩系统;Co nn ection conn = DriverMa nager.getCo nn ectio n(URL,root,123);Stateme nt stmt=c onn .createSta

19、teme nt();ResultSet rs = stmt.executeQuery(select * from用户管理表);while (rs. next()throwsword 范文name=rs.getString(”用户名 ”).trim();pwd=rs.getString(”密码).trim();ustype=rs.getString(”权限组).trim();if (s.equals (n ame )&a.equals(pwd)i=1;if(ustype.trim().equals(管理员)teacher tea=new teacher(); tea.setVisible

20、(true);if(ustype.trim().equals(学生)stude nt stu=new stude nt(n ame); stu.setVisible(true); if(i=0)JOpti onPan e.showMessageDialog( null,”,JOptio nPan e.WARNING_MESSAGE);stmt.close();conn. close();用户名或者密码错误,警告word 范文文件 inquiry.java 代码import java.awt.*;import java.awt.eve nt.*;import java.sql.*;import

21、java.util.*;import javax.swi ng.*;import javax.swi ng.table.*;class inquiry exte nds JFrame impleme nts Actio nListe nerJTextField t1;JTable table;JButton but1;JLabel lab1;JPanel p1;JTable table 仁 null;DefaultTableModel demod 仁 n ull;String n= 课程名,状态,成绩;String data=new Stri ng00;Stri ng No;inqui ry(

22、Stri ng no)super( 成绩);No=no;setBou nds(350,100,470,400);p1= new JPa nel();lab 仁 new JLabel(课程名 ”)；t1= new JTextField(10);but 仁 new JButton(”查询成绩);but1.addAct ion Liste ner(this);p1.add(lab1);p1.add(t1);p1.add(but1);demod 仁 new DefaultTableModel(data ,n);table 仁 new JTable(demod1);JScrollPa ne s1= ne

23、w JScrollPa ne(table1);p1.add(s1);add(p1);setVisible(true);public void acti on Performed(Act ion Eve nt e)int i=0;Stri ng sql1;String url=jdbc:mysql:/localhost:3306/学生成绩系统”Connection con;Statement stmt;tryword 范文Class.forName(org.gjt.mm.mysql.Driver);catch(java .Ian g.ClassNotF oun dExcepti on e1)Sy

24、stem.err.pri ntl n(ClassNotF oun dExcepti on:+e1.getMessage();if(e.getSource()=but1)tryStri ng num=t1.getText();sql 仁select * from学生成绩表 where 学号=+No+;if(! num.equals()sql1=select * from 学生成绩表 where 课程名=+num+and学号=+No+;con=DriverMa nager.getCo nn ectio n(url,root,123);stmt=co n.createStateme nt();Res

25、ultSet rs=stmt.executeQuery(sql1);removeAIIRecord();while(rs. next()Vector data=new Vector();data.addEleme nt(rs.getStri ng(3);data.addEleme nt(rs.getStri ng(4);data.addEleme nt(rs.getStri ng(5);demodl.addRow(data);i=1;if(i=0)JOptionPane.showMessageDialog(this,没有此课程！请重新输入);table1.revalidate();tl.set

26、Text(”);stmt.close();con .close();catch(SQLExceptio n ex)System.err.pri ntln (SQLExcepti on:+ex.getMessage();public void removeAIIRecord()将界面上的所有记录清空int rowco unt;while(true)删除所有存在的行rowco unt = demodl.getRowCo un t()-1;if(rowco unt = 0)word 范文demod1.removeRow(rowco un t); demodl.setRowCo un t(rowco

27、un t);elsebreak;word 范文文件 main .java 代码import java.awt.*;import java.awt.eve nt.*;import java.sql.*;import java.util.*;import javax.swi ng.*;public class mainpublic static void main(String args) en try ent=new en try();en t.setVisible(true);en t.setResizable(false);word 范文文件 record.java 代码import jav

28、a.awt.*;import java.awt.eve nt.*;import java.sql.*;import java.util.*;import javax.swi ng.*;import javax.swi ng.table.*;class record exte nds JFrame impleme nts Acti on Liste nerJTextField t1;TextArea t;JButton but1;JLabel L1;JPanel p1;JTable table 仁 null;DefaultTableModel demod 仁 n ull;String n=平均成

29、绩,优秀,良好,不及格;String data=new Stri ng00;public record()super(”统计);setBou nds(350,30,470,610);setLayout(new GridLayout(1,1,10,10);p1= new JPa nel();L1= new JLabel(课程名);but 仁 new JButton(”查询);but1.addAct ion Liste ner(this);t1= new JTextField(10);p1.add(L1);p1.add(t1);p1.add(but1);demod 仁 new DefaultTab

30、leModel(data ,n);table 仁 new JTable(demod1);JScrollPa ne s1= new JScrollPa ne(table1);p1.add(s1);add(p1);setVisible(true);public void action Performed(Act ionEvent e)int i=0;Stri ng sql1;Stri ng sql2;String url=jdbc:mysql:/localhost:3306/学生成绩系统”Connection con;Statement stmt;word 范文tryClass.forName(o

31、rg.gjt.mm.mysql.Driver);catch(java .Ian g.ClassNotF oun dExcepti on e1)System.err.pri ntl n(ClassNotF oun dExcepti on:+e1.getMessage();if(e.getSource()=but1)tryString nu m 仁 t1.getText();if(n um1.equals()JOptionPane.showMessageDialog(this,学号不能为空，”请输入学号！ ”,JOptionPane.WARNING_MESSAGE);elsesql 仁select

32、 * from学生成绩表 where 学号=+num1+;sql1=select avg( 成绩)from学生成绩表 where 课程名=+num1+;sql2=select cou nt(*) from学生成绩表 where 课程名=+nu m1+ and成绩=90;con=DriverMa nager.getCo nn ectio n(url,root,123);stmt=co n.createStateme nt();ResultSet rs=stmt.executeQuery(sql1);removeAIIRecord();while(rs. next()Vector data=new

33、 Vector();data.addEleme nt(rs.get In t(1);/*data.addEleme nt(rs.getStri ng(3);data.addEleme nt(rs.getStri ng(4);data.addEleme nt(rs.getStri ng(5);*/demodl.addRow(data);i=1;rs=stmt.executeQuery(sql2);while(rs. next()int n = rs.getlnt(1);System.out.pri ntl n(n);if(i=0)JOptionPane.showMessageDialog(thi

34、s,没有此条记录！请重新输入”)；table1.revalidate();tl.setText(”);word 范文stmt.close();con .close();catch(SQLExcepti on ex)System.err.pri ntln (SQLExcepti on:+ex.getMessage();public void removeAIIRecord()将界面上的所有记录清空int rowco unt;while(true)删除所有存在的行rowco unt = demod1.getRowCo un t()-1;if(rowco unt = 0)demod1.removeR

35、ow(rowco un t); demod1.setRowCo un t(rowco un t);elsebreak;word 范文文件 revise.java 代码import java.awt.*;import java.awt.eve nt.*;import java.sql.*;import java.util.*;import javax.swi ng.*;import javax.swi ng.table.*;class revise exte nds JFrame impleme nts Actio nListe nerJTextField t1,t2,t3,t4, t5;JTa

36、ble table;JButton but1;JLabel lab1,lab2,lab3,lab4,lab5;JPanel p1;int n=0;revise()super( 修改);setBou nds(350,100,470,400);setLayout(new GridLayout(1,1,10,10);p1= new JPa nel(); lab仁 new JLabel(lab2=new JLabel(lab3=new JLabel(lab4=new JLabel(lab5=new JLabel( but仁 new JButto n(学号);t1= new JTextField(10)

37、; 姓名);t2=new JTextField(10); 课程名);t3=new JTextField(10);状态);t4=new JTextField(10);成绩);t5=new JTextField(10);修改);but1.addAct ion Liste ner(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(tru

38、e);public void action Performed(Act ionEvent e)String sql1= null,update=nu II;Stri ng url=jdbc:mysql:/localhost:3306/Connection con;Statement stmt;学生成绩系统;word 范文tryClass.forName(org.gjt.mm.mysql.Driver);catch(java .Ian g.ClassNotF oun dExcepti on e1)System.err.pri ntl n(ClassNotF oun dExcepti on:+e1

39、.getMessage();if(e.getSource()=but1) /修改-tryStri ng num 1= t3.getText();Stri ng num2=t1.getText();/Stri ng num3=t5.getText();n= In teger.valueOf(t5.getText().i ntValue();System.out.pri nt(n);con=DriverMa nager.getCo nn ectio n(url,root,123);stmt=c on .createStateme nt();sql 仁select * from学生成绩表where

40、学号=+num2+ and 课程名=+num1+”;update=update学生成绩表 set 课程名=+t3.getText()+, 状态=+t4.getText()+, 成绩=+n+ where学号=+num2+;ResultSet rs=stmt.executeQuery(sql1);if(rs. next()stmt.executeUpdate(update);JOptionPane.showMessageDialog(this,修改成功!);elseJOptionPane.showMessageDialog(this,没有此条记录！请重新输入”)；tl.setText(”);t2.

41、setText();t3.setText();t4.setText();t5.setText();stmt.close();con .close();catch(SQLExcepti on ex)System.err.pri ntln (SQLExcepti on:+ex.getMessage();文件 student.java 代码import java.awt.*;word 范文import java.awt.eve nt.*;import java.sql.*;import java.util.*;import javax.swi ng.*;class stude nt exte nds

42、 JFrame impleme nts Actio nListe ner inquiry cho;JMe nuBar mb;JMe nu m1;JMe nultem mt1,mt2;Stri ng No;Icon icon;JLabel lab;stude nt(Stri ng no)super(学生);icon=new ImageIc on (123.jpg);lab=new JLabel(ic on);add(lab);No=no;setBou nds(130,10,800,500);JMe nuBar mb=new JMe nuBar();setJMe nuBar(mb);m 仁 new

43、 JMenu(”操作);mt1= new JMenultem(”查询成绩);mt2=new JMenultem(”退出);m1.add(mt1);mt1.addActi on Liste ner(this);m1.addSeparator();m1.add(mt2);mt2.addActio nListe ner(this);m1.addAct ion Liste ner(this);mb.add(m1);public void action Performed(Act ionEvent e)if(e.getSource()=mt1)cho=new inqui ry(No);if(e.getS

44、ource()=mt2)dispose();文件 teacher.java 代码import java.awt.*;import java.awt.eve nt.*;import java.sql.*;import java.util.*;import javax.swi ng.*;class teacher exte nds JFrame impleme nts Actio nListe ner addmessage add;word 范文deletemessage delete;revise re;user use;record rec;MenuBar mb;Menu m1;Men ult

45、em mt1,mt2,mt3,mt4,mt5,mt6;Icon icon;JLabel lab;teacher()super(”管理员);setBou nds(130,10,800,500);Men uBar mb=new Men uBar();setMe nuBar(mb);m 仁 new Menu(”操作);mt1= new Menultem(”增加”)；mt2=new Menultem(”删除);mt3=new Menultem(”修改);mt4=new Menultem(”查询);mt5=new Menultem(”统计);mt6 = new Menultem(”退出);icon=ne

46、w Imagelc on (123.jpg);lab=new JLabel(ic on);add(lab);mt1.addActio nListe ner(this);m1.add(mt1);mt2.addActio nListe ner(this);m1.add(mt2);mt3.addAct ion Liste ner(this);m1.add(mt3);mt4.addActio nListe ner(this);m1.add(mt4);mt5.addAct ion Liste ner(this);m1.add(mt5);m1.addSeparator();mt6.addAct ion L

47、iste ner(this); m1.add(mt6);ml.addAct ion Liste ner(this);mb.add(ml);public void action Performed(Act ionEvent e) if(e.getSource()=mt1)add=new addmessage();if(e.getSource()=mt2)delete=new deletemessage();if(e.getSource()=mt3)word 范文re=new revise();if(e.getSource()=mt4)use=new user();if(e.getSource()

48、=mt5)rec=new record();if(e.getSource()=mt6)dispose();word 范文文件 user.java 代码import java.awt.*;import java.awt.eve nt.*;import java.sql.*;import java.util.*;import javax.swi ng.*;import javax.swi ng.table.*;class user exte nds JFrame impleme nts Actio nListe ner JTextField t1,t2;TextArea t;JButton but

49、1;JLabel L1, L2;JPanel p1;JTable table 仁 null;DefaultTableModel demod 仁 n ull;String n= 姓名,课程名,状态,成绩;String data=new Stri ng00;public user()super( 查询);setBou nds(350,30,470,610);setLayout(new GridLayout(1,1,10,10);p1= new JPa nel();L1= new JLabel(学号);L2=new JLabel(课程名);but 仁 new JButton(”查询);but1.addAct ion Liste ner(this);t1= new JTextField(10);t2=new JTextField(10);p1.add(L1);p1.add(t1);p1.add(L2);p1.add(t2);p1.add(but1);demod 仁 new DefaultTableModel(data ,n); table 仁 new JTable(demod1);JScrollPa ne s1= new JScrollPa ne(table1); p1.add(s1);add(p1);setVisible(true);public void action Perfor