wordpress网站主题插件,做合法的海外购网站需要什么手续,中国纪检监察报网站,常州建站程序博主介绍#xff1a; ✌我是阿龙#xff0c;一名专注于Java技术领域的程序员#xff0c;全网拥有10W粉丝。作为CSDN特邀作者、博客专家、新星计划导师#xff0c;我在计算机毕业设计开发方面积累了丰富的经验。同时#xff0c;我也是掘金、华为云、阿里云、InfoQ等平台… 博主介绍 ✌我是阿龙一名专注于Java技术领域的程序员全网拥有10W粉丝。作为CSDN特邀作者、博客专家、新星计划导师我在计算机毕业设计开发方面积累了丰富的经验。同时我也是掘金、华为云、阿里云、InfoQ等平台的优质作者。通过长期分享和实战指导我致力于帮助更多学生完成毕业项目和技术提升。 技术范围 我熟悉的技术领域涵盖SpringBoot、Vue、SSM、HLMT、Jsp、PHP、Nodejs、Python、爬虫、数据可视化、小程序、安卓app、大数据、物联网、机器学习等方面的设计与开发。如果你有任何技术难题我都乐意与你分享解决方案。 主要内容 我的服务内容包括免费功能设计、开题报告、任务书、中期检查PPT、系统功能实现、代码编写、论文撰写与辅导、论文降重、长期答辩答疑辅导。此外我还提供腾讯会议一对一的专业讲解和模拟答辩演练帮助你全面掌握答辩技巧与代码逻辑。 获取源码请在文末联系我 如果你对我的内容感兴趣记得先收藏对于毕设选题、项目开发或论文撰写等相关问题随时欢迎留言咨询我会尽力帮助更多同学顺利完成学业。 最主要的是免费咨询相关问题 系统详细介绍 核心实现代码 package com.config;import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;import com.baomidou.mybatisplus.mapper.MetaObjectHandler;
import com.baomidou.mybatisplus.plugins.PaginationInterceptor;/*** mybatis-plus配置*/
Configuration
public class MybatisPlusConfig {/*** 分页插件*/Beanpublic PaginationInterceptor paginationInterceptor() {return new PaginationInterceptor();}}核心数据库代码
-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64)
--
-- Host: localhost Database: springbootyo546uz0
-- ------------------------------------------------------
-- Server version 5.7.31/*!40101 SET OLD_CHARACTER_SET_CLIENTCHARACTER_SET_CLIENT */;
/*!40101 SET OLD_CHARACTER_SET_RESULTSCHARACTER_SET_RESULTS */;
/*!40101 SET OLD_COLLATION_CONNECTIONCOLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET OLD_TIME_ZONETIME_ZONE */;
/*!40103 SET TIME_ZONE00:00 */;
/*!40014 SET OLD_UNIQUE_CHECKSUNIQUE_CHECKS, UNIQUE_CHECKS0 */;
/*!40014 SET OLD_FOREIGN_KEY_CHECKSFOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS0 */;
/*!40101 SET OLD_SQL_MODESQL_MODE, SQL_MODENO_AUTO_VALUE_ON_ZERO */;
/*!40111 SET OLD_SQL_NOTESSQL_NOTES, SQL_NOTES0 */;--
-- Current Database: springbootyo546uz0
--/*!40000 DROP DATABASE IF EXISTS springbootyo546uz0*/;CREATE DATABASE /*!32312 IF NOT EXISTS*/ springbootyo546uz0 /*!40100 DEFAULT CHARACTER SET utf8mb4 */;USE springbootyo546uz0;--
-- Table structure for table address
--DROP TABLE IF EXISTS address;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE address (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,userid bigint(20) NOT NULL COMMENT 用户id,address varchar(200) NOT NULL COMMENT 地址,name varchar(200) NOT NULL COMMENT 收货人,phone varchar(200) NOT NULL COMMENT 电话,isdefault varchar(200) NOT NULL COMMENT 是否默认地址[是/否],PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT9 DEFAULT CHARSETutf8 COMMENT地址;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table address
--LOCK TABLES address WRITE;
/*!40000 ALTER TABLE address DISABLE KEYS */;
INSERT INTO address VALUES (1,2024-03-10 14:52:16,11,宇宙银河系金星1号,金某,13823888881,是),(2,2024-03-10 14:52:16,12,宇宙银河系木星1号,木某,13823888882,是),(3,2024-03-10 14:52:16,13,宇宙银河系水星1号,水某,13823888883,是),(4,2024-03-10 14:52:16,14,宇宙银河系火星1号,火某,13823888884,是),(5,2024-03-10 14:52:16,15,宇宙银河系土星1号,土某,13823888885,是),(6,2024-03-10 14:52:16,16,宇宙银河系月球1号,月某,13823888886,是),(7,2024-03-10 14:52:16,17,宇宙银河系黑洞1号,黑某,13823888887,是),(8,2024-03-10 14:52:16,18,宇宙银河系地球1号,地某,13823888888,是);
/*!40000 ALTER TABLE address ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table cart
--DROP TABLE IF EXISTS cart;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE cart (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,tablename varchar(200) DEFAULT shangpin COMMENT 商品表名,userid bigint(20) NOT NULL COMMENT 用户id,goodid bigint(20) NOT NULL COMMENT 商品id,goodname varchar(200) DEFAULT NULL COMMENT 商品名称,picture longtext COMMENT 图片,buynumber int(11) NOT NULL COMMENT 购买数量,price double DEFAULT NULL COMMENT 单价,PRIMARY KEY (id)
) ENGINEInnoDB DEFAULT CHARSETutf8 COMMENT购物车表;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table cart
--LOCK TABLES cart WRITE;
/*!40000 ALTER TABLE cart DISABLE KEYS */;
/*!40000 ALTER TABLE cart ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table chat
--DROP TABLE IF EXISTS chat;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE chat (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,userid bigint(20) NOT NULL COMMENT 用户id,adminid bigint(20) DEFAULT NULL COMMENT 管理员id,ask longtext COMMENT 提问,reply longtext COMMENT 回复,isreply int(11) DEFAULT NULL COMMENT 是否回复,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT89 DEFAULT CHARSETutf8 COMMENT在线咨询;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table chat
--LOCK TABLES chat WRITE;
/*!40000 ALTER TABLE chat DISABLE KEYS */;
INSERT INTO chat VALUES (81,2024-03-10 14:52:16,1,1,提问1,回复1,1),(82,2024-03-10 14:52:16,2,2,提问2,回复2,2),(83,2024-03-10 14:52:16,3,3,提问3,回复3,3),(84,2024-03-10 14:52:16,4,4,提问4,回复4,4),(85,2024-03-10 14:52:16,5,5,提问5,回复5,5),(86,2024-03-10 14:52:16,6,6,提问6,回复6,6),(87,2024-03-10 14:52:16,7,7,提问7,回复7,7),(88,2024-03-10 14:52:16,8,8,提问8,回复8,8);
/*!40000 ALTER TABLE chat ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table chathelper
--DROP TABLE IF EXISTS chathelper;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE chathelper (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,ask varchar(200) DEFAULT NULL COMMENT 提问,reply longtext COMMENT 回复,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT99 DEFAULT CHARSETutf8 COMMENT聊天助手表;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table chathelper
--LOCK TABLES chathelper WRITE;
/*!40000 ALTER TABLE chathelper DISABLE KEYS */;
INSERT INTO chathelper VALUES (91,2024-03-10 14:52:16,提问1,回复1),(92,2024-03-10 14:52:16,提问2,回复2),(93,2024-03-10 14:52:16,提问3,回复3),(94,2024-03-10 14:52:16,提问4,回复4),(95,2024-03-10 14:52:16,提问5,回复5),(96,2024-03-10 14:52:16,提问6,回复6),(97,2024-03-10 14:52:16,提问7,回复7),(98,2024-03-10 14:52:16,提问8,回复8);
/*!40000 ALTER TABLE chathelper ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table config
--DROP TABLE IF EXISTS config;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE config (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,name varchar(100) NOT NULL COMMENT 配置参数名称,value varchar(100) DEFAULT NULL COMMENT 配置参数值,url varchar(500) DEFAULT NULL COMMENT url,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT4 DEFAULT CHARSETutf8 COMMENT配置文件;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table config
--LOCK TABLES config WRITE;
/*!40000 ALTER TABLE config DISABLE KEYS */;
INSERT INTO config VALUES (1,picture1,upload/picture1.jpg,NULL),(2,picture2,upload/picture2.jpg,NULL),(3,picture3,upload/picture3.jpg,NULL);
/*!40000 ALTER TABLE config ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table cuxiaoshangpin
--DROP TABLE IF EXISTS cuxiaoshangpin;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE cuxiaoshangpin (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,shangpinmingcheng varchar(200) DEFAULT NULL COMMENT 商品名称,shangpinleibie varchar(200) DEFAULT NULL COMMENT 商品类别,shangpintupian longtext COMMENT 商品图片,shangpinguige varchar(200) DEFAULT NULL COMMENT 商品规格,shangpinxiangqing longtext COMMENT 商品详情,onelimittimes int(11) DEFAULT NULL COMMENT 单限,alllimittimes int(11) DEFAULT NULL COMMENT 库存,discussnum int(11) DEFAULT 0 COMMENT 评论数,price double NOT NULL COMMENT 价格,storeupnum int(11) DEFAULT 0 COMMENT 收藏数,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT49 DEFAULT CHARSETutf8 COMMENT促销商品;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table cuxiaoshangpin
--LOCK TABLES cuxiaoshangpin WRITE;
/*!40000 ALTER TABLE cuxiaoshangpin DISABLE KEYS */;
INSERT INTO cuxiaoshangpin VALUES (41,2024-03-10 14:52:16,商品名称1,商品类别1,upload/cuxiaoshangpin_shangpintupian1.jpg,upload/cuxiaoshangpin_shangpintupian2.jpg,upload/cuxiaoshangpin_shangpintupian3.jpg,商品规格1,商品详情1,1,99,0,99.9,1),(42,2024-03-10 14:52:16,商品名称2,商品类别2,upload/cuxiaoshangpin_shangpintupian2.jpg,upload/cuxiaoshangpin_shangpintupian3.jpg,upload/cuxiaoshangpin_shangpintupian4.jpg,商品规格2,商品详情2,2,99,0,99.9,2),(43,2024-03-10 14:52:16,商品名称3,商品类别3,upload/cuxiaoshangpin_shangpintupian3.jpg,upload/cuxiaoshangpin_shangpintupian4.jpg,upload/cuxiaoshangpin_shangpintupian5.jpg,商品规格3,商品详情3,3,99,0,99.9,3),(44,2024-03-10 14:52:16,商品名称4,商品类别4,upload/cuxiaoshangpin_shangpintupian4.jpg,upload/cuxiaoshangpin_shangpintupian5.jpg,upload/cuxiaoshangpin_shangpintupian6.jpg,商品规格4,商品详情4,4,99,0,99.9,4),(45,2024-03-10 14:52:16,商品名称5,商品类别5,upload/cuxiaoshangpin_shangpintupian5.jpg,upload/cuxiaoshangpin_shangpintupian6.jpg,upload/cuxiaoshangpin_shangpintupian7.jpg,商品规格5,商品详情5,5,99,0,99.9,5),(46,2024-03-10 14:52:16,商品名称6,商品类别6,upload/cuxiaoshangpin_shangpintupian6.jpg,upload/cuxiaoshangpin_shangpintupian7.jpg,upload/cuxiaoshangpin_shangpintupian8.jpg,商品规格6,商品详情6,6,99,0,99.9,6),(47,2024-03-10 14:52:16,商品名称7,商品类别7,upload/cuxiaoshangpin_shangpintupian7.jpg,upload/cuxiaoshangpin_shangpintupian8.jpg,upload/cuxiaoshangpin_shangpintupian9.jpg,商品规格7,商品详情7,7,99,0,99.9,7),(48,2024-03-10 14:52:16,商品名称8,商品类别8,upload/cuxiaoshangpin_shangpintupian8.jpg,upload/cuxiaoshangpin_shangpintupian9.jpg,upload/cuxiaoshangpin_shangpintupian10.jpg,商品规格8,商品详情8,8,99,0,99.9,8);
/*!40000 ALTER TABLE cuxiaoshangpin ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table discusscuxiaoshangpin
--DROP TABLE IF EXISTS discusscuxiaoshangpin;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE discusscuxiaoshangpin (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,refid bigint(20) NOT NULL COMMENT 关联表id,userid bigint(20) NOT NULL COMMENT 用户id,avatarurl longtext COMMENT 头像,nickname varchar(200) DEFAULT NULL COMMENT 用户名,content longtext NOT NULL COMMENT 评论内容,reply longtext COMMENT 回复内容,PRIMARY KEY (id)
) ENGINEInnoDB DEFAULT CHARSETutf8 COMMENT促销商品评论表;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table discusscuxiaoshangpin
--LOCK TABLES discusscuxiaoshangpin WRITE;
/*!40000 ALTER TABLE discusscuxiaoshangpin DISABLE KEYS */;
/*!40000 ALTER TABLE discusscuxiaoshangpin ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table discussjiuwufenxiang
--DROP TABLE IF EXISTS discussjiuwufenxiang;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE discussjiuwufenxiang (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,refid bigint(20) NOT NULL COMMENT 关联表id,userid bigint(20) NOT NULL COMMENT 用户id,avatarurl longtext COMMENT 头像,nickname varchar(200) DEFAULT NULL COMMENT 用户名,content longtext NOT NULL COMMENT 评论内容,reply longtext COMMENT 回复内容,PRIMARY KEY (id)
) ENGINEInnoDB DEFAULT CHARSETutf8 COMMENT旧物分享评论表;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table discussjiuwufenxiang
--LOCK TABLES discussjiuwufenxiang WRITE;
/*!40000 ALTER TABLE discussjiuwufenxiang DISABLE KEYS */;
/*!40000 ALTER TABLE discussjiuwufenxiang ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table discussrexiaoshangpin
--DROP TABLE IF EXISTS discussrexiaoshangpin;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE discussrexiaoshangpin (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,refid bigint(20) NOT NULL COMMENT 关联表id,userid bigint(20) NOT NULL COMMENT 用户id,avatarurl longtext COMMENT 头像,nickname varchar(200) DEFAULT NULL COMMENT 用户名,content longtext NOT NULL COMMENT 评论内容,reply longtext COMMENT 回复内容,PRIMARY KEY (id)
) ENGINEInnoDB DEFAULT CHARSETutf8 COMMENT热销商品评论表;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table discussrexiaoshangpin
--LOCK TABLES discussrexiaoshangpin WRITE;
/*!40000 ALTER TABLE discussrexiaoshangpin DISABLE KEYS */;
/*!40000 ALTER TABLE discussrexiaoshangpin ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table discussshangpin
--DROP TABLE IF EXISTS discussshangpin;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE discussshangpin (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,refid bigint(20) NOT NULL COMMENT 关联表id,userid bigint(20) NOT NULL COMMENT 用户id,avatarurl longtext COMMENT 头像,nickname varchar(200) DEFAULT NULL COMMENT 用户名,content longtext NOT NULL COMMENT 评论内容,reply longtext COMMENT 回复内容,PRIMARY KEY (id)
) ENGINEInnoDB DEFAULT CHARSETutf8 COMMENT商品评论表;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table discussshangpin
--LOCK TABLES discussshangpin WRITE;
/*!40000 ALTER TABLE discussshangpin DISABLE KEYS */;
/*!40000 ALTER TABLE discussshangpin ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table discusszuixinshangpin
--DROP TABLE IF EXISTS discusszuixinshangpin;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE discusszuixinshangpin (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,refid bigint(20) NOT NULL COMMENT 关联表id,userid bigint(20) NOT NULL COMMENT 用户id,avatarurl longtext COMMENT 头像,nickname varchar(200) DEFAULT NULL COMMENT 用户名,content longtext NOT NULL COMMENT 评论内容,reply longtext COMMENT 回复内容,PRIMARY KEY (id)
) ENGINEInnoDB DEFAULT CHARSETutf8 COMMENT最新商品评论表;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table discusszuixinshangpin
--LOCK TABLES discusszuixinshangpin WRITE;
/*!40000 ALTER TABLE discusszuixinshangpin DISABLE KEYS */;
/*!40000 ALTER TABLE discusszuixinshangpin ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table jiuwufenxiang
--DROP TABLE IF EXISTS jiuwufenxiang;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE jiuwufenxiang (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,wupinmingcheng varchar(200) DEFAULT NULL COMMENT 物品名称,shangpinleibie varchar(200) DEFAULT NULL COMMENT 商品类别,wupintupian longtext COMMENT 物品图片,wupinjianjie longtext COMMENT 物品简介,shipin longtext COMMENT 视频,jiage int(11) DEFAULT NULL COMMENT 价格,weixinlianxifangshi varchar(200) DEFAULT NULL COMMENT 微信联系方式,yonghuzhanghao varchar(200) DEFAULT NULL COMMENT 用户账号,xingming varchar(200) DEFAULT NULL COMMENT 姓名,discussnum int(11) DEFAULT 0 COMMENT 评论数,storeupnum int(11) DEFAULT 0 COMMENT 收藏数,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT79 DEFAULT CHARSETutf8 COMMENT旧物分享;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table jiuwufenxiang
--LOCK TABLES jiuwufenxiang WRITE;
/*!40000 ALTER TABLE jiuwufenxiang DISABLE KEYS */;
INSERT INTO jiuwufenxiang VALUES (71,2024-03-10 14:52:16,物品名称1,商品类别1,upload/jiuwufenxiang_wupintupian1.jpg,upload/jiuwufenxiang_wupintupian2.jpg,upload/jiuwufenxiang_wupintupian3.jpg,物品简介1,,1,微信联系方式1,用户账号1,姓名1,0,1),(72,2024-03-10 14:52:16,物品名称2,商品类别2,upload/jiuwufenxiang_wupintupian2.jpg,upload/jiuwufenxiang_wupintupian3.jpg,upload/jiuwufenxiang_wupintupian4.jpg,物品简介2,,2,微信联系方式2,用户账号2,姓名2,0,2),(73,2024-03-10 14:52:16,物品名称3,商品类别3,upload/jiuwufenxiang_wupintupian3.jpg,upload/jiuwufenxiang_wupintupian4.jpg,upload/jiuwufenxiang_wupintupian5.jpg,物品简介3,,3,微信联系方式3,用户账号3,姓名3,0,3),(74,2024-03-10 14:52:16,物品名称4,商品类别4,upload/jiuwufenxiang_wupintupian4.jpg,upload/jiuwufenxiang_wupintupian5.jpg,upload/jiuwufenxiang_wupintupian6.jpg,物品简介4,,4,微信联系方式4,用户账号4,姓名4,0,4),(75,2024-03-10 14:52:16,物品名称5,商品类别5,upload/jiuwufenxiang_wupintupian5.jpg,upload/jiuwufenxiang_wupintupian6.jpg,upload/jiuwufenxiang_wupintupian7.jpg,物品简介5,,5,微信联系方式5,用户账号5,姓名5,0,5),(76,2024-03-10 14:52:16,物品名称6,商品类别6,upload/jiuwufenxiang_wupintupian6.jpg,upload/jiuwufenxiang_wupintupian7.jpg,upload/jiuwufenxiang_wupintupian8.jpg,物品简介6,,6,微信联系方式6,用户账号6,姓名6,0,6),(77,2024-03-10 14:52:16,物品名称7,商品类别7,upload/jiuwufenxiang_wupintupian7.jpg,upload/jiuwufenxiang_wupintupian8.jpg,upload/jiuwufenxiang_wupintupian9.jpg,物品简介7,,7,微信联系方式7,用户账号7,姓名7,0,7),(78,2024-03-10 14:52:16,物品名称8,商品类别8,upload/jiuwufenxiang_wupintupian8.jpg,upload/jiuwufenxiang_wupintupian9.jpg,upload/jiuwufenxiang_wupintupian10.jpg,物品简介8,,8,微信联系方式8,用户账号8,姓名8,0,8);
/*!40000 ALTER TABLE jiuwufenxiang ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table orders
--DROP TABLE IF EXISTS orders;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE orders (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,orderid varchar(200) NOT NULL COMMENT 订单编号,tablename varchar(200) DEFAULT shangpin COMMENT 商品表名,userid bigint(20) NOT NULL COMMENT 用户id,goodid bigint(20) NOT NULL COMMENT 商品id,goodname varchar(200) DEFAULT NULL COMMENT 商品名称,picture longtext COMMENT 商品图片,buynumber int(11) NOT NULL COMMENT 购买数量,price double NOT NULL DEFAULT 0 COMMENT 价格,total double NOT NULL DEFAULT 0 COMMENT 总价格,type int(11) DEFAULT 1 COMMENT 支付类型,status varchar(200) DEFAULT NULL COMMENT 状态,address varchar(200) DEFAULT NULL COMMENT 地址,tel varchar(200) DEFAULT NULL COMMENT 电话,consignee varchar(200) DEFAULT NULL COMMENT 收货人,logistics longtext COMMENT 物流,remark varchar(200) DEFAULT NULL COMMENT 备注,sfsh varchar(200) DEFAULT COMMENT 是否审核,shhf longtext COMMENT 审核回复,role varchar(200) DEFAULT NULL COMMENT 用户角色,PRIMARY KEY (id),UNIQUE KEY orderid (orderid)
) ENGINEInnoDB DEFAULT CHARSETutf8 COMMENT订单;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table orders
--LOCK TABLES orders WRITE;
/*!40000 ALTER TABLE orders DISABLE KEYS */;
/*!40000 ALTER TABLE orders ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table rexiaoshangpin
--DROP TABLE IF EXISTS rexiaoshangpin;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE rexiaoshangpin (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,shangpinmingcheng varchar(200) DEFAULT NULL COMMENT 商品名称,shangpinleibie varchar(200) DEFAULT NULL COMMENT 商品类别,shangpintupian longtext COMMENT 商品图片,shangpinguige varchar(200) DEFAULT NULL COMMENT 商品规格,shangpinxiangqing longtext COMMENT 商品详情,onelimittimes int(11) DEFAULT NULL COMMENT 单限,alllimittimes int(11) DEFAULT NULL COMMENT 库存,discussnum int(11) DEFAULT 0 COMMENT 评论数,price double NOT NULL COMMENT 价格,storeupnum int(11) DEFAULT 0 COMMENT 收藏数,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT29 DEFAULT CHARSETutf8 COMMENT热销商品;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table rexiaoshangpin
--LOCK TABLES rexiaoshangpin WRITE;
/*!40000 ALTER TABLE rexiaoshangpin DISABLE KEYS */;
INSERT INTO rexiaoshangpin VALUES (21,2024-03-10 14:52:16,商品名称1,商品类别1,upload/rexiaoshangpin_shangpintupian1.jpg,upload/rexiaoshangpin_shangpintupian2.jpg,upload/rexiaoshangpin_shangpintupian3.jpg,商品规格1,商品详情1,1,99,0,99.9,1),(22,2024-03-10 14:52:16,商品名称2,商品类别2,upload/rexiaoshangpin_shangpintupian2.jpg,upload/rexiaoshangpin_shangpintupian3.jpg,upload/rexiaoshangpin_shangpintupian4.jpg,商品规格2,商品详情2,2,99,0,99.9,2),(23,2024-03-10 14:52:16,商品名称3,商品类别3,upload/rexiaoshangpin_shangpintupian3.jpg,upload/rexiaoshangpin_shangpintupian4.jpg,upload/rexiaoshangpin_shangpintupian5.jpg,商品规格3,商品详情3,3,99,0,99.9,3),(24,2024-03-10 14:52:16,商品名称4,商品类别4,upload/rexiaoshangpin_shangpintupian4.jpg,upload/rexiaoshangpin_shangpintupian5.jpg,upload/rexiaoshangpin_shangpintupian6.jpg,商品规格4,商品详情4,4,99,0,99.9,4),(25,2024-03-10 14:52:16,商品名称5,商品类别5,upload/rexiaoshangpin_shangpintupian5.jpg,upload/rexiaoshangpin_shangpintupian6.jpg,upload/rexiaoshangpin_shangpintupian7.jpg,商品规格5,商品详情5,5,99,0,99.9,5),(26,2024-03-10 14:52:16,商品名称6,商品类别6,upload/rexiaoshangpin_shangpintupian6.jpg,upload/rexiaoshangpin_shangpintupian7.jpg,upload/rexiaoshangpin_shangpintupian8.jpg,商品规格6,商品详情6,6,99,0,99.9,6),(27,2024-03-10 14:52:16,商品名称7,商品类别7,upload/rexiaoshangpin_shangpintupian7.jpg,upload/rexiaoshangpin_shangpintupian8.jpg,upload/rexiaoshangpin_shangpintupian9.jpg,商品规格7,商品详情7,7,99,0,99.9,7),(28,2024-03-10 14:52:16,商品名称8,商品类别8,upload/rexiaoshangpin_shangpintupian8.jpg,upload/rexiaoshangpin_shangpintupian9.jpg,upload/rexiaoshangpin_shangpintupian10.jpg,商品规格8,商品详情8,8,99,0,99.9,8);
/*!40000 ALTER TABLE rexiaoshangpin ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table shangpin
--DROP TABLE IF EXISTS shangpin;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE shangpin (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,shangpinmingcheng varchar(200) DEFAULT NULL COMMENT 商品名称,shangpinleibie varchar(200) DEFAULT NULL COMMENT 商品类别,shangpintupian longtext COMMENT 商品图片,shangpinguige varchar(200) DEFAULT NULL COMMENT 商品规格,shangpinxiangqing longtext COMMENT 商品详情,onelimittimes int(11) DEFAULT NULL COMMENT 单限,alllimittimes int(11) DEFAULT NULL COMMENT 库存,discussnum int(11) DEFAULT 0 COMMENT 评论数,price double NOT NULL COMMENT 价格,storeupnum int(11) DEFAULT 0 COMMENT 收藏数,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT69 DEFAULT CHARSETutf8 COMMENT商品;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table shangpin
--LOCK TABLES shangpin WRITE;
/*!40000 ALTER TABLE shangpin DISABLE KEYS */;
INSERT INTO shangpin VALUES (61,2024-03-10 14:52:16,商品名称1,商品类别1,upload/shangpin_shangpintupian1.jpg,upload/shangpin_shangpintupian2.jpg,upload/shangpin_shangpintupian3.jpg,商品规格1,商品详情1,1,99,0,99.9,1),(62,2024-03-10 14:52:16,商品名称2,商品类别2,upload/shangpin_shangpintupian2.jpg,upload/shangpin_shangpintupian3.jpg,upload/shangpin_shangpintupian4.jpg,商品规格2,商品详情2,2,99,0,99.9,2),(63,2024-03-10 14:52:16,商品名称3,商品类别3,upload/shangpin_shangpintupian3.jpg,upload/shangpin_shangpintupian4.jpg,upload/shangpin_shangpintupian5.jpg,商品规格3,商品详情3,3,99,0,99.9,3),(64,2024-03-10 14:52:16,商品名称4,商品类别4,upload/shangpin_shangpintupian4.jpg,upload/shangpin_shangpintupian5.jpg,upload/shangpin_shangpintupian6.jpg,商品规格4,商品详情4,4,99,0,99.9,4),(65,2024-03-10 14:52:16,商品名称5,商品类别5,upload/shangpin_shangpintupian5.jpg,upload/shangpin_shangpintupian6.jpg,upload/shangpin_shangpintupian7.jpg,商品规格5,商品详情5,5,99,0,99.9,5),(66,2024-03-10 14:52:16,商品名称6,商品类别6,upload/shangpin_shangpintupian6.jpg,upload/shangpin_shangpintupian7.jpg,upload/shangpin_shangpintupian8.jpg,商品规格6,商品详情6,6,99,0,99.9,6),(67,2024-03-10 14:52:16,商品名称7,商品类别7,upload/shangpin_shangpintupian7.jpg,upload/shangpin_shangpintupian8.jpg,upload/shangpin_shangpintupian9.jpg,商品规格7,商品详情7,7,99,0,99.9,7),(68,2024-03-10 14:52:16,商品名称8,商品类别8,upload/shangpin_shangpintupian8.jpg,upload/shangpin_shangpintupian9.jpg,upload/shangpin_shangpintupian10.jpg,商品规格8,商品详情8,8,99,0,99.9,8);
/*!40000 ALTER TABLE shangpin ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table shangpinleibie
--DROP TABLE IF EXISTS shangpinleibie;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE shangpinleibie (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,shangpinleibie varchar(200) NOT NULL COMMENT 商品类别,PRIMARY KEY (id),UNIQUE KEY shangpinleibie (shangpinleibie)
) ENGINEInnoDB AUTO_INCREMENT39 DEFAULT CHARSETutf8 COMMENT商品类别;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table shangpinleibie
--LOCK TABLES shangpinleibie WRITE;
/*!40000 ALTER TABLE shangpinleibie DISABLE KEYS */;
INSERT INTO shangpinleibie VALUES (31,2024-03-10 14:52:16,商品类别1),(32,2024-03-10 14:52:16,商品类别2),(33,2024-03-10 14:52:16,商品类别3),(34,2024-03-10 14:52:16,商品类别4),(35,2024-03-10 14:52:16,商品类别5),(36,2024-03-10 14:52:16,商品类别6),(37,2024-03-10 14:52:16,商品类别7),(38,2024-03-10 14:52:16,商品类别8);
/*!40000 ALTER TABLE shangpinleibie ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table storeup
--DROP TABLE IF EXISTS storeup;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE storeup (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,userid bigint(20) NOT NULL COMMENT 用户id,refid bigint(20) DEFAULT NULL COMMENT 商品id,tablename varchar(200) DEFAULT NULL COMMENT 表名,name varchar(200) NOT NULL COMMENT 名称,picture longtext COMMENT 图片,type varchar(200) DEFAULT 1 COMMENT 类型,inteltype varchar(200) DEFAULT NULL COMMENT 推荐类型,remark varchar(200) DEFAULT NULL COMMENT 备注,PRIMARY KEY (id)
) ENGINEInnoDB DEFAULT CHARSETutf8 COMMENT收藏表;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table storeup
--LOCK TABLES storeup WRITE;
/*!40000 ALTER TABLE storeup DISABLE KEYS */;
/*!40000 ALTER TABLE storeup ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table token
--DROP TABLE IF EXISTS token;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE token (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,userid bigint(20) NOT NULL COMMENT 用户id,username varchar(100) NOT NULL COMMENT 用户名,tablename varchar(100) DEFAULT NULL COMMENT 表名,role varchar(100) DEFAULT NULL COMMENT 角色,token varchar(200) NOT NULL COMMENT 密码,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 新增时间,expiratedtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 过期时间,PRIMARY KEY (id)
) ENGINEInnoDB DEFAULT CHARSETutf8 COMMENTtoken表;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table token
--LOCK TABLES token WRITE;
/*!40000 ALTER TABLE token DISABLE KEYS */;
/*!40000 ALTER TABLE token ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table users
--DROP TABLE IF EXISTS users;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE users (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,username varchar(100) NOT NULL COMMENT 用户名,password varchar(100) NOT NULL COMMENT 密码,image varchar(200) DEFAULT NULL COMMENT 头像,role varchar(100) DEFAULT 管理员 COMMENT 角色,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 新增时间,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT2 DEFAULT CHARSETutf8 COMMENT用户表;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table users
--LOCK TABLES users WRITE;
/*!40000 ALTER TABLE users DISABLE KEYS */;
INSERT INTO users VALUES (1,admin,admin,upload/image1.jpg,管理员,2024-03-10 14:52:16);
/*!40000 ALTER TABLE users ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table yonghu
--DROP TABLE IF EXISTS yonghu;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE yonghu (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,yonghuzhanghao varchar(200) NOT NULL COMMENT 用户账号,xingming varchar(200) NOT NULL COMMENT 姓名,mima varchar(200) NOT NULL COMMENT 密码,xingbie varchar(200) DEFAULT NULL COMMENT 性别,shouji varchar(200) DEFAULT NULL COMMENT 手机,touxiang longtext COMMENT 头像,money double DEFAULT 0 COMMENT 余额,PRIMARY KEY (id),UNIQUE KEY yonghuzhanghao (yonghuzhanghao)
) ENGINEInnoDB AUTO_INCREMENT19 DEFAULT CHARSETutf8 COMMENT用户;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table yonghu
--LOCK TABLES yonghu WRITE;
/*!40000 ALTER TABLE yonghu DISABLE KEYS */;
INSERT INTO yonghu VALUES (11,2024-03-10 14:52:16,用户账号1,姓名1,123456,男,13823888881,upload/yonghu_touxiang1.jpg,200),(12,2024-03-10 14:52:16,用户账号2,姓名2,123456,男,13823888882,upload/yonghu_touxiang2.jpg,200),(13,2024-03-10 14:52:16,用户账号3,姓名3,123456,男,13823888883,upload/yonghu_touxiang3.jpg,200),(14,2024-03-10 14:52:16,用户账号4,姓名4,123456,男,13823888884,upload/yonghu_touxiang4.jpg,200),(15,2024-03-10 14:52:16,用户账号5,姓名5,123456,男,13823888885,upload/yonghu_touxiang5.jpg,200),(16,2024-03-10 14:52:16,用户账号6,姓名6,123456,男,13823888886,upload/yonghu_touxiang6.jpg,200),(17,2024-03-10 14:52:16,用户账号7,姓名7,123456,男,13823888887,upload/yonghu_touxiang7.jpg,200),(18,2024-03-10 14:52:16,用户账号8,姓名8,123456,男,13823888888,upload/yonghu_touxiang8.jpg,200);
/*!40000 ALTER TABLE yonghu ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table zuixinshangpin
--DROP TABLE IF EXISTS zuixinshangpin;
/*!40101 SET saved_cs_client character_set_client */;
/*!40101 SET character_set_client utf8 */;
CREATE TABLE zuixinshangpin (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,shangpinmingcheng varchar(200) DEFAULT NULL COMMENT 商品名称,shangpinleibie varchar(200) DEFAULT NULL COMMENT 商品类别,shangpintupian longtext COMMENT 商品图片,shangpinguige varchar(200) DEFAULT NULL COMMENT 商品规格,shangpinxiangqing longtext COMMENT 商品详情,onelimittimes int(11) DEFAULT NULL COMMENT 单限,alllimittimes int(11) DEFAULT NULL COMMENT 库存,discussnum int(11) DEFAULT 0 COMMENT 评论数,price double NOT NULL COMMENT 价格,storeupnum int(11) DEFAULT 0 COMMENT 收藏数,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT59 DEFAULT CHARSETutf8 COMMENT最新商品;
/*!40101 SET character_set_client saved_cs_client */;--
-- Dumping data for table zuixinshangpin
--LOCK TABLES zuixinshangpin WRITE;
/*!40000 ALTER TABLE zuixinshangpin DISABLE KEYS */;
INSERT INTO zuixinshangpin VALUES (51,2024-03-10 14:52:16,商品名称1,商品类别1,upload/zuixinshangpin_shangpintupian1.jpg,upload/zuixinshangpin_shangpintupian2.jpg,upload/zuixinshangpin_shangpintupian3.jpg,商品规格1,商品详情1,1,99,0,99.9,1),(52,2024-03-10 14:52:16,商品名称2,商品类别2,upload/zuixinshangpin_shangpintupian2.jpg,upload/zuixinshangpin_shangpintupian3.jpg,upload/zuixinshangpin_shangpintupian4.jpg,商品规格2,商品详情2,2,99,0,99.9,2),(53,2024-03-10 14:52:16,商品名称3,商品类别3,upload/zuixinshangpin_shangpintupian3.jpg,upload/zuixinshangpin_shangpintupian4.jpg,upload/zuixinshangpin_shangpintupian5.jpg,商品规格3,商品详情3,3,99,0,99.9,3),(54,2024-03-10 14:52:16,商品名称4,商品类别4,upload/zuixinshangpin_shangpintupian4.jpg,upload/zuixinshangpin_shangpintupian5.jpg,upload/zuixinshangpin_shangpintupian6.jpg,商品规格4,商品详情4,4,99,0,99.9,4),(55,2024-03-10 14:52:16,商品名称5,商品类别5,upload/zuixinshangpin_shangpintupian5.jpg,upload/zuixinshangpin_shangpintupian6.jpg,upload/zuixinshangpin_shangpintupian7.jpg,商品规格5,商品详情5,5,99,0,99.9,5),(56,2024-03-10 14:52:16,商品名称6,商品类别6,upload/zuixinshangpin_shangpintupian6.jpg,upload/zuixinshangpin_shangpintupian7.jpg,upload/zuixinshangpin_shangpintupian8.jpg,商品规格6,商品详情6,6,99,0,99.9,6),(57,2024-03-10 14:52:16,商品名称7,商品类别7,upload/zuixinshangpin_shangpintupian7.jpg,upload/zuixinshangpin_shangpintupian8.jpg,upload/zuixinshangpin_shangpintupian9.jpg,商品规格7,商品详情7,7,99,0,99.9,7),(58,2024-03-10 14:52:16,商品名称8,商品类别8,upload/zuixinshangpin_shangpintupian8.jpg,upload/zuixinshangpin_shangpintupian9.jpg,upload/zuixinshangpin_shangpintupian10.jpg,商品规格8,商品详情8,8,99,0,99.9,8);
/*!40000 ALTER TABLE zuixinshangpin ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONEOLD_TIME_ZONE */;/*!40101 SET SQL_MODEOLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKSOLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKSOLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENTOLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTSOLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTIONOLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTESOLD_SQL_NOTES */;-- Dump completed on 2024-03-12 18:07:33为什么选择我 我是程序员阿龙专注于软件开发拥有丰富的编程能力和实战经验。在过去的几年里我辅导了上千名学生帮助他们顺利完成毕业项目同时我的技术分享也吸引了超过50W的粉丝。我是CSDN特邀作者、博客专家、新星计划导师并在Java领域内获得了多项荣誉如博客之星。我的作品也被掘金、华为云、阿里云、InfoQ等多个平台推荐成为各大平台的优质作者。 已经为上百名同学获得优秀毕业生 源码获取 大家点赞、收藏、关注、评论啦 、查看获取联系方式 精彩专栏推荐订阅在下方专栏
