开发语言：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`
如需定做或者获取更多资料，请联系QQ：375279829
客服QQ