java學(xué)生成績(jī)管理系統(tǒng)課程設(shè)計(jì)報(bào)告報(bào)告

1、-. z.目 錄TOC o 1-3 h z uHYPERLINK l _Toc2977291171設(shè)計(jì)目的及容要求 PAGEREF _Toc297729117 h 1HYPERLINK l _Toc2977291182 系統(tǒng)總體設(shè)計(jì) PAGEREF _Toc297729118 h 1HYPERLINK l _Toc2977291193 系統(tǒng)詳細(xì)設(shè)計(jì) PAGEREF _Toc297729119 h 2HYPERLINK l _Toc2977291204 運(yùn)行結(jié)果及分析 PAGEREF _Toc297729120 h 17HYPERLINK l _Toc297729121致 PAGEREF _To

2、c297729121 h 21HYPERLINK l _Toc297729122參考文獻(xiàn) PAGEREF _Toc297729122 h 22-. z.簡(jiǎn)單學(xué)生成績(jī)管理系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)1設(shè)計(jì)目的及容要求設(shè)計(jì)目的：鞏固和加深學(xué)生對(duì)高級(jí)語(yǔ)言程序設(shè)計(jì)課程的基本知識(shí)的理解和掌握，掌握java語(yǔ)言編程和程序調(diào)試的基本技能，利用java語(yǔ)言進(jìn)行基本的軟件設(shè)計(jì)，提高運(yùn)用java語(yǔ)言解決實(shí)際問(wèn)題的能力。容要求實(shí)現(xiàn)學(xué)生成績(jī)的管理（增、刪、改、查詢(xún)、持久化、成績(jī)排序、成績(jī)統(tǒng)計(jì)等功能），在文件中增加、刪除、學(xué)生信息，根據(jù)*查詢(xún)、修改學(xué)生信息，統(tǒng)計(jì)功能求每個(gè)人的總分并按從高到低排序，通過(guò)這些操作對(duì)文件中的信息保存。2

3、 系統(tǒng)總體設(shè)計(jì)成功登陸系統(tǒng)以后，出現(xiàn)成績(jī)管理界面，系統(tǒng)初始化，可對(duì)學(xué)生成績(jī)進(jìn)行增加、刪除、查詢(xún)、修改、統(tǒng)計(jì)，進(jìn)入相應(yīng)界面進(jìn)行成績(jī)管理，退出系統(tǒng)自動(dòng)保存本次操作容，保存信息。簡(jiǎn)易流程圖： 登陸成績(jī)管理界面增加刪除查詢(xún)修改統(tǒng)計(jì)退出3 系統(tǒng)詳細(xì)設(shè)計(jì)創(chuàng)建Student類(lèi)，設(shè)置變量及對(duì)應(yīng)方法Student.java代碼：package keshe;import java.io.Serializable;publicclassStudentimplements Serializableprivate String name;privateintnum;privateintyuwen;privateints

4、hu*ue;privateintjava;privateintsum=0;public Student()public Student(String name, int num, int yuwen, int shu*ue,int java) super(); = name;this.num = num;this.yuwen = yuwen;this.shu*ue = shu*ue;this.java = java;public String getName() returnname;publicvoid setName(String name) = na

5、me;publicint getNum() returnnum;publicvoid setNum(int num) this.num = num;publicint getYuwen() returnyuwen;publicvoid setYuwen(int yuwen) this.yuwen = yuwen;publicint getShu*ue() returnshu*ue;publicvoid setShu*ue(int shu*ue) this.shu*ue = shu*ue;publicint getJava() returnjava;publicvoid setJava(int

6、java) this.java = java;publicint getSum() returnsum;publicvoid setSum(int sum) this.sum = sum;public String toString() returnStudent name= + name + , num= + num + , yuwen= + yuwen+ , shu*ue= + shu*ue + , java= + java + , sum= + sum+ ;Student管理類(lèi)StuC，創(chuàng)建對(duì)應(yīng)方法，實(shí)現(xiàn)對(duì)Student對(duì)象的操作（增、刪、改、查詢(xún)、持久化、成績(jī)排序、成績(jī)統(tǒng)計(jì)等功能）供其

7、對(duì)象調(diào)用。StuC.java代碼package keshe;import java.io.BufferedReader;import java.io.File;import java.io.FileInputStream;import java.io.FileNotFoundE*ception;import java.io.FileOutputStream;import java.io.FileReader;import java.io.IOE*ception;import java.io.ObjectInputStream;import java.io.ObjectOutputStream;

8、import java.util.ArrayList;public class StuC ArrayList al=new ArrayList();File file = new File(e:/mydata.dat);/添加public void adds(Student s)al.add(s);/刪除public void del(int n)for(int i=0;ial.size();i+)if(al.get(i).getNum()=n)al.remove(i);/求總分public void sum()for(int i=0;ial.size();i+)al.get(i).setSu

9、m(al.get(i).getJava()+al.get(i).getShu*ue()+al.get(i).getYuwen();/排序public void sort() for (int i = 0; i al.size(); i+) for (int j = 0; j al.size()-1-i; j+) if (al.get(j).getSum() al.get(j+1).getSum() Object o=al.get(j); al.set(j, al.get(j+1); al.set(j+1, (Student) o); public void paint()for(int i=0

10、;ial.size();i+)System.out.println(al.get(i);public String toString() return StuC al= + al + ;/輸出流public void stor()ObjectOutputStream out = null;try out = new ObjectOutputStream(new FileOutputStream(file);out.writeObject(al);out.close(); catch (FileNotFoundE*ception e) e.printStackTrace(); catch (IO

11、E*ception e) e.printStackTrace();/輸入流public void read()ObjectInputStream in = null;try in = new ObjectInputStream(new FileInputStream(file);try al = (ArrayList)in.readObject(); catch (ClassNotFoundE*ception e) al=null;in.close(); catch (FileNotFoundE*ception e) File file = new File(e:/mydata.dat); c

12、atch (IOE*ception e) e.printStackTrace();/查找public Student find(int n)for(int i=0;ial.size();i+)if(al.get(i).getNum()=n)return al.get(i);return null;登陸界面及成績(jī)管理的所有界面，同過(guò)創(chuàng)建StuC的對(duì)象，調(diào)用其方法實(shí)現(xiàn)成績(jī)管理代碼：package keshe;import java.awt.*;import java.awt.event.*;import java.io.FileNotFoundE*ception;import java.io.IO

13、E*ception;import java*.swing.*;public class Login e*tends JFrame private Te*tField f1;private Te*tField f2;private utton b1;private utton b2;private utton b3;StuC scs=new StuC();/登陸界面public Login()Container cp=getContentPane();/容器cp.setLayout(new GridLayout(3,1);/三行一列布局Label l1=new Label(用戶名);Label

14、l2=new Label(密 碼);Panel p1=new Panel();Panel p2=new Panel();Panel p3=new Panel();f1=new Te*tField(10);f2=new Te*tField(10);f2.setEchoChar(*);/回顯字符為*b1=new utton(登錄);b2=new utton(重置);b3=new utton(退出);p1.add(l1);/第一行添加label 1p1.add(f1);p2.add(l2);p2.add(f2);p3.add(b1);p3.add(b2);p3.add(b3);cp.add(p1);

15、cp.add(p2);cp.add(p3);b1.addActionListener(new Enter();b2.addActionListener(new ReWrite();b3.addActionListener(new Close();class Enter implements ActionListenerpublic void actionPerformed(ActionEvent e) if(f1.getTe*t().equals(yazhou)&(f2.getTe*t().equals(123456) scs.read();/初始化，從文件讀入信息 *ueSheng fram

16、e1 = new *ueSheng(); frame1.setBounds(200, 200, 300, 300); frame1.setVisible(true); else JOptionPane.showMessageDialog(null, 用戶名或密碼錯(cuò)誤，請(qǐng)重新登錄！);class ReWrite implements ActionListenerpublic void actionPerformed(ActionEvent e)f1.setTe*t();f2.setTe*t();f1.requestFocus();class Close implements ActionList

17、enerpublic void actionPerformed(ActionEvent e)utton bt=(utton)e.getSource();if(bt=b3)System.e*it(0);/主函數(shù) 程序開(kāi)始public static void main(String args) Login log=new Login();log.setTitle(系統(tǒng)登錄);log.setBounds(200, 200, 300, 300);log.setBackground(Color.blue);log.setVisible(true);/信息管理界面部類(lèi) 進(jìn)行初始化和保存class *ueS

18、heng e*tends JFrame implements ActionListener private utton c*, zj, tc, sc,*g,tj;public *ueSheng() Container c = this.getContentPane();c.setLayout(new GridLayout(3, 1);c.setFont(new Font(true,Font.TRUETYPE_FONT,13);JPanel panel2 = new JPanel();JPanel panel1 = new JPanel();JLabel label1 = new JLabel(

19、歡迎進(jìn)入成績(jī)管理,SwingConstants.CENTER);label1.setFont(new Font(true,Font.TRUETYPE_FONT,13);label1.setForeground(Color.blue);c.add(label1);/添加按鈕c* = new utton(查詢(xún));panel2.add(c*);zj = new utton(增加);panel2.add(zj);sc = new utton(刪除);panel2.add(sc);tc = new utton(退出);panel2.add(tc);*g = new utton(修改);panel1.ad

20、d(*g);tj = new utton(統(tǒng)計(jì));panel1.add(tj);c.add(panel2);c.add(panel1);c*.addActionListener(this);zj.addActionListener(this);sc.addActionListener(this);*g.addActionListener(this);tc.addActionListener(this);tj.addActionListener(this);this.setVisible(true);public void actionPerformed(ActionEvent e) if (e

21、.getSource() = c*) Find f = new Find(); if(e.getSource()=zj) AddFI f = new AddFI(); if(e.getSource()=sc) Delet d = new Delet(); if(e.getSource()=*g) *iuGai *=new *iuGai(); if(e.getSource()=tc)shutDown(); if(e.getSource()=tj) Tongji t=new Tongji();private void shutDown()scs.stor();JOptionPane.showMes

22、sageDialog(null, 信息已保存);this.dispose();/增加信息界面部類(lèi)，捕獲文本框息創(chuàng)建Student對(duì)象，添加到Arraylist中，如果已存在該*/給出提示信息，并重新添加。class AddFI e*tends JFrame implements ActionListener private JTe*tField STNOTe*t, SNAMETe*t, MATe*t, CHITe*t, JAVATe*t;private utton b1, b2, b3;private String STNO, SNAME,MAT, CHI, JAVA;public AddFI

23、() super(添加學(xué)生信息);Container c2 = this.getContentPane();c2.setLayout(new GridLayout(3, 1);JPanel center = new JPanel(new GridLayout(5, 2);JPanel low = new JPanel(new FlowLayout();JLabel label1 = new JLabel(添加學(xué)生信息, SwingConstants.CENTER);label1.setFont(new Font(TRUE, Font.TRUETYPE_FONT, 20);c2.add(labe

24、l1);STNOTe*t = new JTe*tField(30);/30列文本框SNAMETe*t = new JTe*tField(30);CHITe*t = new JTe*tField(30);MATe*t = new JTe*tField(30);JAVATe*t = new JTe*tField(30);center.add(new JLabel(*, SwingConstants.CENTER);/添加標(biāo)簽*寫(xiě)在標(biāo)簽中間center.add(STNOTe*t);/添加文本框center.add(new JLabel(, SwingConstants.CENTER);center.

25、add(SNAMETe*t);center.add(new JLabel(語(yǔ)文, SwingConstants.CENTER);center.add(CHITe*t);center.add(new JLabel(數(shù)學(xué), SwingConstants.CENTER);center.add(MATe*t);center.add(new JLabel(java, SwingConstants.CENTER);center.add(JAVATe*t);c2.add(center);b1 = new utton(添加);b2 = new utton(清除);b3 = new utton(退出);low.

26、add(b1);low.add(b2);low.add(b3);c2.add(low);/ 添加監(jiān)聽(tīng)b1.addActionListener(this);b2.addActionListener(this);b3.addActionListener(this);this.setBounds(200, 200, 600, 400);this.setVisible(true);this.setTitle(添加學(xué)生信息);public void actionPerformed(ActionEvent e) if (e.getSource() = b1) try addFI(); catch (Fil

27、eNotFoundE*ception e1) e1.printStackTrace(); catch (IOE*ception e1) e1.printStackTrace();if (e.getSource() = b2) clearForm();if (e.getSource() = b3) this.dispose();private void addFI() throws FileNotFoundE*ception, IOE*ception STNO = STNOTe*t.getTe*t();SNAME = SNAMETe*t.getTe*t();CHI = CHITe*t.getTe

28、*t();MAT = MATe*t.getTe*t();JAVA = JAVATe*t.getTe*t();if (STNO.length() = 0 | SNAME.length() = 0 | MAT.length() = 0| JAVA.length() = 0 | CHI.length() = 0)JOptionPane.showMessageDialog(this, 請(qǐng)?zhí)砑油耆畔?;else Student a=new Student(SNAME,Integer.parseInt(STNO),Integer.parseInt(CHI),Integer.parseInt(MAT),I

29、nteger.parseInt(JAVA);int b=0;for(int i=0;iscs.al.size();i+)if(scs.al.get(i).getNum()=Integer.parseInt(STNO)b=1;if(b=0)scs.adds(a);JOptionPane.showMessageDialog(this, 添加成功);elseJOptionPane.showMessageDialog(this, 已存在);private void clearForm() STNOTe*t.setTe*t();SNAMETe*t.setTe*t();MATe*t.setTe*t();C

30、HITe*t.setTe*t();JAVATe*t.setTe*t();/查詢(xún)信息界面部類(lèi),根據(jù)輸入的*，在arraylist中查找對(duì)應(yīng)*的學(xué)生信息，分別輸出class Find e*tends JFrame implements ActionListener private JTe*tField STNOTe*t, SNAMETe*t, MATe*t, CHITe*t, JAVATe*t;private String STNO;private utton b1, b2;public Find() Container c1 = this.getContentPane();c1.setLayou

31、t(new GridLayout(4, 1);JLabel label1 = new JLabel(查詢(xún)學(xué)生信息, SwingConstants.CENTER);JLabel label0 = new JLabel(請(qǐng)輸入你的*,SwingConstants.CENTER);JPanel pp = new JPanel(new GridLayout(2, 1);pp.add(label1);pp.add(label0);c1.add(pp);JPanel p1 = new JPanel();STNOTe*t = new JTe*tField(10);p1.add(STNOTe*t);c1.ad

32、d(p1);JPanel p2 = new JPanel();b1 = new utton(查詢(xún));b2 = new utton(退出);b1.addActionListener(this);b2.addActionListener(this);p2.add(b1);p2.add(b2);c1.add(p2);JPanel center = new JPanel(new GridLayout(4, 2);SNAMETe*t = new JTe*tField(30);CHITe*t = new JTe*tField(30);MATe*t = new JTe*tField(30);JAVATe*t

33、 = new JTe*tField(30);center.add(new JLabel(, SwingConstants.CENTER);center.add(SNAMETe*t);center.add(new JLabel(語(yǔ)文, SwingConstants.CENTER);center.add(CHITe*t);center.add(new JLabel(數(shù)學(xué), SwingConstants.CENTER);center.add(MATe*t);center.add(new JLabel(java, SwingConstants.CENTER);center.add(JAVATe*t);

34、c1.add(center);this.setVisible(true);this.setBounds(200, 200, 400, 300);public void actionPerformed(ActionEvent e)if (e.getSource() = b1) STNO = STNOTe*t.getTe*t();int k=0;for(int i=0;iscs.al.size();i+)if(Integer.parseInt(STNO)=scs.al.get(i).getNum()SNAMETe*t.setTe*t(scs.al.get(i).getName();MATe*t.s

35、etTe*t(String.valueOf(scs.al.get(i).getShu*ue();CHITe*t.setTe*t(String.valueOf(scs.al.get(i).getYuwen();JAVATe*t.setTe*t(String.valueOf(scs.al.get(i).getJava();k=1;if(k=0)JOptionPane.showMessageDialog(this, 查無(wú)此人);if (e.getSource() = b2) this.dispose();/刪除信息界面，通過(guò)輸入的*進(jìn)行查找并在arraylist中移除class Delet e*te

36、nds JFrame implements ActionListenerprivate utton yes;private utton cancle;private JTe*tField te*t1;private String STNO;public Delet()Container c3 = this.getContentPane();c3.setLayout(new GridLayout(3, 1);c3.setFont(new Font(true,Font.TRUETYPE_FONT,13);JPanel p1 = new JPanel();JPanel p2 = new JPanel

37、();JLabel label1 = new JLabel(刪除學(xué)生信息,SwingConstants.CENTER);label1.setFont(new Font(true,Font.TRUETYPE_FONT,13);label1.setForeground(Color.blue);c3.add(label1);JLabel label2 = new JLabel(請(qǐng)輸入*);te*t1 = new JTe*tField(10);p1.add(label2);p1.add(te*t1);c3.add(p1);yes = new utton(確定);cancle = new utton(退

38、出);p2.add(yes);p2.add(cancle);c3.add(p2);yes.addActionListener(this);cancle.addActionListener(this);this.setTitle(刪除學(xué)生信息);this.setBounds(200,200,400,300);this.setVisible(true); public void actionPerformed(ActionEvent e)if(e.getSource()=yes)delt();if(e.getSource()=cancle)this.dispose();private void d

39、elt()STNO = te*t1.getTe*t();scs.del(Integer.parseInt(STNO);JOptionPane.showMessageDialog(this, 刪除成功);/統(tǒng)計(jì)界面，對(duì)arraylist中所有對(duì)象進(jìn)行求總分，并按總分從達(dá)到小排序class Tongji e*tends JFrame implements ActionListenerprivate utton b1,b2;JTe*tArea t;public Tongji()Container c1 = this.getContentPane();c1.setLayout(new GridLayo

40、ut(3, 1);JPanel p1 =new JPanel();JLabel label1 = new JLabel(統(tǒng)計(jì)信息, SwingConstants.CENTER);p1.add(label1);c1.add(p1);t=new JTe*tArea();JScrollPane scroll=new JScrollPane(t);c1.add(scroll);JPanel p3=new JPanel();b1 = new utton(統(tǒng)計(jì));b2 = new utton(退出);p3.add(b1);p3.add(b2);c1.add(p3);this.setBounds(200,2

41、00,400,300);this.setVisible(true);b1.addActionListener(this);b2.addActionListener(this);public void actionPerformed(ActionEvent e) if (e.getSource() = b1) scs.sum(); scs.sort(); String s=new String100; String s1=總分從大到小n * 數(shù)學(xué) 語(yǔ)文 java 總分; for(int i=0;iscs.al.size();i+) si=scs.al.get(i).getName()+ +scs

42、.al.get(i).getNum()+ +scs.al.get(i).getShu*ue() + +scs.al.get(i).getYuwen()+ +scs.al.get(i).getJava()+ +scs.al.get(i).getSum(); for(int i=0;iscs.al.size();i+) s1=s1+n+si; t.append(s1);if (e.getSource() = b2) this.dispose();/修改信息界面，捕獲輸入的*，查找該生信息，直接在文本框中修改，類(lèi)似添加功能沖新添加該生信息class *iuGai e*tends JFrame imp

43、lements ActionListenerprivate JTe*tField STNOTe*t, SNAMETe*t, MATe*t, CHITe*t, JAVATe*t;private utton b1,b2,b3;public *iuGai()Container c4 = this.getContentPane();c4.setLayout(new GridLayout(4, 1);c4.setFont(new Font(true,Font.TRUETYPE_FONT,13);JPanel up = new JPanel();JPanel center1 = new JPanel();

44、JPanel center2 = new JPanel(new GridLayout(4, 2);JPanel low = new JPanel();JLabel label11 = new JLabel(需要修改的*);STNOTe*t=new JTe*tField(15);up.add(label11);up.add(STNOTe*t);c4.add(up);b1=new utton(查找);center1.add(b1);c4.add(center1);JLabel label21 = new JLabel(, SwingConstants.CENTER);JLabel label22

45、= new JLabel(數(shù)學(xué), SwingConstants.CENTER);JLabel label23 = new JLabel(語(yǔ)文, SwingConstants.CENTER);JLabel label24 = new JLabel(java, SwingConstants.CENTER);SNAMETe*t=new JTe*tField(22);MATe*t=new JTe*tField(22);CHITe*t=new JTe*tField(22);JAVATe*t=new JTe*tField(22);center2.add(label21);center2.add(SNAME

46、Te*t);center2.add(label22);center2.add(MATe*t);center2.add(label23);center2.add(CHITe*t);center2.add(label24);center2.add(JAVATe*t);c4.add(center2);b2=new utton(修改);b3=new utton(退出);low.add(b2);low.add(b3);c4.add(low);b1.addActionListener(this);b2.addActionListener(this);b3.addActionListener(this);t

47、his.setTitle(修改信息);this.setBounds(200, 200, 600, 400);this.setVisible(true);public void actionPerformed(ActionEvent e) if (e.getSource() = b1) for(int i=0;iscs.al.size();i+)if(Integer.parseInt(STNOTe*t.getTe*t()=scs.al.get(i).getNum()SNAMETe*t.setTe*t(scs.al.get(i).getName();MATe*t.setTe*t(String.va

48、lueOf(scs.al.get(i).getShu*ue();CHITe*t.setTe*t(String.valueOf(scs.al.get(i).getYuwen();JAVATe*t.setTe*t(String.valueOf(scs.al.get(i).getJava();if (e.getSource() = b2) if (SNAMETe*t.getColumns() = 0 | MATe*t.getColumns() = 0| JAVATe*t.getColumns() = 0 | CHITe*t.getColumns() = 0)JOptionPane.showMessa

49、geDialog(this, 請(qǐng)?zhí)砑油耆畔?;else scs.del(Integer.parseInt(STNOTe*t.getTe*t();Student a=new Student(SNAMETe*t.getTe*t(),Integer.parseInt(STNOTe*t.getTe*t(),Integer.parseInt(CHITe*t.getTe*t(),Integer.parseInt(MATe*t.getTe*t(),Integer.parseInt(JAVATe*t.getTe*t();scs.adds(a);JOptionPane.showMessageDialog(th

50、is, 修改成功);if (e.getSource() = b3) this.dispose();4 運(yùn)行結(jié)果及分析1、登陸：輸入用戶名和密碼，通過(guò)程序判斷，若正確則進(jìn)入成績(jī)管理系統(tǒng)！2、成績(jī)管理界面 對(duì)系統(tǒng)進(jìn)行初始化，讀出文件信息，監(jiān)聽(tīng)按鈕，創(chuàng)建其它界面對(duì)象，彈出界面查詢(xún)界面通過(guò)對(duì)輸入的*進(jìn)行查詢(xún)，將查到的對(duì)象的相應(yīng)信息輸出到文本框中添加信息輸入學(xué)生信息，監(jiān)聽(tīng)添加按鈕，實(shí)現(xiàn)向文件中添加信息，若*以存在需要重新添加刪除信息輸入需要?jiǎng)h除的學(xué)生的*，刪除對(duì)應(yīng)*的學(xué)生信息修改信息輸入學(xué)生*，查找所有成績(jī)，在文本框中直接修改按鈕，點(diǎn)擊修改及完成修改功能統(tǒng)計(jì)信息進(jìn)入統(tǒng)計(jì)界面后，點(diǎn)擊統(tǒng)計(jì)按鈕，實(shí)現(xiàn)對(duì)學(xué)生成

51、績(jī)求總分，并按總分從大到小輸出到文本區(qū)域中退出點(diǎn)擊成績(jī)管理界面的退出按鈕，會(huì)對(duì)本次的所有操作進(jìn)行保存致這次課程設(shè)計(jì)能夠順利的完成，要感老師的教導(dǎo)和同學(xué)的無(wú)私的幫助。首先是譚小波老師，為我的設(shè)計(jì)改進(jìn)提供了很多寶貴的意見(jiàn)，還有和同學(xué)一起討論幫我解決了幾個(gè)錯(cuò)誤，老師上課時(shí)講得詳細(xì)并嚴(yán)格要求我們，為我們的課程設(shè)計(jì)起了促進(jìn)作用。在此對(duì)老師和給予我?guī)椭耐瑢W(xué)表示最誠(chéng)摯的感！參考文獻(xiàn)1 海藩.軟件工程導(dǎo)論. 清華大學(xué), 20102 洪, 施明利. VB程序設(shè)計(jì)案例匯編. 清華大學(xué), 20103 孟德欣. VB程序設(shè)計(jì). 清華大學(xué), 20114 石志國(guó).VB.NET數(shù)據(jù)庫(kù)編程. 清華大學(xué), 2009 5 友生

52、. 軟件體系結(jié)構(gòu)原理、方法與實(shí)踐. 清華大學(xué), 2010import java.sql.*;public class Student private String id; private String name; private int math; private int english; private int java; private int puter; public String getId() return id; public void setId(String id) this.id = id; public String getName() return name; publ

53、ic void setName(String name) = name; public int getMath() return math; public void setMath(int math) this.math = math; public int getEnglish() return english; public void setEnglish(int english) this.english = english; public int getJava() return java; public void setJava(int java) this.ja

54、va = java; public int getputer() return puter; public void setputer(int puter) this.puter = puter; public static void main(String args) throws E*ception String id; String cid; String name; int math; int english; int java; int puter; String DBDriver = sun.jdbc.odbc.JdbcOdbcDriver; String conStr = jdb

55、c:odbc:student; Connection con = null; Statement stmt = null; ResultSet rs = null; Class.forName(DBDriver); con = DriverManager.getConnection(conStr, student, 123); stmt = con.createStatement(); String s = nnttt學(xué) 生 成 績(jī)nntt 1 新 增ntt 2 更 改ntt 3 刪 除ntt 4 查 找ntt 5 顯 示ntt 0 退 出nn; System.out.print(s); in

56、t choice = Keyboard.getInteger(); switch (choice) / 添加學(xué)生 case 1: System.out.print(請(qǐng)輸入學(xué)生信息n); System.out.print(*:); id = Keyboard.getString(); System.out.print(:); name = Keyboard.getString(); System.out.print(數(shù)學(xué):); math = Keyboard.getInteger(); System.out.print(英語(yǔ):); english = Keyboard.getInteger();

57、 System.out.print(JAVA:); java = Keyboard.getInteger(); System.out.print(計(jì)算機(jī):); puter = Keyboard.getInteger(); stmt.e*ecuteUpdate(insert into l*h1 values( + id + , + name + , + math + , + english + , + java + , + puter + ); System.out.println(n添加完成。); break; / 更改成績(jī) case 2: System.out.println(請(qǐng)輸入要改的學(xué)生*：); cid = Keyboard.getString(); System.out.println(數(shù)學(xué)：); math = Keyboard.getInteger(); System.out.println(英語(yǔ)：); english = Keyboard.getInteger(); System.out.println(JAVA：); java = Keyboard.getInteger(); System.out.println(計(jì)算機(jī)：); puter = Keyboard.getInteger(); stmt.e*ec