課程管理系統(tǒng)課程設(shè)計(jì)說明書

1、中北大學(xué)信息商務(wù)學(xué)院課程設(shè)計(jì)說明書學(xué)生姓名：學(xué)號(hào)：學(xué)院：計(jì)算機(jī)與控制工程專業(yè)：計(jì)算機(jī)科學(xué)與技術(shù)題 i:課程管理系統(tǒng)指導(dǎo)教師：徐志勇職稱： 講師2013年12月26日1系統(tǒng)設(shè)計(jì)1.1目標(biāo)設(shè)計(jì)在工資管理中，需要從公司管理方式以及實(shí)際情況中提取相關(guān)信息，以反映工資管理情 況。傳統(tǒng)的手工操作方式，易發(fā)生數(shù)據(jù)丟失，統(tǒng)計(jì)錯(cuò)誤，勞動(dòng)強(qiáng)度高，且速度慢。使用計(jì)算 機(jī)可以高速，快捷地完成以上工作。避免重復(fù)勞動(dòng)，規(guī)范工資管理行為，從而提髙了管理效 率和水平。讓人們的效率大大提高.不難想象，正是資訊的迅速發(fā)展使得人們從過去繁復(fù)的手工勞作中得以解脫，從而使這 種服務(wù)在現(xiàn)在才可能迅速普及。同吋，編寫一套完整的工資管理系統(tǒng)

2、的任務(wù)就顯得尤為重要。 1.2開發(fā)和運(yùn)行環(huán)境選擇開發(fā)工具：sql2000, java語(yǔ)言。運(yùn)行壞境：windows xp,windows 2000 或 vista 操作系統(tǒng)。1.3系統(tǒng)功能分析本系統(tǒng)主要用于員工基本信息的管理，對(duì)員工以及其他信息的添加、修改、刪除、查詢 等基本操作。對(duì)于數(shù)據(jù)庫(kù)的保護(hù)有數(shù)據(jù)備份和數(shù)據(jù)恢復(fù)的功能。針對(duì)這些要求，設(shè)計(jì)本月工 資信息管理系統(tǒng)。該系統(tǒng)主要包插職工信息、職工考勤信息、職工津貼信息。1）職工信息管理系統(tǒng)功能為：財(cái)務(wù)部門相關(guān)人員錄入、修改、刪除、查詢員工個(gè)人信息；員工本人能通過用 戶名和密碼查詢口己的信息以及修改口己的密碼；2）職工工資管理系統(tǒng)功能為：根據(jù)工資生

3、成公式，按照員工的考勤情況及各種表現(xiàn)按月生成相應(yīng)的工資；財(cái) 務(wù)部門相關(guān)人員能錄入、修改、刪除、查詢每個(gè)月每個(gè)員工的工資信息以及工資匯總；員工 本人能查詢自己的工資信息以及工資匯總；3）職工津貼管理系統(tǒng)功能為：財(cái)務(wù)部門相關(guān)人員錄入、修改、刪除、查詢職工津貼信息；職工本人能查詢自 己的津貼；4）職工考勤管理系統(tǒng)功能為：后勤管理人員錄入、修改、刪除、查詢職工考勤信息；職工本人能查詢自己的 考勤情況。采用模塊化設(shè)計(jì)思想，可以大大提高設(shè)計(jì)的效率，并且可以最大限度地減少不必要的錯(cuò) 誤。其系統(tǒng)結(jié)構(gòu)框圖如圖1-1所示。圖1-1系統(tǒng)功能模塊圖2.數(shù)據(jù)結(jié)構(gòu)設(shè)計(jì)3.功能模塊詳細(xì)設(shè)計(jì)3. 1主界面及工資基本信息界面的

4、設(shè)計(jì)圖3-1歡迎畫面圖3-2登錄界面圖3-3系統(tǒng)主界血tti錄入修改刪除考勤信息錄入bw余查間所肓查匍羊人考勒逓回職工號(hào)玦勤天數(shù)玦勤類別玦勤日寸同0303290303280303270303262病假2008-3-1 003032503032403032303032203032103032003031903031832008-3-503031703031603031503031403031322008-3-1 6030312030311030310030309030308030307030306030305職工號(hào)缺勒天數(shù)缺勒類別缺勤旳間在止丫處輸入聰工號(hào)點(diǎn)擊查間|冊(cè)除圖3-4考勤信息錄入，修改

5、，刪除，查詢界面3. 2主要源代碼import java.awt.*;impor t java. awt. eve nt.*;import javax.swing.*;import java.awt*;import java.sqi *;import java.丨ang.*;import java. util.*;import javaxswing.table*;impor t java .math.*;class zzlc imp i ements actionlistener jframe frame二new jframe （"歡迎進(jìn)入zzlc工資管理系統(tǒng)”）；jlabel la

6、bel=new jlabel （,r制作人：陳松 張淑靜 張虎 黎成", jlabe i. center）;jbutton button1=new jbutton （"進(jìn)入系統(tǒng)”）;jbutton button2=new jbutton（h退出系統(tǒng)”）;i mage i con im二new i mage icon( "1.jpg");jlabei a1=new jlabei (im);vo i d create () jpanei pcontentpane二(jpanei)frame getcontentpane();jpanel pcontentpa

7、nel二new jpanel ();pcontentpane add(iabei);pcontentpane.setlayout (new fiowlayout();peontentpane. add(buttord);pcontentpane add(button2);pcontentpane add (new labe i (h ");pcontentpane add(a1);peontentpane. setbackground(co i or. p i nk);peontentpane. setvi s i bie(true);button1.addact i onl i s

8、tener(th i s);button2.addact i onl i stener (th i s);frame. setdefauitcioseoperat i on(jframe. ex it_on_close);f rame. pack ();frame. setbounds (200, 100, 550, 600);frame setvisible(true);pub i ic static void ma i n (string args) zz ic dome=new zz ic ();dome. create ();pub i i c void act ionperforme

9、d (actionevent e) i f (bu ttord equa i s (e. get source () dl d i 二new dl ();d i. create ();i f (button2. equa i s (e. getsource () /退出system. ex i t (0);ci ass dl imp i ements actionl i stener jframe frame二new jframe ("職工/管理員登陸”)；jlabe i i abe 11=new jlabel ("用戶名”);jlabe i i abe 12=new jl

10、abe i ("密碼”);jbutton i ogonbutton1=new jbutton ("管理員登錄")；jbutton i ogonbutton2=new jbutton ("職工登錄")；jbutton cance i button二new jbutton ("退出”);jtextf i eid 11=new jtextf i eid (0):jtextfield t2=new jtextfieid (0);i mage icon im二new imageicon("2. jpg");jlabei a2

11、=new jlabei (im);jtextfield username二new jtextfield (9);jpasswordf i eid password二new jpasswordf i eid(9); vo i d create () jpanei p= (jpanei)frame. getcontentpane();jpanei p1=new jpanel ();p. setlayout (new fl owlayout();p.add (iabe11);p. sets i ze (5, 5);p. setlocat i on (4, 8);p. add (username);p

12、. sets i ze (100, 200);p. setlocat i on (800, 800);p. add (iabe 12);p. sets i ze (50, 20);p. setlocat i on (40, 80);p.add (password);p. sets i ze (100, 20);p. setlocat i on (80, 120);p. add(iogonbut;p. add (new jlabel (m");p. add(logonbutton2);p. add (new jlabel ("");p. add(canee i bu

13、tton);p. add(new jlabel ("");p. add (a2);p. add (t1);p.add (t2);p. setbackground (co i or. red);p. setvisible(true);iogonbuttord . addact i onl i stener (th i s);iogonbutton2. addact i onl i stener (th i s);cancei button.addact i onl i stener(th i s);frame. setdefauitcloseoperat ion(jframe

14、. ex it_0n_cl0se);frame pack ();frame. setbounds (200, 100,750,550);frame setv i s i bie (true);pub i ic void actionperformed (actionevent e) if (i ogonbu ttonl equa i s (e. getsource () && (user name get tex t () equa i s ("123")二二 t rue)&& (password. gettext (). equa i s

15、("123") =true) gzglzjm gz二new gzglzjm();gz. create ();e i se jopt ionpane. showmessagedialog(nu i i對(duì) 不起，你 輸入的密碼錯(cuò)誤！ ”）；;i f (i ogonbu tton2. equa i s (e. get source () && (usernam e. get tex t () equa i s (. get tex t () )=true)&&(password. gettext (). equais (t2. gettext ()

16、 true) xk xk=new xk ();xk. create ();connection con;statement sqi;resultset rs;vector vector=new vector();try ci ass. forname("sun. jdbc. odbc. jdbcodbcdr i ver"); catch (classnotfoundexception e1) system. out. println("" + e1);try con 二 dr i vermanager.getconnection ("jdbc:

17、odbc:123","”，;sq i二con.createstatement (resultset. type_scrolsensitive, resultset. concur_read_only)9sq i. executequery ("select gno, mm from y where gno="+t1. gettext () +“and mm="+t2. gettext ();catch (sqlexcept i on e1) system.out. pr i nt in(e1);i f (ca nee i button, equ

18、a i s (e. get source () system. ex i t (0);class gzglzjm extends jframe i mpi ements actionlistenerjframe f=new jframe ("t.資管理系統(tǒng)”);jbuttonb1=newjbuttonc1津貼管理,j;jbuttonb2二newjbutton (n總查詢");jbuttonb3=newjbutton (h工資管理,j;jbuttonb4二newjbuttonc后勤管理j;jbuttonb6=newjbuttonc'員工個(gè)人信息管理”）；jbutton

19、b5二newjbutton (”返回");i mage i con im二new i mage icon("3. jpg");jlabei a3二new jlabei (im);void create() jpanei p=(jpanei)f getcontentpane ();jpanei p1=new jpanei ();p. setlayout(new flowlayout ();p. add (b1);p. add (new jlabe i ("");p. add (b6);p. add (new jlabel (""

20、;);p. add (b3);p. add (new jlabe i (m");p. add (b4);p. add (new jlabe i ("");p. add (b2);p. add (new jlabe i ("");p. add (b5);p. add (a3);p. setbackground (co i or. red);p. setvisiblectrue);b1. addact i onl i stener (th i s);b2. addact i onl i stener (th i s);b3. addact i on

21、l i stener (th i s); b4. addact i onl i stener (th i s); b5. addact i onl i stener (th i s); b6. addact i onl i stener (th i s);f. setbounds (200, 100, 800, 600); f. setvi s i b i e (true);pub ii c vo i d actionperformed (actionevent e) i f (b5. equa i s (e. getsource ()/返回dl d二new dl ();f. d i spos

22、e ();if (b1. equa i s (e. getsource ()/津貼管理jtgl jt=new jtgl ();jt. create ();i f (b6. equa i s (e. getsource () /員工個(gè)人信息管理yggl yg=new yggl ();yg. create ();i f (b2. equa i s (e. getsource ()/查詢xk xk=new xk ();xk.create 0;i f (b4. equa i s (e. getsource () /后勤管理kqgl kq二new kqgl ();kq. create ();i f (b

23、3. equa i s (e. getsource () /工資管理gzgl gz二new gzgl ();gz. create ();ci ass kqgl i mpi ernents actionlistener jframe f二new jframec錄入修改刪除考勤信息")；jbuttonb1=newjbutton (”錄入");jbuttonb2二newjbutton ("修改,');jbuttonb3=newjbutto n(”刪除j;jbuttonb4=newjbutton (n查詢所有j;jtextfieldtf1=new jtextf i

24、 eid (4);jtextfieidtf2=new jtextfield (4);jtextfieldtf3=new jtextf i eid(4);jtextfieldtf4二new jtextf i eid(4);jtextfieldtf5=new jtextf i eid(6);jbutton (n返回 j ;jbuttonb5=newjbutton b6=new jbutton (m查詢單人考勤”)；string cloum二“職工號(hào)”，“缺勤天數(shù)“，“缺勤類別“缺勤時(shí)間”；object row=newobject 50 4;jtable table二new jtable (row,

25、cloum);jscroi i pane scroi ipane=new jscroi i pane (table);jspii tpane splitpane=new jspii tpane(jspii tpane. vert ical_split);void create ()jpanei p= (jpanei)f.getcontentpane ();p. set layout (new fi owlay out ();/p add(scroli pane);p. add (sp i i tpane);jpane i p1=new jpane i ();p1. add (b1);p1. a

26、dd (b2);p1. add (b3);p1. add (b4);p1. add (b6);p1. add (b5);jpanei p2=new jpanei ();p2. setbackground (co i or.red);p2. add (scro i i pane);jpanei p3=new jpanei ():p. set lay out (new fi owlayo ut ();p. add(new jlabel ("");p. add (new jlabel ("職工號(hào)");p. add (tf 1);p. add (new jlab

27、el ("缺勤天數(shù)")；p. add (tf2);p. add (new jlabel ("缺勤類別")；p. add (tf3);p. add(new jlabel ("");p. add (new jlabel ("缺勤時(shí)間");p. add (tf4);p- add (new jlabel ("在此處輸入職工號(hào)點(diǎn)擊查詢刪除")；p. add (tf5);sp i i tpane, add (p1, sp i i tpane. top);sp i i tpane. add (p2, sp i

28、 i tpane. bottom);spi itpane. setd i v i derlocat i on(50); p. setbackground(co i or. cyan);b1 addact i onl i stener (th i s);b2. addact i onl i stener (th i s);b3. addact i onl i stener (th i s);b4. addact i onl i stener (th i s);b5. addact i onl i stener (th i s);b6. addact i onl i stener (th i s)

29、;f. setbounds (200, 100, 500, 600);f. setresizable(true) ；/可以調(diào)整界面大小f setvisible (true);pub i ic void actionperformed (actionevent e) if (b1. equais (e. getsource () /添加connection con;statement sqi;resuitset rs;try ci ass. forname ("sun.jdbc. odbc. jdbcodbcdr i ver"); catch (classnotfoundex

30、ception e1) system. out. println("" + e1);try con = dr ivermanager. getconnection("jdbc:odbc:123","”，""); sq i = con. createstatement ();string insertstr = "insert into k values " + "c +tfl.gettexto +"，“ + t f2. gettext ()+", "+tf3. ge

31、ttext () +“，h+tf4. gettext ()+")“；sq i. executellpdate (i nsertstr);con. c i ose (); catch (sqlexcept i on e1) system. out. pr i nt in (e1);if (b2. equais (e. getsource () /修改connection con;statement sqi;resuitset rs;try ci ass.forname ("sun. jdbc. odbc. jdbcodbcdr i ver"); catch (cia

32、ssnotfoundexception e1) system. out. println("" + e1);try con 二 dr ivermanager.getconnection (”jdbc:odbc:123","”，""); sqi = con.createstatement();sqi. executeupdate (nupdate k set ts二“+tf2. gettext ()+“where kno=h+tf1. gettext() +"");sqi.executeupdate (nupdate

33、 k set ib="+tf3. gettext()+mwhere kno="+tf1. gettext 0 +"");sq i. executeupdate (''update k set sj=n+tf4. gettext ()+mwhere kno=n+tf1. gettext ()+,h);con. c i ose (); catch (sqlexcept i on e1) system. out. pr i nt i n (e1);i f (b3. equa i s (e. getsource () /刪除connection

34、con;statement sqi;resuitset rs;ci ass.forname("sun.jdbc. odbc jdbcodbcdr i verh); catch (classnotfoundexception e1) system. out. println("" + e1);try con = dr ivermanager.getconnection(hjdbc:odbc:123n, hh);sq icon. createstatement (resuitset. type_scroll_sensitive, resuitset. concur_r

35、ead_only)sq i. executeupdate (hdelete from k where kno=lf+tf5. gettext ();con. c i ose (); catch (sqlexception e1) system. out. pr i nt i n (e1);if (b4. equa i s (e. getsource () /查詢?nèi)縞onnection con;statement sql;resuitset rs;vector vector二new vector();try class forname(hsun. jdbc. odbc jdbcodbcdr i

36、 vern); catch (classnotfoundexception e1) system. out. println("" + e1);try con = dr i vermanager. getconnect i on (" jdbc:odbc: 123'*, nsa, ,n);sq icon. createstatement (resultset.type scroll sens itive, resuitset.concur read only)if (b4 equa i s (e. getsource () for (int i二0;i50

37、;i+)for (int j二0;j<4;j卄)tab i e. setva i ueat ("", i, j);rs = sqi. executequery ("select * from k order by kno desc"); int k=-1;while (rs. next () +k;str i ng kno = rs.getstr i ng (1);string ts = rs.getstr i ng(2);string ib = rs. getstring(3);string sj = rs.getstring(4);tab i

38、e. setva i ueat (kno, k, 0);tab i e. setva i ueat (ts, k, 1);tab i e. setva i ueat (i b, k, 2);tab i e. setva i ueat (s j, k, 3);catch (sqlexcept i on e1) system. out. pr i nt i n (e1);if (b6. equa is (e. getsource () /查詢關(guān)鍵字connection con;statement sqi;resuitset rs;vector vector二new vector();try ci ass. forname("sun. jdbc. odbc. jdbcodbcdr i ver"); catch (classnotfoundexception e1) system. out. printl