1、2.2用例图1、顶层用例2、人员档案管理3、人事变动管理4、教育培训管理5、权限管理6、系统管理3系统数据库设计3.1数据库结构图3.2数据库表汇总表名字段类型用户表角色idNumber用户名Varchar(20)密码备注Varchar(200)角色表角色名称功能模块模块id模块名Varchar(40)功能表Id功能名员工表员工id员工编号Varchar(10)姓名性别Varchar(2)学历学位部门id职务人员状态年龄职称技术等级照片身份证Varchar(18)学历证书工资社保员工档案表档案id档案编号内容摘要履历表履历id工作内容取得成绩开始时间Date结束时间合同表合同id合同编号合同开
2、始时间合同借宿时间补充协议id补充协议补充协议内容部门表部门名称部门简介部门现有人数上级部门id部门级别职工定员人事变动表变动id变动类型原来所属部门id现在所属部门id原来职务现在职务调动时间缺员信息表缺员职称缺员人数附加要求昵称信息表昵称id当前职称Data离职表离职id离职时间离职原因离职类型奖惩表奖惩人员id奖惩时间奖惩标题奖惩内容奖惩类别培训表培训id培训方式培训项目类别id培训项目名称培训性质培训项目开始时间培训项目结束时间培训费用培训地点培训课时主办单位负责人姓名培训科目表科目id培训教师学时学分科目表科目名称描述成绩表培训人员id成绩培训类别类别id培训类别名称上级类别培训证书
3、信息表证书id证书编号证书名称证书发放日期培训模式模式id名称Varchar (200)培训记录信息培训记录id考核平均成绩培训模式8id状态职位邮件系统IDNUMBER发件人收件人内容VARCHAR2(200)附件VARCHAR2(100)邮件状态发送时间DATE工资模块用户ID文件地址4接口详细设计4.1接口及方法StaffService.java方法名Public List listAllStaff()列出所有员工Public List listByName(String name)按姓名查询Public List listBySex(String sex)按性别查询Public Lis
4、t listByTitle(String title)按职称查询Public List listByEducation(String education)按学历查询Public List listByTechnology_grade(String technology_grade)按技术等级查询Public Boolean addStaff(Staff staff)增加员工Public Boolean modifyStaff(Staff staff)修改员工信息Public Boolean dropStaff(Staff staff)删除员工信息Rew_punService.javaPubli
5、c Boolean addRew_pun(Rew_pun rp)添加奖惩信息Public Boolean dropRew_pun(Rew_pun rp)删除奖惩信息Public Boolean modifyRew_pun(Rew_pun rp)修改奖惩信息Public List listRew_punByStaffNO(String staffno)按员工编号查询Public List listRew_punByName(String name)按员工姓名查询Bonus_typeService.javaPublic List listBonus_typeAll()列出所有奖惩类别DeptSer
6、vice.javaPublic List listDeptAll()列出所有部门EducationService.javaPublic List listEducationAll()列出所有学历PositionService.javaPublic List listPositionAll()列出所有职务DegreeService.javaPublic List listDegreeAll()列出所有学位Technology_gradeService.JavaPublic List listTechnologyAll()列出所有的技术等级StaffileService1、Public List
7、listAllStafffile()列出所有员工档案2、Public List listByStaffid(Long STAFFID)按员工号查询显示3、Public List listByFileno(String FILENO)按档案编号查询显示4、Public Boolean addStafffile(Staffilef stafffile)增加员工档案5、Public Boolean dropStafffile(Stafffile stafffile)删除员工档案6、Public Boolean modifyStafffile(Stafffile stafffile)修改员工档案Con
8、tractService1、Public List listAllContract()列出所有员工合同信息2、Public List listByStaffid(Long Staffid)3、Public List listByContractno(String Contractno)按合同编号查询显示4、Public Boolean addContract (Contrac contrac)增加员工合同5、Public Boolean dropContract(Contrac contra)删除员工合同6、Public Boolean modifyContract(Contract cont
9、ract)重新上传员工合同RecordService1、Public List listAllRecord()列出所有员工履历3、Public List listByDeptid(Long Deptid)按部门编号查询显示4、Public List listByPosition(String Position)按职位查询显示5、Public List listByEducation(String Education)显示6、Public Boolean addContrac (Contrac contrac)增加员工履历7、Public Boolean dropContrac(Contrac
10、contra)删除员工履历8、Public Boolean modifyStafffile(Stafffile stafffile)修改员工履历LackStaffServicePublic void AddLackStaffInfo(DeptID,LackPosition,LackAmount,Addition)增加缺员信息 Public List ShowLackInfo(DeptID)Public Void ShowLackDetail(ID)查看缺员信息Public Boolean UpdateLackInfo(ID,DeptID,LackPosition,LackAmount,Addi
11、tion)更新缺员信息Public Boolean DeleteLackInfo(ID)删除缺员信息DeployServicePublic void AddDeploy(EmpID,DeployKind,PreDeptID,NowDeptID,PrePosition,NowPosition)员工变动增加SeparationServicePublic String Addseparation (separation rp) 添加离职记录Public String Dropseparation (separation rp) 删除离退记录Public List :listseparationAll
12、() 列出所有离退记录Public List:List_separation_ByStaffNO(String staffno) Public List list_retired_yName(String name) TtitlerecordServicePublic String addtitle(titlerecord rp) 添加职称记录Public String droptitle(titlerecord rp) 删除职称记录Public List listtitleAll() 列出所有职称记录Public List list_title_ByStaffNO(String staffn
13、o) Public List list_position_yName(String name) TrainingModel Service.javaPublic List listAllTrainingmodel ()列出所有模式按名称查询Public string modifyTrainingmodel(TrainingModel)修改培训模式Public String addTrainingmodel (Staff staff)增加培训模式Public String dropStaff(Staff staff)删除培训信息TRAINING_RECORDSService.javaPublic
14、 List listTrainingRecordsAll()列出所有培训记录Public ModifyTrainingRecord()修改培训记录Public deleteTrainingRecord ()删除培训记录Public List listByID(ID)按id查询Public List listBy Trainingmodel (Trainingmodel)按培训模式查询Public List listByResult(Traing traing)按成绩查询Public List listByTraining(Traing traing)按培训信息查询Public List lis
15、tByStaff (Staff staff)按员工查询Public List listByCertificateinfo (Certificateinfo)按证书查询Public List listBySTATE (Sting State)按通过情况查询CertificateinfoService.JavaPublic List listAllCertificateinfo ()列出所有证书记录Public List listBy CertificateNO (String Certificateinfono)按编号查询Public List listByData(Traing traing)
16、按时间查询Public string modifyCertificateinfo (Certificateinfo)修改培训证书Public String addCertificateinfol( Certificateinfo)增加培训证书Public String dropCertificateinfo (Certificateinfo)删除培训证书resultService.javaPublic List listResult All()列出所有成绩记录Public Modifyresult ()修改成绩Public List listBySUBJECT l (Trainingmodel
17、)按科目查询BonusTypeService.javaPublic void saveBonusType(Bonus_type b) ;关于奖惩的增删查改操作Public List listAllBonusType();Public void updateBonusType(Bonus_type b);Public void deleteBonusType(Bonus_type b);Public void saveDept(Dept dept) ;关于部门的增删查改操作Public List listAllDept();Public void updateDept(Dept dept);Pu
18、blic void deleteDept(Dept dept);Public void saveEcucation(Education education) ;关于学历的增删查改操作Public List listAllEducation();Public void updateEducation(Education education);Public void deleteEducation(Education education);Public void savePosition(Position position) ;关于职位的增删查改操作Public List listAllPosit
19、ion();Public void updatePosition(Position position);Public void deletePosition(Position position);Public void saveDegree(Degree degree) ;关于学位的增删查改操作Public List listAllDegree()Public void updateDegree(Degree degree);Public void deleteDegree(Degree degree);UserinfoService.javaPublic void saveUserinfo(
20、Userinfo userinfo) ;系统用户信息的增删查改操作Public List listAllUserinfo()Public void updateUserinfo(Userinfo userinfo);Public void deleteUserinfo(Userinfo userinfo);Roleinfo.javaPublic void saveRoleinfo(Roleinfo roleinfo) ;用户角色的管理操作Public List listAllRoleinfo()Public void updateRoleinfo(Roleinfo roleinfo);Public void deleteRoleinfo(Roleinfo roleinfo);Function_modules.javaPublic void saveFunctionModules(FunctionModules fu
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1