老人评估项目——感知觉

表的创建

CREATE DATABASE elderly_perception_db;
USE elderly_perception_db;

CREATE TABLE elderly_perception_communication (
    id INT AUTO_INCREMENT PRIMARY KEY,
    elderly_id INT NOT NULL,
    consciousness_level_score TINYINT,
    vision_score TINYINT,
    hearing_score TINYINT,
    communication_score TINYINT,
    perception_level TINYINT
);

实体类

package com.example.entity;

public class ElderlyPerceptionCommunication {
    private int id;
    private int elderlyId;
    private int consciousnessLevelScore;
    private int visionScore;
    private int hearingScore;
    private int communicationScore;
    private int perceptionLevel;

    // Getters and Setters
    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public int getElderlyId() {
        return elderlyId;
    }

    public void setElderlyId(int elderlyId) {
        this.elderlyId = elderlyId;
    }

    public int getConsciousnessLevelScore() {
        return consciousnessLevelScore;
    }

    public void setConsciousnessLevelScore(int consciousnessLevelScore) {
        this.consciousnessLevelScore = consciousnessLevelScore;
    }

    public int getVisionScore() {
        return visionScore;
    }

    public void setVisionScore(int visionScore) {
        this.visionScore = visionScore;
    }

    public int getHearingScore() {
        return hearingScore;
    }

    public void setHearingScore(int hearingScore) {
        this.hearingScore = hearingScore;
    }

    public int getCommunicationScore() {
        return communicationScore;
    }

    public void setCommunicationScore(int communicationScore) {
        this.communicationScore = communicationScore;
    }

    public int getPerceptionLevel() {
        return perceptionLevel;
    }

    public void setPerceptionLevel(int perceptionLevel) {
        this.perceptionLevel = perceptionLevel;
    }
}

xml文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.mapper.ElderlyPerceptionCommunicationMapper">
    <insert id="insertPerceptionCommunication" parameterType="com.example.entity.ElderlyPerceptionCommunication">
        INSERT INTO elderly_perception_communication (elderly_id, consciousness_level_score, vision_score,
                                                     hearing_score, communication_score, perception_level)
        VALUES (#{elderlyId}, #{consciousnessLevelScore}, #{visionScore},
                #{hearingScore}, #{communicationScore}, #{perceptionLevel})
    </insert>
</mapper>