人力资源管理系统（大二数据库课设） spring boot，Mybatis+bootstap，ajax项目

四、应用系统功能模块

1.具体模块分析及流程

人力资源管理系统具体由机构管理、常用业务、权限管理、通知公告四部分组成。机构管理权限由总经理持有，总经理对人力资源管理具有所权限可以对公司部门、员工职位进行修改；总经理和人事部经理，拥有常用业务中入职管理、人事档案管理、求职者管理、和人才库管理；用户管理是用户自己进行用户账号管理和用户相应权限可操作范围管理，通知公告即公司公告的发布管理具体见图9所示：

图9          系统功能模块图

系统登录流程图:

不同的员工账号具有不同的权限，登录系统后显示的界面及功能不同，详见图10。

图10        登录流程图

2.总体业务流程：

图11   总体业务流程

五、数据库逻辑结构设计：

1.ER图——关系模型转化

1.1员工关系模型：

db_staff（id，name，sex，age，place，birth，tel，staff_department，staff_position，entry_time，leave_time，isdelete）

1.2部门关系模型：

db_department(id，department_name,position,duty)

1.3文件关系模型：

file（id，file_name，file_content，0post_time，post_staff）

1.4用户关系模型：

db_user（id，staff_name，user_account，user_password，creat time，role_id）

1.5职位关系模型

db_position(id,position_level,position_salary,position)

1.6简历关系模型：

db_Interviewee（id，name，sex，age，desired_position，desired_department，work_experience，work_grade）

2.数据字典

2.1员工表：

表2    数据字典    员工表

2.2部门表：

表3    数据字典    部门表

2.3文件表：

表4    数据字典    文件表

2.4用户表：

表5       数据字典   用户表

2.5职位表：

表6    数据字典   职位表

2.6简历表：

表7    数据字典   简历表

六、详细设计及实现

1.建立数据库（表，视图，索引等

CREATE DATABASE xpu_hrms;
USE xpu_hrms;

-- ----------------------------
-- Table structure for db_department
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[db_department]') AND type IN ('U'))
    DROP TABLE [dbo].[db_department]
GO
CREATE TABLE [dbo].[db_department] (
  [id] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [department_name] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [position] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [duty] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL
)
GO
ALTER TABLE [dbo].[db_department] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'部门名',
'SCHEMA', N'dbo',
'TABLE', N'db_department',
'COLUMN', N'department_name'
GO
EXEC sp_addextendedproperty
'MS_Description', N'职位类型 职位名',
'SCHEMA', N'dbo',
'TABLE', N'db_department',
'COLUMN', N'position'
GO
EXEC sp_addextendedproperty
'MS_Description', N'职责',
'SCHEMA', N'dbo',
'TABLE', N'db_department',
'COLUMN', N'duty'
GO
 
-- ----------------------------
-- Table structure for db_file
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[db_file]') AND type IN ('U'))
    DROP TABLE [dbo].[db_file]
GO
CREATE TABLE [dbo].[db_file] (
  [id] char(32) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [file_name] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [file_content] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [post_time] datetime  NOT NULL,
  [post_staff] char(32) COLLATE Chinese_PRC_CI_AS  NOT NULL
)
GO
ALTER TABLE [dbo].[db_file] SET (LOCK_ESCALATION = TABLE)
GO
-- ----------------------------
-- Table structure for db_interviewee
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[db_interviewee]') AND type IN ('U'))
    DROP TABLE [dbo].[db_interviewee]
GO
CREATE TABLE [dbo].[db_interviewee] (
  [id] char(32) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [name] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [sex] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [age] int  NULL,
  [desired_position] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [desired_department] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [work_experience] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [work_grade] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[db_interviewee] SET (LOCK_ESCALATION = TABLE)
GO
 
-- ----------------------------
-- Table structure for db_position
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[db_position]') AND type IN ('U'))
    DROP TABLE [dbo].[db_position]
GO
CREATE TABLE [dbo].[db_position] (
  [id] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [position_level] char(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [position_salary] real DEFAULT 0 NULL,
  [position] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL
)
GO
ALTER TABLE [dbo].[db_position] SET (LOCK_ESCALATION = TABLE)
GO
-- ----------------------------
-- Table structure for db_staff
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[db_staff]') AND type IN ('U'))
    DROP TABLE [dbo].[db_staff]
GO
CREATE TABLE [dbo].[db_staff] (
  [id] char(32) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [name] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [sex] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [age] int  NULL,
  [place] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [birth] datetime  NULL,
  [tel] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [staff_department] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [staff_position] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [entry_time] datetime  NULL,
  [leave_time] datetime  NULL,
  [isdelete] varchar(10) COLLATE Chinese_PRC_CI_AS  NULL
)
GO
ALTER TABLE [dbo].[db_staff] SET (LOCK_ESCALATION = TABLE)
GO
 
-- ----------------------------
-- Table structure for db_user
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[db_user]') AND type IN ('U'))
    DROP TABLE [dbo].[db_user]
GO
CREATE TABLE [dbo].[db_user] (
  [id] char(32) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [staff_name] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [user_account] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [user_password] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [creat_time] datetime  NOT NULL,
  [role_id] int  NOT NULL
)
GO
ALTER TABLE [dbo].[db_user] SET (LOCK_ESCALATION = TABLE)
GO
-- ----------------------------
-- Primary Key structure for table db_department
-- ----------------------------
ALTER TABLE [dbo].[db_department] ADD CONSTRAINT [PK__db_depar__3213E83F09B759E2] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO
-- ----------------------------
-- Primary Key structure for table db_file
-- ----------------------------
ALTER TABLE [dbo].[db_file] ADD CONSTRAINT [PK__db_file__3213E83F09615A31] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO
-- Primary Key structure for table db_interviewee
-- ----------------------------
ALTER TABLE [dbo].[db_interviewee] ADD CONSTRAINT [PK__db_inter__3213E83F7DB31B7E] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO
-- ----------------------------
-- Primary Key structure for table db_position
-- ----------------------------
ALTER TABLE [dbo].[db_position] ADD CONSTRAINT [PK__db_posit__3213E83FCA3D5B20] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO
-- ----------------------------
-- Primary Key structure for table db_staff
-- ----------------------------
ALTER TABLE [dbo].[db_staff] ADD CONSTRAINT [PK__db_staff__3213E83F739A3F95] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO
-- ----------------------------
-- Primary Key structure for table db_user
-- ----------------------------
ALTER TABLE [dbo].[db_user] ADD CONSTRAINT [PK__db_user__3213E83F1A21E87A] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO
-- ----------------------------
-- Foreign Keys structure for table db_file
-- ----------------------------
ALTER TABLE [dbo].[db_file] ADD CONSTRAINT [FK__db_file__post_st__00DF2177] FOREIGN KEY ([post_staff]) REFERENCES [dbo].[db_user] ([id]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO
-- ----------------------------
-- Foreign Keys structure for table db_interviewee
-- ----------------------------
ALTER TABLE [dbo].[db_interviewee] ADD CONSTRAINT [FK__db_interview__id__03BB8E22] FOREIGN KEY ([id]) REFERENCES [dbo].[db_user] ([id]) ON DELETE CASCADE ON UPDATE CASCADE
GO


 
-- ----------------------------
-- Foreign Keys structure for table db_position
-- ----------------------------
ALTER TABLE [dbo].[db_position] ADD CONSTRAINT [FK__db_positi__posit__05A3D694] FOREIGN KEY ([position]) REFERENCES [dbo].[db_department] ([id]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO

-- ----------------------------
-- Foreign Keys structure for table db_staff
-- ----------------------------
ALTER TABLE [dbo].[db_staff] ADD CONSTRAINT [FK__db_staff__id__04AFB25B] FOREIGN KEY ([id]) REFERENCES [dbo].[db_interviewee] ([id]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO

ALTER TABLE [dbo].[db_staff] ADD CONSTRAINT [FK__db_staff__staff___7849DB76] FOREIGN KEY ([staff_position]) REFERENCES [dbo].[db_position] ([id]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO

ALTER TABLE [dbo].[db_staff] ADD CONSTRAINT [FK__db_staff__staff___7C1A6C5A] FOREIGN KEY ([staff_department]) REFERENCES [dbo].[db_department] ([id]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO

ALTER TABLE [dbo].[db_staff] ADD CONSTRAINT [FK__db_staff__id__7D0E9093] FOREIGN KEY ([id]) REFERENCES [dbo].[db_user] ([id]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO

 2.编码规范定义：

表8          编码规范

3.界面设计：

    登录首页展示,（前端界面来自于网络）如图12：

图12   页面设计

4.项目文件结构及说明

图13   项目文件结构

5.源程序代码

详见github仓库

https://github.com/whd1996/hrms文章来源地址https://www.toymoban.com/news/detail-485531.html

到了这里，关于人力资源管理系统（大二数据库课设） spring boot，Mybatis+bootstap，ajax项目的文章就介绍完了。如果您还想了解更多内容，请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章，希望大家以后多多支持TOY模板网！