摘 ?要
隨著信息技術(shù)和網(wǎng)絡(luò)技術(shù)的飛速發(fā)展，人類已進入全新信息化時代，傳統(tǒng)管理技術(shù)已無法高效，便捷地管理信息。為了迎合時代需求，優(yōu)化管理效率，各種各樣的管理系統(tǒng)應(yīng)運而生，各行各業(yè)相繼進入信息管理時代，財務(wù)管理系統(tǒng)就是信息時代變革中的產(chǎn)物之一。
任何系統(tǒng)都要遵循系統(tǒng)設(shè)計的基本流程，本系統(tǒng)也不例外，同樣需要經(jīng)過市場調(diào)研，需求分析，概要設(shè)計，詳細設(shè)計，編碼，測試這些步驟，基于java技術(shù)、springboot框架、B/S機構(gòu)、Mysql數(shù)據(jù)庫設(shè)計并實現(xiàn)了財務(wù)管理系統(tǒng)。系統(tǒng)主要包括首頁，個人中心，員工管理，部門管理，員工工資管理，工資調(diào)整管理，資產(chǎn)類別管理，固定資產(chǎn)管理，經(jīng)營信息管理，序時賬管理，年度利潤管理，系統(tǒng)管理等功能模塊。
本文首先介紹了財務(wù)管理技術(shù)的發(fā)展背景與發(fā)展現(xiàn)狀，然后遵循軟件常規(guī)開發(fā)流程，首先針對系統(tǒng)選取適用的語言和開發(fā)平臺，根據(jù)需求分析制定模塊并設(shè)計數(shù)據(jù)庫結(jié)構(gòu)，再根據(jù)系統(tǒng)總體功能模塊的設(shè)計繪制系統(tǒng)的功能模塊圖，流程圖以及E-R圖。然后，設(shè)計框架并根據(jù)設(shè)計的框架編寫代碼以實現(xiàn)系統(tǒng)的各個功能模塊。最后，對初步完成的系統(tǒng)進行測試，主要是功能測試、單元測試和性能測試。測試結(jié)果表明，該系統(tǒng)能夠?qū)崿F(xiàn)所需的功能，運行狀況尚可并無明顯缺點。

關(guān)鍵字：財務(wù)管理；springboot；Mysql數(shù)據(jù)庫

?
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開發(fā)意義?? ?1
1.3 研究現(xiàn)狀?? ?1
1.4 研究內(nèi)容?? ?2
第二章 開發(fā)技術(shù)介紹?? ?3
2.1 系統(tǒng)開發(fā)平臺?? ?3
2.2 平臺開發(fā)相關(guān)技術(shù)?? ?3
2.2.1 ?Javar技術(shù)?? ?3
2.2.2 ?Mysql數(shù)據(jù)庫介紹?? ?3
2.2.3 ?Mysql環(huán)境配置?? ?3
2.2.4 ?B/S架構(gòu)?? ?4
2.2.5 ?Springboot框架?? ?4
第三章 系統(tǒng)分析?? ?5
3.1 可行性分析?? ?5
3.1.1技術(shù)可行性?? ?5
3.1.2操作可行性?? ?5
3.1.3經(jīng)濟可行性?? ?5
3.2性能需求分析?? ?5
第四章 系統(tǒng)設(shè)計?? ?7
4.1功能結(jié)構(gòu)?? ?7
4.2 數(shù)據(jù)庫設(shè)計?? ?7
4.2.1 數(shù)據(jù)庫E/R圖?? ?7
4.2.2 數(shù)據(jù)庫表?? ?8
第五章 系統(tǒng)功能實現(xiàn)?? ?15
5.1管理員功能模塊?? ?15
5.2員工功能模塊?? ?20
第六章 系統(tǒng)測試?? ?22
第七章 總結(jié)與心得體會?? ?23
7.1總結(jié)?? ?23
7.2心得體會?? ?23
致 ?謝?? ?24
參考文獻?? ?25

數(shù)據(jù)庫：

-- 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 '創(chuàng)建時間',
? `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,'2022-04-02 08:46:34','部門1'),(22,'2022-04-02 08:46:34','部門2'),(23,'2022-04-02 08:46:34','部門3'),(24,'2022-04-02 08:46:34','部門4'),(25,'2022-04-02 08:46:34','部門5'),(26,'2022-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 '配置參數(shù)名稱',
? `value` varchar(100) DEFAULT NULL COMMENT '配置參數(shù)值',
? 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 '創(chuàng)建時間',
? `diaozhengyuanyin` varchar(200) DEFAULT NULL COMMENT '調(diào)整原因',
? `diaozhengedu` int(11) DEFAULT NULL COMMENT '調(diào)整額度',
? `diaozhengshijian` date DEFAULT NULL COMMENT '調(diào)整時間',
? `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='工資調(diào)整';
/*!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,'2022-04-02 08:46:34','調(diào)整原因1',1,'2022-04-02','員工工號1','員工姓名1','部門1'),(42,'2022-04-02 08:46:34','調(diào)整原因2',2,'2022-04-02','員工工號2','員工姓名2','部門2'),(43,'2022-04-02 08:46:34','調(diào)整原因3',3,'2022-04-02','員工工號3','員工姓名3','部門3'),(44,'2022-04-02 08:46:34','調(diào)整原因4',4,'2022-04-02','員工工號4','員工姓名4','部門4'),(45,'2022-04-02 08:46:35','調(diào)整原因5',5,'2022-04-02','員工工號5','員工姓名5','部門5'),(46,'2022-04-02 08:46:35','調(diào)整原因6',6,'2022-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 '創(chuàng)建時間',
? `zichanmingcheng` varchar(200) DEFAULT NULL COMMENT '資產(chǎn)名稱',
? `fengmian` varchar(200) DEFAULT NULL COMMENT '封面',
? `zichanleibie` varchar(200) DEFAULT NULL COMMENT '資產(chǎn)類別',
? `zichanzhuangtai` varchar(200) DEFAULT NULL COMMENT '資產(chǎn)狀態(tài)',
? `zichanjiazhi` int(11) DEFAULT NULL COMMENT '資產(chǎn)價值',
? `fengxianjiti` int(11) DEFAULT NULL COMMENT '風(fēng)險計提',
? `jitiyuanyin` varchar(200) DEFAULT NULL COMMENT '計提原因',
? `dengjishijian` date DEFAULT NULL COMMENT '登記時間',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='固定資產(chǎn)';
/*!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,'2022-04-02 08:46:35','資產(chǎn)名稱1','upload/gudingzichan_fengmian1.jpg','資產(chǎn)類別1','資產(chǎn)狀態(tài)1',1,1,'計提原因1','2022-04-02'),(62,'2022-04-02 08:46:35','資產(chǎn)名稱2','upload/gudingzichan_fengmian2.jpg','資產(chǎn)類別2','資產(chǎn)狀態(tài)2',2,2,'計提原因2','2022-04-02'),(63,'2022-04-02 08:46:35','資產(chǎn)名稱3','upload/gudingzichan_fengmian3.jpg','資產(chǎn)類別3','資產(chǎn)狀態(tài)3',3,3,'計提原因3','2022-04-02'),(64,'2022-04-02 08:46:35','資產(chǎn)名稱4','upload/gudingzichan_fengmian4.jpg','資產(chǎn)類別4','資產(chǎn)狀態(tài)4',4,4,'計提原因4','2022-04-02'),(65,'2022-04-02 08:46:35','資產(chǎn)名稱5','upload/gudingzichan_fengmian5.jpg','資產(chǎn)類別5','資產(chǎn)狀態(tài)5',5,5,'計提原因5','2022-04-02'),(66,'2022-04-02 08:46:35','資產(chǎn)名稱6','upload/gudingzichan_fengmian6.jpg','資產(chǎn)類別6','資產(chǎn)狀態(tài)6',6,6,'計提原因6','2022-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 '創(chuàng)建時間',
? `tongjiyuefen` varchar(200) DEFAULT NULL COMMENT '統(tǒng)計月份',
? `yingshoujine` int(11) DEFAULT NULL COMMENT '營收金額',
? `yuechanliang` varchar(200) DEFAULT NULL COMMENT '月產(chǎn)量',
? `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='經(jīng)營信息';
/*!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,'2022-04-02 08:46:35','1月份',120000,'月產(chǎn)量1','前一客戶1',1,'前二客戶1',1,'前三客戶1',1,'2022-04-02'),(72,'2022-04-02 08:46:35','2月份',160541,'月產(chǎn)量2','前一客戶2',2,'前二客戶2',2,'前三客戶2',2,'2022-04-02'),(73,'2022-04-02 08:46:35','1月份',3,'月產(chǎn)量3','前一客戶3',3,'前二客戶3',3,'前三客戶3',3,'2022-04-02'),(74,'2022-04-02 08:46:35','1月份',4,'月產(chǎn)量4','前一客戶4',4,'前二客戶4',4,'前三客戶4',4,'2022-04-02'),(75,'2022-04-02 08:46:35','1月份',5,'月產(chǎn)量5','前一客戶5',5,'前二客戶5',5,'前三客戶5',5,'2022-04-02'),(76,'2022-04-02 08:46:35','1月份',6,'月產(chǎn)量6','前一客戶6',6,'前二客戶6',6,'前三客戶6',6,'2022-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 '創(chuàng)建時間',
? `title` varchar(200) NOT NULL COMMENT '標題',
? `introduction` longtext COMMENT '簡介',
? `picture` varchar(200) NOT NULL COMMENT '圖片',
? `content` longtext NOT NULL COMMENT '內(nèi)容',
? 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 '創(chuàng)建時間',
? `niandutongji` varchar(200) DEFAULT NULL COMMENT '年度統(tǒng)計',
? `zhuyingshouru` float DEFAULT NULL COMMENT '主營收入',
? `zhuyingyewuchengben` int(11) DEFAULT NULL COMMENT '主營業(yè)務(wù)成本',
? `zhuyingyewushuijinjifujia` int(11) DEFAULT NULL COMMENT '主營業(yè)務(wù)稅金及附加',
? `qitayewulirun` int(11) DEFAULT NULL COMMENT '其他業(yè)務(wù)利潤',
? `yingyefeiyong` int(11) DEFAULT NULL COMMENT '營業(yè)費用',
? `guanlifeiyong` int(11) DEFAULT NULL COMMENT '管理費用',
? `caiwufeiyong` int(11) DEFAULT NULL COMMENT '財務(wù)費用',
? `touzishouyi` int(11) DEFAULT NULL COMMENT '投資收益',
? `butieshouyi` int(11) DEFAULT NULL COMMENT '補貼收益',
? `yingyewaishouru` int(11) DEFAULT NULL COMMENT '營業(yè)外收入',
? `yingyewaizhichu` int(11) DEFAULT NULL COMMENT '營業(yè)外支出',
? `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,'2022-04-02 08:46:35','年度統(tǒng)計1',1,1,1,1,1,1,1,1,1,1,1,1,1,'2022-04-02'),(92,'2022-04-02 08:46:35','年度統(tǒng)計2',2,2,2,2,2,2,2,2,2,2,2,2,2,'2022-04-02'),(93,'2022-04-02 08:46:35','年度統(tǒng)計3',3,3,3,3,3,3,3,3,3,3,3,3,3,'2022-04-02'),(94,'2022-04-02 08:46:35','年度統(tǒng)計4',4,4,4,4,4,4,4,4,4,4,4,4,4,'2022-04-02'),(95,'2022-04-02 08:46:35','年度統(tǒng)計5',5,5,5,5,5,5,5,5,5,5,5,5,5,'2022-04-02'),(96,'2022-04-02 08:46:35','年度統(tǒng)計6',6,6,6,6,6,6,6,6,6,6,6,6,6,'2022-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','2022-04-02 08:48:22','2022-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','管理員','2022-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 '創(chuàng)建時間',
? `pingzhengdanhao` varchar(200) DEFAULT NULL COMMENT '憑證單號',
? `fapiao` varchar(200) DEFAULT NULL COMMENT '發(fā)票',
? `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,'2022-04-02 08:46:35','1111111111','upload/xushizhang_fapiao1.jpg','收入','摘要1','對方科目1',1,'2022-04-02'),(82,'2022-04-02 08:46:35','2222222222','upload/xushizhang_fapiao2.jpg','收入','摘要2','對方科目2',2,'2022-04-02'),(83,'2022-04-02 08:46:35','3333333333','upload/xushizhang_fapiao3.jpg','收入','摘要3','對方科目3',3,'2022-04-02'),(84,'2022-04-02 08:46:35','4444444444','upload/xushizhang_fapiao4.jpg','收入','摘要4','對方科目4',4,'2022-04-02'),(85,'2022-04-02 08:46:35','5555555555','upload/xushizhang_fapiao5.jpg','收入','摘要5','對方科目5',5,'2022-04-02'),(86,'2022-04-02 08:46:35','6666666666','upload/xushizhang_fapiao6.jpg','收入','摘要6','對方科目6',6,'2022-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 '創(chuàng)建時間',
? `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 '聯(lián)系方式',
? `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,'2022-04-02 08:46:34','員工工號1','123456','員工姓名1','upload/yuangong_zhaopian1.jpg','男','部門1','職位1','13823888881','2022-04-02'),(12,'2022-04-02 08:46:34','員工工號2','123456','員工姓名2','upload/yuangong_zhaopian2.jpg','男','部門2','職位2','13823888882','2022-04-02'),(13,'2022-04-02 08:46:34','員工工號3','123456','員工姓名3','upload/yuangong_zhaopian3.jpg','男','部門3','職位3','13823888883','2022-04-02'),(14,'2022-04-02 08:46:34','員工工號4','123456','員工姓名4','upload/yuangong_zhaopian4.jpg','男','部門4','職位4','13823888884','2022-04-02'),(15,'2022-04-02 08:46:34','員工工號5','123456','員工姓名5','upload/yuangong_zhaopian5.jpg','男','部門5','職位5','13823888885','2022-04-02'),(16,'2022-04-02 08:46:34','員工工號6','123456','員工姓名6','upload/yuangong_zhaopian6.jpg','男','部門6','職位6','13823888886','2022-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 '創(chuàng)建時間',
? `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 '實發(fā)工資',
? `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,'2022-04-02 08:46:34','1月份','員工工號1','員工姓名1','部門1',1,1,1,1,1,1,1,'獎懲說明1',1,'2022-04-02'),(32,'2022-04-02 08:46:34','1月份','員工工號2','員工姓名2','部門2',2,2,2,2,2,2,2,'獎懲說明2',2,'2022-04-02'),(33,'2022-04-02 08:46:34','1月份','員工工號3','員工姓名3','部門3',3,3,3,3,3,3,3,'獎懲說明3',3,'2022-04-02'),(34,'2022-04-02 08:46:34','1月份','員工工號4','員工姓名4','部門4',4,4,4,4,4,4,4,'獎懲說明4',4,'2022-04-02'),(35,'2022-04-02 08:46:34','1月份','員工工號5','員工姓名5','部門5',5,5,5,5,5,5,5,'獎懲說明5',5,'2022-04-02'),(36,'2022-04-02 08:46:34','1月份','員工工號6','員工姓名6','部門6',6,6,6,6,6,6,6,'獎懲說明6',6,'2022-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 '創(chuàng)建時間',
? `zichanleibie` varchar(200) DEFAULT NULL COMMENT '資產(chǎn)類別',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='資產(chǎn)類別';
/*!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,'2022-04-02 08:46:35','資產(chǎn)類別1'),(52,'2022-04-02 08:46:35','資產(chǎn)類別2'),(53,'2022-04-02 08:46:35','資產(chǎn)類別3'),(54,'2022-04-02 08:46:35','資產(chǎn)類別4'),(55,'2022-04-02 08:46:35','資產(chǎn)類別5'),(56,'2022-04-02 08:46:35','資產(chǎn)類別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 2022-04-02 20:16:07