老人评估项目——精神状态

pojo

package com.stu.pojo;

public class olderJingshen {
    private int id;
    private int elderlyId;
    private int eatingScore;
    private int bathingScore;
    private int groomingScore;
    private int dressingScore;
    private int bowelControlScore;
    private int bladderControlScore;
    private int toiletingScore;
    private int bedChairTransferScore;
    private int walkingScore;
    private int stairClimbingScore;
    private int totalScore;
    private int activityLevel;

    // 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 getEatingScore() {
        return eatingScore;
    }

    public void setEatingScore(int eatingScore) {
        this.eatingScore = eatingScore;
    }

    public int getBathingScore() {
        return bathingScore;
    }

    public void setBathingScore(int bathingScore) {
        this.bathingScore = bathingScore;
    }

    public int getGroomingScore() {
        return groomingScore;
    }

    public void setGroomingScore(int groomingScore) {
        this.groomingScore = groomingScore;
    }

    public int getDressingScore() {
        return dressingScore;
    }

    public void setDressingScore(int dressingScore) {
        this.dressingScore = dressingScore;
    }

    public int getBowelControlScore() {
        return bowelControlScore;
    }

    public void setBowelControlScore(int bowelControlScore) {
        this.bowelControlScore = bowelControlScore;
    }

    public int getBladderControlScore() {
        return bladderControlScore;
    }

    public void setBladderControlScore(int bladderControlScore) {
        this.bladderControlScore = bladderControlScore;
    }

    public int getToiletingScore() {
        return toiletingScore;
    }

    public void setToiletingScore(int toiletingScore) {
        this.toiletingScore = toiletingScore;
    }

    public int getBedChairTransferScore() {
        return bedChairTransferScore;
    }

    public void setBedChairTransferScore(int bedChairTransferScore) {
        this.bedChairTransferScore = bedChairTransferScore;
    }

    public int getWalkingScore() {
        return walkingScore;
    }

    public void setWalkingScore(int walkingScore) {
        this.walkingScore = walkingScore;
    }

    public int getStairClimbingScore() {
        return stairClimbingScore;
    }

    public void setStairClimbingScore(int stairClimbingScore) {
        this.stairClimbingScore = stairClimbingScore;
    }

    public int getTotalScore() {
        return totalScore;
    }

    public void setTotalScore(int totalScore) {
        this.totalScore = totalScore;
    }

    public int getActivityLevel() {
        return activityLevel;
    }

    public void setActivityLevel(int activityLevel) {
        this.activityLevel = activityLevel;
    }
}

mybatisutil

package com.stu.util;


        import org.apache.ibatis.io.Resources;
        import org.apache.ibatis.session.SqlSession;
        import org.apache.ibatis.session.SqlSessionFactory;
        import org.apache.ibatis.session.SqlSessionFactoryBuilder;

        import java.io.IOException;
        import java.io.InputStream;

public class MyBatisUtil {
    private static SqlSessionFactory sqlSessionFactory;

    static {
        try {
            InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    public static SqlSession getSqlSession() {
        return sqlSessionFactory.openSession();
    }
}

servlet

package com.stu.servlet;


        import com.stu.mapper.olderInformationJingshenMapper;
        import com.stu.pojo.olderJingshen;
        import com.stu.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("/Jingshen")
public class Jingshen extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("UTF-8");
        olderJingshen assessment = new olderJingshen();
        assessment.setElderlyId(Integer.parseInt(request.getParameter("elderlyId")));
        assessment.setEatingScore(Integer.parseInt(request.getParameter("eatingScore")));
        assessment.setBathingScore(Integer.parseInt(request.getParameter("bathingScore")));
        assessment.setGroomingScore(Integer.parseInt(request.getParameter("groomingScore")));
        assessment.setDressingScore(Integer.parseInt(request.getParameter("dressingScore")));
        assessment.setBowelControlScore(Integer.parseInt(request.getParameter("bowelControlScore")));
        assessment.setBladderControlScore(Integer.parseInt(request.getParameter("bladderControlScore")));
        assessment.setToiletingScore(Integer.parseInt(request.getParameter("toiletingScore")));
        assessment.setBedChairTransferScore(Integer.parseInt(request.getParameter("bedChairTransferScore")));
        assessment.setWalkingScore(Integer.parseInt(request.getParameter("walkingScore")));
        assessment.setStairClimbingScore(Integer.parseInt(request.getParameter("stairClimbingScore")));

        int totalScore = assessment.getEatingScore() + assessment.getBathingScore() + assessment.getGroomingScore() +
                assessment.getDressingScore() + assessment.getBowelControlScore() + assessment.getBladderControlScore() +
                assessment.getToiletingScore() + assessment.getBedChairTransferScore() + assessment.getWalkingScore() +
                assessment.getStairClimbingScore();
        assessment.setTotalScore(totalScore);

        if (totalScore == 100) {
            assessment.setActivityLevel(0);
        } else if (totalScore >= 65 && totalScore <= 95) {
            assessment.setActivityLevel(1);
        } else if (totalScore >= 45 && totalScore <= 60) {
            assessment.setActivityLevel(2);
        } else {
            assessment.setActivityLevel(3);
        }

        SqlSession sqlSession = MyBatisUtil.getSqlSession();
        try {
            olderInformationJingshenMapper mapper = sqlSession.getMapper(olderInformationJingshenMapper.class);
            mapper.insertAssessment(assessment);
            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

<%--
  Created by IntelliJ IDEA.
  User: Lenovo
  Date: 2025/2/19
  Time: 15:15
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE html>
<html>
<head>
    <title>老年人能力评估</title>
</head>
<body>
<h1>老年人日常生活活动评估</h1>
<form action="ElderlyAssessmentServlet" method="post">
    <input type="hidden" name="elderlyId" value="1"> <!-- 可根据实际情况修改老人 ID -->
    <label for="eatingScore">进食得分:</label>
    <select name="eatingScore">
        <option value="10">10 分</option>
        <option value="5">5 分</option>
        <option value="0">0 分</option>
    </select><br>
    <label for="bathingScore">洗澡得分:</label>
    <select name="bathingScore">
        <option value="5">5 分</option>
        <option value="0">0 分</option>
    </select><br>
    <!-- 依次添加其他评估项目 -->
    <label for="groomingScore">修饰得分:</label>
    <select name="groomingScore">
        <option value="5">5 分</option>
        <option value="0">0 分</option>
    </select><br>
    <label for="dressingScore">穿衣得分:</label>
    <select name="dressingScore">
        <option value="10">10 分</option>
        <option value="5">5 分</option>
        <option value="0">0 分</option>
    </select><br>
    <label for="bowelControlScore">大便控制得分:</label>
    <select name="bowelControlScore">
        <option value="10">10 分</option>
        <option value="5">5 分</option>
        <option value="0">0 分</option>
    </select><br>
    <label for="bladderControlScore">小便控制得分:</label>
    <select name="bladderControlScore">
        <option value="10">10 分</option>
        <option value="5">5 分</option>
        <option value="0">0 分</option>
    </select><br>
    <label for="toiletingScore">如厕得分:</label>
    <select name="toiletingScore">
        <option value="10">10 分</option>
        <option value="5">5 分</option>
        <option value="0">0 分</option>
    </select><br>
    <label for="bedChairTransferScore">床椅转移得分:</label>
    <select name="bedChairTransferScore">
        <option value="15">15 分</option>
        <option value="10">10 分</option>
        <option value="5">5 分</option>
        <option value="0">0 分</option>
    </select><br>
    <label for="walkingScore">平地行走得分:</label>
    <select name="walkingScore">
        <option value="15">15 分</option>
        <option value="10">10 分</option>
        <option value="5">5 分</option>
        <option value="0">0 分</option>
    </select><br>
    <label for="stairClimbingScore">上下楼梯得分:</label>
    <select name="stairClimbingScore">
        <option value="10">10 分</option>
        <option value="5">5 分</option>
        <option value="0">0 分</option>
    </select><br>
    <input type="submit" value="提交评估信息">
</form>
</body>
</html>