【原创唯一】基于微信小程序+uni-app+AI大模型的高校校园活动报名与签到小程序

【原创唯一】基于微信小程序+uni-app+AI大模型的高校校园活动报名与签到小程序

发布时间：2026/8/19 8:30:40
【原创唯一】基于微信小程序+uni-app+AI大模型的高校校园活动报名与签到小程序 摘要本文设计并实现高校校园活动报名与签到小程序面向管理员、活动组织者与学生三类角色覆盖活动发布与审核、在线报名、现场签到、积分激励、评价反馈及智能推荐等环节。系统采用AI大模型、 Spring Boot 与 Vue 前后端分离架构并配套 uni-app 小程序学生可在移动端完成浏览、报名、扫码签到与积分查询。针对现场代签、参与动力不足与活动发现效率低等问题系统在活动审核通过后生成唯一签到令牌完成到场确认按报名、签到、评价规则自动发放积分并结合报名率与收藏数生成热度提示。进一步接入大模型根据学生兴趣与参与档案推荐可报名活动并对评价文本进行情感与优缺点归纳。无密钥或调用失败时回退关键词与本地统计保证演示可用。本文完成需求分析、总体设计、数据库设计、接口实现与测试说明形成可运行的校园活动管理方案。技术栈 Spring Boot3uni-appVue3uViewPlusViteMybatsiPlusAI大模型微信小程序数据库表13张创新点二维码签到防代签、活动积分联动激励、活动热度推荐提示、AI大模型智能活动推荐、AI大模型评价智能分析演示视频高校校园活动报名与签到小程序文末获取联系文末获取联系作者介绍专注计算机编程个人开发坚持原创非工作室源码全网唯一。✅技术主流SpringBootVueuni-app前后端分离MySQLAI大模型可本地运行✅技术主流SpringBoot Vue 前后端分离MySQLAI大模型可本地运行✅配套资料源码 数据库 实验报告/论文 答辩 PPT部署演示远程调试问题解答技术范围SpringBoot、Vue、数据可视化、小程序、HLMT、Nodejs、uni-app、MySQL数据库、ElementUi等设计与开发。适用范围软件工程、软件技术、计算机科学与技术、大数据、云计算、JavaWeb开发、JavaEE、Java、Web应用开发、动态网页设计、小程序的毕设参考开发文档创新点说明、功能需求分析、数据库表结构设计、后端接口设计、创新点代码分析功能展示小程序小程序功能菜单名称1首页2活动列表3活动详情4AI推荐5公告通知6我的报名7我的收藏8我的积分9系统消息10个人中心后台功能管理员功能菜单名称1数据统计2活动分类3活动审核4报名管理5签到记录6活动评价7积分规则8积分流水9公告管理10学生管理11组织者管理12管理员账号活动组织者菜单名称1参与统计2我的活动3报名审核4签到管理5个人中心数据库及架构系统数据库设计为数据库设计SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS 0; -- ---------------------------- -- Table structure for activities -- ---------------------------- DROP TABLE IF EXISTS activities; CREATE TABLE activities ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键, organizer_id bigint(20) NOT NULL COMMENT 组织者, category_id bigint(20) NULL DEFAULT NULL COMMENT 活动分类, title varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 活动标题, description text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 活动详情, cover varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 封面图, place varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 活动地点, start_time datetime NULL DEFAULT NULL COMMENT 开始时间, end_time datetime NULL DEFAULT NULL COMMENT 结束时间, signup_deadline datetime NULL DEFAULT NULL COMMENT 报名截止, quota int(11) NULL DEFAULT 0 COMMENT 名额上限, need_audit tinyint(4) NULL DEFAULT 1 COMMENT 报名需审核, status tinyint(4) NULL DEFAULT 0 COMMENT 状态, reject_reason varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 驳回原因, sign_code varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 签到二维码令牌, hot_hint varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 热度推荐提示, summary text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 活动总结, created_at datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间, PRIMARY KEY (id) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 6 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 校园活动 ROW_FORMAT DYNAMIC; -- ---------------------------- -- Table structure for admins -- ---------------------------- DROP TABLE IF EXISTS admins; CREATE TABLE admins ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键, username varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 账号, password varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 密码, name varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 姓名, phone varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 手机号, enabled tinyint(4) NULL DEFAULT 1 COMMENT 是否启用, PRIMARY KEY (id) USING BTREE, UNIQUE INDEX username(username) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 2 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 管理员 ROW_FORMAT DYNAMIC; -- ---------------------------- -- Table structure for categories -- ---------------------------- DROP TABLE IF EXISTS categories; CREATE TABLE categories ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键, name varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 分类名称, sort_order int(11) NULL DEFAULT 0 COMMENT 排序, enabled tinyint(4) NULL DEFAULT 1 COMMENT 是否启用, PRIMARY KEY (id) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 4 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 活动分类 ROW_FORMAT DYNAMIC; -- ---------------------------- -- Table structure for evaluates -- ---------------------------- DROP TABLE IF EXISTS evaluates; CREATE TABLE evaluates ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键, activity_id bigint(20) NOT NULL COMMENT 活动, student_id bigint(20) NOT NULL COMMENT 学生, score tinyint(4) NULL DEFAULT NULL COMMENT 评分, content text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 评价内容, created_at datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间, PRIMARY KEY (id) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 3 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 活动评价 ROW_FORMAT DYNAMIC; -- ---------------------------- -- Table structure for favorites -- ---------------------------- DROP TABLE IF EXISTS favorites; CREATE TABLE favorites ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键, student_id bigint(20) NOT NULL COMMENT 学生, activity_id bigint(20) NOT NULL COMMENT 活动, created_at datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 收藏时间, PRIMARY KEY (id) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 7 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 活动收藏 ROW_FORMAT DYNAMIC; -- ---------------------------- -- Table structure for messages -- ---------------------------- DROP TABLE IF EXISTS messages; CREATE TABLE messages ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键, sender_id bigint(20) NULL DEFAULT NULL COMMENT 发送人, receiver_id bigint(20) NOT NULL COMMENT 接收人, title varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 标题, content text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 内容, read_flag tinyint(4) NULL DEFAULT 0 COMMENT 是否已读, ref_type varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 关联类型, ref_id bigint(20) NULL DEFAULT NULL COMMENT 关联对象, created_at datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间, PRIMARY KEY (id) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 10 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 系统消息 ROW_FORMAT DYNAMIC; -- ---------------------------- -- Table structure for notices -- ---------------------------- DROP TABLE IF EXISTS notices; CREATE TABLE notices ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键, title varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 标题, content text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 内容, status tinyint(4) NULL DEFAULT 1 COMMENT 状态, created_at datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间, PRIMARY KEY (id) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 3 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 平台公告 ROW_FORMAT DYNAMIC; -- ---------------------------- -- Table structure for organizers -- ---------------------------- DROP TABLE IF EXISTS organizers; CREATE TABLE organizers ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键, username varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 账号, password varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 密码, name varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 姓名, phone varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 手机号, dept varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 所属部门, avatar varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 头像, enabled tinyint(4) NULL DEFAULT 1 COMMENT 是否启用, PRIMARY KEY (id) USING BTREE, UNIQUE INDEX username(username) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 3 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 活动组织者 ROW_FORMAT DYNAMIC; -- ---------------------------- -- Table structure for point_records -- ---------------------------- DROP TABLE IF EXISTS point_records; CREATE TABLE point_records ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键, student_id bigint(20) NOT NULL COMMENT 学生, change_amount int(11) NOT NULL COMMENT 变动积分, balance_after int(11) NOT NULL COMMENT 变动后积分, reason varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 变动原因, ref_type varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 关联类型, ref_id bigint(20) NULL DEFAULT NULL COMMENT 关联对象, created_at datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间, PRIMARY KEY (id) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 11 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 积分流水 ROW_FORMAT DYNAMIC; -- ---------------------------- -- Table structure for point_rules -- ---------------------------- DROP TABLE IF EXISTS point_rules; CREATE TABLE point_rules ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键, event_type varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 事件类型, points int(11) NOT NULL COMMENT 积分值, description varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 规则说明, enabled tinyint(4) NULL DEFAULT 1 COMMENT 是否启用, PRIMARY KEY (id) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 4 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 积分规则 ROW_FORMAT DYNAMIC; -- ---------------------------- -- Table structure for signs -- ---------------------------- DROP TABLE IF EXISTS signs; CREATE TABLE signs ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键, activity_id bigint(20) NOT NULL COMMENT 活动, signup_id bigint(20) NOT NULL COMMENT 报名记录, student_id bigint(20) NOT NULL COMMENT 学生, sign_type varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 签到方式, created_at datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 签到时间, PRIMARY KEY (id) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 4 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 活动签到 ROW_FORMAT DYNAMIC; -- ---------------------------- -- Table structure for signups -- ---------------------------- DROP TABLE IF EXISTS signups; CREATE TABLE signups ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键, activity_id bigint(20) NOT NULL COMMENT 活动, student_id bigint(20) NOT NULL COMMENT 学生, status tinyint(4) NULL DEFAULT 0 COMMENT 状态, remark varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 备注, created_at datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间, PRIMARY KEY (id) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 7 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 活动报名 ROW_FORMAT DYNAMIC; -- ---------------------------- -- Table structure for students -- ---------------------------- DROP TABLE IF EXISTS students; CREATE TABLE students ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键, username varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 账号, password varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 密码, name varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 姓名, student_no varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 学号, gender tinyint(4) NULL DEFAULT NULL COMMENT 性别, phone varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 手机号, activity_points int(11) NULL DEFAULT 0 COMMENT 活动积分, avatar varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 头像, enabled tinyint(4) NULL DEFAULT 1 COMMENT 是否启用, PRIMARY KEY (id) USING BTREE, UNIQUE INDEX username(username) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 6 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 学生 ROW_FORMAT DYNAMIC; SET FOREIGN_KEY_CHECKS 1;擅长功能设计、开题报告、任务书、中期检查PPT、系统功能实现、代码编写、论文编写和辅导、论文降重、长期答辩答疑辅导、腾讯会议一对一专业讲解辅导答辩、模拟答辩演练、和理解代码逻辑思路等。获取联系项目功能完整可在本地运行并可远程调试确保运行顺利获取联系方式毕业设计获取https://blog.csdn.net/qq_59059632/article/details/163759879?spm1011.2415.3001.5331