springBoot,mybatisPlus购物商城项目,大学生毕业设计必备!!!

 本次项目的所有mapper,controller,service以及xml文件都由文件生成器一键生成。

不懂得同学可以参考我讲解得mybatisPlus的使用:

https://blog.csdn.net/d2916172682/article/details/135030318?spm=1001.2014.3001.5501

1.项目准备

数据库文件

-- MySQL dump 10.13  Distrib 8.0.25, for Win64 (x86_64)
--
-- Host: 127.0.0.1    Database: easyshop
-- ------------------------------------------------------
-- Server version	8.0.25

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;

--
-- Table structure for table `t_dict_data`
--

DROP TABLE IF EXISTS `t_dict_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `t_dict_data` (
  `dict_code` bigint NOT NULL COMMENT '字典编码',
  `dict_label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '字典标签',
  `dict_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '字典键值',
  `dict_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '字典类型',
  `dict_sort` int DEFAULT NULL COMMENT '字典排序',
  PRIMARY KEY (`dict_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_dict_data`
--

LOCK TABLES `t_dict_data` WRITE;
/*!40000 ALTER TABLE `t_dict_data` DISABLE KEYS */;
INSERT INTO `t_dict_data` VALUES (1,'装饰摆件','01','goods_type',1),(2,'干花花艺','02','goods_type',2),(3,'花瓶花器','03','goods_type',3),(4,'布艺软饰','04','goods_type',4),(5,'桌布罩件','05','goods_type',5),(6,'抱枕靠垫','06','goods_type',6),(7,'墙式壁挂','07','goods_type',7),(8,'蜡艺香薰','08','goods_type',8),(9,'创意家居','09','goods_type',9);
/*!40000 ALTER TABLE `t_dict_data` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_dict_type`
--

DROP TABLE IF EXISTS `t_dict_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `t_dict_type` (
  `dict_id` int NOT NULL AUTO_INCREMENT COMMENT '唯一标识',
  `dict_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '字典名称',
  `dict_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '字典类型',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '状态(0=正常,1=停用)',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '字典描述',
  PRIMARY KEY (`dict_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_dict_type`
--

LOCK TABLES `t_dict_type` WRITE;
/*!40000 ALTER TABLE `t_dict_type` DISABLE KEYS */;
INSERT INTO `t_dict_type` VALUES (1,'商品类型','goods_type','0','商品类型列表');
/*!40000 ALTER TABLE `t_dict_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_goods`
--

DROP TABLE IF EXISTS `t_goods`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `t_goods` (
  `gid` bigint NOT NULL AUTO_INCREMENT COMMENT '商品ID',
  `goods_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '商品名称',
  `goods_title` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '商品标题',
  `goods_img` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '商品图片',
  `goods_detail` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '商品详情',
  `goods_price` decimal(10,2) DEFAULT NULL COMMENT '商品价格',
  `goods_stock` int DEFAULT '0' COMMENT '商品库存',
  `goods_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '商品类型',
  PRIMARY KEY (`gid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='商品信息表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_goods`
--

LOCK TABLES `t_goods` WRITE;
/*!40000 ALTER TABLE `t_goods` DISABLE KEYS */;
INSERT INTO `t_goods` VALUES (1,'【花艺】七头美丽玫瑰仿真花束1','【花艺】七头美丽玫瑰仿真花束1','img/flo1.jpg','【花艺】七头美丽玫瑰仿真花束1',79.00,80,'01'),(2,'【花艺】七头美丽玫瑰仿真花束2','【花艺】七头美丽玫瑰仿真花束2','img/flo2.jpg','【花艺】七头美丽玫瑰仿真花束2',79.00,50,'01'),(3,'【花艺】七头美丽玫瑰仿真花束3','【花艺】七头美丽玫瑰仿真花束3','img/flo3.jpg','【花艺】七头美丽玫瑰仿真花束3',99.00,50,'01'),(4,'【花艺】七头美丽玫瑰仿真花束4','【花艺】七头美丽玫瑰仿真花束4','img/flo4.jpg','【花艺】七头美丽玫瑰仿真花束4',99.00,30,'01'),(5,'【花艺】七头美丽玫瑰仿真花束5','【花艺】七头美丽玫瑰仿真花束5','img/flo5.jpg','【花艺】七头美丽玫瑰仿真花束5',100.00,50,'01'),(6,'【花艺】七头美丽玫瑰仿真花束6','【花艺】七头美丽玫瑰仿真花束6','img/flo6.jpg','【花艺】七头美丽玫瑰仿真花束6',199.00,20,'01'),(13,'【最家】不锈钢壁饰墙饰软装','【最家】不锈钢壁饰墙饰软装','img/s7.jpg','【最家】不锈钢壁饰墙饰软装',688.00,10,'07'),(14,'【最家】小城动物木板画壁挂北欧','【最家】小城动物木板画壁挂北欧','img/s10.jpg','【最家】小城动物木板画壁挂北欧',188.00,10,'07'),(15,'【最家】玄关假山水壁饰背景墙饰挂件创意','【最家】玄关假山水壁饰背景墙饰挂件创意','img/s4.jpg','【最家】玄关假山水壁饰背景墙饰挂件创意',599.00,10,'07'),(16,'【最家】金属树枝壁饰铜鸟装饰品','【最家】金属树枝壁饰铜鸟装饰品','img/s9.jpg','【最家】金属树枝壁饰铜鸟装饰品',928.00,10,'07'),(17,'【最家】金属壁饰创意背景墙面挂件创意','【最家】金属壁饰创意背景墙面挂件创意','img/s6.jpg','【最家】金属壁饰创意背景墙面挂件创意',228.00,10,'07'),(18,'【最家】小城动物木板画壁挂北欧','【最家】小城动物木板画壁挂北欧','img/s8.jpg','【最家】小城动物木板画壁挂北欧',199.00,10,'07'),(19,'【最家】欧式复古挂钟创意餐厅钟表家居挂件','【最家】欧式复古挂钟创意餐厅钟表家居挂件','img/s12.jpg','【最家】欧式复古挂钟创意餐厅钟表家居挂件',666.00,10,'07'),(20,'【最家】客厅地中海欧式现代相片墙创意','【最家】客厅地中海欧式现代相片墙创意','img/s1.jpg','【最家】客厅地中海欧式现代相片墙创意',59.80,10,'07'),(21,'【最家】铁艺荷叶壁挂软装背景墙上装饰品','【最家】铁艺荷叶壁挂软装背景墙上装饰品','img/s5.jpg','【最家】铁艺荷叶壁挂软装背景墙上装饰品',800.00,10,'07'),(22,'【最家】欧式照片墙 创意组合结婚礼物','【最家】欧式照片墙 创意组合结婚礼物','img/s3.jpg','【最家】欧式照片墙 创意组合结婚礼物',189.00,10,'07'),(23,'【最家】欧式钟表相框墙挂墙创意组合','【最家】欧式钟表相框墙挂墙创意组合','img/s2.jpg','【最家】欧式钟表相框墙挂墙创意组合',148.00,10,'07'),(24,'【最家】小城动物木板画壁挂北欧','【最家】小城动物木板画壁挂北欧','img/s11.jpg','【最家】小城动物木板画壁挂北欧',188.00,10,'07');
/*!40000 ALTER TABLE `t_goods` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_order`
--

DROP TABLE IF EXISTS `t_order`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `t_order` (
  `oid` bigint NOT NULL COMMENT '订单ID',
  `user_id` bigint DEFAULT NULL COMMENT '用户ID',
  `address` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '收货地址',
  `person` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '收货人',
  `telephone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '联系电话',
  `total` decimal(10,2) DEFAULT NULL COMMENT '商品总价',
  `pay` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '1' COMMENT '支付方式,外键,来自于字典数据表',
  `mail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '邮寄方式,外键,来自于字典数据表',
  `status` tinyint DEFAULT '0' COMMENT '订单状态,0=创建未支付,1=已支付,2=已取消,3=已发货,4=已退款,5=已完成',
  `create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '订单创建时间',
  `pay_date` timestamp NULL DEFAULT NULL COMMENT '支付时间',
  PRIMARY KEY (`oid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='订单信息表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_order`
--

LOCK TABLES `t_order` WRITE;
/*!40000 ALTER TABLE `t_order` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_order` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_order_item`
--

DROP TABLE IF EXISTS `t_order_item`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `t_order_item` (
  `ooid` bigint NOT NULL COMMENT '订单项ID',
  `oid` bigint DEFAULT NULL COMMENT '订单ID',
  `gid` bigint DEFAULT NULL COMMENT '商品ID',
  `goods_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '商品名称',
  `goods_price` decimal(10,2) DEFAULT NULL COMMENT '商品单价',
  `quantity` int DEFAULT NULL COMMENT '商品数量',
  PRIMARY KEY (`ooid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_order_item`
--

LOCK TABLES `t_order_item` WRITE;
/*!40000 ALTER TABLE `t_order_item` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_order_item` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_user`
--

DROP TABLE IF EXISTS `t_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `t_user` (
  `id` bigint NOT NULL COMMENT '用户ID,手机号码',
  `nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '昵称',
  `password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'MD5(MD5(pass明文+固定salt)+salt)',
  `salt` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '随机salt',
  `register_date` timestamp NULL DEFAULT NULL COMMENT '注册时间',
  `last_login_date` timestamp NULL DEFAULT NULL COMMENT '最后一次登录时间',
  `login_count` int DEFAULT '0' COMMENT '登录次数',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='用户信息表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_user`
--

LOCK TABLES `t_user` WRITE;
/*!40000 ALTER TABLE `t_user` DISABLE KEYS */;
INSERT INTO `t_user` VALUES (17712345678,'小胖','624104883008ed3018caad7519c78427','ea3a166cf72c43ae9e1af88c4a3f4763','2021-12-10 10:36:56',NULL,0),(18012345678,'招财猫','2ccdb502030dd46e59a1444770fe37bd','fef9d4cef08945a883a2c8e7942e007e','2021-05-14 06:38:09',NULL,0);
/*!40000 ALTER TABLE `t_user` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2023-12-27 11:03:44

 完整的项目和源码点我私信

  • 15
    点赞
  • 7
    收藏
    觉得还不错? 一键收藏
  • 1
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值