毕业设计 基于JavaWeb的高校社团管理系统

项目介绍
:高校社团管理系统基于Java语言开发。在开发的时候,使用JavaWeb技术实现。核心业务围绕高校内社团管理展开。此外,基础功能应当能够完成社团活动、社团风采、社团信息、用户信息的管理。在此基础,构建一个对应的网站,用于展示和介绍各种社团信息。对于相关的数据,通过MySQL存储。整个系统的开发,遵循MVC设计模式。

项目类型:JavaWeb源码

用户类型:3个角色(管理员+学生+社长)

主要技术:Jsp+Servlet+MySQL+Jquery

开发工具:Eclipse/Idea均可使用,有两个不同的版本

数据库:MySQL

数据库表:9张

目录

00完整的程序目录

01管理员端

1.0后台登录

1.1用户管理模块

1.2社团管理模块

1.3社团活动管理模块

1.4社团风采管理模块

1.5活动报名管理模块

1.6评价管理

02学生端

2.1 用户端首页

2.2社团活动展示页面

2.3社团活动详情页面

2.4社团展示页面

2.5社团详情查看模块

2.6社团风采查看页面

2.7报名管理

03社长端

3.1社团管理

3.2社团加入审核

3.3社团管理模块

3.4社团成员查看

3.5活动报名审核

3.6活动风采管理

04项目结构

05数据库设计

06演示视频


00 完整的程序目录

01 管理员端

1.0后台登录

1.1用户管理模块

1.2社团管理模块

1.3社团活动管理模块

1.4社团风采管理模块

1.5活动报名管理模块

1.6评价管理

02 学生端

2.1 用户端首页

2.2社团活动展示页面

2.3社团活动详情页面

2.4社团展示页面

2.5社团详情查看模块

2.6社团风采查看页面

2.7报名管理

03 社长端

3.1社团管理

3.2社团加入审核

3.3社团管理模块

3.4社团成员查看

3.5活动报名审核

3.6活动风采管理

04 项目结构

05 数据库设计

06演示视频

【原创】基于JavaWeb的高校社团管理系统



    -- ----------------------------
    -- 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,
      `nickname` 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 = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of admin
    -- ----------------------------
    INSERT INTO `admin` VALUES (1, '1', '泰迪', '1');
    
    -- ----------------------------
    -- Table structure for apply
    -- ----------------------------
    DROP TABLE IF EXISTS `apply`;
    CREATE TABLE `apply`  (
      `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
      `uid` int(11) DEFAULT NULL COMMENT '社长id',
      `gid` int(11) DEFAULT NULL COMMENT '社团id',
      `message` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注',
      `state` int(11) DEFAULT NULL COMMENT '状态',
      `orderno` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '订单号',
      `ordertime` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '时间',
      `stuid` int(11) DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of apply
    -- ----------------------------
    INSERT INTO `apply` VALUES (10, 15, 8, '我想加入', 0, '20230829222738213', '2023-08-29', 18);
    INSERT INTO `apply` VALUES (11, 15, 8, '我想加入', 1, '20230829222738214', '2023-08-29', 19);
    INSERT INTO `apply` VALUES (12, 15, 8, '我想加入', 1, '20230829222738215', '2023-08-29', 20);
    INSERT INTO `apply` VALUES (13, 15, 8, '报名', 1, '20230829231449281', '2023-08-29', 21);
    
    -- ----------------------------
    -- Table structure for category
    -- ----------------------------
    DROP TABLE IF EXISTS `category`;
    CREATE TABLE `category`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `cname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `times` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '录入时间',
      `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `detail` text CHARACTER SET utf8 COLLATE utf8_general_ci,
      `uid` int(11) DEFAULT NULL,
      `state` int(255) DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of category
    -- ----------------------------
    INSERT INTO `category` VALUES (8, '电竞社', '2023-08-29 21:34', '96711692-fc5e-40ee-8062-a6075a3395ea.jpg', '


​      
​    
​    

     **  社团简介:**社团成立时间2023年,现有人数87人,社长万龙飞管理社团,副社长包稻配合社长工作为校内电竞爱好者提供平台。
    
     **社团性质:** 电子竞技
    
      **社团宗旨:** 发扬电子竞技体育精神,锻炼社员的反应能力、思维能力、手脑协调能力、同时提高社员的团队意识、人际交流能力,并通过比赛培养社员坚韧乐观的精神,丰富课余生活,加强对计算机的了解与兴趣。 
    
    **社团活动:** LOL线上内战,学院王者荣耀争霸赛,线下团建,狼人杀卡牌桌游娱乐等。
    
    ![\\"11.jpg\\"](\\"/Web/ueditor/jsp/upload/image/20230829/1693315995836094938.jpg\\")
    
    ![](\\"/Web/ueditor/jsp/upload/image/20230829/1693319063033026842.jpg\\")
    
    ![](\\"/Web/ueditor/jsp/upload/image/20230829/1693319063028082980.jpg\\")
    
    ![](\\"/Web/ueditor/jsp/upload/image/20230829/1693319063044026688.jpg\\")


​      
​    
​    

    ', 15, 1);
    INSERT INTO `category` VALUES (10, '美食社', '2023-08-29 21:46', '05d1547f-47e3-459f-9eed-19ddfbfca020.jpg', '
    
    ![\\"024.jpg\\"/](\\"/Web/ueditor/jsp/upload/image/20230829/1693316783931004130.jpg\\")
    
    ', 16, 1);
    INSERT INTO `category` VALUES (11, '图书社', '2023-08-29 21:55', 'e73c7c9a-d8db-499b-9ccf-cd95338e562b.png', '
    
    图书社团
    
    ![\\"07.png\\"/](\\"/Web/ueditor/jsp/upload/image/20230829/1693317318856061562.png\\")
    
    ', 17, 1);
    
    -- ----------------------------
    -- Table structure for comments
    -- ----------------------------
    DROP TABLE IF EXISTS `comments`;
    CREATE TABLE `comments`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `uid` int(11) DEFAULT NULL,
      `comments` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `ctime` varchar(111) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `hid` int(11) DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of comments
    -- ----------------------------
    INSERT INTO `comments` VALUES (5, 18, '活动很不错', '2023-08-29', 7);
    INSERT INTO `comments` VALUES (6, 18, '优待提高', '2023-08-29', 7);
    
    -- ----------------------------
    -- Table structure for goods
    -- ----------------------------
    DROP TABLE IF EXISTS `goods`;
    CREATE TABLE `goods`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `names` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '名称',
      `cid` int(11) DEFAULT NULL COMMENT 'Cid',
      `times` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '发布时间',
      `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '图片',
      `detail` text CHARACTER SET utf8 COLLATE utf8_general_ci,
      `nums` int(255) DEFAULT NULL COMMENT '查看次数',
      `uid` int(11) DEFAULT NULL,
      `state` int(11) DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of goods
    -- ----------------------------
    INSERT INTO `goods` VALUES (7, '英雄联盟线下比赛报名', 8, '2023-08-29 22:00', '								dfe4a719-919b-4523-a418-96782b5e27e1.jpg\r\n', '
    
    ![\\"OIP-C.jpg\\"/](\\"/Web/ueditor/jsp/upload/image/20230829/1693317623216016961.jpg\\")
    
    ', 28, 15, 1);
    INSERT INTO `goods` VALUES (8, '美食分享活动', 10, '2023-08-29 22:05', '909d4a62-20cf-4d25-ab39-5f569b8e4b96.jpg', '
    
    ![\\"036.jpg\\"/](\\"/Web/ueditor/jsp/upload/image/20230829/1693317898763021015.jpg\\")
    
    ', 16, 16, 1);
    INSERT INTO `goods` VALUES (9, '美食社团外出活动', 10, '2023-08-29 22:08', '306d9cd0-f7ce-4d51-8d56-8bcf32e415ac.jpg', '', 16, 16, 0);
    INSERT INTO `goods` VALUES (10, '电竞比赛招募', 8, '2023-08-29 22:11', 'cc1edffd-e3ca-4c0a-b95a-20540871d428.jpg', '
    
    电竞比赛招募
    
    ', NULL, 15, 1);
    
    -- ----------------------------
    -- Table structure for mien
    -- ----------------------------
    DROP TABLE IF EXISTS `mien`;
    CREATE TABLE `mien`  (
      `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '婚纱id',
      `names` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '婚纱名称',
      `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '图片',
      `detail` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '详情',
      `nums` int(11) DEFAULT NULL,
      `uid` int(11) DEFAULT NULL,
      `ctime` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of mien
    -- ----------------------------
    INSERT INTO `mien` VALUES (9, '电竞比赛风采展示', '7a4bcf64-1f32-49a5-8b92-4aafdb77ee70.jpg', '
    
    【社团简介】
    
    社团全称:电子竞技协会
    
    社团宗旨:发扬奥林匹克体育精神,借电子竞技锻炼社员的反应能力、思维能力、手脑协调能力、同时提高社员的团队意识、协作能力及人际交流能力,并通过比赛培养社员坚韧乐观的精神,丰富课余生活。
    
    社团精神:互助互爱、团队合作、创新求变、积极发展、勤奋锻炼、坚持不懈。
    
    社团活动:SOLO赛、狼人杀等桌游娱乐、校内友谊赛、电竞交流…还有更多。
    
    【社团招新】
    
    ❶.招收实力玩家(LOLDOTA2、守望先锋、王者荣耀等游戏)作为校队预备队员,代表学校参赛。
    
    ❷.招收电竞爱好者,游戏打得好不好不重要!主要是开心!任性!还有很多大神带你上分带你浪!
    
    ❸.招收社团预备管理层,各部门人才稀缺,我们是一个有梦想的社团,需要有梦想的新生与我们一起为社团的未来出谋划策。无论是你想做文字策划、活动执行、海报美工,我们都会给你大展身手的机会,SHOW出你的能力与个性。如果你并没有以上技能,没关系,学长学姐都很乐意教你哦。
    
    ![\\"012.jpg\\"/](\\"/Web/ueditor/jsp/upload/image/20230829/1693317429356066740.jpg\\")
    
    ', 2, 15, '2023-08-29');
    INSERT INTO `mien` VALUES (10, '美食社团风采展示', 'f680894e-962c-478e-a969-c1d3c897e01b.jpg', '
    
    ![\\"01.jpg\\"/](\\"/Web/ueditor/jsp/upload/image/20230829/1693317499356071142.jpg\\")
    
    ', 2, 16, '2023-08-29');
    INSERT INTO `mien` VALUES (11, '图书社团风采展示', '92c83a01-532c-4e51-a304-09d8ed8896b4.jpg', '
    
    ![\\"0211.jpg\\"/](\\"/Web/ueditor/jsp/upload/image/20230829/1693317542580616690.jpg\\")
    
    ', 3, 17, '2023-08-29');
    INSERT INTO `mien` VALUES (12, '电竞社团风采展示', '25997afd-c8d4-4c37-a0f9-2292676a2f22.jpg', NULL, 3, 15, '2023-08-29');
    INSERT INTO `mien` VALUES (13, '电竞风采', 'e1c9f14c-f2cb-47e1-88f0-700e91355e83.jpg', NULL, 5, 15, '2023-08-29');
    
    -- ----------------------------
    -- Table structure for student
    -- ----------------------------
    DROP TABLE IF EXISTS `student`;
    CREATE TABLE `student`  (
      `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户id',
      `realname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
      `pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码',
      `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '性别',
      `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '手机',
      `times` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '注册时间',
      `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '头像',
      `nos` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of student
    -- ----------------------------
    INSERT INTO `student` VALUES (18, '2', '2', '男', '18865412141', '2023-08-29 21:57', 'a4c708e5-e32d-4e87-bfde-4395b024404e.jpg', '2');
    INSERT INTO `student` VALUES (19, '3', '3', '男', '18865412141', '2023-08-29 22:12', 'f53a3fc7-17d7-40d0-8049-ee4099c9751f.jpg', '3');
    INSERT INTO `student` VALUES (20, '4', '4', '男', '18865412141', '2023-08-29 22:12', '0f124dc8-5c7c-4297-82dc-e1749a96785f.jpg', '4');
    INSERT INTO `student` VALUES (21, '5', '1', '男', '5', '2023-08-29 23:14', '16644db1-f257-4776-b577-fae1583a4d6e.png', '5');
    
    -- ----------------------------
    -- Table structure for user
    -- ----------------------------
    DROP TABLE IF EXISTS `user`;
    CREATE TABLE `user`  (
      `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户id',
      `realname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
      `pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码',
      `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '性别',
      `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '手机',
      `times` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '注册时间',
      `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '头像',
      `nos` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of user
    -- ----------------------------
    INSERT INTO `user` VALUES (15, '1', '1', '女', '18020514131', '2023-08-29 21:32', '4d7ae595-8f1a-4d1c-9ba9-718dd98346f2.jpg', '1');
    INSERT INTO `user` VALUES (16, '2', '2', '男', '18020514131', '2023-08-29 21:45', '54fd040a-e8c6-43f5-a861-a2d895c5b44e.jpg', '2');
    INSERT INTO `user` VALUES (17, '4', '4', '男', '18020514131', '2023-08-29 21:54', 'c7236d68-b492-4073-9cb3-ddca2d8ec4e5.jpg', '4');
    
    -- ----------------------------
    -- Table structure for yuyue
    -- ----------------------------
    DROP TABLE IF EXISTS `yuyue`;
    CREATE TABLE `yuyue`  (
      `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
      `uid` int(11) DEFAULT NULL COMMENT '用户id',
      `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系人',
      `hid` int(11) DEFAULT NULL COMMENT '活动id',
      `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系邮箱',
      `message` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注',
      `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系电话',
      `odate` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '日期',
      `state` int(11) DEFAULT NULL COMMENT '状态',
      `orderno` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '订单号',
      `ordertime` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '时间',
      `stuid` int(11) DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of yuyue
    -- ----------------------------
    INSERT INTO `yuyue` VALUES (8, 15, '张三', 7, '321321@qq.com', '我想加入', '18021501541', '2023-08-09', 1, '20230829223005798', '2023-08-29', 18);
    INSERT INTO `yuyue` VALUES (9, 15, '张三', 7, '8321321@qq.com', '我想加入', '18021501541', '2023-08-09', 1, '20230829223005798', '2023-08-29', 19);
    INSERT INTO `yuyue` VALUES (10, 15, '李四', 7, '9321321@qq.com', '我想加入', '18021501541', '2023-08-09', 0, '20230829223005798', '2023-08-29', 20);
    INSERT INTO `yuyue` VALUES (11, 15, '张三', 7, '321321@qq.com', '报名', '18021501541', '2023-08-09', 0, '20230829231543547', '2023-08-29', 21);
    
    SET FOREIGN_KEY_CHECKS = 1;


项目获取:

https://gitee.com/sinonfin/L-javaWebSha/tree/master

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值