贫困地区慈善资助系统-计算机毕业设计源码+LW文档

开发语言：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`