### 社区居民
体检记录管理系统的代码实现
以下是基于 Spring Boot 和 MyBatis-Plus 构建的一个简单的社区居民
体检记录管理系统的代码示例。此系统可以用于存储和查询社区居民的
体检数据。
#### 数据库设计
假设我们有一个 `health_records` 表来保存居民的
体检记录：
| 字段名 | 类型 | 描述 |
|----------------|------------|--------------------|
| id | INT | 主键，自增 |
| resident_name | VARCHAR | 居民姓名 |
| age | INT | 年龄 |
| blood_pressure | FLOAT | 血压 (单位：mmHg) |
| cholesterol | FLOAT | 胆固醇水平 (mg/dL)|
| created_at | TIMESTAMP |
记录创建时间 |
```sql
CREATE TABLE health_records (
id INT AUTO_INCREMENT PRIMARY KEY,
resident_name VARCHAR(255) NOT NULL,
age INT NOT NULL,
blood_pressure FLOAT DEFAULT NULL,
cholesterol FLOAT DEFAULT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
```
---
#### 后端代码实现
##### 1. Maven依赖配置
在项目的 `pom.xml` 文件中引入必要的依赖项：
```xml
<dependencies>
<!-- Spring Boot Starter Web -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<!-- MyBatis Plus -->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.4.0</version>
</dependency>
<!-- MySQL Connector -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
</dependencies>
```
##### 2. 实体类定义 (`HealthRecord.java`)
```java
package com.example.healthrecord.entity;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;
@Data
@TableName("health_records")
public class HealthRecord {
@TableId
private Long id;
private String residentName;
private Integer age;
private Float bloodPressure;
private Float cholesterol;
}
```
##### 3. Mapper接口定义 (`HealthRecordMapper.java`)
```java
package com.example.healthrecord.mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.healthrecord.entity.HealthRecord;
import org.apache.ibatis.annotations.Mapper;
@Mapper
public interface HealthRecordMapper extends BaseMapper<HealthRecord> {
}
```
##### 4. Service层逻辑 (`HealthRecordService.java`)
```java
package com.example.healthrecord.service;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.example.healthrecord.entity.HealthRecord;
import com.example.healthrecord.mapper.HealthRecordMapper;
import org.springframework.stereotype.Service;
@Service
public class HealthRecordService extends ServiceImpl<HealthRecordMapper, HealthRecord> {
public void addRecord(HealthRecord record) {
this.save(record); // 使用 MyBatis-Plus 提供的方法保存数据
}
public HealthRecord getRecordById(Long id) {
return this.getById(id); // 查询单条
记录
}
}
```
##### 5. Controller层暴露API (`HealthRecordController.java`)
```java
package com.example.healthrecord.controller;
import com.example.healthrecord.entity.HealthRecord;
import com.example.healthrecord.service.HealthRecordService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
@RestController
@RequestMapping("/api/records")
public class HealthRecordController {
@Autowired
private HealthRecordService healthRecordService;
@PostMapping
public String createRecord(@RequestBody HealthRecord record) {
healthRecordService.addRecord(record);
return "Record added successfully!";
}
@GetMapping("/{id}")
public HealthRecord getRecordById(@PathVariable Long id) {
return healthRecordService.getRecordById(id);
}
}
```
---
#### 前端展示（简单HTML+ECharts）
以下是一个简单的 HTML 页面，用来显示居民的血压趋势图：
```html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Community Health Records</title>
<script src="https://cdn.jsdelivr.net/npm/echarts/dist/echarts.min.js"></script>
</head>
<body>
<div id="main" style="width: 600px; height: 400px;"></div>
<script type="text/javascript">
var chartDom = document.getElementById('main');
var myChart = echarts.init(chartDom);
var option = {
title: { text: 'Blood Pressure Trend' },
tooltip: {},
xAxis: { data: ["Resident A", "Resident B", "Resident C"] },
yAxis: {},
series: [{
name: 'Blood Pressure',
type: 'bar',
data: [120, 130, 140]
}]
};
myChart.setOption(option);
</script>
</body>
</html>
```
上述代码展示了如何通过 ECharts 来绘制柱状图表示不同居民的血压情况[^3]。
---
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
889
