老人评估项目——社会能力

sql建表

CREATE DATABASE elderly_social_participation_db;
USE elderly_social_participation_db;

CREATE TABLE elderly_social_participation (
    id INT AUTO_INCREMENT PRIMARY KEY,
    elderly_id INT NOT NULL,
    life_ability_score TINYINT,
    work_ability_score TINYINT,
    time_space_orientation_score TINYINT,
    person_orientation_score TINYINT,
    social_adaptability_score TINYINT
);

pojo

package com.example.entity;

public class ElderlySocialParticipation {
    private int id;
    private int elderlyId;
    private int lifeAbilityScore;
    private int workAbilityScore;
    private int timeSpaceOrientationScore;
    private int personOrientationScore;
    private int socialAdaptabilityScore;

    // 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 getLifeAbilityScore() {
        return lifeAbilityScore;
    }

    public void setLifeAbilityScore(int lifeAbilityScore) {
        this.lifeAbilityScore = lifeAbilityScore;
    }

    public int getWorkAbilityScore() {
        return workAbilityScore;
    }

    public void setWorkAbilityScore(int workAbilityScore) {
        this.workAbilityScore = workAbilityScore;
    }

    public int getTimeSpaceOrientationScore() {
        return timeSpaceOrientationScore;
    }

    public void setTimeSpaceOrientationScore(int timeSpaceOrientationScore) {
        this.timeSpaceOrientationScore = timeSpaceOrientationScore;
    }

    public int getPersonOrientationScore() {
        return personOrientationScore;
    }

    public void setPersonOrientationScore(int personOrientationScore) {
        this.personOrientationScore = personOrientationScore;
    }

    public int getSocialAdaptabilityScore() {
        return socialAdaptabilityScore;
    }

    public void setSocialAdaptabilityScore(int socialAdaptabilityScore) {
        this.socialAdaptabilityScore = socialAdaptabilityScore;
    }
}

servlet

package com.example.servlet;

import com.example.entity.ElderlySocialParticipation;
import com.example.mapper.ElderlySocialParticipationMapper;
import com.example.util.MyBatisUtil;
import org.apache.ibatis.session.SqlSession;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;

@WebServlet("/ElderlySocialParticipationServlet")
public class ElderlySocialParticipationServlet extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("UTF-8");
        ElderlySocialParticipation participation = new ElderlySocialParticipation();
        participation.setElderlyId(Integer.parseInt(request.getParameter("elderlyId")));
        participation.setLifeAbilityScore(Integer.parseInt(request.getParameter("lifeAbilityScore")));
        participation.setWorkAbilityScore(Integer.parseInt(request.getParameter("workAbilityScore")));
        participation.setTimeSpaceOrientationScore(Integer.parseInt(request.getParameter("timeSpaceOrientationScore")));
        participation.setPersonOrientationScore(Integer.parseInt(request.getParameter("personOrientationScore")));
        participation.setSocialAdaptabilityScore(Integer.parseInt(request.getParameter("socialAdaptabilityScore")));

        SqlSession sqlSession = MyBatisUtil.getSqlSession();
        try {
            ElderlySocialParticipationMapper mapper = sqlSession.getMapper(ElderlySocialParticipationMapper.class);
            mapper.insertSocialParticipation(participation);
            sqlSession.commit();
            response.getWriter().println("评估信息添加成功");
        } catch (Exception e) {
            e.printStackTrace();
            sqlSession.rollback();
            response.getWriter().println("评估信息添加失败");
        } finally {
            sqlSession.close();
        }
    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doPost(request, response);
    }
}

jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE html>
<html>
<head>
    <title>老年人社会参与评估</title>
</head>
<body>
    <h1>老年人社会参与评估</h1>
    <form action="ElderlySocialParticipationServlet" method="post">
        <input type="hidden" name="elderlyId" value="1"> <!-- 可根据实际情况修改老人 ID -->
        <label for="lifeAbilityScore">生活能力得分:</label>
        <select name="lifeAbilityScore">
            <option value="0">0 分</option>
            <option value="1">1 分</option>
            <option value="2">2 分</option>
            <option value="3">3 分</option>
            <option value="4">4 分</option>
        </select><br>
        <label for="workAbilityScore">工作能力得分:</label>
        <select name="workAbilityScore">
            <option value="0">0 分</option>
            <option value="1">1 分</option>
            <option value="2">2 分</option>
            <option value="3">3 分</option>
            <option value="4">4 分</option>
        </select><br>
        <label for="timeSpaceOrientationScore">时间/空间定向得分:</label>
        <select name="timeSpaceOrientationScore">
            <option value="0">0 分</option>
            <option value="1">1 分</option>
            <option value="2">2 分</option>
            <option value="3">3 分</option>
            <option value="4">4 分</option>
        </select><br>
        <label for="personOrientationScore">人物定向得分:</label>
        <select name="personOrientationScore">
            <option value="0">0 分</option>
            <option value="1">1 分</option>
            <option value="2">2 分</option>
            <option value="3">3 分</option>
            <option value="4">4 分</option>
        </select><br>
        <label for="socialAdaptabilityScore">社会适应能力得分:</label>
        <select name="socialAdaptabilityScore">
            <option value="0">0 分</option>
        </select><br>
        <input type="submit" value="提交评估信息">
    </form>
</body>
</html>