基于springboot+jpa+mysql+html线上中药商城系统(高分毕设)

/* Navicat Premium Data Transfer Source Server : localhost Source Server Type : MySQL Source Server Version : 80021 Source Host : localhost:3306 Source Schema : onlinemall Target Server Type : MySQL Target Server Version : 80021 File Encoding : 65001 Date: 27/05/2022 10:36:14 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for admin_user -- ---------------------------- DROP TABLE IF EXISTS `admin_user`; CREATE TABLE `admin_user` ( `id` int(0) NOT NULL AUTO_INCREMENT, `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of admin_user -- ---------------------------- INSERT INTO `admin_user` VALUES (1, 'admin', 'admin'); INSERT INTO `admin_user` VALUES (2, 'hfb', 'hfb'); -- ---------------------------- -- Table structure for classification -- ---------------------------- DROP TABLE IF EXISTS `classification`; CREATE TABLE `classification` ( `id` int(0) NOT NULL AUTO_INCREMENT, `cname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `parent_id` int(0) NULL DEFAULT NULL, `type` int(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 58 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of classification -- ---------------------------- INSERT INTO `classification` VALUES (1, '解表药', 0, 1); INSERT INTO `classification` VALUES (2, '泻下药', 0, 1); INSERT INTO `classification` VALUES (3, '理湿药', 0, 1); INSERT INTO `classification` VALUES (4, '祛寒药', 0, 1); INSERT INTO `classification` VALUES (5, '辛温解表', 1, 2); INSERT INTO `classification` VALUES (6, '辛凉解表', 1, 2); INSERT INTO `classification` VALUES (7, '驱风湿', 1, 2); INSERT INTO `classification` VALUES (9, '清热药', 0, 1); INSERT INTO `classification` VALUES (10, '寒下', 2, 2); INSERT INTO `classification` VALUES (11, '热下', 2, 2); INSERT INTO `classification` VALUES (16, '涌吐药', 0, 1); INSERT INTO `classification` VALUES (17, '消化药', 0, 1); INSERT INTO `classification` VALUES (18, '止咳药', 0, 1); INSERT INTO `classification` VALUES (19, '理气药', 0, 1); INSERT INTO `classification` VALUES (20, '理血药', 0, 1); INSERT INTO `classification` VALUES (21, '滋补药', 0, 1); INSERT INTO `classification` VALUES (22, '开窍药', 0, 1); INSERT INTO `classification` VALUES (23, '镇静药', 0, 1); INSERT INTO `classification` VALUES (24, '固涩药', 0, 1); INSERT INTO `classification` VALUES (25, '驱虫药', 0, 1); INSERT INTO `classification` VALUES (26, '润下', 2, 2); INSERT INTO `classification` VALUES (27, '泻水', 2, 2); INSERT INTO `classification` VALUES (28, '芳香化湿', 3, 2); INSERT INTO `classification` VALUES (29, '淡渗', 3, 2); INSERT INTO `classification` VALUES (30, '利尿', 3, 2); INSERT INTO `classification` VALUES (31, '温中散寒', 4, 2); INSERT INTO `classification` VALUES (32, '扶阳壮火', 4, 2); INSERT INTO `classification` VALUES (33, '苦寒清热', 9, 2); INSERT INTO `classification` VALUES (34, '甘寒清热', 9, 2); INSERT INTO `classification` VALUES (35, '清热解毒', 9, 2); INSERT INTO `classification` VALUES (36, '涌吐', 16, 2); INSERT INTO `classification` VALUES (37, '消化', 17, 2); INSERT INTO `classification` VALUES (38, '清肺止咳', 18, 2); INSERT INTO `classification` VALUES (39, '温肺止咳', 18, 2); INSERT INTO `classification` VALUES (40, '消痰平喘', 18, 2); INSERT INTO `classification` VALUES (41, '行气', 19, 2); INSERT INTO `classification` VALUES (42, '破气', 19, 2); INSERT INTO `classification` VALUES (43, '活血', 20, 2); INSERT INTO `classification` VALUES (44, '破瘀', 20, 2); INSERT INTO `classification` VALUES (45, '止血', 20, 2); INSERT INTO `classification` VALUES (46, '补气', 21, 2); INSERT INTO `classification` VALUES (47, '补血', 21, 2); INSERT INTO `classification` VALUES (48, '温补', 21, 2); INSERT INTO `classification` VALUES (49, '清补', 21, 2); INSERT INTO `classification` VALUES (50, '开窍', 22, 2); INSERT INTO `classification` VALUES (51, '重镇', 23, 2); INSERT INTO `classification` VALUES (52, '息风潜阳', 23, 2); INSERT INTO `classification` VALUES (53, '安神', 23, 2); INSERT INTO `classification` VALUES (54, '止汗', 24, 2); INSERT INTO `classification` VALUES (55, '固精', 24, 2); INSERT INTO `classification` VALUES (56, '制泻', 24, 2); INSERT INTO `classification` VALUES (57, '驱虫', 25, 2); -- ---------------------------- -- Table structure for order -- ---------------------------- DROP TABLE IF EXISTS `order`; CREATE TABLE `order` ( `id` int(0) NOT NULL AUTO_INCREMENT, `addr` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `order_time` datetime(0) NULL DEFAULT NULL, `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `state` int(0) NULL DEFAULT NULL, `total` double NULL DEFAULT NULL, `user_id` int(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of order -- ---------------------------- INSERT INTO `order` VALUES (13, '北京', '张三', '2021-12-28 01:12:34', '10086', 4, 74, 1); INSERT INTO `order` VALUES (14, '上海', '李四', '2021-12-28 01:14:44', '10087', 1, 52, 2); INSERT INTO `order` VALUES (15, '上海', '张三', '2021-12-28 02:01:27', '10086', 4, 87, 1); INSERT INTO `order` VALUES (16, '深圳', '张三', '2022-01-13 02:11:30', '18200772669', 1, 27, 1); INSERT INTO `order` VALUES (17, '北京', '张三', '2022-05-27 02:29:41', '13726892227', 1, 0, 1); -- ---------------------------- -- Table structure for order_item -- ---------------------------- DROP TABLE IF EXISTS `order_item`; CREATE TABLE `order_item` ( `id` int(0) NOT NULL AUTO_INCREMENT, `count` int(0) NULL DEFAULT NULL, `order_id` int(0) NULL DEFAULT NULL, `product_id` int(0) NULL DEFAULT NULL, `sub_total` double NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of order_item -- ---------------------------- INSERT INTO `order_item` VALUES (20, 1, 13, 10, 35); INSERT INTO `order_item` VALUES (21, 1, 13, 11, 39); INSERT INTO `order_item` VALUES (22, 1, 14, 17, 25); INSERT INTO `order_item` VALUES (23, 1, 14, 13, 27); INSERT INTO `order_item` VALUES (24, 1, 15, 16, 13); INSERT INTO `order_item` VALUES (25, 1, 15, 10, 35); INSERT INTO `order_item` VALUES (26, 1, 15, 11, 39); INSERT INTO `order_item` VALUES (27, 1, 16, 13, 27); -- ---------------------------- -- Table structure for product -- ---------------------------- DROP TABLE IF EXISTS `product`; CREATE TABLE `product` ( `id` int(0) NOT NULL AUTO_INCREMENT, `csid` int(0) NULL DEFAULT NULL, `desc` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `is_hot` int(0) NULL DEFAULT NULL, `market_price` double NULL DEFAULT NULL, `pdate` datetime(0) NULL DEFAULT NULL, `shop_price` bigint(0) NULL DEFAULT NULL, `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) US