开发语言：Java 框架：springboot JDK版本：JDK1.8 服务器：tomcat7 数据库：mysql 5.7（一定要5.7版本） 数据库工具：Navicat11 开发软件：eclipse/myeclipse/idea Maven包：Maven3.3.9 浏览器：谷歌浏览器
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 'wupinxinxi' 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 float DEFAULT NULL COMMENT '单价',
discountprice float DEFAULT NULL COMMENT '会员价',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1680766366880 DEFAULT CHARSET=utf8 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 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 '配置参数值',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 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'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/1680766301758.jpeg');
/!40000 ALTER TABLE config ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table juanzengwuzi
--
DROP TABLE IF EXISTS juanzengwuzi;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE juanzengwuzi (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
qiuzhubiaoti varchar(200) DEFAULT NULL COMMENT '求助标题',
juanzengwuzi varchar(200) DEFAULT NULL COMMENT '捐赠物资',
wuzixiangqing longtext COMMENT '物资详情',
juanzengshijian datetime DEFAULT NULL COMMENT '捐赠时间',
yonghuzhanghao varchar(200) DEFAULT NULL COMMENT '用户账号',
xingming varchar(200) DEFAULT NULL COMMENT '姓名',
zizhuzhanghao varchar(200) DEFAULT NULL COMMENT '资助账号',
zizhuxingming varchar(200) DEFAULT NULL COMMENT '资助姓名',
lianxifangshi varchar(200) DEFAULT NULL COMMENT '联系方式',
sfsh varchar(200) DEFAULT '待审核' COMMENT '是否审核',
shhf longtext COMMENT '审核回复',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1680766415498 DEFAULT CHARSET=utf8 COMMENT='捐赠物资';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table juanzengwuzi
--
LOCK TABLES juanzengwuzi WRITE;
/*!40000 ALTER TABLE juanzengwuzi DISABLE KEYS /;
INSERT INTO juanzengwuzi VALUES (61,'2023-04-06 07:27:19','求助标题1','捐赠物资1','物资详情1','2023-04-06 15:27:19','用户账号1','姓名1','资助账号1','资助姓名1','联系方式1','是',''),(62,'2023-04-06 07:27:19','求助标题2','捐赠物资2','物资详情2','2023-04-06 15:27:19','用户账号2','姓名2','资助账号2','资助姓名2','联系方式2','是',''),(63,'2023-04-06 07:27:19','求助标题3','捐赠物资3','物资详情3','2023-04-06 15:27:19','用户账号3','姓名3','资助账号3','资助姓名3','联系方式3','是',''),(64,'2023-04-06 07:27:19','求助标题4','捐赠物资4','物资详情4','2023-04-06 15:27:19','用户账号4','姓名4','资助账号4','资助姓名4','联系方式4','是',''),(65,'2023-04-06 07:27:19','求助标题5','捐赠物资5','物资详情5','2023-04-06 15:27:19','用户账号5','姓名5','资助账号5','资助姓名5','联系方式5','是',''),(66,'2023-04-06 07:27:19','求助标题6','捐赠物资6','物资详情6','2023-04-06 15:27:19','用户账号6','姓名6','资助账号6','资助姓名6','联系方式6','是',''),(67,'2023-04-06 07:27:19','求助标题7','捐赠物资7','物资详情7','2023-04-06 15:27:19','用户账号7','姓名7','资助账号7','资助姓名7','联系方式7','是',''),(68,'2023-04-06 07:27:19','求助标题8','捐赠物资8','物资详情8','2023-04-06 15:27:19','用户账号8','姓名8','资助账号8','资助姓名8','联系方式8','是',''),(1680766415497,'2023-04-06 07:33:34','发放','发放爱妃','发放爱妃爱妃','2023-04-06 15:33:28','001','张安','002','李四','13700000005','否','法法师阿飞撒');
/!40000 ALTER TABLE juanzengwuzi ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table juanzengzijin
--
DROP TABLE IF EXISTS juanzengzijin;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE juanzengzijin (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
qiuzhubiaoti varchar(200) DEFAULT NULL COMMENT '求助标题',
yijuanjine int(11) DEFAULT NULL COMMENT '捐赠金额',
juanzengshijian datetime DEFAULT NULL COMMENT '捐赠时间',
yonghuzhanghao varchar(200) DEFAULT NULL COMMENT '用户账号',
xingming varchar(200) DEFAULT NULL COMMENT '姓名',
zizhuzhanghao varchar(200) DEFAULT NULL COMMENT '资助账号',
zizhuxingming varchar(200) DEFAULT NULL COMMENT '资助姓名',
lianxifangshi varchar(200) DEFAULT NULL COMMENT '联系方式',
sfsh varchar(200) DEFAULT '待审核' COMMENT '是否审核',
shhf longtext COMMENT '审核回复',
ispay varchar(200) DEFAULT '未支付' COMMENT '是否支付',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1680766422141 DEFAULT CHARSET=utf8 COMMENT='捐赠资金';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table juanzengzijin
--
LOCK TABLES juanzengzijin WRITE;
/*!40000 ALTER TABLE juanzengzijin DISABLE KEYS /;
INSERT INTO juanzengzijin VALUES (71,'2023-04-06 07:27:19','求助标题1',1,'2023-04-06 15:27:19','用户账号1','姓名1','资助账号1','资助姓名1','联系方式1','是','','未支付'),(72,'2023-04-06 07:27:19','求助标题2',2,'2023-04-06 15:27:19','用户账号2','姓名2','资助账号2','资助姓名2','联系方式2','是','','未支付'),(73,'2023-04-06 07:27:19','求助标题3',3,'2023-04-06 15:27:19','用户账号3','姓名3','资助账号3','资助姓名3','联系方式3','是','','未支付'),(74,'2023-04-06 07:27:19','求助标题4',4,'2023-04-06 15:27:19','用户账号4','姓名4','资助账号4','资助姓名4','联系方式4','是','','未支付'),(75,'2023-04-06 07:27:19','求助标题5',5,'2023-04-06 15:27:19','用户账号5','姓名5','资助账号5','资助姓名5','联系方式5','是','','未支付'),(76,'2023-04-06 07:27:19','求助标题6',6,'2023-04-06 15:27:19','用户账号6','姓名6','资助账号6','资助姓名6','联系方式6','是','','未支付'),(77,'2023-04-06 07:27:19','求助标题7',7,'2023-04-06 15:27:19','用户账号7','姓名7','资助账号7','资助姓名7','联系方式7','是','','未支付'),(78,'2023-04-06 07:27:19','求助标题8',8,'2023-04-06 15:27:19','用户账号8','姓名8','资助账号8','资助姓名8','联系方式8','是','','未支付'),(1680766422140,'2023-04-06 07:33:41','发放',500,'2023-04-06 15:33:36','001','张安','002','李四','13700000005','是','发放','已支付');
/!40000 ALTER TABLE juanzengzijin ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table messages
--
DROP TABLE IF EXISTS messages;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE messages (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
userid bigint(20) NOT NULL COMMENT '留言人id',
username varchar(200) DEFAULT NULL COMMENT '用户名',
avatarurl longtext COMMENT '头像',
content longtext NOT NULL COMMENT '留言内容',
cpicture longtext COMMENT '留言图片',
reply longtext COMMENT '回复内容',
rpicture longtext COMMENT '回复图片',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1680766436202 DEFAULT CHARSET=utf8 COMMENT='在线留言';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table messages
--
LOCK TABLES messages WRITE;
/*!40000 ALTER TABLE messages DISABLE KEYS /;
INSERT INTO messages VALUES (131,'2023-04-06 07:27:19',1,'用户名1','upload/messages_avatarurl1.jpg','留言内容1','upload/messages_cpicture1.jpg','回复内容1','upload/messages_rpicture1.jpg'),(132,'2023-04-06 07:27:19',2,'用户名2','upload/messages_avatarurl2.jpg','留言内容2','upload/messages_cpicture2.jpg','回复内容2','upload/messages_rpicture2.jpg'),(133,'2023-04-06 07:27:19',3,'用户名3','upload/messages_avatarurl3.jpg','留言内容3','upload/messages_cpicture3.jpg','回复内容3','upload/messages_rpicture3.jpg'),(134,'2023-04-06 07:27:19',4,'用户名4','upload/messages_avatarurl4.jpg','留言内容4','upload/messages_cpicture4.jpg','回复内容4','upload/messages_rpicture4.jpg'),(135,'2023-04-06 07:27:19',5,'用户名5','upload/messages_avatarurl5.jpg','留言内容5','upload/messages_cpicture5.jpg','回复内容5','upload/messages_rpicture5.jpg'),(136,'2023-04-06 07:27:19',6,'用户名6','upload/messages_avatarurl6.jpg','留言内容6','upload/messages_cpicture6.jpg','回复内容6','upload/messages_rpicture6.jpg'),(137,'2023-04-06 07:27:19',7,'用户名7','upload/messages_avatarurl7.jpg','留言内容7','upload/messages_cpicture7.jpg','回复内容7','upload/messages_rpicture7.jpg'),(138,'2023-04-06 07:27:19',8,'用户名8','upload/messages_avatarurl8.jpg','留言内容8','upload/messages_cpicture8.jpg','回复内容8','upload/messages_rpicture8.jpg'),(1680766436201,'2023-04-06 07:33:55',1680766349168,'002','upload/1680766348444.jpeg','发放','upload/1680766435176.jpeg','发放','upload/1680766538536.jpeg');
/!40000 ALTER TABLE messages ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table news
--
DROP TABLE IF EXISTS news;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE news (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
title varchar(200) NOT NULL COMMENT '标题',
introduction longtext COMMENT '简介',
picture longtext NOT NULL COMMENT '图片',
content longtext NOT NULL COMMENT '内容',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1680766321217 DEFAULT CHARSET=utf8 COMMENT='公告栏';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table news
