“This is my 29th day of participating in the First Challenge 2022. For more details: First Challenge 2022

directory

The research background

System Function Overview

Main functions:

User login:

Home page functions:

Department Management:

Position Management:

Staff management:

System management:

Database table design:

The users table:

Department of tables:

Staff list:

Position table:

Conclusion:

Download the full project

Recommended reading article

Enterprise employee information management system

I. Introduction 2

1.1 Research Background 2

1.2 Purpose and Significance 3

1.2 Research Objectives and content 3

1.3 Project feasibility study design 3

1.4 Technical feasibility 3

spring 4

Spring MVC 4

mybatis 5

jQuery 5

c3p0 6

Mysql 6

Demand Analysis 8

2.1 System Function Overview 8

2.2 System Operating Environment 8

2.3 Function Requirements 9

2.4 Technical difficulties 9

Springmvc resolves Chinese garbled characters: 9

Error 10 when tomcat server is started

Iii. System Design 11

3.1 System Design 11

3.2 Overall architecture of the system module 11

3.3 Module Design 11

3.4 System Flow Description 11

3. 5 Project source code architecture 12

4. System implementation 13

4.1 Program main Class 13

4.1.1 User Entity Class 14

4.1.2 Department 14

4.1.3 Staff 15

4.1.4 Job Category 16

4.3 System Functions Main realization module Screenshot 18

4.3.1 Login page 18

4.3.2 Main Page 19

4.3.4 Display of some key source code: 23

4.4 Database Table Design 32

4.4.0 Database Three normal Form requirements: 32

4.4.1 Database table ER Figure 34

4.4.2 User table Design 34

4.4.3 Department table design 35

4.4.4 Design of employee form 35

4.4.5 Job Form design 35

4.4.6 Database SQL Files 35

Five. System development summary and experience 38

Vi. Refer to Article 38

The research background

The development of computer network technology has brought great convenience to people in the information age. Now on the Internet, you can see a wide variety of information management systems everywhere, such as enterprise office automatic management system, electronic commerce system, university educational management system and so on. With the development of information technology has been deeply into every corner of the society, each large enterprise, are fully aware of the traditional manual management mode has gradually failed to adapt to the development of The Times, in order to better development, have developed their own management system. Don’t care about big business. The same is true of small enterprises with various employee information. The management of enterprises is also deeply aware of this. In the past, most of the management is manual management, which is low efficiency, error-prone, cumbersome, and consumes a lot of human, material and financial resources. They hope to have a suitable for their own management system, to achieve staff information management, department management, leave management, attendance management and other functions. Through this system, managers can make timely changes to information to employees, through the digital management of the computer, convenient staff management information, which can improve work efficiency, the liberation of the administrator’s hands, and it also makes it easier to manage employee information in all kinds of information needed to facilitate rapid entry, query and update, all sorts of function to the corresponding implementation, The corresponding key data can also facilitate the statistical results. At present, the staff management of a large number of enterprises cannot modify the information of employees in time, and there is no good interaction between the administrator and employees. It is still necessary to manually convey information, which is not only inefficient but also often causes losses because the information can not be transmitted in time. Therefore, most enterprises need to design an efficient enterprise employee information management system to help enterprises to better and faster management of employees, strengthen the connection between superior and subordinate, to improve the efficiency of the enterprise. The main purpose of the design of employee information management system is to centralize the management of the information of the employees, facilitate the timely update of the information of the employees, the command of the superior can be accurately and efficiently communicated, and facilitate the establishment of an efficient and accurate employee information database. It is based on SQL database as a development platform, using JSP to write procedures to complete the functions of the data and use SQL database to form data for data storage.

System Function Overview

1. Able to manage department information, convenient to add, modify, delete department information, to adapt to the future development of the enterprise; 2. Manage the employee information, so as to facilitate the entry and management of the employee’s department and the basic information of the employee, so as to achieve standardized management; 3. Add, modify, delete and other operations of job information 4. Ensure the safety and integrity of employee information, avoid information leakage and unnecessary losses to employees.

5. Perform Excel export function for employee data

6. The user logs out

Main functions:

​

User login:

​

The login code

<title>Enterprise employee information management platform</title>

<link rel="stylesheet" type="text/css" href="easyui/themes/default/easyui.css" />
<link rel="stylesheet" type="text/css" href="easyui/themes/icon.css" />
<link rel="stylesheet" type="text/css" href="css/login.css" />
</head>
<body>


<div id="login">
	<p>Login Account:<input type="text"  id="manager" class="textbox"></p>
	<p>Login Password:<input type="password" id="password" class="textbox"></p>
	<p> <font color="# 999">Remember account</font>
		<input  id="saveid" type="checkbox"  onclick="savePaw();"  />
	</p>
	 
</div>

<div id="btn">
	<a href="#" class="easyui-linkbutton">The login</a>
</div>
Copy the code

Home page functions:

​

Home page main.jsp page

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<jsp:include page="check_logstate.jsp"/>
 
<! DOCTYPEhtml>
<html>
<head>
<title>Information management system</title>
<meta charset="UTF-8" />
<link rel="stylesheet" type="text/css" href="easyui/themes/default/easyui.css" />
<link rel="stylesheet" type="text/css" href="easyui/themes/icon.css" />
<link rel="stylesheet" type="text/css" href="css/admin.css" />
</head>
<body class="easyui-layout">

<div data-options="region:'north',title:'header',split:true,noheader:true" style="height:60px; background-color:#01B1EA;">
	<div class="logo">Enterprise staff background information management system</div>
	<div class="logout">Hello, < % = session. The getAttribute (" username ") % > |<a href="logout">exit</a></div>
</div>   
<div data-options="region:'south',title:'footer',split:true,noheader:true" style="height:35px; line-height:30px; text-align:center;">
	&copy; Powered by dashen
</div>    
<div data-options=Region: "west", "the title: 'navigation', split: true, iconCls: 'icon - world" style="width:200px; padding:10px;">
	<ul id="nav"></ul>
</div>   
<div data-options="region:'center'" style="overflow:hidden;">
	<div id="tabs">
		<div title="Start page" iconCls="icon-house" style="padding:0 10px; display:block; font-size:70px">
			<br/><br/> <center>Welcome to the enterprise staff background information management system!</center>
		</div>
	</div>
</div> 


<script type="text/javascript" src="easyui/jquery.min.js"></script>
<script type="text/javascript" src="easyui/jquery.easyui.min.js"></script>
<script type="text/javascript" src="easyui/locale/easyui-lang-zh_CN.js" ></script>
<script type="text/javascript" src="js/admin.js"></script>
</body>
</html>
Copy the code

Department Management:

​

<div id="department_manage_tool" style="padding:5px;">
	<div style="margin-bottom:5px;">
		<a href="#" class="easyui-linkbutton" iconCls="icon-edit-new" plain="true" onclick="department_manage_tool.edit();">Modify the</a>
		<a href="#" class="easyui-linkbutton" iconCls="icon-delete-new" plain="true" onclick="department_manage_tool.remove();">delete</a>
		<a href="#" class="easyui-linkbutton" iconCls="icon-reload" plain="true"  onclick="department_manage_tool.reload();">The refresh</a>
		<a href="#" class="easyui-linkbutton" iconCls="icon-redo" plain="true" onclick="department_manage_tool.redo();">deselect</a>
		<a href="#" class="easyui-linkbutton" iconCls="icon-export" plain="true" onclick="department_manage_tool.exportExcel();">Export to excel</a>
	</div>
	<div style="padding:0 0 0 7px; color:#333;">
		<form id="departmentQueryForm" method="post">
		</form>	
	</div>
</div>

<div id="departmentEditDiv">
	<form id="departmentEditForm" enctype="multipart/form-data"  method="post">
		<div>
			<span class="label">Department No. :</span>
			<span class="inputControl">
				<input class="textbox" type="text" id="department_departmentNo_edit" name="department.departmentNo" style="width:200px" />
			</span>
		</div>
		<div>
			<span class="label">Department Name:</span>
			<span class="inputControl">
				<input class="textbox" type="text" id="department_departmentName_edit" name="department.departmentName" style="width:200px" />

			</span>

		</div>
	</form>
</div>
Copy the code

​

Position Management:

​

​

<div id="employeeEditDiv">
	<form id="employeeEditForm" enctype="multipart/form-data"  method="post">
		<div>
			<span class="label">Employee No. :</span>
			<span class="inputControl">
				<input class="textbox" type="text" id="employee_employeeNo_edit" name="employee.employeeNo" style="width:200px" />
			</span>
		</div>
		<div>
			<span class="label">Position:</span>
			<span class="inputControl">
				<input class="textbox"  id="employee_positionObj_positionId_edit" name="employee.positionObj.positionId" style="width: auto"/>
			</span>
		</div>
		<div>
			<span class="label">Name:</span>
			<span class="inputControl">
				<input class="textbox" type="text" id="employee_name_edit" name="employee.name" style="width:200px" />

			</span>

		</div>
		<div>
			<span class="label">Gender:</span>
			<span class="inputControl">
				<select id="employee_sex_edit" name="employee.sex" >
					<option value="Male">male</option>
					<option value="Female">female</option>
				</select>
			</span>

		</div>
		<div>
			<span class="label">Employee photo:</span>
			<span class="inputControl">
				<img id="employee_employeePhotoImg" width="200px" border="0px"/><br/>
    			<input type="hidden" id="employee_employeePhoto" name="employee.employeePhoto"/>
				<input id="employeePhotoFile" name="employeePhotoFile" type="file" size="50" />
			</span>
		</div>
		<div>
			<span class="label">Date of Birth</span>
			<span class="inputControl">
				<input class="textbox" type="text" id="employee_birthday_edit" name="employee.birthday" />

			</span>

		</div>
		<div>
			<span class="label">Education degree:</span>
			<span class="inputControl">
				<select id="employee_schoolRecord_edit" name="employee.schoolRecord">
					<option value="Primary school">Primary school</option>
					<option value="Junior">Junior high school</option>
					<option value="High school">High school</option>
					<option value="College">college</option>
					<option value="Undergraduate">Undergraduate course</option>
					<option value="Master">A master's degree</option>
					<option value="博士">Dr.</option> 
				</select>
			</span>

		</div>
		<div>
			<span class="label">Employee Introduction:</span>
			<span class="inputControl">
				<textarea id="employee_employeeDesc_edit" name="employee.employeeDesc" rows="8" cols="60"></textarea>

			</span>

		</div>
	</form>
</div>
Copy the code

Staff management:

System management:

Database table design:

The users table:

CREATE TABLE `NewTable` (
`username`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ' ' ,
`password`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`username`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
ROW_FORMAT=COMPACT
;
Copy the code

Department of tables:

CREATE TABLE `NewTable` (
`departmentNo`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'departmentNo' ,
`departmentName`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'Department Name' ,
PRIMARY KEY (`departmentNo`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
ROW_FORMAT=COMPACT
;
Copy the code

Staff list:

CREATE TABLE `NewTable` (
`employeeNo`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'employeeNo' ,
`positionObj`  int(11) NOT NULL COMMENT 'job' ,
`name`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'name' ,
`sex`  varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'gender' ,
`employeePhoto`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'Employee photo' ,
`birthday`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT Date of birth ,
`schoolRecord`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'degree' ,
`employeeDesc`  varchar(5000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'Staff Introduction' ,
PRIMARY KEY (`employeeNo`),
FOREIGN KEY (`positionObj`) REFERENCES `t_position` (`positionId`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `positionObj` (`positionObj`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
ROW_FORMAT=COMPACT
;
Copy the code

Position table:

CREATE TABLE `NewTable` (
`positionId`  int(11) NOT NULL AUTO_INCREMENT COMMENT 'job id' ,
`departmentObj`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'Department' ,
`positionName`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'Job Title' ,
`baseSalary`  float NOT NULL COMMENT 'Basic salary' ,
`sellPercent`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'Sales commission' ,
PRIMARY KEY (`positionId`),
FOREIGN KEY (`departmentObj`) REFERENCES `t_department` (`departmentNo`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `departmentObj` (`departmentObj`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=5
ROW_FORMAT=COMPACT
;
Copy the code

Conclusion:

Through the recent mastery and learning of Java object-oriented programming, front-end knowledge and Java SSM framework, I have better understood the importance of Java learning. During the development of this system, I completed many experiments and tests. During the learning and development at this stage, I realized that I was familiar with it and then became able to use it independently. Through the understanding of Java, I found that it does have a lot of convenience, it integrates abstractness, encapsulation, inheritance and polymorphism, realizes code reuse and code expansion, and improves the efficiency of software development. It is very important for our major to learn Java language well, so IN the process of developing this project, I tried my best to understand Java programming ideas, master basic skills and learn as much knowledge as possible. The basic purpose of my study of programming is to cultivate the key skills to describe programmatic solutions to practical problems. Java object-oriented programming is a highly practical language, and the MVC three-tier architecture of springMVC framework concentrates data access and logical operations into components, which enhances the reuse of the system. The expansibility of the system is greatly enhanced. As well as front-end jQuery, JS and CSS styles, I can make webpage layout, style adjustment and font more accurate.

In general, this project is relatively simple and excellent, suitable for beginners as a reference for course design and graduation design