52ky 发表于 2022-9-24 10:26:59

java实现企业员工信息管理系统(包含详细说明及界面截图)

NO.1
首要依据标题给出的字段笼统成数据库表。标题中包括企业部分信息,人员信息,还有一些基本信息。依据给出的字段及各个信息之间的联系,得到数据库的表如下:
①tb_deptkind:部分种类表
包括字段如下:
列名数据类型长度许可空描绘
DkidInt4否部分种类编号(主键)
DkindVarchar250否部分种类称号
②tb_deptinfo:部分详细信息
包括字段如下:
列名数据类型长度许可空描绘
DeptnoInt4否部分编号(主键)
DnameVarchar50否部分称号
DkidInt4否部分种类编号
③tb_duty:职务信息表
包括字段如下:
列名数据类型长度许可空描绘
DutyidInt4否职务id(主键)
DutynameVarchar20否职务称号
DutygradeInt4是部分等级
HiredateVarchar10是聘任日期
FiredateVarchar10是停止日期
④tb_degree:学历信息表
包括字段如下:
列名数据类型长度许可空描绘
IdInt4否学历编号(主键)
DegreeVarchar20否学历称号
⑤tb_nation:民族信息表
包括字段如下:
列名数据类型长度许可空描绘
IdInt4否民族编号(主键)
NationVarchar20否民族称号
⑥tb_nativeplace:籍贯信息表
..........
欧阳英的项目\.metadata\.plugins\com.genuitec.org.hibernate.eclipse\hibernate-tools.log
欧阳英的项目\.metadata\.plugins\org.eclipse.core.resources\.history\0\00c3cb7fd3ac001d105fa91adc11449d
欧阳英的项目\.metadata\.plugins\org.eclipse.core.resources\.history\0\20c764d4a9ab001d1c64eff6fc784107
欧阳英的项目\.metadata\.plugins\org.eclipse.core.resources\.history\0\40e87d8c91ac001d105fa91adc11449d
欧阳英的项目\.metadata\.plugins\org.eclipse.core.resources\.history\0\70825e8ebdab001d1c64eff6fc784107
欧阳英的项目\.metadata\.plugins\org.eclipse.core.resources\.history\1\100dca1c2bab001d19d3cf3b8b331509
欧阳英的项目\.metadata\.plugins\org.eclipse.core.resources\.history\1\30178ae08fac001d105fa91adc11449d
欧阳英的项目\.metadata\.plugins\org.eclipse.core.resources\.history\1\70367d83ccac001d105fa91adc11449d
欧阳英的项目\.metadata\.plugins\org.eclipse.core.resources\.history\10\60d80ef4caab001d1c64eff6fc784107
欧阳英的项目\.metadata\.plugins\org.eclipse.core.resources\.history\10\80b371bebaac001d105fa91adc11449d
欧阳英的项目\.metadata\.plugins\org.eclipse.core.resources\.history\11\9006c9d8a4ac001d105fa91adc11449d
欧阳英的项目\.metadata\.plugins\org.eclipse.core.resources\.history\11\c03091d073aa001d1a45a5aecb698fca
欧阳英的项目\.metadata\.plugins\org.eclipse.core.resources\.history\11\f0d7c9f1aaab001d1c64eff6fc784107
欧阳英的项目\.metadata\.plugins\org.eclipse.core.resources\.history\13\a01f767a91ac001d105fa91adc11449d
欧阳英的项目\.metadata\.plugins\org.eclipse.core.resources\.history\13\e0a322cfa8ac001d105fa91adc11449d
欧阳英的项目\.metadata\.plugins\org.eclipse.core.resources\.history\14\00a0b43fd0ac001d105fa91adc11449d
欧阳英的项目\.metadata\.plugins\org.eclipse.core.resources\.history\14\a090209f39ab001d19d3cf3b8b331509
欧阳英的项目\.metadata\.plugins\org.eclipse.core.resources\.history\15\309d84128dac001d105fa91adc11449d
欧阳英的项目\.metadata\.plugins\org.eclipse.core.resources\.history\15\c03d24e7abac001d105fa91adc11449d
欧阳英的项目\.metadata\.plugins\org.eclipse.core.resources\.history\16\006ea06a38ab001d19d3cf3b8b331509
欧阳英的项目\.metadata\.plugins\org.eclipse.core.resources\.history\18\00ce12ddcfab001d1c64eff6fc784107
欧阳英的项目\.metadata\.plugins\org.eclipse.core.resources\.history\18\d09b9d9d86ac001d105fa91adc11449d
欧阳英的项目\.metadata\.plugins\org.eclipse.core.resources\.history\19\90ac9c0e38ab001d19d3cf3b8b331509
欧阳英的项目\.metadata\.plugins\org.eclipse.core.resources\.history\19\c0e52b85a9ac001d105fa91adc11449d
欧阳英的项目\.metadata\.plugins\org.eclipse.core.resources\.history\1a\404ccf008bac001d105fa91adc11449d
欧阳英的项目\.metadata\.plugins\org.eclipse.core.resources\.history\1a\f015c17e74ac001d105fa91adc11449d
欧阳英的项目\.metadata\.plugins\org.eclipse.core.resources\.history\1b\10e9ef7876ac001d105fa91adc11449d
欧阳英的项目\.metadata\.plugins\org.eclipse.core.resources\.history\1b\a0f9b02bcbac001d105fa91adc11449d
欧阳英的项目\.metadata\.plugins\org.eclipse.core.resources\.history\1b\b0d0cf1667ac001d105fa91adc11449d
欧阳英的项目\.metadata\.plugins\org.eclipse.core.resources\.history\2\2044aaf3d0ac001d105fa91adc11449d
.....太多文件了略.....

(NO.1
Mainly based on the fields given by the title, the database tables are generally organized. The title includes some corporate information, personnel information, and some basic information. According to the given fields and the relationship between each information, the table of the database is obtained as follows:
①tb_deptkind: part of the kind table
Include fields as follows:
column name data type length allow empty description
DkidInt4 no part kind number (primary key)
DkindVarchar250 No Partial species title
②tb_deptinfo: some detailed information
Include fields as follows:
column name data type length allow empty description
DeptnoInt4 no part number (primary key)
DnameVarchar50 No Partial Title
DkidInt4 no part kind number
③tb_duty: job information table
Include fields as follows:
column name data type length allow empty description
DutyidInt4 No job id (primary key)
DutynameVarchar20 no job title
DutygradeInt4 is a partial grade
HiredateVarchar10 is the appointment date
FiredateVarchar10 is the stop date
④tb_degree: Educational information table
Include fields as follows:
column name data type length allow empty description
IdInt4 no education number (primary key)
DegreeVarchar20 No Degree Title
⑤tb_nation: Nationality information table
Include fields as follows:
column name data type length allow empty description
IdInt4 no nationality number (primary key)
NationVarchar20 no national title
⑥tb_nativeplace: Origin information table
..........
Ouyang Ying's project\.metadata\.plugins\com.genuitec.org.hibernate.eclipse\hibernate-tools.log
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\0\00c3cb7fd3ac001d105fa91adc11449d
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\0\20c764d4a9ab001d1c64eff6fc784107
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\0\40e87d8c91ac001d105fa91adc11449d
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\0\70825e8ebdab001d1c64eff6fc784107
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\1\100dca1c2bab001d19d3cf3b8b331509
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\1\30178ae08fac001d105fa91adc11449d
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\1\70367d83ccac001d105fa91adc11449d
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\10\60d80ef4caab001d1c64eff6fc784107
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\10\80b371bebaac001d105fa91adc11449d
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\11\9006c9d8a4ac001d105fa91adc11449d
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\11\c03091d073aa001d1a45a5aecb698fca
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\11\f0d7c9f1aaab001d1c64eff6fc784107
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\13\a01f767a91ac001d105fa91adc11449d
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\13\e0a322cfa8ac001d105fa91adc11449d
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\14\00a0b43fd0ac001d105fa91adc11449d
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\14\a090209f39ab001d19d3cf3b8b331509
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\15\309d84128dac001d105fa91adc11449d
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\15\c03d24e7abac001d105fa91adc11449d
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\16\006ea06a38ab001d19d3cf3b8b331509
Ouyang Ying's Project\.m)




页: [1]
查看完整版本: java实现企业员工信息管理系统(包含详细说明及界面截图)