基于ssm的演出道具租賃管理系統(tǒng)設(shè)計與實現(xiàn)-計算機畢業(yè)設(shè)計源碼+LW文檔
開發(fā)語言：Java
框架：ssm
JDK版本：JDK1.8
服務(wù)器：tomcat7
數(shù)據(jù)庫：mysql 5.7（一定要5.7版本）
數(shù)據(jù)庫工具：Navicat11
開發(fā)軟件：eclipse/myeclipse/idea
Maven包：Maven3.3.9
瀏覽器：谷歌瀏覽器
數(shù)據(jù)庫腳本：
-- MySQL dump 10.13? Distrib 5.7.31, for Linux (x86_64)
--
-- Host: localhost? ? Database: ssm790m4
-- ------------------------------------------------------
-- 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: `ssm790m4`
--
/*!40000 DROP DATABASE IF EXISTS `ssm790m4`*/;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `ssm790m4` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `ssm790m4`;
--
-- 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 `daojuchuzu`
--
DROP TABLE IF EXISTS `daojuchuzu`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `daojuchuzu` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間',
? `daojumingcheng` varchar(200) NOT NULL COMMENT '道具名稱',
? `daojuleixing` varchar(200) DEFAULT NULL COMMENT '道具類型',
? `tupian` varchar(200) DEFAULT NULL COMMENT '圖片',
? `zulinjiage` int(11) NOT NULL COMMENT '租賃價格',
? `shuliang` int(11) NOT NULL COMMENT '數(shù)量',
? `fabushijian` datetime DEFAULT NULL COMMENT '發(fā)布時間',
? `zhanghao` varchar(200) DEFAULT NULL COMMENT '賬號',
? `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '聯(lián)系電話',
? `youxiang` varchar(200) DEFAULT NULL COMMENT '郵箱',
? `xiangxidizhi` varchar(200) NOT NULL COMMENT '詳細地址',
? `daojuxiangqing` longtext COMMENT '道具詳情',
? `sfsh` varchar(200) DEFAULT '否' COMMENT '是否審核',
? `shhf` longtext 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 `daojuchuzu`
--
LOCK TABLES `daojuchuzu` WRITE;
/*!40000 ALTER TABLE `daojuchuzu` DISABLE KEYS */;
INSERT INTO `daojuchuzu` VALUES (41,'2022-01-20 03:55:50','道具名稱1','道具類型1','upload/daojuchuzu_tupian1.jpg',1,1,'2022-01-20 11:55:50','賬號1','13823888881','773890001@qq.com','詳細地址1','道具詳情1','是',''),(42,'2022-01-20 03:55:50','道具名稱2','道具類型2','upload/daojuchuzu_tupian2.jpg',2,2,'2022-01-20 11:55:50','賬號2','13823888882','773890002@qq.com','詳細地址2','道具詳情2','是',''),(43,'2022-01-20 03:55:50','道具名稱3','道具類型3','upload/daojuchuzu_tupian3.jpg',3,3,'2022-01-20 11:55:50','賬號3','13823888883','773890003@qq.com','詳細地址3','道具詳情3','是',''),(44,'2022-01-20 03:55:50','道具名稱4','道具類型4','upload/daojuchuzu_tupian4.jpg',4,4,'2022-01-20 11:55:50','賬號4','13823888884','773890004@qq.com','詳細地址4','道具詳情4','是',''),(45,'2022-01-20 03:55:50','道具名稱5','道具類型5','upload/daojuchuzu_tupian5.jpg',5,5,'2022-01-20 11:55:50','賬號5','13823888885','773890005@qq.com','詳細地址5','道具詳情5','是',''),(46,'2022-01-20 03:55:50','道具名稱6','道具類型6','upload/daojuchuzu_tupian6.jpg',6,6,'2022-01-20 11:55:50','賬號6','13823888886','773890006@qq.com','詳細地址6','道具詳情6','是','');
/*!40000 ALTER TABLE `daojuchuzu` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `daojuguihai`
--
DROP TABLE IF EXISTS `daojuguihai`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `daojuguihai` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間',
? `dingdanbianhao` varchar(200) DEFAULT NULL COMMENT '訂單編號',
? `daojumingcheng` varchar(200) DEFAULT NULL COMMENT '道具名稱',
? `daojuleixing` varchar(200) DEFAULT NULL COMMENT '道具類型',
? `zhanghao` varchar(200) DEFAULT NULL COMMENT '賬號',
? `yonghuming` varchar(200) DEFAULT NULL COMMENT '用戶名',
? `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
? `shuliang` varchar(200) DEFAULT NULL COMMENT '數(shù)量',
? `zulintianshu` varchar(200) DEFAULT NULL COMMENT '租賃天數(shù)',
? `zulinshijian` varchar(200) DEFAULT NULL COMMENT '租賃時間',
? `guihaishijian` datetime DEFAULT NULL COMMENT '歸還時間',
? `guihaizhengming` longtext COMMENT '歸還證明',
? `crossuserid` bigint(20) DEFAULT NULL COMMENT '跨表用戶id',
? `crossrefid` bigint(20) DEFAULT NULL COMMENT '跨表主鍵id',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COMMENT='道具歸還';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `daojuguihai`
--
LOCK TABLES `daojuguihai` WRITE;
/*!40000 ALTER TABLE `daojuguihai` DISABLE KEYS */;
INSERT INTO `daojuguihai` VALUES (71,'2022-01-20 03:55:50','訂單編號1','道具名稱1','道具類型1','賬號1','用戶名1','姓名1','數(shù)量1','租賃天數(shù)1','租賃時間1','2022-01-20 11:55:50','歸還證明1',1,1),(72,'2022-01-20 03:55:50','訂單編號2','道具名稱2','道具類型2','賬號2','用戶名2','姓名2','數(shù)量2','租賃天數(shù)2','租賃時間2','2022-01-20 11:55:50','歸還證明2',2,2),(73,'2022-01-20 03:55:50','訂單編號3','道具名稱3','道具類型3','賬號3','用戶名3','姓名3','數(shù)量3','租賃天數(shù)3','租賃時間3','2022-01-20 11:55:50','歸還證明3',3,3),(74,'2022-01-20 03:55:50','訂單編號4','道具名稱4','道具類型4','賬號4','用戶名4','姓名4','數(shù)量4','租賃天數(shù)4','租賃時間4','2022-01-20 11:55:50','歸還證明4',4,4),(75,'2022-01-20 03:55:50','訂單編號5','道具名稱5','道具類型5','賬號5','用戶名5','姓名5','數(shù)量5','租賃天數(shù)5','租賃時間5','2022-01-20 11:55:50','歸還證明5',5,5),(76,'2022-01-20 03:55:50','訂單編號6','道具名稱6','道具類型6','賬號6','用戶名6','姓名6','數(shù)量6','租賃天數(shù)6','租賃時間6','2022-01-20 11:55:50','歸還證明6',6,6);
/*!40000 ALTER TABLE `daojuguihai` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `daojuleixing`
--
DROP TABLE IF EXISTS `daojuleixing`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `daojuleixing` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間',
? `daojuleixing` varchar(200) NOT 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 `daojuleixing`
--
LOCK TABLES `daojuleixing` WRITE;
/*!40000 ALTER TABLE `daojuleixing` DISABLE KEYS */;
INSERT INTO `daojuleixing` VALUES (31,'2022-01-20 03:55:50','道具類型1'),(32,'2022-01-20 03:55:50','道具類型2'),(33,'2022-01-20 03:55:50','道具類型3'),(34,'2022-01-20 03:55:50','道具類型4'),(35,'2022-01-20 03:55:50','道具類型5'),(36,'2022-01-20 03:55:50','道具類型6');
/*!40000 ALTER TABLE `daojuleixing` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `discussdaojuchuzu`
--
DROP TABLE IF EXISTS `discussdaojuchuzu`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussdaojuchuzu` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間',
? `refid` bigint(20) NOT NULL COMMENT '關(guān)聯(lián)表id',
? `userid` bigint(20) NOT NULL COMMENT '用戶id',
? `nickname` varchar(200) DEFAULT NULL COMMENT '用戶名',
? `content` longtext NOT NULL COMMENT '評論內(nèi)容',
? `reply` longtext COMMENT '回復內(nèi)容',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8 COMMENT='道具出租評論表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `discussdaojuchuzu`
--
LOCK TABLES `discussdaojuchuzu` WRITE;
/*!40000 ALTER TABLE `discussdaojuchuzu` DISABLE KEYS */;
INSERT INTO `discussdaojuchuzu` VALUES (111,'2022-01-20 03:55:50',1,1,'用戶名1','評論內(nèi)容1','回復內(nèi)容1'),(112,'2022-01-20 03:55:50',2,2,'用戶名2','評論內(nèi)容2','回復內(nèi)容2'),(113,'2022-01-20 03:55:50',3,3,'用戶名3','評論內(nèi)容3','回復內(nèi)容3'),(114,'2022-01-20 03:55:50',4,4,'用戶名4','評論內(nèi)容4','回復內(nèi)容4'),(115,'2022-01-20 03:55:50',5,5,'用戶名5','評論內(nèi)容5','回復內(nèi)容5'),(116,'2022-01-20 03:55:50',6,6,'用戶名6','評論內(nèi)容6','回復內(nèi)容6');
/*!40000 ALTER TABLE `discussdaojuchuzu` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `fahuoxinxi`
--
DROP TABLE IF EXISTS `fahuoxinxi`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fahuoxinxi` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間',
? `dingdanbianhao` varchar(200) DEFAULT NULL COMMENT '訂單編號',
? `daojumingcheng` varchar(200) DEFAULT NULL COMMENT '道具名稱',
? `daojuleixing` varchar(200) DEFAULT NULL COMMENT '道具類型',
? `yonghuming` varchar(200) DEFAULT NULL COMMENT '用戶名',
? `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
? `shouji` varchar(200) DEFAULT NULL COMMENT '手機',
? `wuliuzhuangtai` longtext COMMENT '物流狀態(tài)',
? `zhanghao` varchar(200) DEFAULT NULL COMMENT '賬號',
? `fahuoshijian` datetime DEFAULT NULL COMMENT '發(fā)貨時間',
? `sfsh` varchar(200) DEFAULT '否' COMMENT '是否審核',
? `shhf` longtext COMMENT '審核回復',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='發(fā)貨信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `fahuoxinxi`
--
LOCK TABLES `fahuoxinxi` WRITE;
/*!40000 ALTER TABLE `fahuoxinxi` DISABLE KEYS */;
INSERT INTO `fahuoxinxi` VALUES (61,'2022-01-20 03:55:50','訂單編號1','道具名稱1','道具類型1','用戶名1','姓名1','13823888881','物流狀態(tài)1','賬號1','2022-01-20 11:55:50','是',''),(62,'2022-01-20 03:55:50','訂單編號2','道具名稱2','道具類型2','用戶名2','姓名2','13823888882','物流狀態(tài)2','賬號2','2022-01-20 11:55:50','是',''),(63,'2022-01-20 03:55:50','訂單編號3','道具名稱3','道具類型3','用戶名3','姓名3','13823888883','物流狀態(tài)3','賬號3','2022-01-20 11:55:50','是',''),(64,'2022-01-20 03:55:50','訂單編號4','道具名稱4','道具類型4','用戶名4','姓名4','13823888884','物流狀態(tài)4','賬號4','2022-01-20 11:55:50','是',''),(65,'2022-01-20 03:55:50','訂單編號5','道具名稱5','道具類型5','用戶名5','姓名5','13823888885','物流狀態(tài)5','賬號5','2022-01-20 11:55:50','是',''),(66,'2022-01-20 03:55:50','訂單編號6','道具名稱6','道具類型6','用戶名6','姓名6','13823888886','物流狀態(tài)6','賬號6','2022-01-20 11:55:50','是','');
/*!40000 ALTER TABLE `fahuoxinxi` 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 `shangjia`
--
DROP TABLE IF EXISTS `shangjia`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shangjia` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間',
? `zhanghao` varchar(200) NOT NULL COMMENT '賬號',
? `mima` varchar(200) NOT NULL COMMENT '密碼',
? `shangjiaxingming` varchar(200) DEFAULT NULL COMMENT '商家姓名',
? `xingbie` varchar(200) DEFAULT NULL COMMENT '性別',
? `touxiang` varchar(200) DEFAULT NULL COMMENT '頭像',
? `youxiang` varchar(200) DEFAULT NULL COMMENT '郵箱',
? `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '聯(lián)系電話',
? PRIMARY KEY (`id`),
? UNIQUE KEY `zhanghao` (`zhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT='商家';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `shangjia`
--
LOCK TABLES `shangjia` WRITE;
/*!40000 ALTER TABLE `shangjia` DISABLE KEYS */;
INSERT INTO `shangjia` VALUES (21,'2022-01-20 03:55:50','賬號1','123456','商家姓名1','男','upload/shangjia_touxiang1.jpg','773890001@qq.com','13823888881'),(22,'2022-01-20 03:55:50','賬號2','123456','商家姓名2','男','upload/shangjia_touxiang2.jpg','773890002@qq.com','13823888882'),(23,'2022-01-20 03:55:50','賬號3','123456','商家姓名3','男','upload/shangjia_touxiang3.jpg','773890003@qq.com','13823888883'),(24,'2022-01-20 03:55:50','賬號4','123456','商家姓名4','男','upload/shangjia_touxiang4.jpg','773890004@qq.com','13823888884'),(25,'2022-01-20 03:55:50','賬號5','123456','商家姓名5','男','upload/shangjia_touxiang5.jpg','773890005@qq.com','13823888885'),(26,'2022-01-20 03:55:50','賬號6','123456','商家姓名6','男','upload/shangjia_touxiang6.jpg','773890006@qq.com','13823888886');
/*!40000 ALTER TABLE `shangjia` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `shouhuoxinxi`
--
DROP TABLE IF EXISTS `shouhuoxinxi`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shouhuoxinxi` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間',
? `dingdanbianhao` varchar(200) DEFAULT NULL COMMENT '訂單編號',
? `daojumingcheng` varchar(200) DEFAULT NULL COMMENT '道具名稱',
? `daojuleixing` varchar(200) DEFAULT NULL COMMENT '道具類型',
? `yonghuming` varchar(200) DEFAULT NULL COMMENT '用戶名',
? `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
? `shouji` varchar(200) DEFAULT NULL COMMENT '手機',
? `wuliuzhuangtai` longtext COMMENT '物流狀態(tài)',
? `zhanghao` varchar(200) DEFAULT NULL COMMENT '賬號',
? `fahuoshijian` datetime DEFAULT NULL COMMENT '發(fā)貨時間',
? `sfsh` varchar(200) DEFAULT '否' COMMENT '是否審核',
? `shhf` longtext COMMENT '審核回復',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8 COMMENT='收貨信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `shouhuoxinxi`
--
LOCK TABLES `shouhuoxinxi` WRITE;
/*!40000 ALTER TABLE `shouhuoxinxi` DISABLE KEYS */;
INSERT INTO `shouhuoxinxi` VALUES (81,'2022-01-20 03:55:50','訂單編號1','道具名稱1','道具類型1','用戶名1','姓名1','13823888881','物流狀態(tài)1','賬號1','2022-01-20 11:55:50','是',''),(82,'2022-01-20 03:55:50','訂單編號2','道具名稱2','道具類型2','用戶名2','姓名2','13823888882','物流狀態(tài)2','賬號2','2022-01-20 11:55:50','是',''),(83,'2022-01-20 03:55:50','訂單編號3','道具名稱3','道具類型3','用戶名3','姓名3','13823888883','物流狀態(tài)3','賬號3','2022-01-20 11:55:50','是',''),(84,'2022-01-20 03:55:50','訂單編號4','道具名稱4','道具類型4','用戶名4','姓名4','13823888884','物流狀態(tài)4','賬號4','2022-01-20 11:55:50','是',''),(85,'2022-01-20 03:55:50','訂單編號5','道具名稱5','道具類型5','用戶名5','姓名5','13823888885','物流狀態(tài)5','賬號5','2022-01-20 11:55:50','是',''),(86,'2022-01-20 03:55:50','訂單編號6','道具名稱6','道具類型6','用戶名6','姓名6','13823888886','物流狀態(tài)6','賬號6','2022-01-20 11:55:50','是','');
/*!40000 ALTER TABLE `shouhuoxinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `storeup`
--
DROP TABLE IF EXISTS `storeup`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `storeup` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間',
? `userid` bigint(20) NOT NULL COMMENT '用戶id',
? `refid` bigint(20) DEFAULT NULL COMMENT '收藏id',
? `tablename` varchar(200) DEFAULT NULL COMMENT '表名',
? `name` varchar(200) NOT NULL COMMENT '收藏名稱',
? `picture` varchar(200) NOT NULL COMMENT '收藏圖片',
? `type` varchar(200) DEFAULT '1' COMMENT '類型(1:收藏,21:贊,22:踩)',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='收藏表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `storeup`
--
LOCK TABLES `storeup` WRITE;
/*!40000 ALTER TABLE `storeup` DISABLE KEYS */;
/*!40000 ALTER TABLE `storeup` 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','管理員','cqs1k9s14hdztakhkbjddz6i1tqpmv3a','2022-01-20 03:57:12','2022-01-20 04:57:15');
/*!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-01-20 03:55:50');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `yonghu`
--
DROP TABLE IF EXISTS `yonghu`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yonghu` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間',
? `yonghuming` varchar(200) NOT NULL COMMENT '用戶名',
? `mima` varchar(200) NOT NULL COMMENT '密碼',
? `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
? `xingbie` varchar(200) DEFAULT NULL COMMENT '性別',
? `touxiang` varchar(200) DEFAULT NULL COMMENT '頭像',
? `youxiang` varchar(200) DEFAULT NULL COMMENT '郵箱',
? `shouji` varchar(200) DEFAULT NULL COMMENT '手機',
? PRIMARY KEY (`id`),
? UNIQUE KEY `yonghuming` (`yonghuming`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='用戶';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `yonghu`
--
LOCK TABLES `yonghu` WRITE;
/*!40000 ALTER TABLE `yonghu` DISABLE KEYS */;
INSERT INTO `yonghu` VALUES (11,'2022-01-20 03:55:50','用戶名1','123456','姓名1','男','upload/yonghu_touxiang1.jpg','773890001@qq.com','13823888881'),(12,'2022-01-20 03:55:50','用戶名2','123456','姓名2','男','upload/yonghu_touxiang2.jpg','773890002@qq.com','13823888882'),(13,'2022-01-20 03:55:50','用戶名3','123456','姓名3','男','upload/yonghu_touxiang3.jpg','773890003@qq.com','13823888883'),(14,'2022-01-20 03:55:50','用戶名4','123456','姓名4','男','upload/yonghu_touxiang4.jpg','773890004@qq.com','13823888884'),(15,'2022-01-20 03:55:50','用戶名5','123456','姓名5','男','upload/yonghu_touxiang5.jpg','773890005@qq.com','13823888885'),(16,'2022-01-20 03:55:50','用戶名6','123456','姓名6','男','upload/yonghu_touxiang6.jpg','773890006@qq.com','13823888886');
/*!40000 ALTER TABLE `yonghu` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `zulindingdan`
--
DROP TABLE IF EXISTS `zulindingdan`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `zulindingdan` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間',
? `dingdanbianhao` varchar(200) DEFAULT NULL COMMENT '訂單編號',
? `daojumingcheng` varchar(200) NOT NULL COMMENT '道具名稱',
? `daojuleixing` varchar(200) NOT NULL COMMENT '道具類型',
? `zhanghao` varchar(200) DEFAULT NULL COMMENT '賬號',
? `zulinjiage` int(11) NOT NULL COMMENT '租賃價格',
? `shuliang` int(11) NOT NULL COMMENT '數(shù)量',
? `zulintianshu` int(11) NOT NULL COMMENT '租賃天數(shù)',
? `zongjiage` int(11) DEFAULT NULL COMMENT '總價格',
? `zulinshijian` datetime DEFAULT NULL COMMENT '租賃時間',
? `yonghuming` varchar(200) DEFAULT NULL COMMENT '用戶名',
? `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
? `shouji` varchar(200) DEFAULT NULL COMMENT '手機',
? `dizhi` varchar(200) NOT NULL COMMENT '地址',
? `ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
? PRIMARY KEY (`id`),
? UNIQUE KEY `dingdanbianhao` (`dingdanbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='租賃訂單';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `zulindingdan`
--
LOCK TABLES `zulindingdan` WRITE;
/*!40000 ALTER TABLE `zulindingdan` DISABLE KEYS */;
INSERT INTO `zulindingdan` VALUES (51,'2022-01-20 03:55:50','1111111111','道具名稱1','道具類型1','賬號1',1,1,1,1,'2022-01-20 11:55:50','用戶名1','姓名1','13823888881','地址1','未支付'),(52,'2022-01-20 03:55:50','2222222222','道具名稱2','道具類型2','賬號2',2,2,2,2,'2022-01-20 11:55:50','用戶名2','姓名2','13823888882','地址2','未支付'),(53,'2022-01-20 03:55:50','3333333333','道具名稱3','道具類型3','賬號3',3,3,3,3,'2022-01-20 11:55:50','用戶名3','姓名3','13823888883','地址3','未支付'),(54,'2022-01-20 03:55:50','4444444444','道具名稱4','道具類型4','賬號4',4,4,4,4,'2022-01-20 11:55:50','用戶名4','姓名4','13823888884','地址4','未支付'),(55,'2022-01-20 03:55:50','5555555555','道具名稱5','道具類型5','賬號5',5,5,5,5,'2022-01-20 11:55:50','用戶名5','姓名5','13823888885','地址5','未支付'),(56,'2022-01-20 03:55:50','6666666666','道具名稱6','道具類型6','賬號6',6,6,6,6,'2022-01-20 11:55:50','用戶名6','姓名6','13823888886','地址6','未支付');
/*!40000 ALTER TABLE `zulindingdan` 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-01-20 17:34:26
