基于SSM框架校园物品交易平台的设计与实现

/* Navicat Premium Data Transfer Source Server : 127.0.0.1 Source Server Type : MySQL Source Server Version : 50520 Source Host : localhost:3306 Source Schema : otp Target Server Type : MySQL Target Server Version : 50520 File Encoding : 65001 Date: 07/04/2023 19:43:13 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for cart -- ---------------------------- DROP TABLE IF EXISTS `cart`; CREATE TABLE `cart` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '购物车编号', `uid` int(11) NULL DEFAULT NULL COMMENT '用户编号(外键)', `cid` int(11) NULL DEFAULT NULL COMMENT '物品编号(外键)', `cname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '物品名', `price` int(11) NULL DEFAULT NULL COMMENT '物品价格', `picture` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '物品图像', PRIMARY KEY (`id`) USING BTREE, INDEX `uid`(`uid`) USING BTREE, INDEX `cid`(`cid`) USING BTREE, INDEX `cname`(`cname`) USING BTREE, INDEX `price`(`price`) USING BTREE, INDEX `picture`(`picture`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 34 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of cart -- ---------------------------- INSERT INTO `cart` VALUES (23, 2022001, 100001, 'Zilli皮带', 388, '/otp/upload/commodity/1.jpg'); INSERT INTO `cart` VALUES (24, 2022001, 100002, 'Hermes皮带', 688, '/otp/upload/commodity/2.jpg'); INSERT INTO `cart` VALUES (25, 2022001, 100003, 'Berluti皮带', 468, '/otp/upload/commodity/3.jpg'); INSERT INTO `cart` VALUES (27, 2022001, 100020, 'Libbey水杯', 56, '/otp/upload/commodity/20.jpg'); INSERT INTO `cart` VALUES (29, 2022001, 100014, 'Reebok运动鞋', 568, '/otp/upload/commodity/14.jpg'); INSERT INTO `cart` VALUES (31, 2022001, 100015, 'Vans运动鞋', 288, '/otp/upload/commodity/15.jpg'); INSERT INTO `cart` VALUES (32, 2022001, 100021, '篮球', 88, '/otp/upload/commodity/21.jpg'); INSERT INTO `cart` VALUES (33, 2022001, 100027, '《西游记》', 78, '/otp/upload/commodity/27.jpg'); -- ---------------------------- -- Table structure for commodity -- ---------------------------- DROP TABLE IF EXISTS `commodity`; CREATE TABLE `commodity` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '物品id', `uid` int(11) NULL DEFAULT NULL COMMENT '用户id(外键)', `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '物品名', `price` int(10) NULL DEFAULT NULL COMMENT '物品价格', `miaoshu` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '物品描述', `picture` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '物品图片', PRIMARY KEY (`id`) USING BTREE, INDEX `uid2`(`uid`) USING BTREE, INDEX `name`(`name`) USING BTREE, INDEX `price`(`price`) USING BTREE, INDEX `picture`(`picture`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 100031 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of commodity -- ---------------------------- INSERT INTO `commodity` VALUES (100001, 2022000, 'Zilli皮带', 388, '珍惜皮制作', '/otp/upload/commodity/1.jpg'); INSERT INTO `commodity` VALUES (100002, 2022000, 'Hermes皮带', 688, '珍惜皮制作', '/otp/upload/commodity/2.jpg'); INSERT INTO `commodity` VALUES (100003, 2022000, 'Berluti皮带', 468, '珍惜皮制作', '/otp/upload/commodity/3.jpg'); INSERT INTO `commodity` VALUES (100004, 2022000, 'Gucci皮带', 368, '珍惜皮制作', '/otp/upload/commodity/4.jpg'); INSERT INTO `commodity` VALUES (100005, 2022000, 'Prada皮带', 568, '珍惜皮制作', '/otp/upload/commodity/5.jpg'); INSERT INTO `commodity` VALUES (100006, 2022001, 'Patagonia羽绒服', 406, '保暖，时尚', '/otp/upload/commodity/6.jpg'); INSERT INTO `commodity` VALUES (100007, 2022001, 'MAMMUT羽绒服', 398, '保暖，时尚', '/otp/upload/commodity/7.jpg'); INSERT INTO `commodity` VALUES (100008, 2022001, 'Moncler羽绒服', 3088, '保暖，时尚', '/otp/upload/commodity/8.jpg'); INSERT INTO `commodity` VALUES (100009, 2022001, 'Marmot羽绒服', 368, '保暖，时尚', '/otp/upload/commodity/9.jpg'); INSERT INTO `commodity` VALUES (100010, 2022001, 'DESCENTE羽绒服', 999, '保暖，时尚', '/otp/upload/commodity/10.jpg'); INSERT INTO `commodity` VALUES (100011, 2022002, 'NIKE运动鞋', 1088, '舒适感强', '/otp/upload/commodity/11.jpg'); INSERT INTO `commodity` VALUES (100012, 2022002, 'Adidas运动鞋', 688, '舒适感强', '/otp/upload/commodity/12.jpg'); INSERT INTO `commodity` VALUES (100013, 2022002, 'Puma运动鞋', 358, '舒适感强', '/otp/upload/commodity/13.jpg'); INSERT INTO `commodity` VALUES (100014, 2022002, 'Reebok运动鞋', 568, '舒适感强', '/otp/upload/commodity/14.jpg'); INSERT INTO `commodity` VALUES (100015, 2022002, 'Vans运动鞋', 288, '舒适感强', '/otp/upload/commodity/15.jpg'); INSERT INTO `commodity` VALUES (100016, 2022003, 'Fuguang水杯', 28, '款式简洁', '/otp/upload/commodity/16.jpg'); INSERT INTO `commodity` VALUES (100017, 2022003, 'Glasslock水杯', 36, '款式简洁', '/otp/upload/commodity/17.jpg'); INSERT INTO `commodity` VALUES (100018, 2022003, 'aderia水杯', 48, '款式简洁', '/otp/upload/commodity/18.jpg'); INSERT INTO `commodity` VALUES (100019, 2022003, 'Ocean水杯', 88, '款式简洁', '/otp/upload/commodity/19.jpg'); INSERT INTO `commodity` VALUES (100020, 2022003, 'Libbey水杯', 56, '款式简洁', '/otp/upload/commodity/20.jpg'); INSERT INTO `commodity` VALUES (100022, 2022004, '足球', 128, '实用性强', '/otp/upload/commodity/22.jpg'); INSERT INTO `commodity` VALUES (100023, 2022004, '乒乓球', 5, '实用性强', '/otp/upload/commodity/23.jpg'); INSERT INTO `commodity` VALUES (100024, 2022004, '羽毛球', 10, '实用性强', '/otp/upload/commodity/24.jpg'); INSERT INTO `commodity` VALUES (100025, 2022004, '网球', 12, '实用性强', '/otp/upload/commodity/25.jpg'); INSERT INTO `commodity` VALUES (100026, 2022005, '《红楼梦》', 88, '故事很精彩', '/otp/upload/commodity/26.jpg'); INSERT INTO `commodity` VALUES (100027, 2022005, '《西游记》', 78, '故事很精彩', '/otp/upload/commodity/27.jpg'); INSERT INTO `commodity` VALUES (100028, 2022005, '《水浒传》', 28, '故事很精彩', '/otp/upload/commodity/28.jpg'); INSERT INTO `commodity` VALUES (100029, 2022005, '《三国演义》', 38, '故事很精彩', '/otp/upload/commodity/29.jpg'); INSERT INTO `commodity` VALUES (100030, 2022005, '《白蛇传》', 58, '故事很精彩', '/otp/upload/commodity/30.jpg'); -- ---------------------------- -- Table structure for uorder -- ---------------------------- DROP TABLE IF EXISTS `uorder`; CREATE TABLE `uorder` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '订单编号', `uid` int(11) NULL DEFAULT NULL COMMENT '用户编号(外键)', `cid` int(11) NULL DEFAULT NULL COMMENT '物品编号(外键)', `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '交易类型(购买/交换)', `tradingtime` datetime NULL DEFAULT NULL COMMENT '交易时间', `money` int(11) NULL DEFAULT NULL COMMENT '价格', `comment` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '评价', PRIMARY KEY (`id`) USING BTREE, INDEX `uid1`(`uid`) USING BTREE, INDEX `cid1`(`cid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 46 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of uorder -- ---------------------------- INSERT INTO `uorder` VALUES (34, 2022001, 100004, '购买', '2022-04-24 16:06:04', 368, '还可以吧'); INSERT INTO `uord