基于SSM的衣柜定制系统源码.zip

-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64) -- -- Host: localhost Database: jspm724s2 -- ------------------------------------------------------ -- 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: `jspm724s2` -- /*!40000 DROP DATABASE IF EXISTS `jspm724s2`*/; CREATE DATABASE /*!32312 IF NOT EXISTS*/ `jspm724s2` /*!40100 DEFAULT CHARACTER SET utf8mb4 */; USE `jspm724s2`; -- -- Table structure for table `anzhuangxiaoguo` -- DROP TABLE IF EXISTS `anzhuangxiaoguo`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `anzhuangxiaoguo` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `loufangmingcheng` varchar(200) DEFAULT NULL COMMENT '楼房名称', `suozaixiaoqu` varchar(200) DEFAULT NULL COMMENT '所在小区', `louceng` varchar(200) DEFAULT NULL COMMENT '楼层', `mianji` varchar(200) DEFAULT NULL COMMENT '面积', `anzhuangshijian` datetime DEFAULT NULL COMMENT '安装时间', `anzhuangxiaoguo` longtext COMMENT '安装效果', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=177 DEFAULT CHARSET=utf8 COMMENT='安装效果'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `anzhuangxiaoguo` -- LOCK TABLES `anzhuangxiaoguo` WRITE; /*!40000 ALTER TABLE `anzhuangxiaoguo` DISABLE KEYS */; INSERT INTO `anzhuangxiaoguo` VALUES (171,'2022-03-26 12:44:25','楼房名称1','所在小区1','楼层1','面积1','2022-03-26 20:44:25','安装效果1'),(172,'2022-03-26 12:44:25','楼房名称2','所在小区2','楼层2','面积2','2022-03-26 20:44:25','安装效果2'),(173,'2022-03-26 12:44:25','楼房名称3','所在小区3','楼层3','面积3','2022-03-26 20:44:25','安装效果3'),(174,'2022-03-26 12:44:25','楼房名称4','所在小区4','楼层4','面积4','2022-03-26 20:44:25','安装效果4'),(175,'2022-03-26 12:44:25','楼房名称5','所在小区5','楼层5','面积5','2022-03-26 20:44:25','安装效果5'),(176,'2022-03-26 12:44:25','楼房名称6','所在小区6','楼层6','面积6','2022-03-26 20:44:25','安装效果6'); /*!40000 ALTER TABLE `anzhuangxiaoguo` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `anzhuangxinxi` -- DROP TABLE IF EXISTS `anzhuangxinxi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `anzhuangxinxi` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `dingdanbianhao` varchar(200) DEFAULT NULL COMMENT '订单编号', `anzhuangshijian` date DEFAULT NULL COMMENT '安装时间', `anzhuangneirong` longtext COMMENT '安装内容', `anzhuangjindu` varchar(200) DEFAULT NULL COMMENT '安装进度', `zhanghao` varchar(200) DEFAULT NULL COMMENT '账号', `xingming` varchar(200) DEFAULT NULL COMMENT '姓名', `dianzhangzhanghao` varchar(200) DEFAULT NULL COMMENT '店长账号', `dianzhangxingming` varchar(200) DEFAULT 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 `anzhuangxinxi` -- LOCK TABLES `anzhuangxinxi` WRITE; /*!40000 ALTER TABLE `anzhuangxinxi` DISABLE KEYS */; INSERT INTO `anzhuangxinxi` VALUES (101,'2022-03-26 12:44:25','订单编号1','2022-03-26','安装内容1','安装中','账号1','姓名1','店长账号1','店长姓名1'),(102,'2022-03-26 12:44:25','订单编号2','2022-03-26','安装内容2','安装中','账号2','姓名2','店长账号2','店长姓名2'),(103,'2022-03-26 12:44:25','订单编号3','2022-03-26','安装内容3','安装中','账号3','姓名3','店长账号3','店长姓名3'),(104,'2022-03-26 12:44:25','订单编号4','2022-03-26','安装内容4','安装中','账号4','姓名4','店长账号4','店长姓名4'),(105,'2022-03-26 12:44:25','订单编号5','2022-03-26','安装内容5','安装中','账号5','姓名5','店长账号5','店长姓名5'),(106,'2022-03-26 12:44:25','订单编号6','2022-03-26','安装内容6','安装中','账号6','姓名6','店长账号6','店长姓名6'); /*!40000 ALTER TABLE `anzhuangxinxi` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cailiaoxinxi` -- DROP TABLE IF EXISTS `cailiaoxinxi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cailiaoxinxi` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `cailiaomingcheng` varchar(200) DEFAULT NULL COMMENT '材料名称', `cailiaoleixing` varchar(200) DEFAULT NULL COMMENT '材料类型', `cailiaoguige` varchar(200) DEFAULT NULL COMMENT '材料规格', `cailiaoshoujia` float DEFAULT NULL COMMENT '材料售价', `cailiaojieshao` longtext COMMENT '材料介绍', `cailiaotupian` varchar(200) 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 `cailiaoxinxi` -- LOCK TABLES `cailiaoxinxi` WRITE; /*!40000 ALTER TABLE `cailiaoxinxi` DISABLE KEYS */; INSERT INTO `cailiaoxinxi` VALUES (71,'2022-03-26 12:44:25','材料名称1','材料类型1','材料规格1',1,'材料介绍1','upload/cailiaoxinxi_cailiaotupian1.jpg'),(72,'2022-03-26 12:44:25','材料名称2','材料类型2','材料规格2',2,'材料介绍2','upload/cailiaoxinxi_cailiaotupian2.jpg'),(73,'2022-03-26 12:44:25','材料名称3','材料类型3','材料规格3',3,'材料介绍3','upload/cailiaoxinxi_cailiaotupian3.jpg'),(74,'2022-03-26 12:44:25','材料名称4','材料类型4','材料规格4',4,'材料介绍4','upload/cailiaoxinxi_cailiaotupian4.jpg'),(75,'2022-03-26 12:44:25','材料名称5','材料类型5','材料规格5',5,'材料介绍5','upload/cailiaoxinxi_cailiaotupian5.jpg'),(76,'2022-03-26 12:44:25','材料名称6','材料类型6','材料规格6',6,'材料介绍6','upload/cailiaoxinxi_cailiaotupian6.jpg'); /*!40000 ALTER TABLE `cailiaoxinxi` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cailiaoyuding` -- DROP TABLE IF EXISTS `cailiaoyuding`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cailiaoyuding` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `cailiaomingcheng` varchar(200) DEFAULT NULL COMMENT '材料名称', `cailiaoleixing` varchar(200) DEFAULT NULL COMMENT '材料类型', `cailiaoguige` varchar(200) DEFAULT NULL COMMENT '材料规格', `cailiaoshoujia` float DEFAULT NULL COMMENT '材料售价', `yudingshuliang` int(11) DEFAULT NULL COMMENT '预订数量', `heji` float DEFAULT NULL COMMENT '合计', `beizhu` varchar(200) DEFAULT NULL COMMENT '备注', `yudingshijian` datetime DEFAULT NULL COMMENT '预订时间', `zhanghao` varchar(200) DEFAULT NULL COMMENT '账号', `xingming` varchar(200) DEFAULT NULL COMMENT '姓名', `sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核', `shhf` longtext COMMENT '审核回复', PRIMARY