基于JAVA的学生成绩管理系统设计与实现（源代码）

《基于JAVA的学生成绩管理系统设计与实现（源代码）》由会员分享，可在线阅读，更多相关《基于JAVA的学生成绩管理系统设计与实现（源代码）（21页珍藏版）》请在装配图网上搜索。

1、Java程序设计系 别 专 业班 级学 号 15号姓 名 刘XX题 目基于JAVA的学生成绩管理系统设计与实现任课教师 彭ZZ一：要求1、 用到书上（课本或实验册）上的至少三个实例2、 用到至少两种布局和至少四种组件3、 用到对话框4、 用到对数据库的查询、删除、添加和修改5、 最好用到输入输出流6、 具有一定的实际意义二：内容 本系统用access作为数据库，用到了书上的布局实例和数据库连接实例功能: 1、输入十个同学的学号，姓名，出生日期，二科成绩(学，大学英语) 。2、输入学号查询学生信息。 3、删除记录4、查询记录5、添加记录6、修改记录三：代码第一部分：public class ma

2、in public static void main(String args) zhuchuangkou win=new zhuchuangkou();第二部分主界面：import java.awt.*;import java.awt.event.*;import javax.swing.*;import javax.swing.border.*;public class zhuchuangkou extends Frame implements ActionListenerButton button1,button2,button3,button4,tuichu;Panel p1,p2,p3

3、;Label l1,l2,l3;TextField a1,a2;Box b1,b2,b3,b4,b5;ss s;zhuchuangkou()button1=new Button(登陆);button2=new Button(删除);button3=new Button(修改);button4=new Button(添加);tuichu=new Button(退出);p1=new Panel();p2=new Panel();p3=new Panel();l1=new Label(学生成绩管理,Label.CENTER);l1.setFont(new Font(宋体,Font.BOLD,72);

4、l1.setBackground(Color.green);l2=new Label(登录名);l3=new Label(密码);a1=new TextField(10);a2=new TextField(10);a2.setEchoChar(*);b1=Box.createVerticalBox();b1.add(l2);b1.add(Box.createVerticalStrut(8);b1.add(l3);b2=Box.createVerticalBox();b2.add(a1);b2.add(Box.createVerticalStrut(8);b2.add(a2);b4=Box.cr

5、eateHorizontalBox();b4.add(button1);b4.add(Box.createHorizontalStrut(10);b4.add(tuichu);b3=Box.createHorizontalBox();b3.add(b1);b3.add(Box.createHorizontalStrut(10);b3.add(b2);b5=Box.createVerticalBox();b5.add(b3);b5.add(Box.createVerticalStrut(8);b5.add(b4);button1.addActionListener(this);button2.a

6、ddActionListener(this);button3.addActionListener(this);button4.addActionListener(this);tuichu.addActionListener(this);p1.add(l1);p2.add(b5);add(p1,BorderLayout.NORTH);add(p2,BorderLayout.CENTER);add(p3,BorderLayout.PAGE_END);addWindowListener(new WindowAdapter()public void windowClosing(WindowEvent

7、e)dispose(););setBackground(Color.RED);setBounds(10, 10, 1000, 500);setVisible(true);validate();public void actionPerformed(ActionEvent e)if(e.getSource()=tuichu)System.exit(0);if(e.getSource()=button1)if(a1.getText().equals(liuzhenji)&a2.getText().equals(123456)new chuankou();System.out.println(www

8、ww);dispose();elseSystem.out.print(nishurucuowu);第三部分选择操作：import java.awt.*;import java.awt.event.*;import javax.swing.*;import javax.swing.border.*;public class zhuchuangkou extends Frame implements ActionListenerButton button1,button2,button3,button4,tuichu;Panel p1,p2,p3;Label l1,l2,l3;TextField

9、a1,a2;Box b1,b2,b3,b4,b5;ss s;zhuchuangkou()button1=new Button(登陆);button2=new Button(删除);button3=new Button(修改);button4=new Button(添加);tuichu=new Button(退出);p1=new Panel();p2=new Panel();p3=new Panel();l1=new Label(学生成绩管理,Label.CENTER);l1.setFont(new Font(宋体,Font.BOLD,72);l1.setBackground(Color.gre

10、en);l2=new Label(登录名);l3=new Label(密码);a1=new TextField(10);a2=new TextField(10);a2.setEchoChar(*);b1=Box.createVerticalBox();b1.add(l2);b1.add(Box.createVerticalStrut(8);b1.add(l3);b2=Box.createVerticalBox();b2.add(a1);b2.add(Box.createVerticalStrut(8);b2.add(a2);b4=Box.createHorizontalBox();b4.add

11、(button1);b4.add(Box.createHorizontalStrut(10);b4.add(tuichu);b3=Box.createHorizontalBox();b3.add(b1);b3.add(Box.createHorizontalStrut(10);b3.add(b2);b5=Box.createVerticalBox();b5.add(b3);b5.add(Box.createVerticalStrut(8);b5.add(b4);button1.addActionListener(this);button2.addActionListener(this);but

12、ton3.addActionListener(this);button4.addActionListener(this);tuichu.addActionListener(this);p1.add(l1);p2.add(b5);add(p1,BorderLayout.NORTH);add(p2,BorderLayout.CENTER);add(p3,BorderLayout.PAGE_END);addWindowListener(new WindowAdapter()public void windowClosing(WindowEvent e)dispose(););setBackgroun

13、d(Color.RED);setBounds(10, 10, 1000, 500);setVisible(true);validate();public void actionPerformed(ActionEvent e)if(e.getSource()=tuichu)System.exit(0);if(e.getSource()=button1)if(a1.getText().equals(liuzhenji)&a2.getText().equals(123456)new chuankou();System.out.println(wwwww);dispose();elseSystem.o

14、ut.print(nishurucuowu);第四部分查询界面实现：import java.awt.*;import java.awt.event.*;import java.sql.*;import javax.swing.JOptionPane;public class ss extends Frame implements TextListener,ActionListenerButton xunzhao;TextField input;TextArea show;String s;int k;Connection con; Statement sql; int sum=0; Resul

15、tSet rs;ss()Panel p=new Panel();xunzhao= new Button(查找);input= new TextField(10);show= new TextArea(6,43);p.add(new Label(输入学号);p.add(input);p.add(xunzhao);xunzhao.addActionListener(this);show.addTextListener(this);show.setEditable(false);add(p,BorderLayout.NORTH);add(show,BorderLayout.CENTER);setBo

16、unds(10,30,500,200);setVisible(true);validate();addWindowListener(new WindowAdapter()public void windowClosing(WindowEvent e)dispose(););public void actionPerformed(ActionEvent ee) boolean boo=true;s=input.getText();k=Integer.parseInt(s);try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); catch(ClassNo

17、tFoundException eee) System.out.println(+eee)； try con=DriverManager.getConnection(jdbc:odbc:sun,gxy,123); sql=con.createStatement(); rs=sql.executeQuery(SELECT * FROM chengjibiao ); while(rs.next() int number=rs.getInt(number); String name=rs.getString(name); String date=rs.getString(birthday); int

18、 math=rs.getInt(math); int english=rs.getInt(english); if(number=k) boo=false; show.setText(null); show.append(学号：+number+ 姓名：+name+ 出生：+date+ 数学 +math+ 英语 +english); show.append(n); con.close(); if(boo) JOptionPane.showMessageDialog(this, 你输入的学号不存在); catch(SQLException eee) System.out.println(eee);

19、 第五部分删除：import java.awt.*;import java.awt.event.*;import java.sql.*;import javax.swing.JOptionPane;public class shanchu extends Frame implements TextListener,ActionListenerButton xunzhao;TextField input;TextArea show;String s;int k,s1,j;Connection con; Statement sql; int sum=0; ResultSet rs;shanchu(

20、)Panel p=new Panel();xunzhao= new Button(删除);input= new TextField(10);show= new TextArea(6,43);p.add(new Label(输入要删除的 +学号);p.add(input);p.add(xunzhao);xunzhao.addActionListener(this);show.addTextListener(this);show.setEditable(false);add(p,BorderLayout.NORTH);add(show,BorderLayout.CENTER);setBounds(

21、10,30,500,200);setVisible(true);validate();addWindowListener(new WindowAdapter()public void windowClosing(WindowEvent e)dispose(););public void actionPerformed(ActionEvent ee) boolean boo=true;s=input.getText();k=Integer.parseInt(s);String m,dir;try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); catch

22、(ClassNotFoundException eee) System.out.println(+eee); try con=DriverManager.getConnection(jdbc:odbc:sun,gxy,123); sql=con.createStatement(); rs=sql.executeQuery(SELECT * FROM chengjibiao); while(rs.next() int number=rs.getInt(2); String name=rs.getString(3); String date=rs.getString(birthday); int

23、math=rs.getInt(math); int english=rs.getInt(english); if(number=k) show.setText(你删除了:); show.append(学号：+number+ 姓名：+name+ 出生：+date+ 数学 +math+ 英语 +english); show.append(n); m=DELETE FROM chengjibiao WHERE number=+k+; sql.executeUpdate(m); con.close(); catch(SQLException e) System.out.println(e); 第六部分

24、修改：import java.awt.*;import java.awt.event.*;import java.sql.*;import javax.swing.JOptionPane;public class xiugai extends Frame implements TextListener,ActionListenerButton charu;TextField input1,input2,input3,input4,input5,input6;TextArea show;Panel p1,p2;int k,s1,j;Connection con; Statement sql; i

25、nt sum=0; ResultSet rs;xiugai() p1=new Panel(); p2=new Panel();charu= new Button(修改);input1= new TextField(10);input2= new TextField(10);input3= new TextField(10);input4= new TextField(10);input5= new TextField(10);input6= new TextField(10);show= new TextArea(6,43);p1.add(new Label(请输入要修改的学号);p1.add

26、(new Label(number);p1.add(input1);p2.add(new Label(请输入修改的数据);p2.add(new Label(name);p2.add(input2);p2.add(new Label(date);p2.add(input3);p2.add(new Label(math);p2.add(input4);p2.add(new Label(english);p2.add(input5);p2.add(charu);charu.addActionListener(this);show.addTextListener(this);show.setEdita

27、ble(false);add(p1,BorderLayout.NORTH);add(p2,BorderLayout.CENTER);setBounds(10,30,1200,200);setVisible(true);validate();addWindowListener(new WindowAdapter()public void windowClosing(WindowEvent e)dispose(););public void actionPerformed(ActionEvent ee) boolean boo=true;String s0,s1,s2,s3,s4,s5,inser

28、t1,recode,name,date;int m0,m1,m2,m3,number,math,english;s1=input1.getText();m1=Integer.parseInt(s1);number=m1;s4=input4.getText();m2=Integer.parseInt(s4);math=m2;s5=input5.getText();m3=Integer.parseInt(s5);english=m3;try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); catch(ClassNotFoundException eee)

29、System.out.println(+eee); try con=DriverManager.getConnection(jdbc:odbc:sun,gxy,123); sql=con.createStatement();recode=(+m0+,+number+,+name+,+date+,+math+,+english+); insert1=UPDATE chengjibiao SET math=+math+,english=+english+ WHERE number=+number+; sql.executeUpdate(insert1); catch(SQLException e)

30、 System.out.println(e); 第七部分添加：import java.awt.*;import java.awt.event.*;import java.sql.*;import javax.swing.JOptionPane;public class charu extends Frame implements TextListener,ActionListenerButton charu;TextField input1,input2,input3,input4,input5,input6;TextArea show;int k,s1,j;Connection con; S

31、tatement sql; int sum=0; ResultSet rs;charu()Panel p=new Panel();charu= new Button(插入);input1= new TextField(10);input2= new TextField(10);input3= new TextField(10);input4= new TextField(10);input5= new TextField(10);input6= new TextField(10);show= new TextArea(6,43);p.add(new Label(请输入要插入的数据);p.add

32、(new Label(ID);p.add(input6);p.add(new Label(number);p.add(input1);p.add(new Label(name);p.add(input2);p.add(new Label(date);p.add(input3);p.add(new Label(math);p.add(input4);p.add(new Label(english);p.add(input5);p.add(charu);charu.addActionListener(this);show.addTextListener(this);show.setEditable

33、(false);add(p,BorderLayout.NORTH);add(show,BorderLayout.CENTER);setBounds(10,30,1200,200);setVisible(true);validate();addWindowListener(new WindowAdapter()public void windowClosing(WindowEvent e)dispose(););public void actionPerformed(ActionEvent ee) boolean boo=true;String s0,s1,s2,s3,s4,s5,insert1

34、,recode,name,date;int m0,m1,m2,m3,number,math,english;s0=input5.getText();m0=Integer.parseInt(s0);s1=input1.getText();m1=Integer.parseInt(s1);number=m1;s2=input2.getText();name=s2;s3=input3.getText();date=s3;s4=input4.getText();m2=Integer.parseInt(s4);math=m2;s5=input5.getText();m3=Integer.parseInt(

35、s5);english=m3;try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); catch(ClassNotFoundException eee) System.out.println(+eee); try con=DriverManager.getConnection(jdbc:odbc:sun,gxy,123); sql=con.createStatement();recode=(+m0+,+number+,+name+,+date+,+math+,+english+); insert1=INSERT INTO chengjibiao VAL

36、UES +recode; sql.executeUpdate(insert1); show.setText(你插入了:); show.append(学号：+number+ 姓名：+name+ 出生：+date+ 数学 +math+ 英语 +english); show.append(n); catch(SQLException e) System.out.println(e); JOptionPane.showMessageDialog(this, 你输入的不正确); 四：运行效果五总结：本次课程设计，让我获益匪浅，不仅更深入的了解Java这门学科，更使自己有了继续探索的兴趣。于个人而言，在程

37、序设计的过程中，我深感“认真严谨”这个词的重要性，一点点小的马虎，便会导致整个程序不能正常运行。在今后的学习中，我定将“认真严谨时刻作为自的谨言。与此同时，本小组成员的互帮互助，让我体会到了团结的力量，而更让人难以忘怀的是在热烈讨论问题时，那激情横溢的场面。总之，此次课程设计在我的学生生涯中启上了至关重要的作用。最后，真诚的感谢彭老师的指导和教诲。恋爱运UP一绪Lets月亭方正！気持今Flying Get！dou都斗豆逗陡抖痘兜读蚪窦篼蔸乧侸兠凟剅吺唗投斣枓梪橷毭氀浢渎渎瞗窬窦脰艔豆读逾郖酘酡钭鋀钭閗闘阧餖饾斗鬦鬪鬬鬭du读度毒渡堵独肚镀赌睹杜督都犊妒顿蠹笃嘟渎椟牍黩髑芏儥凟剢剫匵厾噣土涂妬嬻

38、剬塅媏彖断毈瑖碫篅簖缎专腶葮褍踹躖锻鍴Mr Najib met search crews at Pearce RAAF base near Perth on Thursday morning, before their planes left for the day, and then later held talks with Mr Abbott.The disappearance of MH370 has tested our collective resolve, he told a news conference.Faced with so little evidence, and s

39、uch a Herculean task, investigators from Malaysia, the US, the UK, China, Australia and France have worked without pauseHe thanked both search teams and the Australian government for their efforts in recent weeks, and said the search would go on.Continue reading the main storyMH370 - Facts at a glan

40、ce 8 March:Malaysia Airlines Kuala Lumpur-Beijing flight carrying 239 people disappears Planes transponder, which communicates with ground radar, was switched off as it left Malaysian airspace Satellite pings indicate plane was still flying seven hours after satellite contact was lost 24 March:Based

41、 on new calculations, Malaysian PM says beyond reasonable doubt that plane crashed in southern Indian Ocean with no survivors What we know The search for flight MH370I know that until we find the plane, many families cannot start to grieve. I cannot imagine what they must be going through. But I can

42、 promise them that we will not give up, he said.Malaysian authorities have come in for heavy criticism over their management of the search, especially from relatives of thWeather conditions were fair, with visibility of approximately 10km (6 miles), the Joint Agency Coordination Centre (JACC) - whic

43、h is overseeing the search - said.The British submarine HMS Tireless is also in the southern Indian Ocean and is due to be joined by Royal Navy ship HMS Echo.The Australian Navy ship Ocean Shield is heading to the region and has equipment for detecting the planes black-box flight recorder.Experts sa

44、y timing is critical as the flight recorder may only have enough battery power to send out a signal until 7 April.Air Chief Marshall Angus Houston, head of the JACC, warned that the search operation faced multiple difficulties.This is one of the most demanding and challenging search and rescue opera

45、tions, or search and recovery operations, that I have ever seen and I think probably one of the most complex operations of this nature that the world has ever seen, he told Mr Najib and Mr Abbott.On Wednesday Malaysian police chief Khalid Abu Bakar said investigators had cleared all passengers of po

46、ssible involvement in hijacking, sabotage or having personal or psychological problems that could have been connected to the disappearance.But he said that the criminal investigation could go on and on and on. We have to clear every little thing.At the end of the investigations, we may not even know

47、 the real cause. We may not even know the reason for this incident, he added.The police chief said that more than 170 interviews had been conducted with family members of the pilots and crew members, and that even cargo and food served on the plane were being investigated in case ofdui对队堆兑敦镦碓怼憝兊兑垖埻塠

48、夺夺対对嵟憞怼捶杸濧濻瀢瀩痽磓祋綐膭薱謉譈譵追鈗锐锐錞鎚镦鐜锐陮队頧鴭dul乧dun吨顿蹲墩敦钝盾囤遁不趸沌盹镦礅炖砘伅俊吨墪壿庉忳敦憞撉撴楯橔潡炖犜獤碷腞腯蜳豚踲蹾趸逇遯钝镦鐜顿驐duo多朵夺舵剁垛跺惰堕掇哆驮度躲踱沲咄铎裰哚缍亸仛兊兑兑凙刴剟剫吋喥嚉嚲垜埵堕墯夛夺奲媠嫷尮崜嶞憜挅挆捶揣敓敚敠敪朶杂杕枤柁柂柮桗棰椯椭毲沰沱泽痥硾缍茤袳詑誃貀趓跢跥跿躱軃郸郸鈬錞锗铎锗陀陊隋隋隓飿饳驮駄鬌鮵鵽点e饿哦额鹅蛾扼俄讹阿遏峨娥恶厄鄂锇谔垩锷阏萼苊轭婀莪鳄颚腭愕呃噩鹗屙亚亜亚伪佮侉偔伪伪僫匎匼卾吪呝咢咹哑唖啈啊啐哑恶囐囮垭垭垩堨堮妸妿姶娾娿媕屵岋峉峩崿庵廅悪恶戹搕搤搹擜曷枙桠櫮唉歞歹歺洝涐湂猡珴琧痷皒睋

49、砈砐砨砵硆硪磀礘胺蒍蕚蘁蚅蝁覨讹咯誐谔譌讍豟轭軶輵迗遌遻邑鈋锇锷鑩閜阏阨阸隘頞頟额颚饿餩騀鬲魤魥鳄鰪鳄鴳鵈鹅鵞鹗齃腭齾青年（）、技术（）、恋爱（）、翡翠（）、読书（）、人（，）、幸福（）、训读词汇：青（）、术（）、恋（）、好（）、読（）、人（）、幸（）、汉字“海”可以读成“”也可以读成“”。“”是它的音读，“”是它的训读。“史宪巨”等汉字一般只使用它们的一种音读，“贝又咲（）”一般只使用它们的一种训读，但这类汉字较少。日语里的汉字通常都有两三种甚至更多的音训读发音。比如“生”，音读可读作“”，训读可读作“”等。同上面所说的，汉字每个字都有与之对应的音读、训读，但也有一些比较特殊。比如“梅雨”，

50、它的发音为“”，不能把每个汉字分别读什么区分开来。我们把这类发音叫做“熟字训”。以下这些也是“熟字训”：田舎（） 时雨（）相扑（写作“相扑”，）土产（） 为替（）红叶（）吹雪（） 足袋（）日和（）蒲公英（）en恩摁蒽嗯奀峎煾饐唔eng鞥eo仒eol乻eom欕eos旕er而二耳儿饵尔贰洱珥鲕鸸佴迩铒侕児儿刵咡唲奶尒尓峏弍弐杒栭栮樲毦洏渪濡尔粫耏聏胹臑荋薾衈袻誀貮贰趰輀輭轜迩铒陑陾隭饵駬髵髶鲕鸸fa发法罚伐乏筏阀珐垡砝佱傠姂废彂拔拨拨栰橃泛沷泛灋珐疺発发瞂笩罚罸茷蕟藅贬贬醗发鍅阀髪发fan反饭翻番犯凡帆返泛繁烦贩范樊藩矾钒燔蘩畈蕃蹯梵幡仮伋凢凣勫匥噃墦奿婏嬎嬏嬔忛憣払拚旙幡杋柉棥枫橎氾泛渢滼瀪瀿烦

51、犿璠畨盕矾笲笵范籓籵緐翻羳膰舤舧舩薠蟠蠜袢襎訉贩軓軬轓辺钒鐇颿飜饭飰鱕鷭攵犭fang放房防纺芳方访仿坊妨肪钫彷邡枋舫鲂仿匚埅堏旊昉昘昞汸淓牥瓬眆眪祊纺蚄访趽钫錺雱髣鲂鰟鳑鴋鶭fei非飞肥费肺废匪吠沸菲诽啡篚蜚腓扉妃斐狒芾悱镄霏翡榧淝鲱绯痱俷剕厞墢奜婓婔扉廃废怫拂昲暃曊朏杮柹棐橃橨櫠渄濷犻猆琲痱癈砩祓笰绋绯绋巯胏胐茀茇萉蕜蕟蕡蜰蟦裴裵裶襏诽费镄陫靅靟飞飝餥馡騑騛髴鲱鼣鼥fen分份芬粉坟奋愤纷忿粪酚焚吩氛汾棼瀵鲼玢偾鼢偾匪喷喷坆坋坟奔奋妢岎帉幩弅愍愤扮拚敃昐朆朌枌梤棻橨歕濆炃燌燓燔獖盼瞓砏秎竕粪纷羒羵翂肦膹葐蒶蕡蚠蚡衯訜豮豶贲贲躮轒鈖錀鐼隫雰颁颁餴饙馚馩魵鱝鳻黂黺鼖feng风封逢缝蜂丰枫疯冯奉讽凤

52、峰锋烽砜俸酆葑沣唪仹偑僼凨凬凮埄堸夆妦寷峯崶捀捧摓桻枫檒沨泛浲渢湗溄漨沣炐焨煈熢犎猦琒甮疯盽碸篈綘缝肨舽艂莑蘕蘴蚌覂讽豊丰賵赗逄鄷锋鎽鏠靊风飌冯鳯凤鴌鹏鹏麷覅fo佛仏仸坲梻fou否缶不垺妚炰紑缹缻芣杯雬鴀fu副幅扶浮富福负伏付复服附俯斧赴缚拂夫父符孵敷赋辅府腐腹妇抚覆辐肤氟佛俘傅讣弗涪袱市甫釜脯腑阜咐黼砩苻趺跗蚨芾鲋幞茯滏蜉拊菔蝠鳆蝮绂绋赙罘稃匐麸凫桴莩孚馥驸怫祓呋郛芙艴黻不乀仅夫俌俛偩逼冨冹刜包呒咈哹哺呒坿垘垺报妋姇娐婏妇媍嬎嬔宓尃岪峊巿帗弣彳佛复怀怤懯抙捊捬掊抚旉枎枹柎柫柭栿棴椨椱榑汱沕沸泭洑溥澓炥烰焤玞玸琈璷甶畉畐畗癁盙砆祔禣秿稪竎笰筟箁箙簠粰糐紨绂绋絥綍綒緮缚纀罘翇胕肤艀芣茀荂荴莆萉萯葍蓲蕧虙蚥蚹蛗蜅蝜衭袚袝复褔襆襥覄讣詂諨豧负费赋赙费踾軵辅輹辐还邚邞郍郙鄜酜酻釡鈇鉘鉜錇鍑鍢锫阝陚鞴韍韛韨頫颫颰驸髴鬴鮄鲋鮲鳆凫凫鳺鴔鵩鶝麸麬麱