基于java的學(xué)生管理系統(tǒng)源代碼

1、一、課程設(shè)計要求：1、用到書上（課本或?qū)嶒瀮裕┥系闹辽偃齻€實例;2、用到至少兩種布局和至少四種組件；3、用到對話框；4、用到對數(shù)據(jù)庫的查詢、刪除、添加和修改；5、最好用到輸入輸出流；6、具有一定的實際意義。二、用到的實例及實際意義:2.1程序所用到的實例：1、java2使用教程第10章例題10. 12p282；2、java2使用教程第11章例題11. 8p323；3、java2使用教程第15章所冇例題均冇使用作參考p391-411；4、在其他參考書和網(wǎng)上也冇用到相關(guān)程序和代碼，并冇所參考和借鑒。22程序的實際意義：木學(xué)生成績管理系統(tǒng)具有對學(xué)牛成績進(jìn)行管理的功能。并于數(shù)據(jù)庫相連接，能夠?qū)?學(xué)生的

2、成績、姓名、出生l1期進(jìn)行查詢、添加和刪除等，簡捷方便，容易使用。三、程序代碼及運行效果：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系統(tǒng)“)；jmenuitem mexit=new jmenuitem(z，退出“)；jmenu moperate=new jmenu c數(shù)據(jù)操作")；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學(xué)生成績管理系統(tǒng))；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,"學(xué)生成績

7、管理系統(tǒng)口!1 m用科學(xué) 學(xué)院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修改數(shù)據(jù):/*修改數(shù)據(jù)*/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 ("修改數(shù)據(jù)");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刪除數(shù)據(jù):/*刪除數(shù)據(jù)*/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刪除數(shù)據(jù))； 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) /實現(xiàn)杳詢功能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) ;/使刪除按鈕功能實現(xiàn) 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添加數(shù)據(jù):/*添加數(shù)據(jù)*/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，添加數(shù)據(jù)&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按姓名查詢數(shù)據(jù)：/*按姓名杏詢數(shù)據(jù)*/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按成績查詢數(shù)據(jù)：/*按成績杏詢數(shù)據(jù)*/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條在笫一個血板加入內(nèi)容/把而板1放到窗口頂部pan2. add(head, "north");/將表頭放在面板2的頂部getcontentpane() add (panl, "north"); pan2 setlayout(new borderlayout();/農(nóng)格放在pan21»間pan2 add(jsp, cenler");getcontentpane (). add (pan2, "center"); 把lil板2整體加入到主窗口中btnquery. addactionlistener