express+mysql+vue,从零搭建一个商城管理系统12-添加商品到购物车

/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 80028 Source Host : localhost:3306 Source Database : express_service Target Server Type : MYSQL Target Server Version : 80028 File Encoding : 65001 Date: 2024-03-14 15:03:21 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for cart -- ---------------------------- DROP TABLE IF EXISTS `cart`; CREATE TABLE `cart` ( `id` int NOT NULL AUTO_INCREMENT, `userId` varchar(255) DEFAULT NULL, `shopId` varchar(255) DEFAULT NULL, `shopName` varchar(255) DEFAULT NULL, `goodsId` varchar(255) DEFAULT NULL, `goodsName` varchar(255) DEFAULT NULL, `price` float DEFAULT NULL, `count` int DEFAULT NULL, `specs` varchar(255) DEFAULT NULL, `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3; -- ---------------------------- -- Records of cart -- ---------------------------- INSERT INTO `cart` VALUES ('2', '9e14ebba3be0ae546374e8f5a49f9e80', '79194be0b10509d407ec414e297da595', 'shop03', '59ab7156aab608c14f90ddd7e1dcbdd4', '娃哈哈500ml', '4.5', '5', '500ml/瓶', '2024-03-14 03:23:12', '2024-03-14 03:23:48'); INSERT INTO `cart` VALUES ('3', '9e14ebba3be0ae546374e8f5a49f9e80', 'a81184a745ad97a4de19823f9782f733', 'shop02', 'a1787a5e48133e3b688412c27643df80', '大辣片', '4.9', '1', '240克/袋', '2024-03-14 03:26:40', '2024-03-14 03:26:40'); INSERT INTO `cart` VALUES ('4', '9e14ebba3be0ae546374e8f5a49f9e80', 'a81184a745ad97a4de19823f9782f733', 'shop02', 'dd427517fbdc6760a14b11ee84772685', '卫龙辣条', '4.9', '2', '35克/袋', '2024-03-14 03:27:20', '2024-03-14 03:27:33'); INSERT INTO `cart` VALUES ('5', '9e14ebba3be0ae546374e8f5a49f9e80', '098a0c4828d7d0c78f42e6124f911a77', 'shop01', '3984cac360808573a7b703b61a66d0fe', '奥利奥原味饼干', '8.8', '1', '200克/盒', '2024-03-14 03:30:26', '2024-03-14 03:30:26'); INSERT INTO `cart` VALUES ('6', '9e14ebba3be0ae546374e8f5a49f9e80', '098a0c4828d7d0c78f42e6124f911a77', 'shop01', '94f2965af1c719ade377fd9f85b61e1f', '乐事薯片', '6.4', '3', '160克/罐', '2024-03-14 03:31:03', '2024-03-14 03:49:04'); -- ---------------------------- -- Table structure for goods -- ---------------------------- DROP TABLE IF EXISTS `goods`; CREATE TABLE `goods` ( `id` int NOT NULL AUTO_INCREMENT, `goodsId` varchar(255) DEFAULT NULL, `goodsName` varchar(255) NOT NULL, `createId` varchar(255) DEFAULT NULL, `shopId` varchar(255) DEFAULT NULL, `shopName` varchar(255) DEFAULT NULL, `price` float DEFAULT NULL, `inventory` int DEFAULT NULL, `specs` varchar(255) DEFAULT NULL, `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `goodsName` (`goodsName`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3; -- ---------------------------- -- Records of goods -- ---------------------------- INSERT INTO `goods` VALUES ('1', '3984cac360808573a7b703b61a66d0fe', '奥利奥原味饼干', '94bca74490de0f84e1f478ed602123d3', '098a0c4828d7d0c78f42e6124f911a77', 'shop01', '8.8', '100', '200克/盒', '2024-03-13 08:08:51', '2024-03-13 08:08:51'); INSERT INTO `goods` VALUES ('5', '94f2965af1c719ade377fd9f85b61e1f', '乐事薯片', '94bca74490de0f84e1f478ed602123d3', '098a0c4828d7d0c78f42e6124f911a77', 'shop01', '6.4', '200', '160克/罐', '2024-03-13 08:37:07', '2024-03-13 08:37:07'); INSERT INTO `goods` VALUES ('6', 'dd427517fbdc6760a14b11ee84772685', '卫龙辣条', '1c270113be21412c87b87aff22fe19ec', 'a81184a745ad97a4de19823f9782f733', 'shop02', '4.9', '1000', '35克/袋', '2024-03-14 02:45:20', '2024-03-14 02:45:20'); INSERT INTO `goods` VALUES ('7', '52f20f495e66657126497715130a2997', '亲嘴铜锣烧', '1c270113be21412c87b87aff22fe19ec', 'a81184a745ad97a4de19823f9782f733', 'shop02', '1.2', '2400', '10克/袋', '2024-03-14 02:46:01', '2024-03-14 02:46:01'); INSERT INTO `goods` VALUES ('8', 'a1787a5e48133e3b688412c27643df80', '大辣片', '1c270113be21412c87b87aff22fe19ec', 'a81184a745ad97a4de19823f9782f733', 'shop02', '4.9', '200', '240克/袋', '2024-03-14 02:46:33', '2024-03-14 02:46:33'); INSERT INTO `goods` VALUES ('9', '59ab7156aab608c14f90ddd7e1dcbdd4', '娃哈哈100ml', '69a41e3cc40e980da8d7b7d36ef273c2', '79194be0b10509d407ec414e297da595', 'shop03', '5.9', '2000', '6瓶/排', '2024-03-14 02:47:53', '2024-03-14 02:47:53'); INSERT INTO `goods` VALUES ('10', 'd1d828d718d4db54e1790e17c69055dc', '娃哈哈220g', '69a41e3cc40e980da8d7b7d36ef273c2', '79194be0b10509d407ec414e297da595', 'shop03', '7.8', '2000', '4瓶/排', '2024-03-14 02:49:06', '2024-03-14 02:49:06'); INSERT INTO `goods` VALUES ('11', '552528655c60297fa70d2ca1cb96f995', '娃哈哈500ml', '69a41e3cc40e980da8d7b7d36ef273c2', '79194be0b10509d407ec414e297da595', 'shop03', '4.5', '500', '500ml/瓶', '2024-03-14 02:49:38', '2024-03-14 02:49:38'); -- ---------------------------- -- Table structure for shop -- ---------------------------- DROP TABLE IF EXISTS `shop`; CREATE TABLE `shop` ( `id` int NOT NULL AUTO_INCREMENT, `shopId` varchar(255) DEFAULT NULL, `shopName` varchar(255) NOT NULL, `createId` varchar(255) DEFAULT NULL, `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `shopName` (`shopName`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3; -- ---------------------------- -- Records of shop -- ---------------------------- INSERT INTO `shop` VALUES ('1', '098a0c4828d7d0c78f42e6124f911a77', 'shop01', '94bca74490de0f84e1f478ed602123d3', '2024-03-13 07:49:01', '2024-03-13 07:49:01'); INSERT INTO `shop` VALUES ('5', 'a81184a745ad97a4de19823f9782f733', 'shop02', '1c270113be21412c87b87aff22fe19ec', '2024-03-14 02:44:10', '2024-03-14 02:44:10'); INSERT INTO `shop` VALUES ('6', '79194be0b10509d407ec414e297da595', 'shop03', '69a41e3cc40e980da8d7b7d36ef273c2', '2024-03-14 02:44:18', '2024-03-14 02:44:18'); -- ---------------------------- -- Table structure for user -- ---------------------------- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` int NOT NULL AUTO_INCREMENT, `userId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `userName` varchar(255) NOT NULL, `password` varchar(255) DEFAULT NULL, `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `userName` (`userName`) ) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb3; -- ---------------------------- -- Records of user -- ---------------------------- INSERT INTO `user` VALUES ('17', '94bca74490de0f84e1f478ed602123d3', 'test0001', '$2a$09$5dEXj./B8oLvoC31ty9EHeiWKBeSevccS.JLcMOFbpjRxZiPOxkqm', '2024-03-13 07:23:41', '2024-03-13 07:23:41'); INSERT INTO `user` VALUES ('18', '1c270113be21412c87b87aff22fe19ec', 'test0002', '$2a$09$v/NV07v3SLW6jFnNRD7JmORlHHSrwIKrJF9he8CZEIlkFybyTPVau', '2024-03-13 07:23:44', '2024-03-13 07:23:44'); INSERT INTO `user` VALUES ('19', '69a41e3cc40e980da8d7b7d36ef273c2', 'test0003', '$2a$09$ksvlGnHHdF25RkB.qW1OpOb6ctj3uq8WiIqxYWokLYnTjC20pVZ/K', '2024-03-13 07:23:49', '2024-03-13 07:23:49'); INSERT INTO `user` VALUES ('29', '9e14ebba3be0ae546374e8f5a49f9e80', 'long001', '$2a$09$KVs93ij.a8Wvk9Zu2qpU..pPzxtoAWJ6VspCkugNlX1HrRHHUWMHW', '2024-03-14 02:23:46', '2024-03-14 02:23:46');