Springboot+vue的应急救援物资管理系统，Javaee项目，springboot vue前后端分离项目

/* Navicat MySQL Data Transfer Source Server : localhost_3306 Source Server Version : 80031 Source Host : localhost:3306 Source Database : springbootxnj6l Target Server Type : MYSQL Target Server Version : 80031 File Encoding : 65001 Date: 2023-10-01 17:15:32 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for config -- ---------------------------- DROP TABLE IF EXISTS `config`; CREATE TABLE `config` ( `id` bigint 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=utf8mb3 COMMENT='配置文件'; -- ---------------------------- -- Records of config -- ---------------------------- INSERT INTO `config` VALUES ('1', 'picture1', 'upload/picture1.jpg'); INSERT INTO `config` VALUES ('2', 'picture2', 'upload/picture2.jpg'); INSERT INTO `config` VALUES ('3', 'picture3', 'upload/picture3.jpg'); -- ---------------------------- -- Table structure for gonggaoxinxi -- ---------------------------- DROP TABLE IF EXISTS `gonggaoxinxi`; CREATE TABLE `gonggaoxinxi` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `gonggaobiaoti` varchar(200) NOT NULL COMMENT '公告标题', `gonggaoleixing` varchar(200) NOT NULL COMMENT '公告类型', `gonggaotupian` varchar(200) DEFAULT NULL COMMENT '公告图片', `gonggaoneirong` longtext COMMENT '公告内容', `faburiqi` date DEFAULT NULL COMMENT '发布日期', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb3 COMMENT='公告信息'; -- ---------------------------- -- Records of gonggaoxinxi -- ---------------------------- INSERT INTO `gonggaoxinxi` VALUES ('11', '2023-05-06 21:09:16', '公告标题1', '资讯', 'upload/gonggaoxinxi_gonggaotupian1.jpg', '公告内容1', '2023-05-06'); INSERT INTO `gonggaoxinxi` VALUES ('12', '2023-05-06 21:09:16', '公告标题2', '资讯', 'upload/gonggaoxinxi_gonggaotupian2.jpg', '公告内容2', '2023-05-06'); INSERT INTO `gonggaoxinxi` VALUES ('13', '2023-05-06 21:09:16', '公告标题3', '资讯', 'upload/gonggaoxinxi_gonggaotupian3.jpg', '公告内容3', '2023-05-06'); INSERT INTO `gonggaoxinxi` VALUES ('14', '2023-05-06 21:09:16', '公告标题4', '资讯', 'upload/gonggaoxinxi_gonggaotupian4.jpg', '公告内容4', '2023-05-06'); INSERT INTO `gonggaoxinxi` VALUES ('15', '2023-05-06 21:09:16', '公告标题5', '资讯', 'upload/gonggaoxinxi_gonggaotupian5.jpg', '公告内容5', '2023-05-06'); INSERT INTO `gonggaoxinxi` VALUES ('16', '2023-05-06 21:09:16', '公告标题6', '资讯', 'upload/gonggaoxinxi_gonggaotupian6.jpg', '公告内容6', '2023-05-06'); -- ---------------------------- -- Table structure for token -- ---------------------------- DROP TABLE IF EXISTS `token`; CREATE TABLE `token` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `userid` bigint 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=3 DEFAULT CHARSET=utf8mb3 COMMENT='token表'; -- ---------------------------- -- Records of token -- ---------------------------- INSERT INTO `token` VALUES ('1', '1', 'admin', 'users', '管理员', 'h0bzdprwkg3irwws3cdyhcgdt2ylvxya', '2023-10-01 17:05:34', '2023-10-01 18:09:55'); INSERT INTO `token` VALUES ('2', '21', '用户名1', 'yonghu', '用户', '2ai2pae2qzxpax7vfzh4j254wtvmb6yu', '2023-10-01 17:07:29', '2023-10-01 18:12:12'); -- ---------------------------- -- Table structure for users -- ---------------------------- DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `id` bigint 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=utf8mb3 COMMENT='用户表'; -- ---------------------------- -- Records of users -- ---------------------------- INSERT INTO `users` VALUES ('1', 'admin', 'admin', '管理员', '2023-05-06 21:09:17'); -- ---------------------------- -- Table structure for wuzichuku -- ---------------------------- DROP TABLE IF EXISTS `wuzichuku`; CREATE TABLE `wuzichuku` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `chukubianhao` varchar(200) DEFAULT NULL COMMENT '出库编号', `wuzimingcheng` varchar(200) DEFAULT NULL COMMENT '物资名称', `wuzifenlei` varchar(200) DEFAULT NULL COMMENT '物资分类', `wuzitupian` varchar(200) DEFAULT NULL COMMENT '物资图片', `wuzishuliang` int NOT NULL COMMENT '物资数量', `chukuriqi` date DEFAULT NULL COMMENT '出库日期', `chukuleixing` varchar(200) DEFAULT NULL COMMENT '出库类型', `chukubeizhu` longtext COMMENT '出库备注', `yonghuming` varchar(200) NOT NULL COMMENT '用户名', `xingming` varchar(200) DEFAULT NULL COMMENT '姓名', `shouji` varchar(200) DEFAULT NULL COMMENT '手机', PRIMARY KEY (`id`), UNIQUE KEY `chukubianhao` (`chukubianhao`) ) ENGINE=InnoDB AUTO_INCREMENT=1696151199111 DEFAULT CHARSET=utf8mb3 COMMENT='物资出库'; -- ---------------------------- -- Records of wuzichuku -- ---------------------------- INSERT INTO `wuzichuku` VALUES ('61', '2023-05-06 21:09:17', '1111111111', '物资名称1', '物资分类1', 'upload/wuzichuku_wuzitupian1.jpg', '1', '2023-05-06', '出库类型1', '出库备注1', '用户名1', '姓名1', '13823888881'); INSERT INTO `wuzichuku` VALUES ('62', '2023-05-06 21:09:17', '2222222222', '物资名称2', '物资分类2', 'upload/wuzichuku_wuzitupian2.jpg', '2', '2023-05-06', '出库类型2', '出库备注2', '用户名2', '姓名2', '13823888882'); INSERT INTO `wuzichuku` VALUES ('63', '2023-05-06 21:09:17', '3333333333', '物资名称3', '物资分类3', 'upload/wuzichuku_wuzitupian3.jpg', '3', '2023-05-06', '出库类型3', '出库备注3', '用户名3', '姓名3', '13823888883'); INSERT INTO `wuzichuku` VALUES ('64', '2023-05-06 21:09:17', '4444444444', '物资名称4', '物资分类4', 'upload/wuzichuku_wuzitupian4.jpg', '4', '2023-05-06', '出库类型4', '出库备注4', '用户名4', '姓名4', '13823888884'); INSERT INTO `wuzichuku` VALUES ('65', '2023-05-06 21:09:17', '5555555555', '物资名称5', '物资分类5', 'upload/wuzichuku_wuzitupian5.jpg', '5', '2023-05-06', '出库类型5', '出库备注5', '用户名5', '姓名5', '13823888885'); INSERT INTO `wuzichuku` VALUES ('66', '2023-05-06 21:09:17', '6666666666', '物资名称6', '物资分类6', 'upload/wuzichuku_wuzitupian6.jpg', '6', '2023-05-06', '出库类型6', '出库备注6', '用户名6', '姓名6', '13823888886'); INSERT INTO `wuzichuku` VALUES ('1696151199110', '2023-10-01 17:06:38', '1696151178381', '物资名称1', '物资分类1', 'upload/wuzixinxi_wuzitupian1.jpg', '1', '2023-10-01', '刚需', '', '用户名1', '姓名1', '13823888881'); -- ---------------------------- -- Table structure for wuziruku -- ---------------------------- DROP TABLE IF EXISTS `wuziruku`; CREATE TABLE `wuziruku` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时�