帮我写一份“基于Springboot的健身会所管理系统”的器材使用统计介绍与代码

介绍：

本健身会所管理系统基于Springboot框架开发，主要功能包括器材管理和器材使用统计。其中，器材管理包括器材的添加、删除、修改、查询等功能；器材使用统计包括会员的器材使用情况统计，以及健身教练的器材使用情况统计。

代码：

1. 器材管理

// 器材实体类
@Entity
@Table(name = "equipment")
public class Equipment {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Long id;
private String name;
private String type;
private String description;
// 省略getter和setter方法
}

// 器材服务类
@Service
public class EquipmentService {
@Autowired
private EquipmentRepository equipmentRepository;

// 添加器材
public void addEquipment(Equipment equipment) {
equipmentRepository.save(equipment);
}

// 删除器材
public void deleteEquipment(Long id) {
equipmentRepository.deleteById(id);
}

// 修改器材
public void updateEquipment(Equipment equipment) {
equipmentRepository.save(equipment);
}

// 查询器材
public Equipment getEquipment(Long id) {
return equipmentRepository.findById(id).orElse(null);
}

// 查询所有器材
public List<Equipment> getAllEquipment() {
return equipmentRepository.findAll();
}
}

// 器材控制器类
@RestController
@RequestMapping("/equipment")
public class EquipmentController {
@Autowired
private EquipmentService equipmentService;

// 添加器材
@PostMapping("/add")
public void addEquipment(@RequestBody Equipment equipment) {
equipmentService.addEquipment(equipment);
}

// 删除器材
@DeleteMapping("/delete/{id}")
public void deleteEquipment(@PathVariable Long id) {
equipmentService.deleteEquipment(id);
}

// 修改器材
@PutMapping("/update")
public void updateEquipment(@RequestBody Equipment equipment) {
equipmentService.updateEquipment(equipment);
}

// 查询器材
@GetMapping("/get/{id}")
public Equipment getEquipment(@PathVariable Long id) {
return equipmentService.getEquipment(id);
}

// 查询所有器材
@GetMapping("/getAll")
public List<Equipment> getAllEquipment() {
return equipmentService.getAllEquipment();
}
}

2. 器材使用统计

// 器材使用记录实体类
@Entity
@Table(name = "equipment_record")
public class EquipmentRecord {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Long id;
private Long equipmentId;
private Long memberId;
private Long coachId;
private LocalDateTime startTime;
private LocalDateTime endTime;
// 省略getter和setter方法
}

// 器材使用记录服务类
@Service
public class EquipmentRecordService {
@Autowired
private EquipmentRecordRepository equipmentRecordRepository;

// 添加器材使用记录
public void addEquipmentRecord(EquipmentRecord equipmentRecord) {
equipmentRecordRepository.save(equipmentRecord);
}

// 删除器材使用记录
public void deleteEquipmentRecord(Long id) {
equipmentRecordRepository.deleteById(id);
}

// 修改器材使用记录
public void updateEquipmentRecord(EquipmentRecord equipmentRecord) {
equipmentRecordRepository.save(equipmentRecord);
}

// 查询所有器材使用记录
public List<EquipmentRecord> getAllEquipmentRecord() {
return equipmentRecordRepository.findAll();
}

// 根据会员ID查询器材使用记录
public List<EquipmentRecord> getEquipmentRecordByMemberId(Long memberId) {
return equipmentRecordRepository.findByMemberId(memberId);
}

// 根据教练ID查询器材使用记录
public List<EquipmentRecord> getEquipmentRecordByCoachId(Long coachId) {
return equipmentRecordRepository.findByCoachId(coachId);
}
}

// 器材使用记录控制器类
@RestController
@RequestMapping("/equipmentRecord")
public class EquipmentRecordController {
@Autowired
private EquipmentRecordService equipmentRecordService;

// 添加器材使用记录
@PostMapping("/add")
public void addEquipmentRecord(@RequestBody EquipmentRecord equipmentRecord) {
equipmentRecordService.addEquipmentRecord(equipmentRecord);
}

// 删除器材使用记录
@DeleteMapping("/delete/{id}")
public void deleteEquipmentRecord(@PathVariable Long id) {
equipmentRecordService.deleteEquipmentRecord(id);
}

// 修改器材使用记录
@PutMapping("/update")
public void updateEquipmentRecord(@RequestBody EquipmentRecord equipmentRecord) {
equipmentRecordService.updateEquipmentRecord(equipmentRecord);
}

// 查询所有器材使用记录
@GetMapping("/getAll")
public List<EquipmentRecord> getAllEquipmentRecord() {
return equipmentRecordService.getAllEquipmentRecord();
}

// 根据会员ID查询器材使用记录
@GetMapping("/getByMemberId/{memberId}")
public List<EquipmentRecord> getEquipmentRecordByMemberId(@PathVariable Long memberId) {
return equipmentRecordService.getEquipmentRecordByMemberId(memberId);
}

// 根据教练ID查询器材使用记录
@GetMapping("/getByCoachId/{coachId}")
public List<EquipmentRecord> getEquipmentRecordByCoachId(@PathVariable Long coachId) {
return equipmentRecordService.getEquipmentRecordByCoachId(coachId);
}
}