人事与工资管理系统--源代码说明

1、东莞理工学院城市学院city college of dgut人事与工资管理系统设计与实现源代码说明书version 1.028-8-2015版本及修订记录版本日期描述作者1.02018-8-28第一个版本林进容文档信息文档号：a0002发行：v授权：东莞理工学院城市学院创建日期：2015-8-28目录人事与工资管理系统1设计与实现1源代码说明书1version1.0128-8-20151目录21引言31.1编写目的32程序目录结构33关键代码33.1登录33.2管理员操作63.3绩效考核管理83.4员工信息管理123.5薪酬管理161引言11编写目的编写此文档的目的在于为以后的修改提供依据。2

2、程序目录结构1) com.action.admin_servlet管理员操作代码2) com.action.jixiao_servlet绩效考核管理代码3) com.action.xinchou_servlet-薪酬管理代码4) com.action.yuangong_servlet员工信息管理代码3关键代码3.1登录在登录界面输入的账号、密码、选择登录方式，通过验证的账号，将向服务 器请求数据，进行加载数据。package com service;b *import javasqlresnl匸s亡匸;匚 public class logmservicepublic string login(

3、string usernamer scrxng userpwr int usertype)|system.out.println(rusertype"*usertype);trythread.s2eep(700); catch (interruptedexception e)</ todo autogenerated catch block e.prmtscacictrace ();>string resulcno"if (usertype0) /系纟克管運员登陆(string sqlorselect from t_actao.n where usernaae&

4、#174;? and userpw»?w; object pararc-fusernameuserpw;d3 mydbnew db();mydbdopscm(sql/ params);try< resultset rs-mydb.getrs(); boolean mark= (rs=null | | !rs.next () ?false:true);if (mar)c=false)ix)o丄ean marc- (rsnull | | ! zsnext () ?false: true): ifalse)< result-"now;elseresult-"

5、yes:tadmin admin-new tadxnin (); adminsecuserid(r9.getint(ruserldw): admin setusername (rs .getstring (fu3ernamew); admxn9ectjsei:pw(i：9gecsizljig(r*=sempw*); webcontext ctx webcontextractory.g*t(); hctpsession session-ccx getsession(); sessionseuattribute(wusertype"r 0); session seractribute (

6、"adirxn", adxxn);rs.close ();>catch (sqlexception e)<systemout.printin! ”)； eprintstacktrace();finallymydb.closedo;>if (usertypel)if(usertype=l)system outprmtln (kdddddddddddk);string sql-wselecc from t_yuangong where del»*no and loginnaxe-? and loginpw-?1*; object( param3&qu

7、ot;usernaxne,userpw;db mydb-new db ();mydbdopstm(sql, parama);try<resultset rs«mydbgetrs(); boolean mart- (rsmnull | | ! rs .next () ?false: true); if (marjc«-false) result-no*;>else<resultyes11;yuangong yuangong-new yuangong(); yuangongsetld(rs.gettnt("id");yuangong .se

8、tname (rs getstr2ng;yuangong setsex (rs .getstrxng (ltsexlt);yuangong setage (rs .getstring);yuangong.settex (rs .getstring (tel1*); yuangongsetaddress (rs .getstring(address1*): yuangong. setzhiwei (rs .qetstrxng (zhiarei.1*);yuangong setquanxian (rs .getlnt (quanxi.aii1*);yuangong secloginname (rs

9、 .getstring ("loginn皿e*); yuangong setloginpw (rs getstring ("logmpw");webcontext ccx = webcontextfactory.get(); hctpsession session=ccxgetsession();sessionsecattrxbute(kusertype*# 1);webcontext ctx webcontextfactory.get(); httpsession session-ctxgetsession(); session.皀tat匸riknite(&qu

10、ot;umertype*1.】)； session. setattribute (yuangong yuangong);rs close ();catch (sqlexception e)<system, out .printin (! r); 色.printstacjctrace ();finallymydb closed();if (usertype2) return result;public string admxneedit(string userpwnew) system.out.prlntln(hddddm);trythread.sleep(700);e printstac

11、ktrace();webcontext ctx = webcontextfactoryhctpsession session-ctxgecsession():tadmm admxn» (tadmxn) session.gecartmibute (adnixn");string sql-wupdate t_adnu,n sec userlr-? where userid-?" object j params-user pwnew# adnan get(jseir1d();db mydb=new db ();mydbdopstm(sql, parazu);return

12、 "yesm;pablic list yuanongselect()<血list yuangongllst*new arrayllst();string sql-select from t_yuangong where del«*no, object( params*: db mydb°new db();try mydb.dopstm(sql, params); resultset rs«mydb getrs();while(rs.hex匸()<yuangong yuangongwnew yuangong(): yuangongge匕tut

13、(id'*);yuangongse匸name(rs .getstring (二ame11); 血yuangonglisc.add(yuangong);>rs close():yuangonglistadd(yuangong): >rs.close();>catch(exception e)<e.prmtstaclctrace ();>mydb.clos皀d();return yuangonglisr;3.2管理员操作管理进行密码修改、账户添加删除。package com.agion;import javaio.loexueption;public clas

14、s admlnservlet extends httpservlet<pnblic void service(httpservletrequest reqrhttpservletresponse res)throws servletexceptionr <string type-req.getparameuer ('匸ype*);if (type .endsvjith ("adminmana1*)<adminmana (reqr res) ;|>i f(type endswith(adminadd")<adminadd(req, res

15、);>if (cype.endswith(hactau.ni>elr)<admindel(reqr res);ice> 三public void adminmana(httpservletrequest reqrhttpservletresponse res) throws servletexceptionr 】 <list adminlist«new arraylist():string sql-rselect from t_adminw;object( params«db mydb-new db();trymydb.dops匕paramo)

16、;resultset rs=mydbgerrs();while(m9next()kc9u1 uocu rsiu/qd cuks while(rs.next ()<tadmin adminnew tadmin();admin.setuserid(rs.getint(wuseridm);actain.setusername(rs.getstring("username"):adxtin.securerpw(rs.qetscring(ruserpw"); adniinlist add (admin);rsclose ():catch(exception e)<

17、;皂prinrstaclctrace ();mydbclosed ():req.setattributeadminlist):req.getrequescdispatcher(mactaan/adnan/actainmana.jap")forward(reqr res);public void actaanadd(httpservletrequest reqrhttpservletresponae res) <string usernanie=req get parade 匸 ezr ("usernameie)；string userpw*reqgetparamete

18、r (tu3erpww):string sql1”insert into t_adrcin values(?# ?)*;object parains-fusernaae.userpw;db mydb-new ds();mydbdopstit (sql, params);mydb.closed():mydbclosed();reqsetattribute ("message11 r 按作成功;r皀q secattribute (path" wadnin?type=adnixnmana");string targecurl "/common/successj

19、spw； dispatch(targeturlr req. res);public void admindel(htcpservletrequest req,httpservletresponse res)<system out.prlntln(r皀qgetparameter ("userid") *");string sql«hdelete from tadblln where useridaw*lnteaer.parselnc(req.getparaneter ("userid1*); object() param3«(;d

20、b mydb-new db();mydb.dopstm(sql, params);mydbclosed();req.setattribute (message*.作咸功t ;reqttrtbute(wpath"r haddu.n?cype-adminmana*>estring targeturl "/coomon/success .jsp*；dispatch(targeturl, reqr res):public void dispatch(string targeturirhttpservletrequest requesthttpservletresponse r

21、esponse)public void dispatch(srrmg targecuri,hrrpservlecrequesc requestrhttpservlerresponse response) <requestdispatcher dispatch getservletcontext()getrequestdispatcher(targeturi);try<dispatch.forward(request, response);return;catch (servletexceptlon e)eprintstacktrace();oatoh (icexception e)

22、eprxncscacktrace();public void init(servletconfig config) throws servletexception (super.mic(config);public void destroy()3.3绩效考核管理对员工进行绩效考核，其中有添加绩效.删除绩效和编辑绩效。ioe>package com.accion;+ import java i>o ioexception;public class jixxac_servler extends httpservlet<八public void service(httpservle

23、trequest reqrhttpservletresponse res)throws servletexception/string type-req: if (typeend9wi.uh (jixi.ooh&ca1*) jixiaomana(req, res);>if(type.endmwixh("jixiaoadd")( jixiaoadd(req, res);>if(type.endswith("jixiaodel")<jixiaodel(req. res);>if (type)<jixiaoedit(req

24、, res);>if (type.endswixh (*jmochajmbyygngong_yuef"*') jixiaochaxunbyyuangong_yuefen(reqr res);public void jixiaoadd(httpservletrequest reqrhttpservletresponse res)public void jixiaoadd(hctpservlerrequesc reqfhctpservlelresponse res)string j xxiao_yufen-reqgetparaiteter(wj ixiao_yufen&qu

25、ot;);int jixiao_yuangong_id°integer.parselnt(reqgetparameter("jixiao_yuangonq_idr>):string jixiao_yaungong_chidao«req.getparameter("jixiaoyaungong_chidaow);int jixiao_jlangjina500-integer .parelnt (jixlaoyaungongchidao) s0;/迟到次扣共soo块購寿 string del-wnow;boolean b-jixiaoservicesh

26、dfoulurujixido(jlx丄aoyuangongd. jlxiao_yufen);system ozit.printlii (b+wyk/k/vn);if (btrue)req.setattribuce (rttessagerr 该员工在it匕月份的绩效考核信亘己录入。i青不要更复檢作t ； req se匸入匸tr丄bute (path1'. r3ixiao?type-jixiaomana"):string targecurl "/coffmon/success.jspw； dispatch(targecurl, req. res);>else(st

27、ring sql=minsert into t_jixiao values(?f?r?f?r?)r;ob3ect( params-jixiao_yufenr jlxiao_yuangong_ldr jixiao_yaungong_chldaor jixiao_jlangjinr db mydb=new db();niydb.dopscm(sqlr parains);niydb. closed ();zeqsetattribute (wmeasagerr作咸功代);req setattribute(wpath"r wjixiao?type-jixiaomana");strin

28、g targeturl /conanon/success .，叩并； dispatch(targeturl, req, res);public void jixiaodel(httpservletrequest req,httpservletresponse res)string sql"wupciate t_jix丄ao set del*"yes* where jixiao_id-"*integergetparametc object pararcs=;db mydb-new db();mydb.dopstm(sqlr params);mydbclosed();

29、req.5皀tattribute ("message作咸功;req.setattribute(path*, jixiao?type-jixiaomana");string targeturl /conmon/success.jspr； dispatch(targeturl, req, res);public void jixxaomana(httpservlecrequest reqrhttpservletrempong res) throws servletexcepvion, <血list j ixiaolist«new arraylist():stri

30、ng sql-select from c_jlxiao where del-no*w;object params-;db mydb«new db();trymydb.dopstm(sql, paraxs);resultset rsnydb g£crs();while(r3.next()jixiao jixiao=new jixiaoo : set jixiao id (rs getlirc ( jixiao id*); iinijixiao setjixiao_ jixiao sejixiao jixiao setjixiao jixiao setjixiao jixiao

31、 sr匸jixiao jixiao setjixiao.id(rsgevlnt (w jixiao_idff);yufen (rsg色ts匸ring ("jix丄ao_yuten*);yuangongid (rs gezlnv (" jixiao_yuangong_id,');yaungong_chidao (rs.getint ("jixiao_yaungong_chidaom);jiangjin (rs .gedin; (n jixiao_jxangjinn);yuangong name(yuangongservicegetyuangongnamc(x

32、s.grtlnt(wjixiao yuejixiaolist add(jixiao); rs.close ();catch(exception e)e printstacktrace();mydb closed();req setatcribute (rjixiaollsc,t/ jixiaollsc);reqge匸r己匸dispa匚cher(admin/jix丄ac/jixiaomanajspm)forward(reqz res);public void jixiaoedit(httpservletrequest reqfhttpservletresponse res)<string

33、jixiao_yufen=reqgwcfarame匸wr(”jixinoyufen");int j ixiao_yuangong_id-integer parse in t (req getparaunecer ( j lxiao_yuangong_ldr);int jixlao_yanngong_chidao=integer .peirselnt; (rqg亡匕pazame匸亡rr (冃 jix2lac_yaungong_uhidao”);int jixiao_jiangjin=500-jixiao_yaungong_chidao*50;/ifi至l次扣50» 共500块

34、缰效奖全string sql"rupdate c_jxxiao set jlxiac_yufen"?r jix丄&o_yuangong_dd？，jixiao_yaungong_chidao«: object paraies= jixiao_yufenr jixiao_yuangcng_idz jixiao_yaxingong_chidaor jixiao_jiangjin; db mydbnew d3();mydb dopstm(sqlz parairs);wvrtb rlnrpd 八:orring sq丄乙己ixzac sez jjixiao j-ang

35、ong ia= yr jixiac yaungong cniaao=:厶object params®jxxiaoyufen# jixiao_yuangong_idf jxxiaoyaxmgongchidao,jixiao_jlangjin; db mydb=new db();mydb.dops匕ni(sql. parang);mydb closed ();req. setactribute ("message -援作成功);r皀qsetattribute("path", wjixiao?type*jxxiaomana");string targ

36、eturl "/cottmon/successjsp: dispatch(targeturlr req. res);public void jixiaochaxunbyyuangong_yuefen(httpservlecrequest req#httpservletresponse res) throws string yuefen-req.getparameter("yuefen");lnt yuangongld-integer匕(reqgetparameter("yuangongld");boolean b-5lxiaoservice *

37、211.£0口丄uruj丄兀丄4o(yu&ngongld yuefen);if(bw«false)<req.gecrequestdi>9patcher (admin/jl.x丄ao/j丄xi.oowei.xairu jyp") forward (req, res);>elseint jixiaojlangji*jixiaoservice.getjixiaojiangji(yuangongld, yuefen);req se匕attribute("3xxiaojlangj1, jxxiaojxangji);reqgetreques

38、tdispatcher(wadmin/jixiao/jlxiaoyxluru.jspw)forward(reqr res);public void dispatch(string targeturirhttpservletrequest request.httpservl色response response) requestd丄3pa匕uher dispatch getservletcontext()getrequestdispatcher(targeturi);34员工信息管理获取员工信息，添加员工，删除员工，编辑员工，给员工添加登录账户。package com.acrion;j '

39、import java.io.ioexceptiorkal public class yuangongservlet extends 旦ttpservler<public void service(httpservletrequest reqrhttpservletresponse res)throws servletexceptionr ioe> string type-reqge匸pamajxetez: ("type");if (typeendskixh(ryu&mougadd)< yuangongadd(req, res):>if(ty

40、pe.endswith("yuangongmana")|< yuangongmana(req, res);>if (typeendski,th(ryuangougdex)< yuangongdel(req, res):>if (type.endswxthyuaingongedrf)< yuangongedit(req, res);>if (type.exidyviitbcryuangozigsrdrch1*)yuangongsearch(req, res):if (type 亡ndsk丄tb(*yuangongseai:uh_b：lanh

41、ao*)<yuangongsearch_bianhao(zeqr res);mi£) loginservkejava 哭 ：” admin servletjava."jixiaoservletjava； q yuangong>ervletjavapublic void yuangongadd(httpservletrequest reqhctpservletresponse rea) <string bianhao*req.getparanieter ("bianhao");string name-req(naae*');str

42、ing sex«reqgetparameter("sex"):string ageareqgetparameter(hage");string rel=req.getparammcer("*el");string address=reqg色匸pazax色匸ex (addiresslt)；string zhiwei°reqgetparameter("zhiweir);string card-req.getparameter("card");mt ruzhimanfei"integer .

43、paesexnu (zeqgetparameter ("ruzhm丄anfei1*);string sql*binsert into t_yuangong values (?, 7, ?？?object paraits«bianhaor namer sexr age.tel,address.zhlweir card ruzhinianfei,0,wwr r"# wno" db mydb-new db();znydb dopsun(3qx. params);mydb closed ();req.setattribute (*messagerr * jiff

44、 j® 功);re：q aetattribute ("pathrr ryuangong?type-yuangongmana"):string targeturl « w/coironon/success.jsp”;dispatch(targeturl. req. res);public void yuangongdel(httpservletrequemt reqrhctpservletresponse res) <int id«integer.parsetnt(reqgetparameter;iffpublic void yuagong

45、del(hccpservlecrequest zeqrhcrpservletresponse res) int id=inrege二.parselnt (reqg匸pazrainmre二(二d);string sql«wupdate t_yuangong set del«? where id«?w;object paratts«wyeswrid;db mydb«new db();mydb.dopscm(sql, params);mydb.closed();req setattr丄bate (mes9&gevv. *播作成功);reqse

46、tattribute(wpath"r ryuangong?type*yuangongmanar);string targeturl "/common/success.jsp"dispatch(targeturl, req, res):public void yuangongmana(httpservletrequest req.httpservletr色mponqe res) throws servletexceptlor <list yuangonglist«new arraylist();string sql«"select

47、 from t_yuangong where del«*no*w;object paramss;d3 mydb=new d3();trymydbdopstm(sqlr params);resultset rsfvdb aetrs () ; >public void yuangongmana(htcpservletrequest reqrhttpservletresponse res) throws servletexceptlorlist yuangonglistnew arraylist();string sqi-select * from t_yuangong where

48、del-"no1 object params=;db mydb«new db();trymydb.dopstm(sql, params); resultset rsmydb getry(); while(rs.next()yuangong yuangong-new yuangong();yuangong.secld(rs.getlnt(ridr);yuangong secb丄anhao (rs .gecscirijigebianhao1*);yuangong se匕nam亡(rs .getstiring ("name");yuangongsecsex(r

49、s .getscringcesex11);yuangong.setag色(rsge匕stiring (nage");yuangongse匸tel(rs g巳匸s匸ring ("匸el*1);yuangong seuaddr巳ss(rs g巳匸spring("addressr);yuangong.seczhiwmi(rs qetstring(rzhiweir);yuangong setcard (rs getstring (card1*);yuangong.setruzhinianfel (rs.getlnt (rruzhinianfel,t);yuangong.

50、setgongling (new date ()() *1900-rs.getlnt (wruzhlnianfeiw); yuangong.setquanxian(rs.getlnt(hquanxlanw);yuangong.setloginn&me(rs getstrlng(rloginnaxnem); yuangong aetlogmpw (ra getstrlng (rlogmpww);yuangonglistadd(yuanqong);rs.close ();catch(exception e)public void yuanaongedlt(httpservletreques

51、c reqrhttpservletresponse res)narce=req; sex-reqg色匕paraxe匸色工(*9色3*): age=reqgetparaiterer ("age"); 匸exreqge匸par皿; address«reqgetparameter("address"); zhiweireq gecparometer("zhiwei");int id»integerp&r$o：tnt(reqgetpar&meter ("id");stringstring

52、stringstringstringsql°"update t yuangong set nanes?r sex°?rag«°?r tel«?r address*?,zhiwei-? wherestringstringobject params*namersexrage,tel,address,zhiwei; db mydb-n©w db();mydbdopstm(sql, parang);mydb.closed();reqsetattribute ("message1*,作成功:req.setactribute(

53、"path"r "yuangong?type«yuangongmanar);string targeturl /coranon/success. jsp" dispatch(targeturl req, res);public void yuangongsearch(httpservletrequest reqrhttpservletresponse res) throws servletexceptistring namewreqge匕pazame匕er ("name'*);list yuangonglist-new arr

54、aylist();string sql=hselect * from t_yuangong where del=*no* and name like %w-f-name.crim() +%' w; object! params«d3 mydb=new d3();trypxiblic void yuangongsearch(httpservletrequest req?httpservieresponse res throws servlecexcepclst ring name-re q getparame teir (enaine");list yuangongl

55、isc=new axraylist();string sql-select from t_yuangong where del-no* and name like %h4nam皀crim()%h; object( params-;db mydb-new db();trymydbdopstmcsql paranis); resultset rsmydb getrs(); while(rs.next()yuangong yuangong=new yuangong(); yuangong setid(rs getlnt(widh); yuangong setbianhao (rs getstring

56、 (r,bianhaow); yuangong setname (rs .getstring (kname*); yuangong setsex (rsgetstrlng (f,sexm); yuangong meuaqe (rs.getstrmg (mageh); yuangong yettel(rs getstring(mteln);yuangong s色匸address(rs qecstring("address"); yuangong seczhiwei(xs.gecstring(wzhiwei");yuangong s已*uruz5mhar:f 殳二(r

57、s gw匸tn匸(rruzhzn2.anfelr); yuangongsetcard(rs.getstrmg(wcardw);yuangongse匸gongling(new dare()+1900-rsgezlnz(nruzhinianfeir): yuangong metquanx 丄 an (rm ger inc (quanxianr):yuangong setloginnaite (rs .gmtstring (rloginnair.er); yuangong setlogmpw(rs getstring (mloglnpwh): yuangonglistadd(yuangong);rsclose ();catch(exception 皀) i public void yuangongsearch_bxanhao(httpservletrequesc reqrhtrpservlecresponse res) throws servle<string bianhao«req.getparameter("bxanhao");list yuangonglistew axraylist ();string 5ql»rselect * fr