基于ssm的演出道具租赁管理系统设计与实现-计算机毕业设计源码+LW文档

开发语言：Java
框架：ssm
JDK版本：JDK1.8
服务器：tomcat7
数据库：mysql 5.7（一定要5.7版本）
数据库工具：Navicat11
开发软件：eclipse/myeclipse/idea
Maven包：Maven3.3.9
浏览器：谷歌浏览器

数据库脚本：
-- 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 '配置参数名称',
  `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 `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 '创建时间',
  `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 '数量',
  `fabushijian` datetime DEFAULT NULL COMMENT '发布时间',
  `zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
  `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
  `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 '创建时间',
  `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 '数量',
  `zulintianshu` varchar(200) DEFAULT NULL COMMENT '租赁天数',
  `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','数量1','租赁天数1','租赁时间1','2022-01-20 11:55:50','归还证明1',1,1),(72,'2022-01-20 03:55:50','订单编号2','道具名称2','道具类型2','账号2','用户名2','姓名2','数量2','租赁天数2','租赁时间2','2022-01-20 11:55:50','归还证明2',2,2),(73,'2022-01-20 03:55:50','订单编号3','道具名称3','道具类型3','账号3','用户名3','姓名3','数量3','租赁天数3','租赁时间3','2022-01-20 11:55:50','归还证明3',3,3),(74,'2022-01-20 03:55:50','订单编号4','道具名称4','道具类型4','账号4','用户名4','姓名4','数量4','租赁天数4','租赁时间4','2022-01-20 11:55:50','归还证明4',4,4),(75,'2022-01-20 03:55:50','订单编号5','道具名称5','道具类型5','账号5','用户名5','姓名5','数量5','租赁天数5','租赁时间5','2022-01-20 11:55:50','归还证明5',5,5),(76,'2022-01-20 03:55:50','订单编号6','道具名称6','道具类型6','账号6','用户名6','姓名6','数量6','租赁天数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 '创建时间',
  `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 '创建时间',
  `refid` bigint(20) NOT NULL COMMENT '关联表id',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
  `content` longtext NOT NULL COMMENT '评论内容',
  `reply` longtext COMMENT '回复内容',
  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','评论内容1','回复内容1'),(112,'2022-01-20 03:55:50',2,2,'用户名2','评论内容2','回复内容2'),(113,'2022-01-20 03:55:50',3,3,'用户名3','评论内容3','回复内容3'),(114,'2022-01-20 03:55:50',4,4,'用户名4','评论内容4','回复内容4'),(115,'2022-01-20 03:55:50',5,5,'用户名5','评论内容5','回复内容5'),(116,'2022-01-20 03:55:50',6,6,'用户名6','评论内容6','回复内容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 '创建时间',
  `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 '物流状态',
  `zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
  `fahuoshijian` datetime DEFAULT NULL COMMENT '发货时间',
  `sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
  `shhf` longtext 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 `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','物流状态1','账号1','2022-01-20 11:55:50','是',''),(62,'2022-01-20 03:55:50','订单编号2','道具名称2','道具类型2','用户名2','姓名2','13823888882','物流状态2','账号2','2022-01-20 11:55:50','是',''),(63,'2022-01-20 03:55:50','订单编号3','道具名称3','道具类型3','用户名3','姓名3','13823888883','物流状态3','账号3','2022-01-20 11:55:50','是',''),(64,'2022-01-20 03:55:50','订单编号4','道具名称4','道具类型4','用户名4','姓名4','13823888884','物流状态4','账号4','2022-01-20 11:55:50','是',''),(65,'2022-01-20 03:55:50','订单编号5','道具名称5','道具类型5','用户名5','姓名5','13823888885','物流状态5','账号5','2022-01-20 11:55:50','是',''),(66,'2022-01-20 03:55:50','订单编号6','道具名称6','道具类型6','用户名6','姓名6','13823888886','物流状态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 '创建时间',
  `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 `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 '创建时间',
  `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 '联系电话',
  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 '创建时间',
  `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 '物流状态',
  `zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
  `fahuoshijian` datetime DEFAULT NULL COMMENT '发货时间',
  `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','物流状态1','账号1','2022-01-20 11:55:50','是',''),(82,'2022-01-20 03:55:50','订单编号2','道具名称2','道具类型2','用户名2','姓名2','13823888882','物流状态2','账号2','2022-01-20 11:55:50','是',''),(83,'2022-01-20 03:55:50','订单编号3','道具名称3','道具类型3','用户名3','姓名3','13823888883','物流状态3','账号3','2022-01-20 11:55:50','是',''),(84,'2022-01-20 03:55:50','订单编号4','道具名称4','道具类型4','用户名4','姓名4','13823888884','物流状态4','账号4','2022-01-20 11:55:50','是',''),(85,'2022-01-20 03:55:50','订单编号5','道具名称5','道具类型5','用户名5','姓名5','13823888885','物流状态5','账号5','2022-01-20 11:55:50','是',''),(86,'2022-01-20 03:55:50','订单编号6','道具名称6','道具类型6','用户名6','姓名6','13823888886','物流状态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 '创建时间',
  `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 '创建时间',
  `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 '创建时间',
  `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 '数量',
  `zulintianshu` int(11) NOT NULL COMMENT '租赁天数',
  `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