摘 要
随着信息技术和网络技术的飞速发展，人类已进入全新信息化时代，传统管理技术已无法高效，便捷地管理信息。为了迎合时代需求，优化管理效率，各种各样的管理系统应运而生，各行各业相继进入信息管理时代，财务管理系统就是信息时代变革中的产物之一。
任何系统都要遵循系统设计的基本流程，本系统也不例外，同样需要经过市场调研，需求分析，概要设计，详细设计，编码，测试这些步骤，基于java技术、springboot框架、B/S机构、Mysql数据库设计并实现了财务管理系统。系统主要包括首页，个人中心，员工管理，部门管理，员工工资管理，工资调整管理，资产类别管理，固定资产管理，经营信息管理，序时账管理，年度利润管理，系统管理等功能模块。
本文首先介绍了财务管理技术的发展背景与发展现状，然后遵循软件常规开发流程，首先针对系统选取适用的语言和开发平台，根据需求分析制定模块并设计数据库结构，再根据系统总体功能模块的设计绘制系统的功能模块图，流程图以及E-R图。然后，设计框架并根据设计的框架编写代码以实现系统的各个功能模块。最后，对初步完成的系统进行测试，主要是功能测试、单元测试和性能测试。测试结果表明，该系统能够实现所需的功能，运行状况尚可并无明显缺点。
关键字：财务管理；springboot；Mysql数据库
Abstract
With the rapid development of information technology and network technology, human beings have entered a new information age, traditional management technology has been unable to efficiently and conveniently manage information. In order to meet the needs of The Times and optimize management efficiency, a variety of management systems have emerged. All walks of life have entered the information management era. Financial management system is one of the products in the information era.
Any system should follow the basic process of system design, this system is no exception, also need to go through market research, demand analysis, outline design, detailed design, coding, testing these steps, based on Java technology, Springboot framework, B/S institutions, Mysql database design and implementation of the financial management system. The system mainly includes home page, personal center, staff management, department management, staff salary management, salary adjustment management, asset class management, fixed assets management, business information management, chronological account management, annual profit management, system management and other functional modules.
This article first introduces the background and the development of financial management technology development present situation, and then follow the routine software development process, first of all, in view of the system and the selection of suitable language development platform, according to the requirement analysis module and database structure design, and then based on the system's overall function module design rendering system function module chart, flow diagram and e-r diagram. Then, design the framework and write code according to the designed framework to achieve each functional module of the system. Finally, the preliminary completed system is tested, mainly functional test, unit test and performance test. The test results show that the system can achieve the required functions, and the running condition is fair and there is no obvious defect.
Key words: Financial management; Springboot; The Mysql database
目 录
第一章 概述 1
1.1研究背景 1
1.2开发意义 1
1.3 研究现状 1
1.4 研究内容 2
第二章 开发技术介绍 3
2.1 系统开发平台 3
2.2 平台开发相关技术 3
2.2.1 Javar技术 3
2.2.2 Mysql数据库介绍 3
2.2.3 Mysql环境配置 3
2.2.4 B/S架构 4
2.2.5 Springboot框架 4
第三章 系统分析 5
3.1 可行性分析 5
3.1.1技术可行性 5
3.1.2操作可行性 5
3.1.3经济可行性 5
3.2性能需求分析 5
第四章 系统设计 7
4.1功能结构 7
4.2 数据库设计 7
4.2.1 数据库E/R图 7
4.2.2 数据库表 8
第五章 系统功能实现 15
5.1管理员功能模块 15
5.2员工功能模块 20
第六章 系统测试 22
第七章 总结与心得体会 23
7.1总结 23
7.2心得体会 23
致 谢 24
参考文献 25
数据库：
-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64)
--
-- Host: localhost Database: springbootqc6r2
-- ------------------------------------------------------
-- Server version 5.7.31
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Current Database: `springbootqc6r2`
--
/*!40000 DROP DATABASE IF EXISTS `springbootqc6r2`*/;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `springbootqc6r2` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `springbootqc6r2`;
--
-- Table structure for table `bumen`
--
DROP TABLE IF EXISTS `bumen`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bumen` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`bumen` varchar(200) DEFAULT NULL COMMENT '部门',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT='部门';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `bumen`
--
LOCK TABLES `bumen` WRITE;
/*!40000 ALTER TABLE `bumen` DISABLE KEYS */;
INSERT INTO `bumen` VALUES (21,'-04-02 08:46:34','部门1'),(22,'-04-02 08:46:34','部门2'),(23,'-04-02 08:46:34','部门3'),(24,'-04-02 08:46:34','部门4'),(25,'-04-02 08:46:34','部门5'),(26,'-04-02 08:46:34','部门6');
/*!40000 ALTER TABLE `bumen` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `config`
--
DROP TABLE IF EXISTS `config`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(100) NOT NULL COMMENT '配置参数名称',
`value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `config`
--
LOCK TABLES `config` WRITE;
/*!40000 ALTER TABLE `config` DISABLE KEYS */;
INSERT INTO `config` VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `gongzidiaozheng`
--
DROP TABLE IF EXISTS `gongzidiaozheng`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gongzidiaozheng` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`diaozhengyuanyin` varchar(200) DEFAULT NULL COMMENT '调整原因',
`diaozhengedu` int(11) DEFAULT NULL COMMENT '调整额度',
`diaozhengshijian` date DEFAULT NULL COMMENT '调整时间',
`yuangonggonghao` varchar(200) DEFAULT NULL COMMENT '员工工号',
`yuangongxingming` varchar(200) DEFAULT NULL COMMENT '员工姓名',
`bumen` varchar(200) DEFAULT NULL COMMENT '部门',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='工资调整';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `gongzidiaozheng`
--
LOCK TABLES `gongzidiaozheng` WRITE;
/*!40000 ALTER TABLE `gongzidiaozheng` DISABLE KEYS */;
INSERT INTO `gongzidiaozheng` VALUES (41,'-04-02 08:46:34','调整原因1',1,'-04-02','员工工号1','员工姓名1','部门1'),(42,'-04-02 08:46:34','调整原因2',2,'-04-02','员工工号2','员工姓名2','部门2'),(43,'-04-02 08:46:34','调整原因3',3,'-04-02','员工工号3','员工姓名3','部门3'),(44,'-04-02 08:46:34','调整原因4',4,'-04-02','员工工号4','员工姓名4','部门4'),(45,'-04-02 08:46:35','调整原因5',5,'-04-02','员工工号5','员工姓名5','部门5'),(46,'-04-02 08:46:35','调整原因6',6,'-04-02','员工工号6','员工姓名6','部门6');
/*!40000 ALTER TABLE `gongzidiaozheng` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `gudingzichan`
--
DROP TABLE IF EXISTS `gudingzichan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gudingzichan` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`zichanmingcheng` varchar(200) DEFAULT NULL COMMENT '资产名称',
`fengmian` varchar(200) DEFAULT NULL COMMENT '封面',
`zichanleibie` varchar(200) DEFAULT NULL COMMENT '资产类别',
`zichanzhuangtai` varchar(200) DEFAULT NULL COMMENT '资产状态',
`zichanjiazhi` int(11) DEFAULT NULL COMMENT '资产价值',
`fengxianjiti` int(11) DEFAULT NULL COMMENT '风险计提',
`jitiyuanyin` varchar(200) DEFAULT NULL COMMENT '计提原因',
`dengjishijian` date DEFAULT NULL COMMENT '登记时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='固定资产';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `gudingzichan`
--
LOCK TABLES `gudingzichan` WRITE;
/*!40000 ALTER TABLE `gudingzichan` DISABLE KEYS */;
INSERT INTO `gudingzichan` VALUES (61,'-04-02 08:46:35','资产名称1','upload/gudingzichan_fengmian1.jpg','资产类别1','资产状态1',1,1,'计提原因1','-04-02'),(62,'-04-02 08:46:35','资产名称2','upload/gudingzichan_fengmian2.jpg','资产类别2','资产状态2',2,2,'计提原因2','-04-02'),(63,'-04-02 08:46:35','资产名称3','upload/gudingzichan_fengmian3.jpg','资产类别3','资产状态3',3,3,'计提原因3','-04-02'),(64,'-04-02 08:46:35','资产名称4','upload/gudingzichan_fengmian4.jpg','资产类别4','资产状态4',4,4,'计提原因4','-04-02'),(65,'-04-02 08:46:35','资产名称5','upload/gudingzichan_fengmian5.jpg','资产类别5','资产状态5',5,5,'计提原因5','-04-02'),(66,'-04-02 08:46:35','资产名称6','upload/gudingzichan_fengmian6.jpg','资产类别6','资产状态6',6,6,'计提原因6','-04-02');
/*!40000 ALTER TABLE `gudingzichan` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jingyingxinxi`
--
DROP TABLE IF EXISTS `jingyingxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jingyingxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`tongjiyuefen` varchar(200) DEFAULT NULL COMMENT '统计月份',
`yingshoujine` int(11) DEFAULT NULL COMMENT '营收金额',
`yuechanliang` varchar(200) DEFAULT NULL COMMENT '月产量',
`qianyikehu` varchar(200) DEFAULT NULL COMMENT '前一客户',
`qianyibaifenbi` float DEFAULT NULL COMMENT '前一百分比',
`qianerkehu` varchar(200) DEFAULT NULL COMMENT '前二客户',
`qianerbaifenbi` float DEFAULT NULL COMMENT '前二百分比',
`qiansankehu` varchar(200) DEFAULT NULL COMMENT '前三客户',
`qiansanbaifenbi` float DEFAULT NULL COMMENT '前三百分比',
`dengjishijian` date DEFAULT NULL COMMENT '登记时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COMMENT='经营信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jingyingxinxi`
--
LOCK TABLES `jingyingxinxi` WRITE;
/*!40000 ALTER TABLE `jingyingxinxi` DISABLE KEYS */;
INSERT INTO `jingyingxinxi` VALUES (71,'-04-02 08:46:35','1月份',120000,'月产量1','前一客户1',1,'前二客户1',1,'前三客户1',1,'-04-02'),(72,'-04-02 08:46:35','2月份',160541,'月产量2','前一客户2',2,'前二客户2',2,'前三客户2',2,'-04-02'),(73,'-04-02 08:46:35','1月份',3,'月产量3','前一客户3',3,'前二客户3',3,'前三客户3',3,'-04-02'),(74,'-04-02 08:46:35','1月份',4,'月产量4','前一客户4',4,'前二客户4',4,'前三客户4',4,'-04-02'),(75,'-04-02 08:46:35','1月份',5,'月产量5','前一客户5',5,'前二客户5',5,'前三客户5',5,'-04-02'),(76,'-04-02 08:46:35','1月份',6,'月产量6','前一客户6',6,'前二客户6',6,'前三客户6',6,'-04-02');
/*!40000 ALTER TABLE `jingyingxinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `news`
--
DROP TABLE IF EXISTS `news`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`title` varchar(200) NOT NULL COMMENT '标题',
`introduction` longtext COMMENT '简介',
`picture` varchar(200) NOT NULL COMMENT '图片',
`content` longtext NOT NULL COMMENT '内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8 COMMENT='公司公告';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `news`
--
-- Table structure for table `niandulirun`
--
DROP TABLE IF EXISTS `niandulirun`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `niandulirun` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`niandutongji` varchar(200) DEFAULT NULL COMMENT '年度统计',
`zhuyingshouru` float DEFAULT NULL COMMENT '主营收入',
`zhuyingyewuchengben` int(11) DEFAULT NULL COMMENT '主营业务成本',
`zhuyingyewushuijinjifujia` int(11) DEFAULT NULL COMMENT '主营业务税金及附加',
`qitayewulirun` int(11) DEFAULT NULL COMMENT '其他业务利润',
`yingyefeiyong` int(11) DEFAULT NULL COMMENT '营业费用',
`guanlifeiyong` int(11) DEFAULT NULL COMMENT '管理费用',
`caiwufeiyong` int(11) DEFAULT NULL COMMENT '财务费用',
`touzishouyi` int(11) DEFAULT NULL COMMENT '投资收益',
`butieshouyi` int(11) DEFAULT NULL COMMENT '补贴收益',
`yingyewaishouru` int(11) DEFAULT NULL COMMENT '营业外收入',
`yingyewaizhichu` int(11) DEFAULT NULL COMMENT '营业外支出',
`suodeshui` int(11) DEFAULT NULL COMMENT '所得税',
`jinglirun` int(11) DEFAULT NULL COMMENT '净利润',
`dengjishijian` date DEFAULT NULL COMMENT '登记时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8 COMMENT='年度利润';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `niandulirun`
--
LOCK TABLES `niandulirun` WRITE;
/*!40000 ALTER TABLE `niandulirun` DISABLE KEYS */;
INSERT INTO `niandulirun` VALUES (91,'-04-02 08:46:35','年度统计1',1,1,1,1,1,1,1,1,1,1,1,1,1,'-04-02'),(92,'-04-02 08:46:35','年度统计2',2,2,2,2,2,2,2,2,2,2,2,2,2,'-04-02'),(93,'-04-02 08:46:35','年度统计3',3,3,3,3,3,3,3,3,3,3,3,3,3,'-04-02'),(94,'-04-02 08:46:35','年度统计4',4,4,4,4,4,4,4,4,4,4,4,4,4,'-04-02'),(95,'-04-02 08:46:35','年度统计5',5,5,5,5,5,5,5,5,5,5,5,5,5,'-04-02'),(96,'-04-02 08:46:35','年度统计6',6,6,6,6,6,6,6,6,6,6,6,6,6,'-04-02');
/*!40000 ALTER TABLE `niandulirun` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `token`
--
DROP TABLE IF EXISTS `token`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `token` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`username` varchar(100) NOT NULL COMMENT '用户名',
`tablename` varchar(100) DEFAULT NULL COMMENT '表名',
`role` varchar(100) DEFAULT NULL COMMENT '角色',
`token` varchar(200) NOT NULL COMMENT '密码',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
`expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='token表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `token`
--
LOCK TABLES `token` WRITE;
/*!40000 ALTER TABLE `token` DISABLE KEYS */;
INSERT INTO `token` VALUES (1,1,'abo','users','管理员','j82vd2408u2pnor43fgfcv0pwxxnsf7f','-04-02 08:48:22','-04-02 09:48:22');
/*!40000 ALTER TABLE `token` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`username` varchar(100) NOT NULL COMMENT '用户名',
`password` varchar(100) NOT NULL COMMENT '密码',
`role` varchar(100) DEFAULT '管理员' COMMENT '角色',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'abo','abo','管理员','-04-02 08:46:35');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xushizhang`
--
DROP TABLE IF EXISTS `xushizhang`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xushizhang` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`pingzhengdanhao` varchar(200) DEFAULT NULL COMMENT '凭证单号',
`fapiao` varchar(200) DEFAULT NULL COMMENT '发票',
`shouzhileixing` varchar(200) DEFAULT NULL COMMENT '收支类型',
`zhaiyao` varchar(200) DEFAULT NULL COMMENT '摘要',
`duifangkemu` varchar(200) DEFAULT NULL COMMENT '对方科目',
`jine` float DEFAULT NULL COMMENT '金额',
`dengjishijian` date DEFAULT NULL COMMENT '登记时间',
PRIMARY KEY (`id`),
UNIQUE KEY `pingzhengdanhao` (`pingzhengdanhao`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8 COMMENT='序时账';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xushizhang`
--
LOCK TABLES `xushizhang` WRITE;
/*!40000 ALTER TABLE `xushizhang` DISABLE KEYS */;
INSERT INTO `xushizhang` VALUES (81,'-04-02 08:46:35','1111111111','upload/xushizhang_fapiao1.jpg','收入','摘要1','对方科目1',1,'-04-02'),(82,'-04-02 08:46:35','2222222222','upload/xushizhang_fapiao2.jpg','收入','摘要2','对方科目2',2,'-04-02'),(83,'-04-02 08:46:35','3333333333','upload/xushizhang_fapiao3.jpg','收入','摘要3','对方科目3',3,'-04-02'),(84,'-04-02 08:46:35','4444444444','upload/xushizhang_fapiao4.jpg','收入','摘要4','对方科目4',4,'-04-02'),(85,'-04-02 08:46:35','5555555555','upload/xushizhang_fapiao5.jpg','收入','摘要5','对方科目5',5,'-04-02'),(86,'-04-02 08:46:35','6666666666','upload/xushizhang_fapiao6.jpg','收入','摘要6','对方科目6',6,'-04-02');
/*!40000 ALTER TABLE `xushizhang` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `yuangong`
--
DROP TABLE IF EXISTS `yuangong`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yuangong` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`yuangonggonghao` varchar(200) DEFAULT NULL COMMENT '员工工号',
`mima` varchar(200) NOT NULL COMMENT '密码',
`yuangongxingming` varchar(200) DEFAULT NULL COMMENT '员工姓名',
`zhaopian` varchar(200) DEFAULT NULL COMMENT '照片',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`bumen` varchar(200) DEFAULT NULL COMMENT '部门',
`zhiwei` varchar(200) DEFAULT NULL COMMENT '职位',
`lianxifangshi` varchar(200) DEFAULT NULL COMMENT '联系方式',
`ruzhishijian` date DEFAULT NULL COMMENT '入职时间',
PRIMARY KEY (`id`),
UNIQUE KEY `yuangonggonghao` (`yuangonggonghao`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='员工';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `yuangong`
--
LOCK TABLES `yuangong` WRITE;
/*!40000 ALTER TABLE `yuangong` DISABLE KEYS */;
INSERT INTO `yuangong` VALUES (11,'-04-02 08:46:34','员工工号1','123456','员工姓名1','upload/yuangong_zhaopian1.jpg','男','部门1','职位1','13823888881','-04-02'),(12,'-04-02 08:46:34','员工工号2','123456','员工姓名2','upload/yuangong_zhaopian2.jpg','男','部门2','职位2','13823888882','-04-02'),(13,'-04-02 08:46:34','员工工号3','123456','员工姓名3','upload/yuangong_zhaopian3.jpg','男','部门3','职位3','13823888883','-04-02'),(14,'-04-02 08:46:34','员工工号4','123456','员工姓名4','upload/yuangong_zhaopian4.jpg','男','部门4','职位4','13823888884','-04-02'),(15,'-04-02 08:46:34','员工工号5','123456','员工姓名5','upload/yuangong_zhaopian5.jpg','男','部门5','职位5','13823888885','-04-02'),(16,'-04-02 08:46:34','员工工号6','123456','员工姓名6','upload/yuangong_zhaopian6.jpg','男','部门6','职位6','13823888886','-04-02');
/*!40000 ALTER TABLE `yuangong` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `yuangonggongzi`
--
DROP TABLE IF EXISTS `yuangonggongzi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yuangonggongzi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`gongziyuefen` varchar(200) DEFAULT NULL COMMENT '工资月份',
`yuangonggonghao` varchar(200) DEFAULT NULL COMMENT '员工工号',
`yuangongxingming` varchar(200) DEFAULT NULL COMMENT '员工姓名',
`bumen` varchar(200) DEFAULT NULL COMMENT '部门',
`jibengongzi` int(11) DEFAULT NULL COMMENT '基本工资',
`gonglingbutie` int(11) DEFAULT NULL COMMENT '工龄补贴',
`jiabangongzi` int(11) DEFAULT NULL COMMENT '加班工资',
`jiangli` int(11) DEFAULT NULL COMMENT '奖励',
`fakuan` int(11) DEFAULT NULL COMMENT '罚款',
`geshui` int(11) NOT NULL COMMENT '个税',
`shebaodaijiao` int(11) DEFAULT NULL COMMENT '社保代缴',
`jiangchengshuoming` varchar(200) DEFAULT NULL COMMENT '奖惩说明',
`shifagongzi` float DEFAULT NULL COMMENT '实发工资',
`dengjishijian` date DEFAULT NULL COMMENT '登记时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='员工工资';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `yuangonggongzi`
--
LOCK TABLES `yuangonggongzi` WRITE;
/*!40000 ALTER TABLE `yuangonggongzi` DISABLE KEYS */;
INSERT INTO `yuangonggongzi` VALUES (31,'-04-02 08:46:34','1月份','员工工号1','员工姓名1','部门1',1,1,1,1,1,1,1,'奖惩说明1',1,'-04-02'),(32,'-04-02 08:46:34','1月份','员工工号2','员工姓名2','部门2',2,2,2,2,2,2,2,'奖惩说明2',2,'-04-02'),(33,'-04-02 08:46:34','1月份','员工工号3','员工姓名3','部门3',3,3,3,3,3,3,3,'奖惩说明3',3,'-04-02'),(34,'-04-02 08:46:34','1月份','员工工号4','员工姓名4','部门4',4,4,4,4,4,4,4,'奖惩说明4',4,'-04-02'),(35,'-04-02 08:46:34','1月份','员工工号5','员工姓名5','部门5',5,5,5,5,5,5,5,'奖惩说明5',5,'-04-02'),(36,'-04-02 08:46:34','1月份','员工工号6','员工姓名6','部门6',6,6,6,6,6,6,6,'奖惩说明6',6,'-04-02');
/*!40000 ALTER TABLE `yuangonggongzi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `zichanleibie`
--
DROP TABLE IF EXISTS `zichanleibie`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `zichanleibie` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`zichanleibie` varchar(200) DEFAULT NULL COMMENT '资产类别',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='资产类别';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `zichanleibie`
--
LOCK TABLES `zichanleibie` WRITE;
/*!40000 ALTER TABLE `zichanleibie` DISABLE KEYS */;
INSERT INTO `zichanleibie` VALUES (51,'-04-02 08:46:35','资产类别1'),(52,'-04-02 08:46:35','资产类别2'),(53,'-04-02 08:46:35','资产类别3'),(54,'-04-02 08:46:35','资产类别4'),(55,'-04-02 08:46:35','资产类别5'),(56,'-04-02 08:46:35','资产类别6');
/*!40000 ALTER TABLE `zichanleibie` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on -04-02 20:16:07
