基于java的学生管理系统源代码

1、一、课程设计要求：1、用到书上（课本或实验册）上的至少三个实例;2、用到至少两种布局和至少四种组件；3、用到对话框；4、用到对数据库的查询、删除、添加和修改；5、最好用到输入输出流；6、具有一定的实际意义。二、用到的实例及实际意义:2.1程序所用到的实例：1、java2使用教程第10章例题10. 12p282；2、java2使用教程第11章例题11. 8p323；3、java2使用教程第15章所冇例题均冇使用作参考p391-411；4、在其他参考书和网上也冇用到相关程序和代码，并冇所参考和借鉴。22程序的实际意义：木学生成绩管理系统具有对学牛成绩进行管理的功能。并于数据库相连接，能够对 学生的

2、成绩、姓名、出生l1期进行查询、添加和删除等，简捷方便，容易使用。三、程序代码及运行效果：3.1.1主类代码：/*主类代码*/import javax. swing *;import java, awt*;import java. awt. event*;class mypanel extends jpanel image img二toolkit. getdefaulttoolkit (). getlmagec'cr/a. jpg"); public void paint(graphics g)g. drawlmage (img, 0, 0, this);public cla

3、ss mainform extends jframe implements actionlistenerjmenu msystem=new jmenu (，z系统“)；jmenuitem mexit=new jmenuitem(z，退出“)；jmenu moperate=new jmenu c数据操作")；jmenuitem madd=new jmenuitem(，z添加);jmenuitem mdel=new jmenuitem(，?删除“)；jmenuitem mmodify=new jmenuitem(?，修改”)；jmenu mquery=new jmenu ("查

4、询“)；jmenuitem mname=new jmenuitem(，z按姓名查询“)；jmenuitem mscore二new jmenuitem(按成绩查询")；jmenu mhelp=new jmenu c帮助”)；jmenuitem mabout=new jmenuitemc'软件信息“)；jmenubar inbar=new jmenubar ();mainformosuper r学生成绩管理系统)；setsize (875, 583);msystem.add(mexit);moperate. add (m?dd);moperate. add(mdel);moper

5、ate. add (nimodify);mquery. add(mname);mquery. add(mscore);mhelp add(mabout);mbar add(msystem);mbar add(moperate);mbar add(mquery);mbar add(nihelp);setjmenubar (mbar);mexit.addact ionli stener (this);madd. addactionlistener (this);mdel. addactionlistener(this); mmodify. addactionlistener(this);mname

6、. addactionlistener (this);mscore. addactionlistener(this);mabout. addactionlistener(this); setcontentpane(new mypanel();setvisible(true);public void actionperformed(actionevent ae)if (ae. getsource()mexit)system, exit (0);else if (ae getsource()=mabout)joptionpane. showmessagedialog(this,"学生成绩

7、管理系统口!1 m用科学 学院nn2011 年 4 月，软件信息，jopt ionpane. informat i onj'less age);else if (ae. getsource() =inadd)new addform() setvisible(true);else if(ae.getsource()=mdel)new deleteformo. setvisible (true);else if(ae> getsource()=mmodify)new modifyformo. setvisible(true);else if (ae. getsource() nina

8、me)new namequeryform(). setvisible(true);else if (ae. getsource0=mscore)new scorequeryformo. setvisible(true);public static void main(string args) new mainformo ;3. 1.2运行效果:3.2.1修改数据:/*修改数据*/import javax. swing. *;import java.awt.*;import java. awt event. *;import javasql*;public class modifyform ex

9、tends jframe implements actionlistener rijlabel labname二new jlabel ("姓名：“)；j label labdate=new jlabel 出生日期：“);jlabel labscore二new jlabel (成绩：”)；jtextfield txtname=new jtextfield(20);jtextfield txtdate=new jtextfield(18);jtextfield txtscore=new jtextfield(20);jbutton btnmodify=new jbutton(z，修改“)

10、；jbutton btncancel=new jbutton("取消");jbutton btnquery=new jbutton(“查询“)；jpanel pan二new jpanel();jpanel panl二new jpanel();jpanel pan2=new jpanel();jpanel pan3=new jpanel();jpanel pan4=new jpanel();cormection con;statement sql ;resultset rs;modifyformo super ("修改数据");setsize(400, 3

11、00);panl. add(labname);panl. add(txtname);pan2. add(labdate);pan2 add(txtdate);pan3. add(labscore);pan3. add (txtscore);pan4 add(btnquery);pan4. add(btnmodi fy);pan4 add(btncancel);pan. setlayout(new gridlayout (3,1); pan. add(panl);pan. add (pan2);pan. add (pan3);getconlentpane() add(pan, "cen

12、ter"); getcontcntpanc() add(pan4, "south");btnquery addactionli stener(this);btnmodi fy. addactionlistener (this);btncancel. addactionlistener(this);btnmodify. setenabled (false);lxtdate seteditable(false);txtscore. seteditable (false);setvisible(true);txtname. requestfocus ();public

13、void actionperformed (actionevent ao)if (ae. getsource()=btncancel) di sposeo ; else if (ae. getsource () =b tn query) tryclass fornamcn. jdbc odbc. jdbcodbcdriver，z) ;catch(classnotfoundexception e) try con=drivermanager. getconnection: odbc: sugxy123)； sql二con. crcatestatement ();rs=sql. executequ

14、ery (z/select * from 成绩表 where 姓名二'，+txtname. gettext()+"'");if (rs. next () txtname. settext (rs. getstring c姓名");txtscore. settext (new integer (rs. getlnt ("成绩"). tostringo);txtdate. settext (rs. getdate("出生日期").tostringo);btnmodify. setenabled(true);txt

15、date.seteditable(true); txtscore.seteditable(true);else system, out. printlnc'不存在该记录！ ”)；btnmodify. setenabled (false); txtname-settext (")； txtscore. settext(")； txtdate. settext ("");txtdate seteditable(false); txtscore. setedi table (false);catch(sqlexception e) jelse if (

16、aegetsource()=btnmodify)try system, out. print in (''update 成绩表 set 出牛 fl期='"+txtdate. gettext () +"'，成绩二"+txtscore. gcttext () +" where 姓名=，z+txtname. gettext () +"' “)；sql. executeupdate("update 成绩表 set 出生日期 二'"+txtdate gettext () +"&

17、#39;，成绩二"+txtscore gettext () +" where 姓名 ='"+txtname. gettext ()+"' ”)；system, out. printin(，z记录修改完毕! ”); btnmodify. setenabled(false);txtname. settextc"); txtscore. settextc");txtdate. settextc");txtdate. seteditable(false); txtscore. seteditable(false);

18、con. close();catch(sqlexception e) public static void main(string args) new modifyformo ;3.2.2运行效果：3.3.1删除数据:/*删除数据*/import javax. swing. *;import java, awt*;import java. awt. event*;import java, sql*;public class deleteform extends jframe implements actionlistener jjlabel labname=new jlabel (z/姓名：”

19、)；jlabel labdate=new jlabel(，zlb生日期;jlabel labscore=new jlabel (z，成绩：”)；jtextfield txtname=new jtextfield(20);jtextfield txtdate=new jtextfield(18);jtextfield txtscore=new jtextfield(20);jbutton btndelete=new jbuttonc删除“)；jbutton btncancel=new jbutton ("取消“)；jbutton btnquery=new jbutton ("

20、杏询”)；jpanel pan二new jpanel();jpanel panl=new jpanel();jpanel pan2=new jpanel();jpanel pan3=new jpanel();jpanel pan4=new jpanel();connection con;statement sql;resultset rs;deleteformoitsuper r删除数据)； setsize(400, 300);pan1 add(labname);pan1 add(txtname);pan2. add(labdate); pan2 add(txtdate);pan3 add(l

21、abscore);pan3 add (txtscore);pan4 add(btnquery);pan4 add(btndelete);pan4 add(btncancel);pan. setlayout (new gridlayout (3, 1);pan.add (pan1);pan. add (pan2);pan. add (pan3);getcontentpane(). add(pan, "center"); getcontentpaneo. add (pan4, "south"); btnquery. addactionlistener(thi

22、s);btndelete.addactionlistener(this);btncancel.addactionlistener(this);btndelete. setenabled (false) ;/取消删除按钮的功能 txtdate. seteditable(false);txtscore seteditable(false); setvisible(true);txtname. requestfocus();public void actionperformed(actionevent ae)if (ae. getsource () btncancel)dispose();else

23、if (ae. getsource()btnquery) /实现杳询功能tryclass. forname(z，sun. jdbc. odbc. jdbcodbcdriverz，); catch(classnotfoundexception e) trycon=drivermanager. getconnection("jdbc:odbc:sun",123)；sql=con createstatement ();rs=sql. executequery ('"select * from 成绩表 where 姓 名 ='"+txtname.

24、 gettext ()+"' ”)；if (rs. next ()txtname. settext (rs. getstringc姓名");txtscore.settext (new integer(rs. getlnt(“ 成 绩 ) tostringo)；txtdate. settext (rs. getdate("出生日期").tostringo); btndelete. setenabled (true) ;/使删除按钮功能实现 txtdate seteditable(true);txtscore seteditable(true);el

25、sesystem, out. printlnc不存在该记录！ “);btndelete. setenabled (false);txtname settext (")； txtscore. settext ()； txtdate. settext (")； txtdate seteditable(false); txtscore seteditable(false);catch(sqlexception e) trysystem, out. print in ("'update 成绩表 set 出 生日期 二'"+txtdate. get

26、text () +"', 成 绩 =，/+txtscore. gettext () +" where 姓 名 二'，+txtname. gettext () +"'");sql. executeupdate("'delete from 成绩表 where 姓名 二'，+txtname. gettext () +"'");system, out. printin("记录删除完毕! ”);btndelete. setenabled (false);txtname. set

27、text("");txtscore. settext ("");txtdate. settext("");txtdate. seteditable(false);txtscore. seteditable(false);con. close ();catch(sqlexception e) public static void main(string args)new deleteformo ; 3.3.2运行效果：3.4.1添加数据:/*添加数据*/import javax. swing. *;import java.awt.*;i

28、mport java. awt event. *;import javasql*;public class addform extends jframe implements actionlistener rijlabel labname二new jlabel (，z姓名：“)；j label labdate=new jlabel 出生日期：“);jlabel labscore二new jlabel (成绩：”)；jtextfield txtname=new jtextfield(20);jtextfield txtdate=new jtextfield(18);jtextfield txts

29、core=new jtextfield(20);jbutton btnadd=new jbutton (，z添加“);jbutton btncancel=new jbutton("取消");jpanel pan=new jpancl();jpanel panl二new jpanel();jpanel pan2=new jpanel();jpanel pan3=new jpanel();jpanel pan4=new jpanel();connection con;statement sql;resultset rs;addform ()itsuper (z，添加数据&quo

30、t;);setsize(400,300);panl. add(labname);panl. add(txtname);pan2 add(labdate);pan2. add(txtdate);pan3 add(labscore);pan3. add (txtscore);pand. add(btnadd);pan4 add(btncancel);pan. setlayout(new gridlayout (3,1);pan. add (panl);pan. add (pan2);pan. add (pan3);getcontentpane(). add(pan, "center&qu

31、ot;);getcontentpanc() add(pan4, "south");btnadd addactionli stoner (this);btncance1. addactionlistener(this);btnadd setenabled(true);txtdate. seteditable(true);txtscore seteditable(true);setvisible(true);txtname requestfocus ();public void actionperformed(actionevent ae)string recode, inse

32、rtl, hi生日期，姓名；int成绩；if (ae. getsource () btncancel)this, dispose ();else if(ae. getsource ()二二btnadd)tryclass fornamesin. jdbc odbc. jdbcodbcdriver，z) ;catch (classnotfoundexception e) try con=drivermanager getconnection: odbc: sun，z, "gxy", "123");sql二con. creatcstatement();姓名二t

33、xtname. gettext ();出生日期二txtdate. gettext ();成绩二integer. parselnttxtscore. gettext ();recode r+/z，+姓名+' +,+，+出生日期+', +成绩+)；insert 1=z，insert tnto 成绩表 values "+recode;sql. executeupdate (insert 1);system, out. print in (z，记录添加完毕！");btnadd setenabled(false);txtname. settext ;txtscore.

34、 settext("");txtdate. settext("");con. closeo ;catch(sqlexcept i on e) public static void main(string args)inew addformo ;3.4.2运行效果:3. 5.1按姓名查询数据：/*按姓名杏询数据*/import javax swing *;import java.awt.*;import java. awt. event*;import java.sql.*;public class namcqueryform extends jframo

35、 imp1ements actionlistcner jlabel labname=new jlabelc'姓名：”)；jlabel labdate=new jlabel ("出生 口期：“)；jlabel labscorenew jlabel (，z成绩：”)；jtextfield txtname二new jtextfield(20);jtextfield txtdate二new jtextfield(18);jtextfield txtscore二new jtextfield(20);jbutton btncancel=new jbutton("取消"

36、);jbutton btnquery=new jbutton(査询“)；jpanel pan=new jpanel();jpanel panlnew jpanel();jpanel pan2=new jpanel();jpanel pan3=new jpanel();jpanel pan4=new jpanel();connection con;statement sql;resultset rs;namequeryform ()super (z/按姓名杏询)；setsize(400,300);panl. add(labname);panl. add(txtname);pan2. add(la

37、bdate);pan2 add(txtdate);pan3. add (labscore);pan3. add (txtscore);pan4. add(btnquery);pand. add(btncancel);pan. setlayout(new gridlayout(3,1);pan. add(panl);pan. add (pan2);pan. add (pan3);getcontentpaneo. add (pan, center");getcontentpane () - add (pan4, /zsouthz，);btnquery. addactionlistener

38、(this);btncancel. addactionlistener (this);txtdate. seteditable(false); txtscore seteditable (false); setvisible(true);txtnamc. requestfocus ();public void actionperformed (actionevent ae)if (ae. getsource 0 btncancel) dispose(); else if (ae getsource ()=bt，nqucry) tryclass. fornamesm. jdbe. odbe. j

39、dbcodbcdriverz，) ;catch(classnotfoundexception e) try condrivermanager getconncction: odbc: sunzz, "gxy", "123"); sql二con createstatement ();rs=sql. executequery (，zselect * from 成绩表i where 姓名 二'"+txtname. gettext () +"'");if (rs. next () txtname. settcxt (

40、rs. getstring(z，姓名")； txtscore settext (new integer (rs. getlnt (成绩) tostringo);txtdate. settext (rs. getdatec出生日期) tostringo);elsesystem, out. println(z，不存在该记录！"); txtname. settextd ;txtscore settextc");txtdate. settext("");txtname. requcsteocus 0; catch (sqi.exception e) p

41、ublic static void mdin(stting args) new namequeryform();3. 5.2运行效果：3.6.1按成绩查询数据：/*按成绩杏询数据*/import javax swing *;import java.awt.*;import java. awt. event*;import java.sql.*;import javax.swing, table dofau11tab1emodo1;import javax. swing table jtabloheader;public class scorequeryform extends jframe i

42、mplements actionlistenerj label labscore 二 new jlabel ( 请输入成绩：“);jtextfield txtscore=new jtextfield(10);jbutton btnquery=new jbutton(z，査询“);jpanel panl二new jpanel();jpanel pan2=new jpanel();string str=f姓名，出生日期，成绩;object data二new object103;jtable table二new jtable(data, str):jtableheader head二table ge

43、ttableheader (); jscrolipane jsp=new jscrol1 pane(table); connection con;statement sql;resultset rs;scorequeryform()super (，?按成绩查询)；setsize(400, 300);panl. add(labscore);panl. add(txtscore);panl. add(btnquery);/滚动以上3条在笫一个血板加入内容/把而板1放到窗口顶部pan2. add(head, "north");/将表头放在面板2的顶部getcontentpane() add (panl, "north"); pan2 setlayout(new borderlayout();/农格放在pan21»间pan2 add(jsp, cenler");getcontentpane (). add (pan2, "center"); 把lil板2整体加入到主窗口中btnquery. addactionlistener