企业人事管理系统课程设计 .docx
精品名师归纳总结河南城建学院JAVA 基础课程设计设计说明书课程名称：JAVA 基础课程设计设计题目：企业人事治理系统指导老师：陈红军班级：0844131学号：084413120同学姓名：陈功亮同组人员：李泽坤、郭鹏成绩：评语：运算机科学与工程学院2021 年 1 月 9 日可编辑资料 - - - 欢迎下载精品名师归纳总结目录第 1 章 选 题 .2.1.1 题目背景 .2.1.2 系统实现的详细分工 .3.1.2.1 选题 .3.1.2.2 团队分工 .3.1.3 开发环境 .3.第 2 章 设计内容 .3.2.1 实现功能 .3.2.2 概要设计（涉及类的框图） .4.2.3 界面设计 .1 1.第 3 章 系统实现 .1.2.3.1 涉及学问点 .1.2.3.2 系统运行（主要运行界面抓图）.1 33.3 源程序清单（关键代码） .1 4.第 4 章 测试与试验结果 .3.4.第 5 章 终止语 .3.8.参考文献 .3.9.可编辑资料 - - - 欢迎下载精品名师归纳总结第 1 章 选 题1.1 题目背景随着全球经济一体化时代的到来，竞争的范畴快速扩大，竞争的程度空前加剧. 那么，谁将是竞争中的胜者？是那些占据人事优势的的区、国家和企业.由于经济竞争，说究竟是人才的竞争，是人综合素养的竞争.被称作 “经营之神 ”的日本闻名企业家松下幸之助说得好： “国家的兴盛在于人，国家的灭亡亦在于人，古圣先贤，早有明训。回忆历史，可谓丝毫不爽.经营事业的成败，不容讳言，与治国同一道理，在于人事支配是否合宜 . ”毫无疑问，人事在一个企业中起着举足轻重的作用.在竞争越来越猛烈的社会里，企业人事治理就越显示出其不行缺性，成为企业一个特别重要的模块 .企业人事治理系统主要是用于员工个人资料的录入，职务变动的记录和治理 .使用人事治理系统，便于公司领导把握人员的动向和人员的综合素养，准时调整人才的安排 ,使用运算机对人事劳资信息进行治理.企业人事治理包括人员的聘请、员工的档案治理、公共信息治理、合同治理、绩效考评、薪资福利的制定运算与发放、考勤及休假治理工作等 .传统的人事治理方式存在着很多缺点,如:文件查找困难，治理效率低、人事信息保密性差,另外时间一长 ,将产生大量的文件和数据 ,这对于查找、更新和保护都带来了不少的困难.随着科学技术的不断提高，运算机科学与网 络技术日渐成熟 ,其强大的功能与跨的域性已为人们深刻熟悉,它已进入人类社会的各个领域并发挥着越来越重要的作用.作为运算机应用的一部分 ,使用运算机企业内部信息进行治理 ,具有着手工治理所无法比拟的优点.例如: 检索快速、查找便利、牢靠性高、储备量大、保密性好、寿命长、成本低等.这些优点能够极大的提高企业信息管 理的效率 ,也是企业的科学化、正规化治理 ,与世界接轨的重要条件 .人事治理系统的开发与实现，转变了传统手工办理人事业务速度慢、效率低的弊 端，极大的节约了时间和人力，把人事业务从单调、重复的事务性工作中解脱出来， 降低了劳动成本，供应了更为高效的公共信息服务.本系统可使治理人员对全局人员结构及岗位配置情形有清楚的明白.在人才选拔上可实现人才的内部挖掘，保证人事的合理配置 . 在系统的实施过程中完成了对治理制度和流程的完善和优化，提高了整个企业的人事治理效率，促进人事治理工作向着标准化、规范化的方向进展.可编辑资料 - - - 欢迎下载精品名师归纳总结1.2 系统实现的详细分工郭鹏：主界面 .李泽坤：待遇治理->奖惩治理模块 .陈功亮：人事治理->档案治理，考勤治理，培训治理模块.1.2.1 选题企业人事治理系统 .1.2.2 团队分工表 1.1 工程分工一览表角色姓名承担的详细任务组长陈功亮档案治理，考勤治理，培训治理模块组员李泽坤奖惩治理模块组员郭鹏主界面的分析与设计1.3 开发环境编程工具： JDK+ECLIPSE （+MySQL ） 运算机： PC操作系统： Microsoft Windows 7.0第 2 章 设计内容2.1 实现功能1、增加、修改职工档案信息，包括个人信息、职务信息、以及档案信息.2、对员工日常、开会、加班进行考勤治理.3、对员工的实现奖惩治理 .4、可以快捷的打开系统的运算器、 Excel、Word 等常用工具 .可编辑资料 - - - 欢迎下载精品名师归纳总结2.2 概要设计（涉及类的框图）可编辑资料 - - - 欢迎下载精品名师归纳总结郭鹏李泽坤可编辑资料 - - - 欢迎下载精品名师归纳总结可编辑资料 - - - 欢迎下载精品名师归纳总结可编辑资料 - - - 欢迎下载精品名师归纳总结可编辑资料 - - - 欢迎下载精品名师归纳总结数据库设计：可编辑资料 - - - 欢迎下载精品名师归纳总结陈功亮、郭鹏、李泽坤共同监制可编辑资料 - - - 欢迎下载精品名师归纳总结2.3 界面设计可编辑资料 - - - 欢迎下载精品名师归纳总结第 3 章 系统实现3.1 涉及学问点1、面对对象2、GUI面板、对话框、表格、组合框、滚动条、标签、按钮等常用组件3、页面布局4、Map 集合类可编辑资料 - - - 欢迎下载精品名师归纳总结5、数据库的增删改查及多表联查 .3.2 系统运行（主要运行界面抓图）可编辑资料 - - - 欢迎下载精品名师归纳总结3.3 源程序清单（关键代码）1、数据库设计CREATE TABLE info_employee.bringup id int10 UNSIGNED NOT NULL AUTO_INCREMENT,bid int11 NOT NULL,bname varchar20 CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,num int6 UNSIGNED NOT NULL, PRIMARY KEY id。CREATE TABLE info_employee.info_bringup_content id int11 UNSIGNED NOT NULL AUTO_INCREMENT,name varchar40 CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,content varchar100 CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,object varchar100 CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,start_date varchar30 CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,end_date varchar30 CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,unit varchar40 CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,lecturer varchar20 CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,place varchar60 CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL, PRIMARY KEY id。CREATE TABLE info_employee.info_duty id int11 UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '档案编号 ',dept varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,duty varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,acform varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,acdate varchar30 CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,didate varchar30 CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,direasonvarchar30CHARACTERSETgbkCOLLATEgbk_chinese_ciNULLDEFAULT NULL,fpdate varchar30 CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,psdate varchar30 CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,pedate varchar30 CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,bknamevarchar30CHARACTERSET gbkCOLLATEgbk_chinese_ciNULLDEFAULT NULL,bkno varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,ssno varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,asno varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,dsno varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,msno varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,csno varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,可编辑资料 - - - 欢迎下载精品名师归纳总结afno varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL, PRIMARY KEY id ,FOREIGN KEY id REFERENCES info_employee.info_record ,INDEX dept dept, INDEX duty duty。CREATE TABLE info_employee.info_login id int11 UNSIGNED NOT NULL AUTO_INCREMENT,username varchar7 CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,pwd varchar10 CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,record_num int6 UNSIGNED NOT NULL,sex varchar5 CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,purview varchar15 CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,state varchar15 CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,authorization int11 NOT NULL, PRIMARY KEY id ,FOREIGN KEY record_num REFERENCES info_employee.info_record record_num, INDEX record_num record_num。CREATE TABLE info_employee.info_record record_num int6 UNSIGNED NOT NULL AUTO_INCREMENT,nation varchar30 CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,nativeplace varchar30 CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,name varchar30 CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,sex varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,birthday varchar30 CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,photo varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,idcard varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,marriaged varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,address varchar40 CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,postalcode varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,partymember varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,schoolage varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,specialty varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,folanguage varchar30 CHARACTERSET gbk COLLATEgbk_chinese_ci NULLDEFAULT NULL,fograde varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,qq varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,email varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,handset varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,telphonevarchar30CHARACTERSETgbk COLLATEgbk_chinese_ciNULLDEFAULT NULL,可编辑资料 - - - 欢迎下载精品名师归纳总结secsage varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,scspecialty varchar30 CHARACTERSET gbk COLLATEgbk_chinese_ci NULLDEFAULT NULL,gdschoolvarchar30CHARACTERSET gbk COLLATEgbk_chinese_ciNULLDEFAULT NULL,gddate varchar30 CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,pmdatevarchar30CHARACTERSET utf8COLLATEutf8_general_ciNULLDEFAULT NULL,cmpgrade varchar30 CHARACTERSET gbk COLLATEgbk_chinese_ciNULLDEFAULT NULL,likes varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,stsuit varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL, PRIMARY KEY record_num ,INDEX name name, INDEX sex sex。CREATE TABLE info_employee.rewards_and_punishment id int11 UNSIGNED NOT NULL AUTO_INCREMENT,record_num int6 UNSIGNED NOT NULL,type varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,reason varchar60 CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,content varchar100 CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,money int11 NOT NULL,start_date varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,end_date varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,ratifier_dept varchar11 CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,ratifier_record_num int11 NOT NULL,ratifier_date varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL, PRIMARY KEY id ,CONSTRAINTrewards_and_punishment_ibfk_1FOREIGNKEYrecord_num REFERENCES info_employee.info_record record_num,INDEX record_num record_num。CREATE TABLE info_employee.timecard id int11 UNSIGNED NOT NULL AUTO_INCREMENT,record_num int6 UNSIGNED NOT NULL,type varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,explains varchar100 CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,start_date varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,end_date varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,ratifier_dept int11 NOT NULL,retifier_record_num int11 NOT NULL,可编辑资料 - - - 欢迎下载精品名师归纳总结ratifier_date varchar30 CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL, PRIMARY KEY id ,CONSTRAINTtimecard_ibfk_1FOREIGNKEYrecord_numREFERENCESinfo_employee.info_record record_num, INDEX record_num record_num。源程序：package com.hncj.currdesign.frame 。import javax.swing.JPanel 。import java.awt.BorderLayout 。import java.awt.Color 。import java.awt.Dimension 。import java.awt.FlowLayout。import java.awt.GridBagConstraints 。import java.awt.GridBagLayout。import java.awt.Insets 。import java.awt.event.ActionEvent 。import java.awt.event.ActionListener。import java.awt.event.MouseAdapter 。import java.awt.event.MouseEvent 。import java.io.File 。import java.io.FileInputStream 。import java.io.FileOutputStream 。import java.io.InputStream 。import java.io.OutputStream 。import java.lang.reflect.Method 。import .URL 。import java.sql.Date 。import java.util.Enumeration 。import javax.swing.AbstractButton。import javax.swing.ButtonGroup。import javax.swing.ImageIcon 。import javax.swing.JButton 。import javax.swing.JComboBox 。import javax.swing.JFileChooser 。import javax.swing.JFrame 。import javax.swing.JLabel 。import javax.swing.JOptionPane 。import javax.swing.JRadioButton。import javax.swing.JScrollPane 。import javax.swing.JTextField 。import javax.swing.SwingConstants 。import javax.swing.SwingUtilities。可编辑资料 - - - 欢迎下载精品名师归纳总结import javax.swing.border.TitledBorder。import javax.swing.filechooser.FileFilter。import com.hncj.currdesign.mysql.SqlUtil。import com.hncj.personinfo.*。import com.hncj.tool.LayoutUtil。import com.hncj.tool.Today 。public class RecordOperatePanel extends JPanel private JTextField deptTextField 。private JComboBox accessionFormComboBox 。private JComboBox dutyComboBox 。private ButtonGroup partyMemberButtonGroup = new ButtonGroup。private ButtonGroup marriagedButtonGroup = new ButtonGroup。private ButtonGroup sexButtonGroup = new ButtonGroup。private JComboBox schoolageComboBox 。private JComboBox nativePlaceComboBox 。private JComboBox nationComboBox 。private JTextField accumulationFundNOTextField。private JTextField annuitySafetyNOTextField。private JTextField pactEndDateTextField 。private JTextField dimissionReasonTextField 。private JTextField compoSafetyNOTextField 。private JTextField doleSafetyNOTextField 。private JTextField medicareSafetyNOTextField 。private JTextField societySafetyNOTextField 。可编辑资料 - - - 欢迎下载精品名师归纳总结private JTextField pactAgeTextField 。private JTextField bankNOTextField 。private JTextField pactStartDateTextField 。private JTextField dimissionDateTextField 。private JTextField bankNameTextField 。private JTextField firstPactDateTextField 。private JTextField accessionDateTextField 。private JTextField homeAddressTextField 。private JTextField onesStrongSuitTextField 。private JTextField likeTextField 。private JTextField homePostalcodeTextField 。private JTextField partyMemberDateTextField 。private JTextField gra
