Main technologies: Java, SpringMVC, VUE, Node.js, Mybatis, mysql, tomcat, jquery, Layui, Bootstarp, JavaScript, HTML, CSS, JSP, log4j and other common basic technologies.
Main design of the document:
Abstract* * * *2
Based on Java epidemic prevention platform information system Design and implementation of the* * * *3
One, the introduction* * * *3
1.1 Research Background 3
1.2 Project Objectives: 4
Ii. Introduction of related technologies Analysis of the* * * *4
2.1 spring 5
Spring MVC 2.2 6
2.3 mybatis 6
2.4 the jQuery 6
Mysql 2.5 7
Iii. Feasibility Analysis of the* * * *7
3.2 System Operating Environment 7
3.3 Overall technical design 8
3.4 Social feasibility analysis 8
3.5 Security feasibility analysis 8
3.6 Economic feasibility analysis 9
3.7 Legal feasibility analysis 9
4. System design and analysis* * * *9
4.1 System Mode Architecture 9
4.2 System Hierarchical Architecture 10
4.3 Detailed system Function design 11
4.4 Overall Data Process Analysis 12
4.5 Source Code Architecture 13
4.6 Technical Difficulties 15
六四运动Five,六四运动Programming and implementation* * * *15
5.1 Main Category of procedures 15
5.2 Main system function design and realization 20
5.1. Login module: 20
5.2 Menu Management: 22
5.3 User Management: 23
5.4 Real-time epidemic status distribution map: 24
5.5 Health Punch card application: 25
5.6 Historical Itinerary list: 27
5.7 Outbound Report list: 27
5.8 Quarantine substance audit: 28
5.9 Review list of Notices: 29
5.10 Changing the Password: 29
5.11 Global Exception Handling: 30
5.12 Database Connection Configuration 31
Vi. Database design* * * *32
6.1 Basic design of Table 32
6.2 Database Three normal form requirements: 32
6.3 Database table ER Figure 32
6.4 User table Design 33
6.5 Role Table Design 34
6.6 Menu Table Design 34
6.7 Historical Schedule Design 35
6.8 Health Punch Card Design 36
6.9 Design of out-going reporting table 37
6.10 Resume Application Form Design 38
6.11 Design of notice and Announcement Table 38
Seven, experience And summary* * * *39
Eight, test examples* * * *40
Test one: 40
Test two: 41
Test three: 41
Test evaluation 42
Thank you 42
Nine, refer to the text* * * *43
Main modules:
Administrator login: User login.
User information: View, modify, and delete the list of user information data, and bind users to roles to display corresponding menus.
Role management: View, modify, and delete the role information list. Each role can be displayed on different menus. The super administrator has the highest rights.
Menu management: menu information data list view, modify and delete, can be set by user role
Menu permission: Allows users to bind roles, display role binding menus, and add, modify, and delete basic menus.
Real-time epidemic status: Using Echarts ICONS to simulate data-driven identification, real-time display of epidemic distribution map and infected personnel information, etc.
Historical itinerary management: Daily registration management: out reporting management: resume application management: audit information management:
Notice and announcement management: the administrator issued some notice and announcement information and management view
Screenshots of the main functions of the system are as follows:
Enter the system home page after login: The main functions of the system are as follows
User management module: user add, modify, delete, query and other basic operations
Role management module, through user binding role, role control menu display, flexible control menu.
Front-end VUE code adds menu
<template> <div class="mod-menu"> <el-form :inline="true" :model="dataForm"> <el-form-item> <el-button V-if ="isAuth('sys:menu:save')" type="primary" @click="addOrUpdateHandle()" new </el-button> </el-form-item> </el-form> <el-table :data="dataList" row-key="menuId" border style="width: 100%; "> <el-table-column prop="name" header-align="center" min-width="150" label=" name" ></el-table-column> <el-table-column Prop ="parentName" header-align="center" align="center" width="120" label=" upper menu "> </el-table-column> <el-table-column The header - the align = "center" align = "center" label = "icon" > < template slot - scope = "scope" > < icon - SVG: name = "scope. Row. Icon | | ''"></icon-svg></template> </el-table-column> <el-table-column prop="type" header-align="center" align="center" Label =" type "> <template slot-scope="scope"> <el-tag V-if ="scope.row.type === 0" size="small"> Directory </el-tag> <el-tag V-else -if="scope.row.type === 1" size="small" type="success"> menu </el-tag> <el-tag v-else-if="scope.row.type === 2" Size ="small" type="info"> button </el-tag> </template> </el-table-column> <el-table-column prop="orderNum" Header -align="center" align="center" label=" sort "> </el-table-column> <el-table-column prop="url" header-align="center" Align ="center" width="150" :show-overflow-tooltip="true" label=" menu URL"> </el-table-column> <el-table-column prop="perms" "> </el-table-column> </el-table-column> <el-table-column fixed="right" header-align="center" align="center" width="150" label=" operation "> <template slot-scope="scope"> <el-button v-if="isAuth('sys:menu:update')" type="text" size="small" @click="addOrUpdateHandle(scope.row.menuid)"> modify </el-button> <el-button V-if ="isAuth('sys:menu:delete')" type="text" Size ="small" @click="deleteHandle(scope.row.menuid)"> Delete </el-button> </template> </el-table-column> </el-table> <! - play a window, <add-or-update v-if="addOrUpdateVisible" ref="addOrUpdate" @refreshDatalist ="getDataList"></add-or-update> </div> </template> <script> import AddOrUpdate from './menu-add-or-update' import { treeDataTranslate } from '@/utils' export default { data () { return { dataForm: {}, dataList: [], dataListLoading: false, addOrUpdateVisible: false } }, components: { AddOrUpdate }, activated () { this.getDataList() }, methods: GetDataList () {this.datalistLoading = true this.$HTTP ({url: this.$http.adornUrl('/sys/menu/list'), method: 'get', params: this.$http.adornParams() }).then(({data}) => { this.dataList = treeDataTranslate(data, 'menuId') this.dataListLoading = false }) }, AddOrUpdateHandle (id) {this.addOrUpdatevisible = true this.$nextTick(() => { This.$refs.addorUpdate.init (id)})}, // Delete deleteHandle (id) {this.$confirm(' delete from [id=${id}]? ', 'confirmButtonText ', {confirmButtonText:' confirm ', cancelButtonText: 'cancel ', type: 'warning'}). Then (() => {this.$HTTP ({url: this.$http.adornUrl(`/sys/menu/delete/${id}`), method: 'post', data: This.$http.adornData()}). Then (({data}) => {if (data && data. Code === 0) {this. 'success', duration: 1500, onClose: () => { this.getDataList() } }) } else { this.$message.error(data.msg) } }) }).catch(() => {}) } } } </script>Copy the codeMenu add modify column surface operation
History itinerary data management: add, modify, delete and other operations
Daily health punch list data display and add punch information
Staff out to report management applications
Employee resume application
Administrator audit
Notification module:
Database connection:
spring: datasource: type: com.alibaba.druid.pool.DruidDataSource druid: driver-class-name: com.mysql.jdbc.Driver url: jdbc:mysql://localhost:3306/renren_fast? useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai username: root password: 123456 initial-size: 10 max-active: 100 min-idle: 10 max-wait: 60000 pool-prepared-statements: true max-pool-prepared-statement-per-connection-size: 20 time-between-eviction-runs-millis: #validation-query: SELECT 1 FROM DUAL test-while-idle: SELECT 1 FROM DUAL test-while-idle: SELECT 1 FROM DUAL test-while-idle: SELECT 1 FROM DUAL test-while-idle: SELECT 1 FROM DUAL test-while-idle: true test-on-borrow: false test-on-return: false stat-view-servlet: enabled: true url-pattern: /druid/* #login-username: admin #login-password: admin filter: stat: log-slow-sql: true slow-sql-millis: 1000 mergeD-sql: false wall: config: multi-statement-allow: true ## # driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver # url: jdbc:sqlserver://localhost:1433; DatabaseName=renren_security # username: sa # password: 123456 # slave2: # driver-class-name: org.postgresql.Driver # url: jdbc:postgresql://localhost:5432/renren_security # username: renren # password: 123456Copy the codeFront-end and back-end code structure:
Main table design:
The users table:
CREATE TABLE `NewTable` ( `user_id` bigint(20) NOT NULL AUTO_INCREMENT , 'username' varchar(50) CHARACTER SET UTf8MB4 COLLATE UTf8MB4_general_ci NOT NULL COMMENT 'username', Varchar (100) CHARACTER SET utf8MB4 COLLATE UTf8MB4_general_ci NULL DEFAULT NULL COMMENT 'password', 'salt' varchar(20) CHARACTER SET utf8MB4 COLLATE UTf8MB4_general_ci NULL DEFAULT NULL COMMENT 'salt', 'email' varchar(100) CHARACTER SET UTf8MB4 COLLATE UTf8MB4_general_ci NULL DEFAULT NULL COMMENT ' 'mobile' varchar(100) CHARACTER SET UTf8MB4 COLLATE UTf8MB4_general_ci NULL DEFAULT NULL COMMENT 'cellphone', 'status' tinyint(4) NULL DEFAULT NULL COMMENT' Create_user_id bigint(20) NULL DEFAULT NULL COMMENT 'create_user_id', 'create_time' datetime NULL DEFAULT NULL COMMENT 'create time', PRIMARY KEY (' user_id '), UNIQUE INDEX `username` (`username`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE= UTf8MB4_general_ci COMMENT=' system user 'Copy the codeOutgoing reporting form:
CREATE TABLE 'NewTable' (' id 'int(11) NOT NULL AUTO_INCREMENT,' wc_time 'datetime NULL DEFAULT NULL COMMENT' 'wc_yy' VARCHar (255) CHARACTER SET utf8 COLLATE UTf8_general_ci NULL DEFAULT NULL COMMENT 'Cause', Wc_dd 'varchar(255) CHARACTER SET utf8 COLLATE UTf8_general_ci NULL DEFAULT NULL COMMENT' 'username' varchar(255) CHARACTER SET utf8 COLLATE UTf8_general_ci NULL DEFAULT NULL COMMENT 'username', 'phone' varchar(255) CHARACTER SET utf8 COLLATE UTf8_general_ci NULL DEFAULT NULL COMMENT ' 'bz' varchar(255) CHARACTER SET utf8 COLLATE UTf8_general_ci NULL DEFAULT NULL COMMENT ' `stu` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=17 ROW_FORMAT=COMPACT ;Copy the codeHealth Registration Form:
CREATE TABLE `NewTable` ( `id` int(11) NOT NULL AUTO_INCREMENT , 'name' varchar(255) CHARACTER SET utf8 COLLATE UTf8_general_ci NULL DEFAULT NULL COMMENT 'name', 'phone' varchar(255) CHARACTER SET utf8 COLLATE UTf8_general_ci NULL DEFAULT NULL COMMENT 'cellphone', 'SZD' varchar(255) CHARACTER SET utf8 COLLATE UTf8_general_ci NULL DEFAULT NULL COMMENT ' 'STZK' varchar(255) CHARACTER SET utf8 COLLATE UTf8_general_ci NULL DEFAULT NULL COMMENT '主 体', 'GRJC' varchar(255) CHARACTER SET utf8 COLLATE UTf8_general_ci NULL DEFAULT NULL COMMENT 'Whether to contact with infected person', `bz` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , 'create_time' datetime NULL DEFAULT NULL COMMENT 'date', `tw` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=10 ROW_FORMAT=COMPACT ;Copy the codeUser schedule:
CREATE TABLE `NewTable` (
`id` int(11) NOT NULL AUTO_INCREMENT ,
`username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`cx_time` datetime NULL DEFAULT NULL ,
`place` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`bz` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`mobile` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=8
ROW_FORMAT=COMPACT
;
Copy the codeSome design reports and documentation description reference
Relevant system design and implementation recommendations:
Based on Java Springboot + Mybatis film ticket website management system front + background design and implementation
Design and implementation of winery internal management system based on Java SSM Springboot + Mybatis
Design and implementation of intelligent life sharing platform based on JAVA Springboot + Mybatis
Based on Java Springboot + VUE + Redis front and back end separation furniture mall platform system design and implementation
Design and implementation of anti-epidemic material information management system based on JAVA SSM Springboot