文章目录源码获取稀缺资源尽快转存到自己网盘防止失效详细视频演示具体实现截图后端框架SpringBoot前端框架Vue持久层框架MyBaits代码参考数据库源码获取稀缺资源尽快转存到自己网盘防止失效网盘内附带教程代码文件完整可提供远程部署夸克网盘百度网盘详细视频演示视频演示具体实现截图后端框架SpringBootSpring Boot允许开发者快速构建出既可以独立运行又满足生产级别标准的Spring基础应用程序。此框架通过提供一系列便捷的工具和服务极大地促进了基于Spring的应用开发工作的效率和质量。通过提供一系列大型项目中常用的默认配置Spring Boot最大化减少配置文件的使用开发者能够迅速启动和运行Spring应用程序。Spring Boot通过约定优于配置的原则避免了许多传统Spring应用开发时繁琐的配置该框架支持对内嵌服务器的自动配置如Tomcat、Jetty或Undertow从而简化了Web应用的部署过程。前端框架VueVue.js是一种流行的JavaScript框架它具有许多优势。其中Vue.js的核心优势之一是虚拟DOM技术。虚拟DOM是一个内存中的数据结构它在实现高效的DOM操作方面发挥了重要作用。Vue.js采用了响应式数据绑定、虚拟DOM、组件化等现代化技术为开发者提供了一种灵活、高效、易于维护的开发模式。当数据发生变化时Vue.js能够自动更新UI开发者无需手动更新UI从而能够更加专注于数据处理。持久层框架MyBaitsMyBatis是一个开源的持久层框架它可以帮助开发者简化数据库操作的编写和管理。MyBatis的核心思想是将SQL语句和Java代码分离通过XML或注解的方式来描述数据库操作从而实现了数据访问层的解耦和灵活性。MyBatis的优势主要包括以下几点简化数据库操作MyBatis通过提供强大的SQL映射功能可以将Java对象与数据库表进行映射开发者无需手动编写繁琐的SQL语句大大简化了数据库操作的编写和维护。灵活的SQL控制MyBatis支持动态SQL可以根据不同的条件和逻辑来动态生成SQL语句使得查询、更新等操作更加灵活和可控。缓存支持MyBatis提供了一级缓存和二级缓存的支持可以有效减少数据库的访问次数提高系统性能。可扩展性强MyBatis采用插件机制可以方便地扩展和定制自己的功能满足各种不同的业务需求。代码参考packagecom.example.springboot.controller;importcom.baomidou.mybatisplus.extension.plugins.pagination.Page;importcom.example.springboot.common.Result;importcom.example.springboot.entity.DormManager;importcom.example.springboot.entity.User;importcom.example.springboot.service.DormManagerService;importorg.springframework.web.bind.annotation.*;importjavax.annotation.Resource;importjavax.servlet.http.HttpSession;RestControllerRequestMapping(/dormManager)publicclassDormManagerController{ResourceprivateDormManagerServicedormManagerService;/** * 宿管添加 */PostMapping(/add)publicResult?add(RequestBodyDormManagerdormManager){intidormManagerService.addNewDormManager(dormManager);if(i1){returnResult.success();}else{returnResult.error(-1,添加失败);}}/** * 宿管信息更新 */PutMapping(/update)publicResult?update(RequestBodyDormManagerdormManager){intidormManagerService.updateNewDormManager(dormManager);if(i1){returnResult.success();}else{returnResult.error(-1,更新失败);}}/** * 宿管删除 */DeleteMapping(/delete/{username})publicResult?delete(PathVariableStringusername){intidormManagerService.deleteDormManager(username);if(i1){returnResult.success();}else{returnResult.error(-1,删除失败);}}/** * 宿管查找 */GetMapping(/find)publicResult?findPage(RequestParam(defaultValue1)IntegerpageNum,RequestParam(defaultValue10)IntegerpageSize,RequestParam(defaultValue)Stringsearch){PagepagedormManagerService.find(pageNum,pageSize,search);if(page!null){returnResult.success(page);}else{returnResult.error(-1,查询失败);}}/** * 宿管登录 */PostMapping(/login)publicResult?login(RequestBodyUseruser,HttpSessionsession){ObjectodormManagerService.dormManagerLogin(user.getUsername(),user.getPassword());if(o!null){System.out.println(o);//存入sessionsession.setAttribute(Identity,dormManager);session.setAttribute(User,o);returnResult.success(o);}else{returnResult.error(-1,用户名或密码错误);}}}数据库-- ------------------------------ Table structure for adjust_room-- ----------------------------DROPTABLEIFEXISTSadjust_room;CREATETABLEadjust_room(idint(0)NOTNULLAUTO_INCREMENT,usernamevarchar(255)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULLCOMMENT账号,namevarchar(255)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULLCOMMENT姓名,currentroom_idint(0)NOTNULLCOMMENT当前房间,currentbed_idint(0)NOTNULLCOMMENT当前床位号,towardsroom_idint(0)NOTNULLCOMMENT目标房间,towardsbed_idint(0)NOTNULLCOMMENT目标床位号,stateenum(未处理,通过,驳回)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULLDEFAULT未处理COMMENT申请状态,apply_timevarchar(255)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULLCOMMENT申请时间,finish_timevarchar(255)CHARACTERSETutf8COLLATEutf8_general_ciNULLDEFAULTNULLCOMMENT处理时间,PRIMARYKEY(id)USINGBTREE)ENGINEInnoDBAUTO_INCREMENT8CHARACTERSETutf8COLLATEutf8_general_ci ROW_FORMATDynamic;-- ------------------------------ Records of adjust_room-- ----------------------------INSERTINTOadjust_roomVALUES(2,stu1,张三,1101,1,1102,4,通过,2025-02-17 14:35:02,2025-03-19 23:07:21);INSERTINTOadjust_roomVALUES(5,stu2,田田,1101,2,1104,1,未处理,2025-03-19 23:05:25,NULL);INSERTINTOadjust_roomVALUES(6,stu3,吉安,1101,3,1104,2,驳回,2025-03-19 23:05:52,2025-03-19 23:07:37);INSERTINTOadjust_roomVALUES(7,stu9,德萨,1103,2,1105,1,未处理,2025-03-19 23:06:18,NULL);INSERTINTOadjust_roomVALUES(8,stu6,泡泡,1102,2,1104,4,未处理,2025-03-19 23:06:52,NULL);-- ------------------------------ Table structure for admin-- ----------------------------DROPTABLEIFEXISTSadmin;CREATETABLEadmin(usernamevarchar(255)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULLCOMMENT用户名,passwordvarchar(32)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULLCOMMENT密码,namevarchar(255)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULLCOMMENT姓名,genderenum(男,女)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULLDEFAULT男COMMENT性别,ageint(0)NOTNULLCOMMENT年龄,phone_numvarchar(11)CHARACTERSETutf8COLLATEutf8_general_ciNULLDEFAULTNULLCOMMENT手机号,emailvarchar(255)CHARACTERSETutf8COLLATEutf8_general_ciNULLDEFAULTNULLCOMMENT邮箱,avatarvarchar(255)CHARACTERSETutf8COLLATEutf8_general_ciNULLDEFAULTNULLCOMMENT头像,PRIMARYKEY(username)USINGBTREE)ENGINEInnoDBCHARACTERSETutf8COLLATEutf8_general_ci ROW_FORMATDynamic;-- ------------------------------ Records of admin-- ----------------------------INSERTINTOadminVALUES(admin,123456,大强,男,18,14785412478,NULL,4eb7dd1d20ad4b68b3b6a39651281537.png);-- ------------------------------ Table structure for dorm_build-- ----------------------------DROPTABLEIFEXISTSdorm_build;CREATETABLEdorm_build(dormbuild_idint(0)NOTNULLCOMMENT宿舍楼号码,dormbuild_namevarchar(255)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULLCOMMENT宿舍楼名称,dormbuild_detailvarchar(255)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULLCOMMENT宿舍楼备注,idint(0)NOTNULLAUTO_INCREMENTCOMMENT主键,PRIMARYKEY(id)USINGBTREE)ENGINEInnoDBAUTO_INCREMENT20CHARACTERSETutf8COLLATEutf8_general_ci ROW_FORMATDynamic;-- ------------------------------ Records of dorm_build-- ----------------------------INSERTINTOdorm_buildVALUES(1,一号楼,男宿舍,1);INSERTINTOdorm_buildVALUES(2,二号楼,女宿舍,2);INSERTINTOdorm_buildVALUES(3,三号楼,男宿舍,3);INSERTINTOdorm_buildVALUES(4,四号楼,女宿舍,4);-- ------------------------------ Table structure for dorm_manager-- ----------------------------DROPTABLEIFEXISTSdorm_manager;CREATETABLEdorm_manager(usernamevarchar(255)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULLCOMMENT用户名,passwordvarchar(32)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULLDEFAULT123456COMMENT密码,dormbuild_idint(0)NOTNULLCOMMENT所管理的宿舍楼栋号,namevarchar(255)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULLCOMMENT名字,genderenum(男,女)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULLDEFAULT男COMMENT性别,ageint(0)NOTNULLCOMMENT年龄,phone_numvarchar(11)CHARACTERSETutf8COLLATEutf8_general_ciNULLDEFAULTNULLCOMMENT手机号,emailvarchar(255)CHARACTERSETutf8COLLATEutf8_general_ciNULLDEFAULTNULLCOMMENT邮箱,avatarvarchar(255)CHARACTERSETutf8COLLATEutf8_general_ciNULLDEFAULTNULLCOMMENT头像,PRIMARYKEY(username)USINGBTREE)ENGINEInnoDBCHARACTERSETutf8COLLATEutf8_general_ci ROW_FORMATDynamic;-- ------------------------------ Records of dorm_manager-- ----------------------------INSERTINTOdorm_managerVALUES(dorm1,123456,1,张三,男,35,15995917873,NULL,NULL);INSERTINTOdorm_managerVALUES(dorm2,123456,2,李四,女,55,15995917874,NULL,NULL);INSERTINTOdorm_managerVALUES(dorm3,123456,3,王五,男,38,15896875201,NULL,NULL);INSERTINTOdorm_managerVALUES(dorm4,123456,4,赵花,女,40,15877535247,NULL,NULL);-- ------------------------------ Table structure for dorm_room-- ----------------------------DROPTABLEIFEXISTSdorm_room;CREATETABLEdorm_room(dormroom_idint(0)NOTNULLCOMMENT宿舍房间号,dormbuild_idint(0)NOTNULLCOMMENT宿舍楼号,floor_numint(0)NOTNULLCOMMENT楼层,max_capacityint(0)NOTNULLDEFAULT4COMMENT房间最大入住人数,current_capacityint(0)NOTNULLDEFAULT0COMMENT当前房间入住人数,first_bedvarchar(255)CHARACTERSETutf8COLLATEutf8_general_ciNULLDEFAULTNULLCOMMENT一号床位,second_bedvarchar(255)CHARACTERSETutf8COLLATEutf8_general_ciNULLDEFAULTNULLCOMMENT二号床位,third_bedvarchar(255)CHARACTERSETutf8COLLATEutf8_general_ciNULLDEFAULTNULLCOMMENT三号床位,fourth_bedvarchar(255)CHARACTERSETutf8COLLATEutf8_general_ciNULLDEFAULTNULLCOMMENT四号床位,PRIMARYKEY(dormroom_id)USINGBTREE)ENGINEInnoDBCHARACTERSETutf8COLLATEutf8_general_ci ROW_FORMATDynamic;