基于java的人力资源管理系统_基于JavaWeb的企业人力资源管理系统的设计与实现...

《基于Java Web的企业人力资源管理系统的设计与实现.doc》由会员分享，可免费在线阅读全文，更多与《基于Java Web的企业人力资源管理系统的设计与实现》相关文档资源请在帮帮文库(www.woc88.com)数亿文档库存里搜索。

1、nattendanceList；}**通过指定日期查询考勤*ublicArrayListgetAttendanceByDate(Datedate){ArrayListattendanceList=newArrayList()；try{ct=newConnDB()getConn()；获取ConnDB中的方法，操作数据库sm=ctcreateStatement()；rs=smexecuteQuery(quotselect*fromattendancewhereattendanceDate='quot+date+quot'quot)；while(rsnext()){Checkattendanceattendance=newCheckattendance()；attendancesetDate(rsgetDate())；attendancesetEmName(r

2、='quot+emId+quot'andattendanceDate='quot+date+quot'quot)；a是删除的记录数if(a==){b=true；}}catch(Excetione){erintStackTrace()；}returnb；}工资管理主要代码**计算员工应领取的工资*ublicintgetPaySalary(){aySalary=totalSalaryinsurancescot；returnaySalary；}ublicvoidsetTotalSalary(inttotalSalary){thistotalSalary=totalSalary；}计算员工总工资ublicintgetTotalSalary(){totalSalary=basicSalary+eatSalary+houseSalary+bonus+otherubl

3、id){booleanb=false；try{ct=newConnDB()getConn()；sm=ctcreateStatement()；inta=smexecuteUdate(quotdeletefromuserswhereid='quot+id+quot'quot)；a是删除的记录数if(a==){b=true；}}catch(Excetione){erintStackTrace()；}returnb；}考勤管理主要代码**通过员工编号查看员工考勤信息*ublicArrayListgetAttendanceById(StringemId){ArrayListattendanceList=newArrayList()；try{ct=newConnDB()getConn()；获取ConnDB中的方法，操作数据库sm=ctcreateStatement(

4、sgetString())；attendancesetEmId(rsgetString())；attendancesetResult(rsgetString())；attendanceListadd(attendance)；}}catch(Excetione){erintStackTrace()；}finally{关闭各种打开的资源，释放内存thisclose()；}returnattendanceList；}**删除考勤记录*ublicbooleandelAttendance(StringemId,Datedate){booleanb=false；try{ct=newConnDB()getConn()；sm=ctcreateStatement()；inta=smexecuteUdate(quotdeletefromattendancewhereemId

5、quot'quot)；while(rsnext()){usersetId(rsgetString())；usersetUsername(rsgetString())；usersetPassword(rsgetString())；usersetSex(rsgetString())；usersetBirthday(rsgetDate())；usersetIsadmin(rsgetString())；usersetContent(rsgetString())；usersetPhone(rsgetString())；usersetEmail(rsgetString())；}}catch(Excetione){erintStackTrace()；}finally{关闭各种打开的资源，释放内存thisclose()；}returnuser；}**添加新员工*ubli

6、ace()；}finally{关闭各种打开的资源，释放内存thisclose()；}returnall；}***添加新奖惩记录*ublicbooleanaddRewPunish(RewPunishrewPunish){booleanb=false；try{ct=newConnDB()getConn()；获取ConnDB中的方法，操作数据库sm=ctcreateStatement()；rs=smexecuteQuery(quotselectusernamefromuserswhereid='quot+rewPunishgetId()+quot'quot)；while(rsnext()){rewPunishsetName(rsgetString())；}插入新奖惩记录intcount=smexecuteUdate(quotinsertintorewPunis

7、+quot','quot+usergetEmail()+quot')quot)；if(count==){b=true；}}catch(Excetione){erintStackTrace()；}finally{关闭各种打开的资源，释放内存thisclose()；}returnb；}**修改员工信息*ublicbooleanudateUser(Useruser){booleanb=false；try{ct=newConnDB()getConn()；sm=ctcreateStatement()；inta=smexecuteUdate(quotudateusersSETusername='quot+usergetUsername()+quot',id='quot+usergetId()+quot',hone='quot+usergetPhone()+quot'

8、ement()；rs=smexecuteQuery(quotselect*fromRewPunishquot)；while(rsnext()){RewPunishrewPunish=newRewPunish()；rewPunishsetRewId(rsgetString())；rewPunishsetId(rsgetString())；rewPunishsetName(rsgetString())；rewPunishsetKind(rsgetString())；rewPunishsetReason(rsgetString())；rewPunishsetMoney(rsgetInt())；rewPunishsetCreatetime(rsgetDate())；alladd(rewPunish)；}}catch(Excetione){erintStackTr

9、cbooleanaddUser(Useruser){booleanb=false；try{ct=newConnDB()getConn()；获取ConnDB中的方法，操作数据库sm=ctcreateStatement()；插入新用户intcount=smexecuteUdate(quotinsertintousersvalues('quot+usergetId()+quot','quot+usergetUsername()+quot','quot+usergetPassword()+quot','quot+usergetSex()+quot','quot+usergetBirthday()+quot','quot+usergetIsadmin()+quot','quot+usergetContent()+quot','quot+usergetPhone()

10、)；rs=smexecuteQuery(quotselect*fromattendancewhereemId='quot+emId+quot'quot)；while(rsnext()){Checkattendanceattendance=newCheckattendance()；attendancesetDate(rsgetDate())；attendancesetEmName(rsgetString())；attendancesetEmId(rsgetString())；attendancesetResult(rsgetString())；attendanceListadd(attendance)；}}catch(Excetione){erintStackTrace()；}finally{关闭各种打开的资源，释放内存thisclose()；}retur

11、,assword='quot+usergetPassword()+quot',birthday='quot+usergetBirthday()+quot',email='quot+usergetEmail()+quot',content='quot+usergetContent()+quot',isadmin='quot+usergetIsadmin()+quot',sex='quot+usergetSex()+quot'whereid='quot+usergetId()+quot'quot)；a是修改的记录数Systemoutrintln(usergetId())；if(a==){b=true；}}catch(Excetione){erintStackTrace()；}returnb；}**删除员工*ublicbooleandelUser(String

12、ishment；returntotalSalary；}ublicvoidsetBonus(intbonus){thisbonus=bonus；etConn()；sm=ctcreateStatement()；inta=smexecuteUdate(quotdeletefrombarginwherebarginId='quot+barginId+quot'quot)；a是删除的记录数if(a==){b=true；}}catch(Excetione){erintStackTrace()；}returnb；}奖惩管理主要代码**查看奖惩记录*ublicArrayListgetAll(){ArrayListall=newArrayList()；try{ct=newConnDB()getConn()；获取ConnDB中的方法，操作数据库sm=ctcreateStat