在线商城项目（SSM+Maven+mysql+IDEA）

CREATE DATABASE IF NOT EXISTS `db_zshop` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */; USE `db_zshop`; -- MySQL dump 10.13 Distrib 8.0.15, for Win64 (x86_64) -- -- Host: localhost Database: db_zshop -- ------------------------------------------------------ -- Server version 8.0.15 /*!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 */; 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 */; -- -- Table structure for table `t_admin` -- DROP TABLE IF EXISTS `t_admin`; /*!40101 SET @saved_cs_client = @@character_set_client */; SET character_set_client = utf8mb4 ; CREATE TABLE `t_admin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) DEFAULT NULL, `login_name` varchar(50) DEFAULT NULL, `password` varchar(50) DEFAULT NULL, `phone` varchar(20) DEFAULT NULL, `email` varchar(50) DEFAULT NULL, `is_valid` int(11) DEFAULT NULL COMMENT '1-有效，0-无效', `create_date` datetime DEFAULT NULL, `role_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `admin_role` (`role_id`), CONSTRAINT `admin_role` FOREIGN KEY (`role_id`) REFERENCES `t_role` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `t_admin` -- LOCK TABLES `t_admin` WRITE; /*!40000 ALTER TABLE `t_admin` DISABLE KEYS */; INSERT INTO `t_admin` VALUES (1,'陈然','admin','123456','13548115133','96594@qq.com',1,'2019-03-06 00:00:00',1),(3,'珊莎','shansha','123456','1298492083','shansha4@qq.com',1,'2019-03-06 00:00:00',3),(4,'yangying','yangying','111','111','111',1,'2019-03-18 14:03:18',2),(5,'asa','sa','sa','sa','sassa',1,'2019-03-18 14:03:18',2),(6,'测试人员22','sasa','333','121','121sas2',1,'2019-03-18 14:03:19',3),(7,'测试人员2','test2','123456','111','111',1,'2019-03-18 14:25:54',2); /*!40000 ALTER TABLE `t_admin` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `t_customer` -- DROP TABLE IF EXISTS `t_customer`; /*!40101 SET @saved_cs_client = @@character_set_client */; SET character_set_client = utf8mb4 ; CREATE TABLE `t_customer` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(20) DEFAULT NULL, `login_name` varchar(45) NOT NULL, `password` varchar(50) DEFAULT NULL, `phone` varchar(20) DEFAULT NULL, `is_valid` int(11) DEFAULT NULL, `regist_date` datetime DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `login_name` (`login_name`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `t_customer` -- LOCK TABLES `t_customer` WRITE; /*!40000 ALTER TABLE `t_customer` DISABLE KEYS */; INSERT INTO `t_customer` VALUES (1,'chenran','chenran','111111','13548115133',1,'2019-03-23 10:13:53'); /*!40000 ALTER TABLE `t_customer` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `t_item` -- DROP TABLE IF EXISTS `t_item`; /*!40101 SET @saved_cs_client = @@character_set_client */; SET character_set_client = utf8mb4 ; CREATE TABLE `t_item` ( `id` int(11) NOT NULL AUTO_INCREMENT, `product_id` int(11) DEFAULT NULL, `num` int(11) DEFAULT NULL, `price` double DEFAULT NULL, `order_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `item_product` (`product_id`), KEY `item_order` (`order_id`), CONSTRAINT `item_order` FOREIGN KEY (`order_id`) REFERENCES `t_order` (`id`), CONSTRAINT `item_product` FOREIGN KEY (`product_id`) REFERENCES `t_product` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `t_item` -- LOCK TABLES `t_item` WRITE; /*!40000 ALTER TABLE `t_item` DISABLE KEYS */; /*!40000 ALTER TABLE `t_item` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `t_order` -- DROP TABLE IF EXISTS `t_order`; /*!40101 SET @saved_cs_client = @@character_set_client */; SET character_set_client = utf8mb4 ; CREATE TABLE `t_order` ( `id` int(11) NOT NULL AUTO_INCREMENT, `no` varchar(300) NOT NULL, `customer_id` int(11) DEFAULT NULL, `price` double DEFAULT NULL, `create_date` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `order_customer` (`customer_id`), CONSTRAINT `order_customer` FOREIGN KEY (`customer_id`) REFERENCES `t_customer` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `t_order` -- LOCK TABLES `t_order` WRITE; /*!40000 ALTER TABLE `t_order` DISABLE KEYS */; /*!40000 ALTER TABLE `t_order` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `t_product` -- DROP TABLE IF EXISTS `t_product`; /*!40101 SET @saved_cs_client = @@character_set_client */; SET character_set_client = utf8mb4 ; CREATE TABLE `t_product` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(200) DEFAULT NULL, `price` double DEFAULT NULL, `info` varchar(200) DEFAULT NULL, `image` varchar(200) DEFAULT NULL, `product_type_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FK_ID` (`product_type_id`), CONSTRAINT `FK_ID` FOREIGN KEY (`product_type_id`) REFERENCES `t_product_type` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `t_product` -- LOCK TABLES `t_product` WRITE; /*!40000 ALTER TABLE `t_product` DISABLE KEYS */; INSERT INTO `t_product` VALUES (6,'牛仔外套',388,NULL,'C:\\Users\\67013\\IdeaProjects\\zshop_parent\\zshop_backweb\\src\\main\\webapp\\WEB-INF\\upload/2019032122544820.jpg',24),(7,'韩版貂皮大衣',888,NULL,'C:\\Users\\67013\\IdeaProjects\\zshop_parent\\zshop_backweb\\src\\main\\webapp\\WEB-INF\\upload/2019032122414214.jpg',24),(8,'黑色打底衫',88,NULL,'C:\\Users\\67013\\IdeaProjects\\zshop_parent\\zshop_backweb\\src\\main\\webapp\\WEB-INF\\upload/2019032122415056.jpg',24),(9,'红色毛衣',158,NULL,'C:\\Users\\67013\\IdeaProjects\\zshop_parent\\zshop_backweb\\src\\main\\webapp\\WEB-INF\\upload/2019032122415922.jpg',24),(10,'红色短款大衣',449,NULL,'C:\\Users\\67013\\IdeaProjects\\zshop_parent\\zshop_backweb\\src\\main\\webapp\\WEB-INF\\upload/2019032122420870.jpg',24),(22,'面包服',344,NULL,'C:\\Users\\67013\\IdeaProjects\\zshop_parent\\zshop_backweb\\src\\main\\webapp\\WEB-INF\\upload/2019032311472089.jpg',24),(23,'tst1',12,NULL,'C:\\Users\\67013\\IdeaProjects\\zshop_parent\\zshop_backweb\\src\\main\\webapp\\WEB-INF\\upload/2019032123064132.png',7),(24,'灰灰的外套',222,NULL,'C:\\Users\\67013\\IdeaProjects\\zshop_parent\\zshop_backweb\\src\\main\\webapp\\WEB-INF\\upload/2019032311483921.jpg',24),(25,'油菜花',11,NULL,'C:\\Users\\67013\\IdeaProjects\\zshop_parent\\zshop_backweb\\src\\main\\webapp\\WEB-INF\\upload/2019032311491356.jpeg',20); /*!40000 ALTER TABLE `t_product` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `t_product_type` -- DROP TABLE IF EXISTS `t_product_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; SET character_set_client = utf8mb4 ; CREATE TABLE `t_product_type` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(200) NOT NULL, `status` int(11) DEFAULT NULL, PRIMARY KEY (`id`), U