基于java的springboot鲜花商城系统源码.zip

/* SQLyog Ultimate v11.33 (64 bit) MySQL - 5.7.18-log : Database - db_mall ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!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 */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`db_mall` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `db_mall`; /*Table structure for table `admin_user` */ DROP TABLE IF EXISTS `admin_user`; CREATE TABLE `admin_user` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户id', `password` varchar(255) DEFAULT NULL COMMENT '密码', `username` varchar(255) NOT NULL COMMENT '用户', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; /*Data for the table `admin_user` */ insert into `admin_user`(`id`,`password`,`username`) values (1,'123456','java1234'); /*Table structure for table `classification` */ DROP TABLE IF EXISTS `classification`; CREATE TABLE `classification` ( `id` int(11) NOT NULL AUTO_INCREMENT, `cname` varchar(255) DEFAULT NULL, `parent_id` int(11) DEFAULT NULL, `type` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8; /*Data for the table `classification` */ insert into `classification`(`id`,`cname`,`parent_id`,`type`) values (12,'玫瑰',0,1),(13,'隐逸花',0,1),(15,'rose',12,2),(16,'chrysanthemum',13,2),(18,'百合',0,1),(19,'满天星',0,1),(21,'lily',18,2),(22,'Babysbreath',19,2),(23,'其他',0,1),(24,'other',23,2); /*Table structure for table `comment` */ DROP TABLE IF EXISTS `comment`; CREATE TABLE `comment` ( `id` int(11) NOT NULL AUTO_INCREMENT, `content` varchar(255) COLLATE utf8_croatian_ci DEFAULT NULL, `create_time` datetime DEFAULT NULL, `order_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_croatian_ci; /*Data for the table `comment` */ /*Table structure for table `order` */ DROP TABLE IF EXISTS `order`; CREATE TABLE `order` ( `id` int(11) NOT NULL AUTO_INCREMENT, `addr` varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `order_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `phone` varchar(255) DEFAULT NULL, `state` int(11) DEFAULT NULL, `total` double DEFAULT NULL, `user_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8; /*Data for the table `order` */ insert into `order`(`id`,`addr`,`name`,`order_time`,`phone`,`state`,`total`,`user_id`) values (6,'湖南长沙','石魁','2019-10-02 22:59:58','15575884696',3,555,1),(7,'湖南长沙湖南信息职业技术学院','lambert.shi','2019-10-14 12:55:15','13786887337',4,600,5),(8,'这些','地方','2019-10-14 13:06:53','214',3,9600,5),(9,'是','qq','2019-10-16 08:07:32','1',2,600,5),(10,'11','11','2019-10-18 02:14:20','11',1,55,5),(11,'sa','sa','2019-10-18 02:51:29','sa',2,666,6),(12,'sss','张三','2022-12-24 16:04:10','2321421321',4,629,7); /*Table structure for table `order_item` */ DROP TABLE IF EXISTS `order_item`; CREATE TABLE `order_item` ( `id` int(11) NOT NULL AUTO_INCREMENT, `count` int(11) DEFAULT NULL, `order_id` int(11) DEFAULT NULL, `product_id` int(11) DEFAULT NULL, `sub_total` double DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8; /*Data for the table `order_item` */ insert into `order_item`(`id`,`count`,`order_id`,`product_id`,`sub_total`) values (1,1,1,10,8888),(2,2,2,9,17998),(3,2,3,11,78),(4,1,3,13,5999),(5,1,4,9,8999),(6,1,5,13,5999),(7,1,6,14,555),(8,1,7,15,600),(9,5,8,15,9600),(10,1,9,15,600),(11,1,10,14,55),(12,1,11,14,666),(13,1,12,32,310),(14,1,12,24,319); /*Table structure for table `product` */ DROP TABLE IF EXISTS `product`; CREATE TABLE `product` ( `id` int(11) NOT NULL AUTO_INCREMENT, `csid` int(11) DEFAULT NULL, `desc` varchar(1000) DEFAULT NULL, `image` varchar(255) DEFAULT NULL, `is_hot` int(11) DEFAULT NULL, `market_price` double DEFAULT NULL, `pdate` datetime DEFAULT NULL, `shop_price` bigint(20) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8; /*Data for the table `product` */ insert into `product`(`id`,`csid`,`desc`,`image`,`is_hot`,`market_price`,`pdate`,`shop_price`,`title`) values (14,15,'花色是最标准的玫瑰红，红色中的经典款，也是最畅销的一款，属于红玫瑰中的顶级品种。','/mall/admin/product/img/56FD776C1C422092775FED55D46CB1.jpg',1,999,'2019-10-18 03:12:39',666,'红玫瑰（卡罗拉）'),(15,15,'颜色组合古朴、别致平满芯。翘角、卷边外瓣色淡，个别外瓣瓣缘呈浅绿色；内瓣色浓、均匀，花瓣排列整齐、紧凑。','/mall/admin/product/img/E3F3F84A92328CC39A1442411D3329.png',0,280,'2019-10-18 03:12:32',200,'香槟'),(17,15,'具有迷人的气质，玫瑰不仅危险，还经常成为重金属摇滚乐专辑和幻想书籍的封面，无法说出口的爱。','/mall/admin/product/img/CBF6B82567780B11E0413BEED4E408.jpg',0,800,'2019-10-18 03:12:18',750,'黑玫瑰'),(18,15,'戴安娜是最漂亮的粉玫瑰。就像午后阳光，淡淡的温暖里，有着我们无法拒绝的舒适。','/mall/admin/product/img/1D72E840B1FE8279DC07D57F028E25.jpg',0,230,'2019-10-18 03:12:12',190,'戴安娜'),(19,24,'开花的植物中最香的一个品种，蓝色风信子代表生命、贞操、忧郁的爱，白色代表纯洁和暗恋，黄色代表幸福与感谢，红色代表热情和热恋，粉色代表浪漫与宁静，而紫色则代表道歉、自责或缅怀之意。','/mall/admin/product/img/80DA674A949BFF15F9173BE8520375.jpg',0,119,'2019-10-18 03:12:05',110,'风信子'),(20,21,'“云裳仙子”，外表高雅纯洁，天主教以白百合花为圣母玛利亚的象征，而梵蒂冈以百合花为国花。百合的种头由鳞片抱合而成，取“百年好合”“百事合意”之意，中国自古视为婚礼必不可少的吉祥花卉。','/mall/admin/product/img/4CB22186282455D2A29F590AF64F37.jpg',1,688,'2019-10-18 03:11:58',599,'香水百合'),(21,21,'重逢的喜悦；期待再一次相遇；深深的祝福和百年好合之意。','/mall/admin/product/img/A295FE68A3B1AF2959F86E6A53A5B4.png',0,288,'2019-10-18 03:11:50',199,'水仙百合'),(22,16,'黄色的菊花代表着高雅的君子品格，所以在平时也可以用来送给老师、长辈等。','/mall/admin/product/img/70F8F1F1342FB5EC758C8FDDEC1F20.jpg',0,155,'2019-10-18 03:11:43',100,'黄半球菊花'),(23,16,'纯洁的美·天真·幼稚, 愉快、幸福、和平、希望，还有“深藏在心底的爱”。','/mall/admin/product/img/72A784C69649F8A3C403DCBD6E7C86.jpg',1,288,'2019-10-18 03:11:33',199,'小雏菊'),(24,24,'热情、魅力、使人柔弱的爱、真情、母亲我爱你、温馨的祝福、热爱着你、慈祥、不求代价的母爱、宽容、母亲之花、浓郁的亲情、亲情思念、清纯的爱慕之情、热恋、热心、伤心与懊悔、伟大、神圣，慰问、心灵的相通、真挚、走运、思念。','/mall/admin/product/img/83070AEFAED058105A4A35E5DB5897.jpg',1,399,'2019-10-18 03:11:17',319,'康乃馨'),(25,22,'思念、清纯、梦境、真心喜欢、配角，但不可缺。','/mall/admin/product/img/6D6496CDDDC3950D792A068064210A.jpg',0,99,'2019-10-18 03:11:09',88,'蓝色满天星'),(26,22,'思念、清纯、梦境、真心喜欢、配角，但不可缺。','/mall/admin/product/img/4CA802C15AE1DB7624AC6469621371.jpg',0,99,'2019-10-18 03:10:59',88,'红色满天星'),(27,24,'信念、光辉、高傲、忠诚、爱慕，向日葵的寓意是沉默的爱