项目介绍:闲置衣物捐赠系统分为捐赠者端+受赠者者端+管理员端用户通过注册登录到系统,用户可以进行查看个人信息,查看闲置衣服求赠信息,在线捐衣物等一系列操作,用户帮助别人后有相应的积分奖励,积分可以用于兑换相应的物品奖励。
项目类型:SSM源码
用户类型:3个角色(管理员+捐赠者+受赠者者)
主要技术:SSM+MySQL+Jquery(前端Bootstrap)
开发工具:Eclipse/Idea均可使用,有两个不同的版本
数据库:MySQL
数据库表:8张
🍅演示视频在底部🍅
🍅文末获取联系🍅
目录
01管理员端
1.0系统登录
1.1后台首页+数据统计
1.2受赠者管理模块
1.3帮助者管理模块
1.4公告管理模块
1.5奖品管理模块
1.6物品兑换管理管理模块
1.7衣物捐赠管理模块
1.8衣物需求管理模块
02受赠者端
2.1 衣物需求管理
2.2闲置衣服需求发布
2.3受赠评论
2.4个人资料修改
03捐赠者端
3.1查看衣物捐赠需求
3.2 衣物捐赠提交
3.3物品积分兑换
04项目结构
05数据库设计
06完整的程序目录
07演示视频
【原创毕设】ssm体育场馆预约管理系统
-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES (1, '1', '1', '1');
-- ----------------------------
-- Table structure for agent
-- ----------------------------
DROP TABLE IF EXISTS `agent`;
CREATE TABLE `agent` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`realname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`tx` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`score` int(11) DEFAULT 0,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of agent
-- ----------------------------
INSERT INTO `agent` VALUES (3, '刘伟', 'liuwei', '1', '/images/2023-08-28/b3f6b689-54d4-4b20-a241-b730bbe65756.jpg', '1', 120);
INSERT INTO `agent` VALUES (4, '牛魔王', 'niumow', '1', '/images/2023-08-28/d8be00af-e79e-4dbc-8677-14987b57c6da.jpg', '123456', 133);
INSERT INTO `agent` VALUES (5, '吴良镛', 'wuliangy', '4', '/images/2023-08-28/484abe6c-d3df-477d-b291-3dfc1da3c8d8.jpg', '123456', 0);
-- ----------------------------
-- Table structure for board
-- ----------------------------
DROP TABLE IF EXISTS `board`;
CREATE TABLE `board` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`editor` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`times` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for commodity
-- ----------------------------
DROP TABLE IF EXISTS `commodity`;
CREATE TABLE `commodity` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`score` int(11) DEFAULT NULL,
`totals` int(11) DEFAULT NULL,
`createTime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of commodity
-- ----------------------------
INSERT INTO `commodity` VALUES (1, '书本', '一本书', '/images/2023-08-28/dea6fd53-9d45-4963-bd46-598e9ad8d6bd.jpg', 5, 8, '2022-11-22 23:51');
INSERT INTO `commodity` VALUES (2, '笔记本', '笔记本', '/images/2023-08-28/ee205d06-9315-4dad-90e5-667539afacd6.jpg', 2, 10, '2023-08-28 20:37');
INSERT INTO `commodity` VALUES (3, 'U盘', '金士顿U盘', '/images/2023-08-28/af1a4ef1-bd3f-47b0-8c86-03cd5dba981b.jpg', 5, 8, '2023-08-28 20:38');
-- ----------------------------
-- Table structure for notes
-- ----------------------------
DROP TABLE IF EXISTS `notes`;
CREATE TABLE `notes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nums` int(255) DEFAULT NULL,
`aid` int(11) DEFAULT NULL,
`cid` int(11) DEFAULT NULL,
`createTime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`allScores` int(255) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of notes
-- ----------------------------
INSERT INTO `notes` VALUES (1, 1, 4, 1, '2022-11-22 23:52', 1);
INSERT INTO `notes` VALUES (2, 1, 4, 1, '2023-02-14 23:50', 1);
INSERT INTO `notes` VALUES (3, 1, 3, 3, '2023-08-28 21:09', 5);
-- ----------------------------
-- Table structure for send
-- ----------------------------
DROP TABLE IF EXISTS `send`;
CREATE TABLE `send` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`aid` int(11) DEFAULT NULL,
`tid` int(11) DEFAULT NULL,
`photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`detail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`youbian` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`uname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`createtime` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`state` int(255) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of send
-- ----------------------------
INSERT INTO `send` VALUES (10, 4, 4, '/images/2023-02-14/c2cbc6b3-1b6b-43bb-b669-8c1e933d26de.jpg', '<p>3</p>', '3', '3', '3', '3', '2023-02-14 23:48:36', 4);
INSERT INTO `send` VALUES (11, 3, 6, '/images/2023-08-28/ef87af80-2fd9-48f8-95fa-dafb9d351975.jpg', '<p><img src=\"/ssm_class_arrangement/ueditor/jsp/upload/image/20230828/1693227430410023644.jpg\" title=\"1693227430410023644.jpg\" alt=\"blog22.jpg\"/></p><p>捐赠了这样的衣服</p>', '江苏省南京市江宁区', '210000', '18521413512', '刘伟', '2023-08-28 20:57:36', 4);
INSERT INTO `send` VALUES (12, 3, 5, '/images/2023-08-28/3bf38db6-8d9e-4998-9893-665946c58101.jpg', '<p><img src=\"/ssm_class_arrangement/ueditor/jsp/upload/image/20230828/1693228119558020946.jpg\" title=\"1693228119558020946.jpg\" alt=\"bg2.jpg\"/></p>', '江苏', '210000', '18521413241', '剩下', '2023-08-28 21:08:41', 4);
-- ----------------------------
-- Table structure for task
-- ----------------------------
DROP TABLE IF EXISTS `task`;
CREATE TABLE `task` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`sid` int(11) DEFAULT NULL,
`createTime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`planTime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`state` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '0' COMMENT '0待接单 1已接单 2已送达 3已评论',
`detail` longtext CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '任务详情',
`aid` int(11) DEFAULT NULL,
`photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`score` int(11) DEFAULT NULL COMMENT '积分奖励',
`arriveTime` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`comments` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`realname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`tx` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (6, '陈晨', '123456', '13542497970', '/images/2023-08-28/f59e12e5-6d5b-4a96-afc7-d59ac524bc1f.jpg', '123456');
INSERT INTO `user` VALUES (7, '方嘉豪', '123456', '2', '/images/2023-08-28/58d1c22d-bfd9-4f0a-9979-21edbd1ce173.jpg', '123456');
INSERT INTO `user` VALUES (8, '孙悟空', '1', '1', '/images/2023-08-28/fc6e3dbd-eb1f-45ff-a11e-89de6a5273dd.jpg', '123456');
INSERT INTO `user` VALUES (10, '张飞', 'zf', '1', '/images/2023-08-28/db9269ee-9204-4a39-b6cd-3510f56c9e33.jpg', '1');
SET FOREIGN_KEY_CHECKS = 1;