从0到1：基于SSM的校园社团活动报名小程序开发笔记（中）

头像
CC同学呀
     广东
    阅读 8 分钟

    构想

    面向校园社团管理和活动组织的工具，旨在提高社团管理效率、增强学生参与感、便于信息沟通与活动管理。主要功能包括：活动展示，自主报名，取消报名，后台录入活动项目，统计每项活动报名情况，导出数据，用户管理，管理员管理等。

    • 活动列表：展示所有正在进行或即将举行的校园活动，包括学科竞赛、科技创新竞赛、体育竞赛等。
    • 活动详情：点击活动后，显示详细信息，如时间、地点、报名方式、参与要求等。
    • 分类筛选：根据活动类型等进行筛选，方便用户快速找到感兴趣的活动。
    • 在线报名：用户可以在线报名参加活动，提交必要的资料
    • 管理员角色：发布活动信息

    • 后台统计管理：按每项活动进行报名统计，查看每个活动的已报名人数，了解活动的参与热度，支持名单数据导出Excel，打印

      可行性分析

      image.png

    技术选型

    • 前端基于微信小程序平台进行开发
    • 后端基于Java Springboot SSM架构开发
    • 数据库： MySQL (8.0+)

    数据字典

     
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for actcampus_activity
-- ----------------------------
DROP TABLE IF EXISTS `actcampus_activity`;
CREATE TABLE `actcampus_activity`  (
  `ACTIVITY_ID` int NOT NULL AUTO_INCREMENT,
  `ACTIVITY_TITLE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `ACTIVITY_CATE_ID` int NOT NULL DEFAULT 0,
  `ACTIVITY_CATE_NAME` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `ACTIVITY_STATUS` int NOT NULL DEFAULT 1,
  `ACTIVITY_START` bigint NOT NULL DEFAULT 0,
  `ACTIVITY_END` bigint NOT NULL DEFAULT 0,
  `ACTIVITY_STOP` bigint NOT NULL DEFAULT 0,
  `ACTIVITY_ADDRESS` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `ACTIVITY_ADDRESS_GEO` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `ACTIVITY_ORDER` int NOT NULL DEFAULT 9999,
  `ACTIVITY_VOUCH` int NOT NULL DEFAULT 0,
  `ACTIVITY_VIEW_CNT` int NOT NULL DEFAULT 0,
  `ACTIVITY_JOIN_CNT` int NOT NULL DEFAULT 0,
  `ACTIVITY_MAX_CNT` int NOT NULL DEFAULT 0,
  `ACTIVITY_FORMS` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `ACTIVITY_OBJ` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `ADD_TIME` bigint NOT NULL DEFAULT 0,
  `EDIT_TIME` bigint NOT NULL DEFAULT 0,
  PRIMARY KEY (`ACTIVITY_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 44 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;



-- ----------------------------
-- Table structure for actcampus_activity_join
-- ----------------------------
DROP TABLE IF EXISTS `actcampus_activity_join`;
CREATE TABLE `actcampus_activity_join`  (
  `ACTIVITY_JOIN_ID` int NOT NULL AUTO_INCREMENT,
  `ACTIVITY_JOIN_USER_ID` int NOT NULL DEFAULT 0,
  `ACTIVITY_JOIN_ACTIVITY_ID` int NOT NULL DEFAULT 0,
  `ACTIVITY_JOIN_CODE` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `ACTIVITY_JOIN_IS_CHECK` int NOT NULL DEFAULT 0,
  `ACTIVITY_JOIN_CHECK_TIME` bigint NOT NULL DEFAULT 0,
  `ACTIVITY_JOIN_FORMS` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `ACTIVITY_JOIN_OBJ` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `ACTIVITY_JOIN_STATUS` int NOT NULL DEFAULT 0,
  `ADD_TIME` bigint NOT NULL DEFAULT 0,
  `EDIT_TIME` bigint NOT NULL DEFAULT 0,
  PRIMARY KEY (`ACTIVITY_JOIN_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10963 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for actcampus_admin
-- ----------------------------
DROP TABLE IF EXISTS `actcampus_admin`;
CREATE TABLE `actcampus_admin`  (
  `ADMIN_ID` int NOT NULL AUTO_INCREMENT,
  `ADMIN_NAME` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `ADMIN_PASSWORD` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `ADMIN_DESC` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `ADMIN_PHONE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `ADMIN_LOGIN_CNT` int NOT NULL DEFAULT 0,
  `ADMIN_TYPE` int NOT NULL DEFAULT 0,
  `ADMIN_STATUS` int NOT NULL DEFAULT 1,
  `ADMIN_LOGIN_TIME` bigint NOT NULL DEFAULT 0,
  `ADD_TIME` bigint NOT NULL DEFAULT 0,
  `EDIT_TIME` bigint NOT NULL DEFAULT 0,
  PRIMARY KEY (`ADMIN_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

INSERT INTO `actcampus_admin` VALUES (1, 'admin', 'e10adc3949ba59abbe56e057f20f883e', 'admin', NULL, 1, 1, 1, 1735302901541, 0, 1734786380484);

-- ----------------------------
-- Table structure for actcampus_fav
-- ----------------------------
DROP TABLE IF EXISTS `actcampus_fav`;
CREATE TABLE `actcampus_fav`  (
  `FAV_ID` int NOT NULL AUTO_INCREMENT,
  `FAV_USER_ID` int NOT NULL DEFAULT 0,
  `FAV_TITLE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `FAV_TYPE` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `FAV_OID` int NOT NULL DEFAULT 0,
  `FAV_PATH` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `ADD_TIME` bigint NOT NULL DEFAULT 0,
  `EDIT_TIME` bigint NOT NULL DEFAULT 0,
  PRIMARY KEY (`FAV_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for actcampus_news
-- ----------------------------
DROP TABLE IF EXISTS `actcampus_news`;
CREATE TABLE `actcampus_news`  (
  `NEWS_ID` int NOT NULL AUTO_INCREMENT,
  `NEWS_TITLE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `NEWS_CATE_ID` int NOT NULL DEFAULT 0,
  `NEWS_CATE_NAME` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `NEWS_STATUS` int NOT NULL DEFAULT 1,
  `NEWS_ORDER` int NOT NULL DEFAULT 9999,
  `NEWS_VOUCH` int NOT NULL DEFAULT 0,
  `NEWS_CONTENT` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `NEWS_VIEW_CNT` int NOT NULL DEFAULT 0,
  `NEWS_PIC` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `NEWS_OBJ` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `NEWS_FORMS` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `ADD_TIME` bigint NOT NULL DEFAULT 0,
  `EDIT_TIME` bigint NOT NULL DEFAULT 0,
  PRIMARY KEY (`NEWS_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 73 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for actcampus_setup
-- ----------------------------
DROP TABLE IF EXISTS `actcampus_setup`;
CREATE TABLE `actcampus_setup`  (
  `SETUP_ID` int NOT NULL AUTO_INCREMENT,
  `SETUP_TYPE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `SETUP_KEY` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `SETUP_VALUE` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `ADD_TIME` bigint NOT NULL DEFAULT 0,
  `EDIT_TIME` bigint NOT NULL DEFAULT 0,
  PRIMARY KEY (`SETUP_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for actcampus_user
-- ----------------------------
DROP TABLE IF EXISTS `actcampus_user`;
CREATE TABLE `actcampus_user`  (
  `USER_ID` int NOT NULL AUTO_INCREMENT,
  `USER_NAME` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `USER_ACCOUNT` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `USER_STATUS` int NOT NULL DEFAULT 1,
  `USER_PASSWORD` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `USER_LOGIN_TIME` bigint NOT NULL DEFAULT 0,
  `USER_LOGIN_CNT` int NOT NULL DEFAULT 0,
  `USER_OBJ` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `USER_FORMS` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `ADD_TIME` bigint NOT NULL DEFAULT 0,
  `EDIT_TIME` bigint NOT NULL DEFAULT 0,
  PRIMARY KEY (`USER_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 215 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

SET FOREIGN_KEY_CHECKS = 1;

    UI设计

    image.png
    image.png
    image.png
    image.png
    image.png
    image.png
    image.png

    管理系统

    image.png
    image.png
    image.png
    image.png
    image.png
    image.png
    image.png
    image.png
    image.png
    image.png

    git代码分享

    点击下载

    javaspringboot小程序
    CC同学呀
    24 声望15 粉丝

    鹅厂程序猿一枚，交流v: cclinux0730

    « 上一篇
    从0到100：基于Java的大学选修课选课小程序开发笔记（上）
    下一篇 »
    从0到1：琴房预订小程序开发笔记（上）

    引用和评论

    推荐阅读
    头像
    从0到1：琴房预订小程序开发笔记（上）

    CC同学呀阅读 567

    头像
    Java8的新特性

    codecraft赞 35阅读 31.1k评论 1

    头像
    Java11的新特性

    codecraft赞 28阅读 22k评论 3

    头像
    Java5的新特性

    codecraft赞 13阅读 25.2k

    头像
    Java9的新特性

    codecraft赞 20阅读 18.2k

    头像
    Java13的新特性

    codecraft赞 17阅读 13.3k

    头像
    Java7的新特性

    codecraft赞 10阅读 20.9k

    0 条评论
    得票最新