文章目录源码获取稀缺资源尽快转存到自己网盘防止失效详细视频演示具体实现截图后端框架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.itmk.web.house_list.controller;importcom.baomidou.mybatisplus.core.conditions.query.QueryWrapper;importcom.baomidou.mybatisplus.core.metadata.IPage;importcom.itmk.utils.ResultUtils;importcom.itmk.utils.ResultVo;importcom.itmk.web.house_list.entity.HouseList;importcom.itmk.web.house_list.entity.ListParm;importcom.itmk.web.house_list.service.HouseListService;importorg.springframework.beans.factory.annotation.Autowired;importorg.springframework.security.access.prepost.PreAuthorize;importorg.springframework.web.bind.annotation.*;importjava.util.List;/** * 房屋管理控制器 */RestControllerRequestMapping(/api/houseList)publicclassHouseListController{AutowiredprivateHouseListServicehouseListService;/** * 获取房屋列表 */GetMapping(/list)publicResultVogetList(ListParmparm){IPageHouseListlisthouseListService.getList(parm);returnResultUtils.success(查询成功,list);}/** * 新增 */PostMappingPreAuthorize(hasAuthority(sys:house:add))publicResultVoadd(RequestBodyHouseListhouseList){System.out.println(houseList.toString());booleansavehouseListService.save(houseList);if(save){returnResultUtils.success(新增房屋成功);}returnResultUtils.error(新增房屋失败!);}/** * 编辑 */PutMappingPreAuthorize(hasAuthority(sys:house:edit))publicResultVoedit(RequestBodyHouseListhouseList){booleansavehouseListService.updateById(houseList);if(save){returnResultUtils.success(编辑房屋成功);}returnResultUtils.error(编辑房屋失败!);}/** * 删除 */DeleteMapping(/{houseId})PreAuthorize(hasAuthority(sys:house:delete))publicResultVodelete(PathVariable(houseId)LonghouseId){booleansavehouseListService.removeById(houseId);if(save){returnResultUtils.success(删除房屋成功);}returnResultUtils.error(删除房屋失败!);}/** * 根据单元id获取房屋列表 */GetMapping(/getHouseByUnitId)publicResultVogetHouseByUnitId(HouseListhouseList){QueryWrapperHouseListquerynewQueryWrapper();query.lambda().eq(HouseList::getUnitId,houseList.getUnitId());ListHouseListlisthouseListService.list(query);returnResultUtils.success(查询成功,list);}}数据库DROPTABLEIFEXISTSfee_park;CREATETABLEfee_park(park_fee_idintNOTNULLAUTO_INCREMENTCOMMENT主键,user_idintNULLDEFAULTNULLCOMMENT业主id,park_idintNULLDEFAULTNULLCOMMENT车位id,pay_park_monthvarchar(16)CHARACTERSETutf8mb4COLLATEutf8mb4_binNULLDEFAULTNULLCOMMENT缴费年月,pay_park_moneydecimal(18,2)NULLDEFAULTNULLCOMMENT缴费金额,pay_park_statusvarchar(2)CHARACTERSETutf8mb4COLLATEutf8mb4_binNULLDEFAULTNULLCOMMENT0:未缴费 1已缴费,pay_park_timedatetimeNULLDEFAULTNULL,PRIMARYKEY(park_fee_id)USINGBTREE)ENGINEInnoDBAUTO_INCREMENT14CHARACTERSETutf8mb4COLLATEutf8mb4_bin ROW_FORMATDYNAMIC;-- ------------------------------ Records of fee_park-- ----------------------------INSERTINTOfee_parkVALUES(1,1,1,2024-03,120.00,1,NULL);INSERTINTOfee_parkVALUES(2,2,2,2024-03,120.00,0,NULL);INSERTINTOfee_parkVALUES(3,3,3,2024-03,120.00,0,NULL);INSERTINTOfee_parkVALUES(4,4,4,2024-03,120.00,1,NULL);INSERTINTOfee_parkVALUES(5,5,5,2024-03,120.00,0,NULL);INSERTINTOfee_parkVALUES(6,6,6,2024-03,120.00,0,NULL);INSERTINTOfee_parkVALUES(7,7,7,2024-03,120.00,1,NULL);INSERTINTOfee_parkVALUES(9,8,8,2024-03,120.00,0,NULL);INSERTINTOfee_parkVALUES(10,9,9,2024-03,120.00,0,NULL);INSERTINTOfee_parkVALUES(12,12,11,2024-03,120.00,0,NULL);INSERTINTOfee_parkVALUES(13,12,11,2024-03,120.00,0,NULL);-- ------------------------------ Table structure for fee_power-- ----------------------------DROPTABLEIFEXISTSfee_power;CREATETABLEfee_power(power_idintNOTNULLAUTO_INCREMENTCOMMENT主键,house_idintNULLDEFAULTNULLCOMMENT房屋id,user_idintNULLDEFAULTNULLCOMMENT业主id,pay_power_monthvarchar(16)CHARACTERSETutf8mb4COLLATEutf8mb4_binNULLDEFAULTNULLCOMMENT缴费年月,pay_power_moneydecimal(18,2)NULLDEFAULTNULLCOMMENT缴费金额,power_numvarchar(16)CHARACTERSETutf8mb4COLLATEutf8mb4_binNULLDEFAULTNULLCOMMENT表显,pay_power_statusvarchar(2)CHARACTERSETutf8mb4COLLATEutf8mb4_binNULLDEFAULTNULLCOMMENT0:未缴费 1已缴费,pay_power_timedatetimeNULLDEFAULTNULLCOMMENT缴费时间,PRIMARYKEY(power_id)USINGBTREE)ENGINEInnoDBAUTO_INCREMENT15CHARACTERSETutf8mb4COLLATEutf8mb4_bin ROW_FORMATDYNAMIC;-- ------------------------------ Records of fee_power-- ----------------------------INSERTINTOfee_powerVALUES(1,1,1,2024-03,100.00,100,0,NULL);INSERTINTOfee_powerVALUES(2,2,2,2024-03,120.00,120,1,NULL);INSERTINTOfee_powerVALUES(3,3,3,2024-03,123.00,123,1,NULL);INSERTINTOfee_powerVALUES(4,4,4,2024-03,112.00,112,0,NULL);INSERTINTOfee_powerVALUES(5,5,5,2024-03,80.00,80,1,NULL);INSERTINTOfee_powerVALUES(6,6,7,2024-03,55.00,55,0,NULL);INSERTINTOfee_powerVALUES(7,45,22,2024-03,44.00,44,0,NULL);INSERTINTOfee_powerVALUES(8,7,6,2024-03,76.00,76,0,NULL);INSERTINTOfee_powerVALUES(9,8,8,2024-03,55.00,55,0,NULL);INSERTINTOfee_powerVALUES(10,9,9,2024-03,76.00,76,0,NULL);INSERTINTOfee_powerVALUES(11,10,10,2024-03,44.00,44,0,NULL);INSERTINTOfee_powerVALUES(13,1,1,2024-08,111.00,111,1,NULL);INSERTINTOfee_powerVALUES(14,21,51,2024-05,123.00,13,0,NULL);-- ------------------------------ Table structure for fee_water-- ----------------------------DROPTABLEIFEXISTSfee_water;CREATETABLEfee_water(water_idintNOTNULLAUTO_INCREMENTCOMMENT主键,house_idintNULLDEFAULTNULLCOMMENT房屋id,user_idintNULLDEFAULTNULLCOMMENT业主id,pay_water_monthvarchar(16)CHARACTERSETutf8mb4COLLATEutf8mb4_binNULLDEFAULTNULLCOMMENT缴费年月,pay_water_moneydecimal(18,2)NULLDEFAULTNULLCOMMENT缴费金额,waterr_numvarchar(16)CHARACTERSETutf8mb4COLLATEutf8mb4_binNULLDEFAULTNULLCOMMENT表显,pay_water_statusvarchar(2)CHARACTERSETutf8mb4COLLATEutf8mb4_binNULLDEFAULTNULLCOMMENT0:未缴费 1已缴费,pay_water_timedatetimeNULLDEFAULTNULLCOMMENT缴费时间,PRIMARYKEY(water_id)USINGBTREE)ENGINEInnoDBAUTO_INCREMENT17CHARACTERSETutf8mb4COLLATEutf8mb4_bin ROW_FORMATDYNAMIC;-- ------------------------------ Records of fee_water-- ----------------------------INSERTINTOfee_waterVALUES(1,1,1,2024-03,30.00,30,1,2024-04-19 22:41:53);INSERTINTOfee_waterVALUES(2,2,2,2024-03,40.00,40,0,NULL);INSERTINTOfee_waterVALUES(3,3,3,2024-03,50.00,50,0,NULL);INSERTINTOfee_waterVALUES(4,4,4,2024-03,20.00,20,1,2024-04-19 22:41:48);INSERTINTOfee_waterVALUES(5,5,5,2024-03,40.00,40,1,2024-10-22 18:13:33);INSERTINTOfee_waterVALUES(6,45,22,2024-03,90.00,90,0,NULL);INSERTINTOfee_waterVALUES(7,6,7,2024-03,34.00,34,1,2024-04-19 22:41:56);INSERTINTOfee_waterVALUES(8,7,6,2024-03,43.00,43,0,NULL);INSERTINTOfee_waterVALUES(9,8,8,2024-03,55.00,55,1,2024-04-19 22:41:58);INSERTINTOfee_waterVALUES(10,10,10,2024-03,66.00,66,0,NULL);INSERTINTOfee_waterVALUES(13,9,9,2024-03,90.00,90,0,NULL);INSERTINTOfee_waterVALUES(14,10,10,2024-03,90.00,90,0,NULL);INSERTINTOfee_waterVALUES(15,11,11,2024-03,90.00,90,0,NULL);INSERTINTOfee_waterVALUES(16,12,12,2024-03,90.00,90,0,NULL);