1802 jsp互助平台系统Myeclipse开发mysql数据库web结构java编程计算机网页项目区块链技术

/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50067 Source Host : localhost:3306 Source Database : jsphuzhu Target Server Type : MYSQL Target Server Version : 50067 File Encoding : 65001 Date: 2022-03-26 19:37:29 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for gly -- ---------------------------- DROP TABLE IF EXISTS `gly`; CREATE TABLE `gly` ( `glyid` int(11) NOT NULL auto_increment, `yhm` varchar(40) default NULL COMMENT '用户名', `mm` varchar(40) default NULL COMMENT '密码', `xm` varchar(40) default NULL COMMENT '姓名', PRIMARY KEY (`glyid`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of gly -- ---------------------------- INSERT INTO `gly` VALUES ('1', 'admin', 'admin', 'admin'); -- ---------------------------- -- Table structure for gonggao -- ---------------------------- DROP TABLE IF EXISTS `gonggao`; CREATE TABLE `gonggao` ( `ggid` int(11) NOT NULL auto_increment, `bt` varchar(40) default NULL COMMENT '标题', `nr` varchar(4000) default NULL COMMENT '内容', `fbsj` varchar(40) default NULL COMMENT '发布时间', PRIMARY KEY (`ggid`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of gonggao -- ---------------------------- INSERT INTO `gonggao` VALUES ('1', '系统公告', '系统公告系统公告', '2022-03-25 20:22:30'); -- ---------------------------- -- Table structure for juanzeng -- ---------------------------- DROP TABLE IF EXISTS `juanzeng`; CREATE TABLE `juanzeng` ( `jzid` int(11) NOT NULL auto_increment, `qz` varchar(40) default NULL COMMENT '求助', `gy` varchar(40) default NULL COMMENT '概要', `sm` varchar(4000) default NULL COMMENT '说明', `jzr` varchar(40) default NULL COMMENT '捐赠人', `jzfs` varchar(40) default NULL COMMENT '捐赠方式', `lxfs` varchar(40) default NULL COMMENT '联系方式', `jzsj` varchar(40) default NULL COMMENT '捐赠时间', `shzt` varchar(40) default NULL COMMENT '审核状态', PRIMARY KEY (`jzid`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of juanzeng -- ---------------------------- INSERT INTO `juanzeng` VALUES ('5', '1', '捐赠了', '阿萨德发', '123', '金钱', '0120320130', '2022-03-26 19:22:52', '未审核'); -- ---------------------------- -- Table structure for qiuzhu -- ---------------------------- DROP TABLE IF EXISTS `qiuzhu`; CREATE TABLE `qiuzhu` ( `qzid` int(11) NOT NULL auto_increment, `bt` varchar(40) default NULL COMMENT '标题', `tp` varchar(40) default NULL COMMENT '图片', `nr` varchar(4000) default NULL COMMENT '内容', `sqr` varchar(40) default NULL COMMENT '申请人', `qzfs` varchar(40) default NULL COMMENT '求助方式', `sqsj` varchar(40) default NULL COMMENT '申请时间', `zt` varchar(40) default NULL COMMENT '状态', PRIMARY KEY (`qzid`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of qiuzhu -- ---------------------------- INSERT INTO `qiuzhu` VALUES ('1', '现金和帮助现金和帮助现金和帮助', '1648272727524.jpg', '现金和帮助现金和帮助现金和帮助现金和帮助现金和帮助现金和帮助', '123', '现金和帮助', '2022-03-26 13:31:44', '同意'); -- ---------------------------- -- Table structure for qkl -- ---------------------------- DROP TABLE IF EXISTS `qkl`; CREATE TABLE `qkl` ( `qklid` int(11) NOT NULL auto_increment, `jz` varchar(400) default NULL COMMENT '捐赠', `qz` varchar(400) default NULL COMMENT '求助', `ccz` varchar(4000) default NULL COMMENT '存储值', PRIMARY KEY (`qklid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of qkl -- ---------------------------- INSERT INTO `qkl` VALUES ('1', '4', '1', '@'); INSERT INTO `qkl` VALUES ('2', '5', '1', 'A'); -- ---------------------------- -- Table structure for qkmx -- ---------------------------- DROP TABLE IF EXISTS `qkmx`; CREATE TABLE `qkmx` ( `qkmxid` int(11) NOT NULL auto_increment, `bt` varchar(4000) default NULL COMMENT '标题', `nr` varchar(4000) default NULL COMMENT '内容', `sqr` varchar(4000) default NULL COMMENT '申请人', `qzfs` varchar(4000) default NULL COMMENT '求助方式', `qzsj` varchar(4000) default NULL COMMENT '求助时间', `qk` varchar(4000) default NULL COMMENT '区块', PRIMARY KEY (`qkmxid`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of qkmx -- ---------------------------- INSERT INTO `qkmx` VALUES ('1', '546w6YeR5ZKM5biu5Yqp546w6YeR5ZKM5biu5Yqp546w6YeR5ZKM5biu5Yqp', '546w6YeR5ZKM5biu5Yqp546w6YeR5ZKM5biu5Yqp546w6YeR5ZKM5biu5Yqp546w6YeR5ZKM5biu\r\n5Yqp546w6YeR5ZKM5biu5Yqp546w6YeR5ZKM5biu5Yqp', 'MTIz', '546w6YeR5ZKM5biu5Yqp', 'MjAyMi0wMy0yNiAxMzozMTo0NA==', 'A'); -- ---------------------------- -- Table structure for tongzhi -- ---------------------------- DROP TABLE IF EXISTS `tongzhi`; CREATE TABLE `tongzhi` ( `tzid` int(11) NOT NULL auto_increment, `bt` varchar(40) default NULL COMMENT '标题', `nr` varchar(4000) default NULL COMMENT '内容', `jsyh` varchar(40) default NULL COMMENT '接收用户', `fbsj` varchar(40) default NULL COMMENT '发布时间', PRIMARY KEY (`tzid`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of tongzhi -- ---------------------------- INSERT INTO `tongzhi` VALUES ('1', '撒旦法', '撒旦法', '123', '2022-03-26 11:58:50'); -- ---------------------------- -- Table structure for yonghu -- ---------------------------- DROP TABLE IF EXISTS `yonghu`; CREATE TABLE `yonghu` ( `yhid` int(11) NOT NULL auto_increment, `yhm` varchar(40) default NULL COMMENT '用户名', `mm` varchar(40) default NULL COMMENT '密码', `xm` varchar(40) default NULL COMMENT '姓名', `lxdh` varchar(40) default NULL COMMENT '联系电话', `lxdz` varchar(40) default NULL COMMENT '联系地址', `yx` varchar(40) default NULL COMMENT '邮箱', `zyzbs` varchar(40) default NULL COMMENT '志愿者（标识）', PRIMARY KEY (`yhid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of yonghu -- ---------------------------- INSERT INTO `yonghu` VALUES ('1', '123', '123', '123', '12312312', '123123', '123@123.com', '是'); INSERT INTO `yonghu` VALUES ('2', '333', '333', '333', '231231211231231', '12312312', 'null', '否'); -- ---------------------------- -- Table structure for zyzsq -- ---------------------------- DROP TABLE IF EXISTS `zyzsq`; CREATE TABLE `zyzsq` ( `zyzsqid` int(11) NOT NULL auto_increment, `bt` varchar(40) default NULL COMMENT '标题', `ms` varchar(40) default NULL COMMENT '描述', `sqsj` varchar(40) default NULL COMMENT '申请时间', `sqr` varchar(40) default NULL COMMENT '申请人', `zt` varchar(40) default NULL COMMENT '状态', PRIMARY KEY (`zyzsqid`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of zyzsq -- ---------------------------- INSERT INTO `zyzsq` VALUES ('1', '申请当志愿者', '申请当志愿者申请当志愿者', '2022-03-26 17:10:57', '123', '同意');