Springboot+vue的网上鲜花商城管理系统 Javaee项目，springboot vue前后端分离项目

/* Navicat MySQL Data Transfer Source Server : xing Source Server Type : MySQL Source Server Version : 80031 Source Host : localhost:3306 Source Schema : flower Target Server Type : MySQL Target Server Version : 80031 File Encoding : 65001 Date: 05/02/2023 15:58:11 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for carts -- ---------------------------- DROP TABLE IF EXISTS `carts`; CREATE TABLE `carts` ( `id` int(0) NOT NULL AUTO_INCREMENT, `fid` int(0) NULL DEFAULT NULL, `flower` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `amount` int(0) NULL DEFAULT NULL, `price` float NULL DEFAULT NULL, `uid` int(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `flower`(`flower`) USING BTREE, INDEX `uid`(`uid`) USING BTREE, INDEX `fk2`(`fid`) USING BTREE, CONSTRAINT `carts_ibfk_2` FOREIGN KEY (`uid`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk2` FOREIGN KEY (`fid`) REFERENCES `flowers` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of carts -- ---------------------------- INSERT INTO `carts` VALUES (32, 1, '丁香', 1, NULL, 1); INSERT INTO `carts` VALUES (33, 3, '荷花', 1, NULL, 1); -- ---------------------------- -- Table structure for flowers -- ---------------------------- DROP TABLE IF EXISTS `flowers`; CREATE TABLE `flowers` ( `id` int(0) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `species_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `price` float NULL DEFAULT NULL, `detail` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `img_guid` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `state` int(0) NULL DEFAULT 1 COMMENT '商品状态', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `name`(`name`) USING BTREE, INDEX `species_name`(`species_name`) USING BTREE, CONSTRAINT `flowers_ibfk_1` FOREIGN KEY (`species_name`) REFERENCES `species` (`species_name`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of flowers -- ---------------------------- INSERT INTO `flowers` VALUES (1, '丁香', '春日', 23, '丁香', '42c7e06816f344dfa72481a6583179b6.jpg', 1); INSERT INTO `flowers` VALUES (2, '康乃馨', '夏日', 34, '康乃馨', '0029785497f5403988a1072dcdf49ad8.jpg', 1); INSERT INTO `flowers` VALUES (3, '荷花', '夏日', 22, '荷花', 'deeb7ce6bbe14a3792af5d7b83220b5a.jpg', 1); INSERT INTO `flowers` VALUES (4, '玫瑰', '秋日', 999.99, '玫瑰', 'e941015efd84441cb07a19bf7662ab75.jpg', 1); INSERT INTO `flowers` VALUES (5, '金梅', '夏日', 56.36, '金梅', '8122669a559a48979d49d4d3a4cdb939.jpg', 1); INSERT INTO `flowers` VALUES (8, '秋菊', '秋日', 23, '秋菊', '00d18262740a45f79e1ca095c53b80a3.jpg', 1); INSERT INTO `flowers` VALUES (9, '春菊', '春日', 44, '春菊', '35ffe54a53cc4f9a982e47944b20d03d.jpg', 1); -- ---------------------------- -- Table structure for orders -- ---------------------------- DROP TABLE IF EXISTS `orders`; CREATE TABLE `orders` ( `id` int(0) NOT NULL AUTO_INCREMENT, `order_guid` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `flower` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `amount` int(0) NULL DEFAULT NULL, `price` float NULL DEFAULT NULL, `state` int(0) NULL DEFAULT NULL, `uid` int(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `flower`(`flower`) USING BTREE, INDEX `uid`(`uid`) USING BTREE, CONSTRAINT `orders_ibfk_2` FOREIGN KEY (`uid`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of orders -- ---------------------------- INSERT INTO `orders` VALUES (25, NULL, '康乃馨', 1, 34, 1, 1); INSERT INTO `orders` VALUES (26, NULL, '荷花', 1, 22, 0, 1); INSERT INTO `orders` VALUES (27, NULL, '康乃馨', 1, 34, 0, 1); INSERT INTO `orders` VALUES (28, NULL, '春菊', 1, 44, 0, 1); -- ---------------------------- -- Table structure for species -- ---------------------------- DROP TABLE IF EXISTS `species`; CREATE TABLE `species` ( `id` int(0) NOT NULL AUTO_INCREMENT, `species_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `species`(`species_name`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of species -- ---------------------------- INSERT INTO `species` VALUES (7, '冬日'); INSERT INTO `species` VALUES (2, '夏日'); INSERT INTO `species` VALUES (1, '春日'); INSERT INTO `species` VALUES (3, '秋日'); -- ---------------------------- -- Table structure for users -- ---------------------------- DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `id` int(0) NOT NULL AUTO_INCREMENT, `account` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `password` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `phone` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `role` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '角色', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `account`(`account`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of users -- ---------------------------- INSERT INTO `users` VALUES (1, 'zhangsan', '张三', '123456', '15891589413', '山东省济南市历城区凤河南路765号天福名家6栋2单元0703房', 'user'); INSERT INTO `users` VALUES (2, 'admin', '管理员', 'admin', '123456', '上海市黄浦区南京西路8号', 'admin'); SET FOREIGN_KEY_CHECKS = 1;