java學(xué)生成績管理系統(tǒng)源碼

1、文件 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,lab5;JP

2、anel 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("學(xué)號");t1= new JTextField(10); 姓名");t

3、2=new JTextField(10); 課程名");t3=new JTextField(10);狀態(tài)");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);se

4、tVisible(true);public void action Performed(Act ionEvent e) int i=0 ;String sql1= null,sql2=n ull,update=n ull;學(xué)生成績系統(tǒng)"Stri ng url="jdbc:mysql:/localhost:3306/Connection con;Statement stmt;tryClass.forName("org.gjt.mm.mysql.Driver");catch(java .Ian g.ClassNotF oun dExcepti on e1)S

5、ystem.err.pri ntl n("ClassNotF oun dExcepti on:"+e1.getMessage();if(e.getSource()=but1)/添力口trycon=DriverMa nager.getCo nn ectio n(url,"root","123");VALUESstmt=c on .createStateme nt();sql1="INSERTINTO 學(xué) 生 成 績 表(”'+t1.getText()+"',”'+t2.getText()+&q

6、uot;',”'+ t3.getText()+"',”'+t4.getText()+"',”'+t5.getText()+"')"String nu m仁t1.getText();課程名String num2=t1.getText();String sele="select * from學(xué)生成績表 where 學(xué)號='"+nu m1+"' and=”'+num2+"”'ResultSet rs=stmt.executeQuery

7、(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. cl

8、ose();catch(SQLExcepti on ex)System.err.pri ntln ("SQLExceptio n:"+ex.getMessage();文件 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

9、 nListe nerJTextField t1,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("學(xué)號"

10、;);t1= new JTextField(10); 姓名");t2=new JTextField(10); 課程名");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);學(xué)生成績系統(tǒng)"public void action Performed(Act ionEvent e

11、) Stri ng sql1= null,sql2=null;Stri ng url="jdbc:mysql:/localhost:3306/ 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()

12、=but1) /刪除tryString nu m仁t1.getText();String num2=t2.getText();String num3=t3.getText();sql2="deletefrom 學(xué)生 成績表 where 學(xué)號="'+num1+"'and課程名='"+num3+"'"con=DriverMa nager.getCo nn ectio n(url,"root","123");where 學(xué)號='"+num1+"

13、;'and 姓名沒有此條記錄！請重新輸入");stmt=c on .createStateme nt();sql仁"select* from 學(xué)生成績表='"+nu m2+"' and課程名="'+num3+""'ResultSet rs=stmt.executeQuery(sql1);if(rs. next()stmt.executeUpdate(sql2);JOpti onPan e.showMessageDialog(this,"elseJOpti onPan e.sh

14、owMessageDialog(this,"t1.setText("");stmt.close();con. close();catch(SQLExcepti on ex)System.err.pri ntl n("SQLExceptio n:"+ex.getMessage();文件entry.java 代碼import java.awt.*;import java.awt.eve nt.*;import java.sql.*;import javax.swi ng.*;class en try exte nds JFrame impleme

15、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(”學(xué)生成績管理系統(tǒng)”)；setBou nds(400,200,400,300);GridBagLayout gbL=new GridBagLayout(); GridBagC on stra ints gbc =new GridBagC on strai nts(); se

16、tLayout(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(

17、lab1);pa1.add(tf1);gbc.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 JB

18、utton(”確定");btul.addAct ion Liste ner(this);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

19、e)logi nsure ls;if(e.getSource()=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

20、i=0;String n ame=nu ll,pwd=n ull, ustype=n ull;throwspubliclog 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/學(xué)生成績系統(tǒng)"Co nn ection conn = DriverMa nager.getCo

21、nn ectio n(URL,"root","123");Stateme nt stmt=c onn .createStateme nt();ResultSet rs = stmt.executeQuery("select * from用戶管理表");while (rs. next()name=rs.getString(”用戶名 ”).trim();pwd=rs.getString(”密碼").trim();ustype=rs.getString(”權(quán)限組").trim();if (s.equals (n ame

22、)&&a.equals(pwd)i=1;if(ustype.trim().equals("管理員")teacher tea=new teacher(); tea.setVisible(true);if(ustype.trim().equals("學(xué)生")stude nt stu=new stude nt(n ame); stu.setVisible(true);"用戶名或者密碼錯誤","警告 if(i=0)JOpti onPan e.showMessageDialog( null,”,JOptio nPan

23、e.WARNING_MESSAGE);stmt.close();conn. close();文件inquiry.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 inquiry exte nds JFrame impleme nts Actio nListe nerJTextField t1;JTable table;JButton but1;JLabel la

24、b1;JPanel p1;JTable table仁 null;DefaultTableModel demod 仁n ull;String n=" 課程名","狀態(tài)","成績"String data=new Stri ng00;Stri ng No;inqui ry(Stri ng no)super(" 成績");No=no;setBou nds(350,100,470,400);p1= new JPa nel();lab仁new JLabel("課程名 ”)；t1= new JTextField(10)

25、;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= new JScrollPa ne(table1);p1.add(s1);add(p1);setVisible(true);public void acti on Performed(Act ion Eve nt e)int i=0;Stri

26、 ng sql1;String url="jdbc:mysql:/localhost:3306/學(xué)生成績系統(tǒng)”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()=but1)tryStri ng

27、num=t1.getText();sql仁"select * from學(xué)生成績表 where 學(xué)號='"+No+""'if(! num.equals("")sql1="select * from 學(xué)生成績表 where 課程名="'+num+"'and學(xué)號='"+No+"'"con=DriverMa nager.getCo nn ectio n(url,"root","123");stmt

28、=co n.createStateme nt();ResultSet 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,"沒有此課程

29、！請重新輸入");table1.revalidate();tl.setText(”);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)demod1.r

30、emoveRow(rowco un t); demodl.setRowCo un t(rowco un t);elsebreak;文件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(

31、false);文件record.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 record exte nds JFrame impleme nts Acti on Liste nerJTextField t1;TextArea t;JButton but1;JLabel L1;JPanel p1;JTable table仁 null;DefaultTable

32、Model demod 仁n ull;String n="平均成績","優(yōu)秀","良好","不及格"String data=new Stri ng00;public record()super(”統(tǒng)計");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

33、ion Liste ner(this);t1= new JTextField(10);p1.add(L1);p1.add(t1);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 Performed(Act ionEvent e)int i=0;Stri ng sql1;Stri ng sql2;St

34、ring url="jdbc:mysql:/localhost:3306/學(xué)生成績系統(tǒng)”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()=but1)tryString nu m仁t1.getT

35、ext();if(n um1.equals("")JOptionPane.showMessageDialog(this,"學(xué)號不能為空"，”請輸入學(xué)號！ ”,JOptionPane.WARNING_MESSAGE);elsesql仁"select * from學(xué)生成績表 where 學(xué)號='"+num1+""sql1="select avg( 成績)from學(xué)生成績表 where 課程名="'+num1+""sql2="select cou nt(*

36、) from學(xué)生成績表 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 Vector();data.addEleme nt(rs.get In t(1);/*d

37、ata.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(this,"沒有此條記錄！請重新輸入”)；table1.revalidate();tl

38、.setText(”);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.removeRow(rowco un t); demod1.setRowC

39、o un t(rowco un t);elsebreak;文件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;JTable table;JButton but1;JLabel lab1,lab

40、2,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("學(xué)號");t1=

41、 new JTextField(10); 姓名");t2=new JTextField(10); 課程名");t3=new JTextField(10);狀態(tài)");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(lab

42、5);p1.add(t5);p1.add(but1);add(p1);setVisible(true);public void action Performed(Act ionEvent e)String sql1= null,update=nu II;學(xué)生成績系統(tǒng)"Stri ng url="jdbc:mysql:/localhost:3306/Connection con;Statement stmt;tryClass.forName("org.gjt.mm.mysql.Driver");catch(java .Ian g.ClassNotF oun

43、dExcepti on e1)System.err.pri ntl n("ClassNotF oun dExcepti on:"+e1.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

44、 n(url,"root","123");stmt=c on .createStateme nt();sql仁"select * from學(xué)生成績表where 學(xué)號="'+num2+"' and 課程名='"+num1+"”'update="update學(xué)生成績表 set 課程名="'+t3.getText()+"', 狀態(tài)='"+t4.getText()+"', 成績="'

45、+n+"' where學(xué)號='"+num2+""'ResultSet rs=stmt.executeQuery(sql1);if(rs. next()stmt.executeUpdate(update);JOptionPane.showMessageDialog(this,"修改成功!");elseJOptionPane.showMessageDialog(this,"沒有此條記錄！請重新輸入”)；tl.setText(”);t2.setText("");t3.setText(&q

46、uot;");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.*;import java.awt.eve nt.*;import java.sql.*;import java.util.*;import javax.swi ng.*;class

47、stude nt exte nds 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("學(xué)生");icon=new ImageIc on ("123.jpg");lab=new JLabel(ic on);add(lab);No=no;setBou nds(130,10,800,500);JMe nuBar mb

48、=new JMe nuBar();setJMe nuBar(mb);m仁new 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 ionEv

49、ent e)if(e.getSource()=mt1)cho=new inqui ry(No);if(e.getSource()=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;deletemessage delete;revise

50、re;user use;record rec;MenuBar mb;Menu m1;Men ultem 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=

51、new Menultem(”查詢");mt5=new Menultem(”統(tǒng)計");mt6 = new Menultem(”退出");icon=new 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 nList

52、e ner(this);m1.add(mt4);mt5.addAct ion Liste ner(this);m1.add(mt5);m1.addSeparator();mt6.addAct ion Liste 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 deletemessa

53、ge();if(e.getSource()=mt3)re=new revise();if(e.getSource()=mt4)use=new user();if(e.getSource()=mt5)rec=new record();if(e.getSource()=mt6)dispose();文件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 use

54、r exte nds JFrame impleme nts Actio nListe ner JTextField t1,t2;TextArea t;JButton but1;JLabel L1, L2;JPanel p1;JTable table仁 null;DefaultTableModel demod 仁n ull;String n=" 姓名","課程名","狀態(tài)","成績"String data=new Stri ng00;public user()super(" 查詢");setBou

55、 nds(350,30,470,610);setLayout(new GridLayout(1,1,10,10);p1= new JPa nel();L1= new JLabel("學(xué)號");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 Performed(Act ionEvent e)int i=0;Stri ng sqll;String url="jdbc:mysql:/localhost:3306/學(xué)生成績系統(tǒng)"Connection con;Statement stmt;t