宿舍管理系统代码实现

宿舍管理系统代码实现宿舍管理系统旨在实现对宿舍信息、学生住宿信息、宿舍报修等功能的有效管理。通过该系统，宿舍管理人员能够方便快捷地进行各项操作，提高宿舍管理的效率和准确性。##二、技术选型1.前端：采用HTML5、CSS3和JavaScript进行页面设计，使用Vue.js框架构建前端应用，以提高代码的可维护性和交互性。2.后端：选择SpringBoot作为后端开发框架，它具有快速开发、内置Web容器等优点。数据库采用MySQL，用于存储系统中的各种数据。##三、数据库设计1.宿舍表（dormitory）-字段：dormitory_id（宿舍编号，主键），dormitory_name（宿舍名称），building_id（所属楼栋编号），room_number（房间号），capacity（宿舍容量）2.学生表（student）-字段：student_id（学生编号，主键），student_name（学生姓名），gender（性别），department（所在院系），major（专业），entrance_year（入学年份）3.住宿关系表（student_dormitory）-字段：id（主键），student_id（学生编号，外键关联student表），dormitory_id（宿舍编号，外键关联dormitory表），start_date（入住时间），end_date（离校时间）4.报修表（repair）-字段：repair_id（报修编号，主键），student_id（学生编号，外键关联student表），dormitory_id（宿舍编号，外键关联dormitory表），problem_description（问题描述），repair_status（报修状态，如待处理、处理中、已完成），repair_date（报修时间）##四、后端代码实现（一）SpringBoot项目搭建1.创建SpringBoot项目使用SpringInitializr创建一个新的SpringBoot项目，选择所需的依赖，如SpringWeb、SpringDataJPA、MySQLDriver等。2.配置文件在`src/main/resources/perties`中配置数据库连接信息：```propertiesspring.datasource.url=jdbc:mysql://localhost:3306/dormitory_managementspring.datasource.username=rootspring.datasource.password=passwordspring.datasource.driver-class-name.mysql.cj.jdbc.Driverspring.jpa.database-platform=org.hibernate.dialect.MySQL57Dialect```（二）宿舍相关接口实现1.创建宿舍接口在`DormitoryController`中编写创建宿舍的接口：```java@RestController@RequestMapping("/dormitories")publicclassDormitoryController{privatefinalDormitoryServicedormitoryService;publicDormitoryController(DormitoryServicedormitoryService){this.dormitoryService=dormitoryService;}@PostMappingpublicResponseEntity<Dormitory>createDormitory(@RequestBodyDormitorydormitory){DormitorycreatedDormitory=dormitoryService.createDormitory(dormitory);returnnewResponseEntity<>(createdDormitory,HttpStatus.CREATED);}}```其中`DormitoryService`接口和实现类：```javapublicinterfaceDormitoryService{DormitorycreateDormitory(Dormitorydormitory);}@ServicepublicclassDormitoryServiceImplimplementsDormitoryService{privatefinalDormitoryRepositorydormitoryRepository;publicDormitoryServiceImpl(DormitoryRepositorydormitoryRepository){this.dormitoryRepository=dormitoryRepository;}@OverridepublicDormitorycreateDormitory(Dormitorydormitory){returndormitoryRepository.save(dormitory);}}````DormitoryRepository`继承自`JpaRepository`：```javapublicinterfaceDormitoryRepositoryextendsJpaRepository<Dormitory,Long>{}```2.获取所有宿舍接口```java@GetMappingpublicResponseEntity<List<Dormitory>>getAllDormitories(){List<Dormitory>dormitories=dormitoryService.getAllDormitories();returnnewResponseEntity<>(dormitories,HttpStatus.OK);}``````javapublicinterfaceDormitoryService{List<Dormitory>getAllDormitories();}@ServicepublicclassDormitoryServiceImplimplementsDormitoryService{privatefinalDormitoryRepositorydormitoryRepository;publicDormitoryServiceImpl(DormitoryRepositorydormitoryRepository){this.dormitoryRepository=dormitoryRepository;}@OverridepublicList<Dormitory>getAllDormitories(){returndormitoryRepository.findAll();}}```（三）学生相关接口实现1.创建学生接口```java@RestController@RequestMapping("/students")publicclassStudentController{privatefinalStudentServicestudentService;publicStudentController(StudentServicestudentService){this.studentService=studentService;}@PostMappingpublicResponseEntity<Student>createStudent(@RequestBodyStudentstudent){StudentcreatedStudent=studentService.createStudent(student);returnnewResponseEntity<>(createdStudent,HttpStatus.CREATED);}}``````javapublicinterfaceStudentService{StudentcreateStudent(Studentstudent);}@ServicepublicclassStudentServiceImplimplementsStudentService{privatefinalStudentRepositorystudentRepository;publicStudentServiceImpl(StudentRepositorystudentRepository){this.studentRepository=studentRepository;}@OverridepublicStudentcreateStudent(Studentstudent){returnstudentRepository.save(student);}}``````javapublicinterfaceStudentRepositoryextendsJpaRepository<Student,Long>{}```2.获取所有学生接口```java@GetMappingpublicResponseEntity<List<Student>>getAllStudents(){List<Student>students=studentService.getAllStudents();returnnewResponseEntity<>(students,HttpStatus.OK);}``````javapublicinterfaceStudentService{List<Student>getAllStudents();}@ServicepublicclassStudentServiceImplimplementsStudentService{privatefinalStudentRepositorystudentRepository;publicStudentServiceImpl(StudentRepositorystudentRepository){this.studentRepository=studentRepository;}@OverridepublicList<Student>getAllStudents(){returnstudentRepository.findAll();}}```（四）住宿关系相关接口实现1.分配学生到宿舍接口```java@RestController@RequestMapping("/student-dormitories")publicclassStudentDormitoryController{privatefinalStudentDormitoryServicestudentDormitoryService;publicStudentDormitoryController(StudentDormitoryServicestudentDormitoryService){this.studentDormitoryService=studentDormitoryService;}@PostMappingpublicResponseEntity<StudentDormitory>assignStudentToDormitory(@RequestBodyStudentDormitorystudentDormitory){StudentDormitoryassigned=studentDormitoryService.assignStudentToDormitory(studentDormitory);returnnewResponseEntity<>(assigned,HttpStatus.CREATED);}}``````javapublicinterfaceStudentDormitoryService{StudentDormitoryassignStudentToDormitory(StudentDormitorystudentDormitory);}@ServicepublicclassStudentDormitoryServiceImplimplementsStudentDormitoryService{privatefinalStudentDormitoryRepositorystudentDormitoryRepository;publicStudentDormitoryServiceImpl(StudentDormitoryRepositorystudentDormitoryRepository){this.studentDormitoryRepository=studentDormitoryRepository;}@OverridepublicStudentDormitoryassignStudentToDormitory(StudentDormitorystudentDormitory){returnstudentDormitoryRepository.save(studentDormitory);}}``````javapublicinterfaceStudentDormitoryRepositoryextendsJpaRepository<StudentDormitory,Long>{}```2.获取学生住宿信息接口```java@GetMapping("/{studentId}")publicResponseEntity<List<StudentDormitory>>getStudentAmodation(@PathVariableLongstudentId){List<StudentDormitory>studentDormitories=studentDormitoryService.getStudentAmodation(studentId);returnnewResponseEntity<>(studentDormitories,HttpStatus.OK);}``````javapublicinterfaceStudentDormitoryService{List<StudentDormitory>getStudentAmodation(LongstudentId);}@ServicepublicclassStudentDormitoryServiceImplimplementsStudentDormitoryService{privatefinalStudentDormitoryRepositorystudentDormitoryRepository;publicStudentDormitoryServiceImpl(StudentDormitoryRepositorystudentDormitoryRepository){this.studentDormitoryRepository=studentDormitoryRepository;}@OverridepublicList<StudentDormitory>getStudentAmodation(LongstudentId){returnstudentDormitoryRepository.findByStudentId(studentId);}}```（五）报修相关接口实现1.提交报修接口```java@RestController@RequestMapping("/repairs")publicclassRepairController{privatefinalRepairServicerepairService;publicRepairController(RepairServicerepairService){this.repairService=repairService;}@PostMappingpublicResponseEntity<Repair>submitRepair(@RequestBodyRepairrepair){RepairsubmittedRepair=repairService.submitRepair(repair);returnnewResponseEntity<>(submittedRepair,HttpStatus.CREATED);}}``````javapublicinterfaceRepairService{RepairsubmitRepair(Repairrepair);}@ServicepublicclassRepairServiceImplimplementsRepairService{privatefinalRepairRepositoryrepairRepository;publicRepairServiceImpl(RepairRepositoryrepairRepository){this.repairRepository=repairRepository;}@OverridepublicRepairsubmitRepair(Repairrepair){returnrepairRepository.save(repair);}}``````javapublicinterfaceRepairRepositoryextendsJpaRepository<Repair,Long>{}```2.获取所有报修记录接口```java@GetMappingpublicResponseEntity<List<Repair>>getAllRepairs(){List<Repair>repairs=repairService.getAllRepairs();returnnewResponseEntity<>(repairs,HttpStatus.OK);}``````javapublicinterfaceRepairService{List<Repair>getAllRepairs();}@ServicepublicclassRepairServiceImplimplementsRepairService{privatefinalRepairRepositoryrepairRepository;publicRepairServiceImpl(RepairRepositoryrepairRepository){this.repairRepository=repairRepository;}@OverridepublicList<Repair>getAllRepairs(){returnrepairRepository.findAll();}}```##五、前端代码实现（一）页面布局使用VueRouter进行路由管理，创建不同的页面组件，如宿舍管理页面、学生管理页面、住宿分配页面、报修页面等。例如，宿舍管理页面的模板：```html<template><div><h1>宿舍管理</h1><table><thead><tr><th>宿舍编号</th><th>宿舍名称</th><th>所属楼栋</th><th>房间号</th><th>容量</th></tr></thead><tbody><trv-for="dormitoryindormitories":key="dormitory.dormitory_id"><td>{{dormitory.dormitory_id}}</td><td>{{dormitory.dormitory_name}}</td><td>{{dormitory.building_id}}</td><td>{{dormitory.room_number}}</td><td>{{dormitory.capacity}}</td></tr></tbody></table><button@click="createDormitory">创建宿舍</button></div></template>```（二）数据交互通过Axios库与后端接口进行数据交互。例如，获取所有宿舍信息：```javascriptexportdefault{data(){return{dormitories:[]};},mounted(){this.fetchDormitories();},methods:{fetchDormitories(){axios.get('/dormitories').then(response=>{this.dormitories=response.data;}).catch(error=>{console.error('Errorfetchingdormitories:',error);});},createDormitory(){constnewDormitory={dormitory_name:'新宿舍',building_id:1,room_number:'101',capacity:4};axios.post('/dormitories',newDormitory).then(response=>{this.fetchDormitories();}).catch(error=>{console.error('Errorcreatingdormitory:',error);});}}};```##六、测试1.单元测试使用JUnit对后端接口进行单元测试。例如，测试创建宿舍接口：```java@SpringBootTestpublicclassDormitoryControllerTest{@AutowiredprivateMockMvcmockMv