寒假web开发5
表四： daily
sql
点击查看代码
CREATE TABLE tb_daily(
AssessmentID CHAR(8) PRIMARY KEY, -- 评估编号（主键，关联到 tb_older 表的 AssessmentID）
Eating INT, -- B.1.1 进食（0分、5分、10分）
Bathing INT, -- B.1.2 洗澡（0分、5分）
Grooming INT, -- B.1.3 修饰（0分、5分）
Dressing INT, -- B.1.4 穿衣（0分、5分、10分）
BowelControl INT, -- B.1.5 大便控制（0分、5分、10分）
BladderControl INT, -- B.1.6 小便控制（0分、5分、10分）
Toileting INT, -- B.1.7 如厕（0分、5分、10分）
BedChairTransfer INT, -- B.1.8 床椅转移（0分、5分、10分、15分）
Walking INT, -- B.1.9 平地行走（0分、5分、10分、15分）
Stairs INT, -- B.1.10 上下楼梯（0分、5分、10分）
TotalScore INT, -- B.1.11 日常生活活动总分
ActivityLevel INT -- B.1 日常生活活动分级（0: 能力完好, 1: 轻度受损, 2: 中度受损, 3: 重度受损）
);
DailyMapper
点击查看代码
package com.QixunQiu.mapper;
import com.QixunQiu.pojo.User;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import java.util.List;
public interface UserMapper {
@Select("select * from tb_user where UserID = #{UserID} and Password = #{Password}")
User select(@Param("UserID") String UserID, @Param("Password") String Password);
void addUser(User user);
}
Daily的pojo
点击查看代码
package com.QixunQiu.pojo;
public class Daily {
private String assessmentID;
private Integer eating;
private Integer bathing;
private Integer grooming;
private Integer dressing;
private Integer bowelControl;
private Integer bladderControl;
private Integer toileting;
private Integer bedChairTransfer;
private Integer walking;
private Integer stairs;
private Integer totalScore;
private Integer activityLevel;
// Getter 和 Setter 方法
public String getAssessmentID() {
return assessmentID;
}
public void setAssessmentID(String assessmentID) {
this.assessmentID = assessmentID;
}
public Integer getEating() {
return eating;
}
public void setEating(Integer eating) {
this.eating = eating;
}
public Integer getBathing() {
return bathing;
}
public void setBathing(Integer bathing) {
this.bathing = bathing;
}
public Integer getGrooming() {
return grooming;
}
public void setGrooming(Integer grooming) {
this.grooming = grooming;
}
public Integer getDressing() {
return dressing;
}
public void setDressing(Integer dressing) {
this.dressing = dressing;
}
public Integer getBowelControl() {
return bowelControl;
}
public void setBowelControl(Integer bowelControl) {
this.bowelControl = bowelControl;
}
public Integer getBladderControl() {
return bladderControl;
}
public void setBladderControl(Integer bladderControl) {
this.bladderControl = bladderControl;
}
public Integer getToileting() {
return toileting;
}
public void setToileting(Integer toileting) {
this.toileting = toileting;
}
public Integer getBedChairTransfer() {
return bedChairTransfer;
}
public void setBedChairTransfer(Integer bedChairTransfer) {
this.bedChairTransfer = bedChairTransfer;
}
public Integer getWalking() {
return walking;
}
public void setWalking(Integer walking) {
this.walking = walking;
}
public Integer getStairs() {
return stairs;
}
public void setStairs(Integer stairs) {
this.stairs = stairs;
}
public Integer getTotalScore() {
return totalScore;
}
public void setTotalScore(Integer totalScore) {
this.totalScore = totalScore;
}
public Integer getActivityLevel() {
return activityLevel;
}
public void setActivityLevel(Integer activityLevel) {
this.activityLevel = activityLevel;
}
@Override
public String toString() {
return "DailyLivingActivity{" +
"assessmentID='" + assessmentID + '\'' +
", eating=" + eating +
", bathing=" + bathing +
", grooming=" + grooming +
", dressing=" + dressing +
", bowelControl=" + bowelControl +
", bladderControl=" + bladderControl +
", toileting=" + toileting +
", bedChairTransfer=" + bedChairTransfer +
", walking=" + walking +
", stairs=" + stairs +
", totalScore=" + totalScore +
", activityLevel=" + activityLevel +
'}';
}
}
DailyService
点击查看代码
package com.QixunQiu.service;
import com.QixunQiu.mapper.DailyMapper;
import com.QixunQiu.pojo.Daily;
import com.QixunQiu.util.SqlSessionFactoryUtils;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import java.util.List;
public class DailyService {
SqlSessionFactory sqlSessionFactory = SqlSessionFactoryUtils.getSqlSessionFactory();
public List<Daily> selectDaily(String AssessmentID) {
SqlSession sqlSession = sqlSessionFactory.openSession();
DailyMapper dailyMapper = sqlSession.getMapper(DailyMapper.class);
List<Daily> dailyList=dailyMapper.select(AssessmentID);
sqlSession.close();
return dailyList;
}
public void addDaily(Daily daily) {
SqlSession sqlSession = sqlSessionFactory.openSession();
DailyMapper dailyMapper = sqlSession.getMapper(DailyMapper.class);
dailyMapper.add(daily);
sqlSession.commit();
sqlSession.close();
}
}
AddDailyServlet
点击查看代码
package com.QixunQiu.web;
import com.QixunQiu.pojo.Daily;
import com.QixunQiu.service.DailyService;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.annotation.*;
import java.io.IOException;
@WebServlet("/AddDailyServlet")
public class AddDailyServlet extends HttpServlet {
private DailyService dailyService = new DailyService();
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
response.setContentType("text/html;charset=UTF-8");
String assessmentID=request.getParameter("assessmentID");
int eating= Integer.parseInt(request.getParameter("eating"));
int bathing= Integer.parseInt(request.getParameter("bathing"));
int grooming= Integer.parseInt(request.getParameter("grooming"));
int dressing= Integer.parseInt(request.getParameter("dressing"));
int bowelControl= Integer.parseInt(request.getParameter("bowelControl"));
int bladderControl= Integer.parseInt(request.getParameter("bladderControl"));
int toileting= Integer.parseInt(request.getParameter("toileting"));
int bedChairTransfer= Integer.parseInt(request.getParameter("bedChairTransfer"));
int walking= Integer.parseInt(request.getParameter("walking"));
int stairs= Integer.parseInt(request.getParameter("stairs"));
// 计算总分
int totalScore = eating + bathing + grooming + dressing +
bowelControl + bladderControl + toileting +
bedChairTransfer + walking + stairs;
// 计算分级
int activityLevel;
if (totalScore == 100) {
activityLevel = 0;
} else if (totalScore >= 65 && totalScore <= 95) {
activityLevel = 1;
} else if (totalScore >= 45 && totalScore <= 60) {
activityLevel = 2;
} else {
activityLevel = 3;
}
Daily daily=new Daily();
daily.setAssessmentID(assessmentID);
daily.setEating(eating);
daily.setBathing(bathing);
daily.setGrooming(grooming);
daily.setDressing(dressing);
daily.setBowelControl(bowelControl);
daily.setBladderControl(bladderControl);
daily.setToileting(toileting);
daily.setBedChairTransfer(bedChairTransfer);
daily.setWalking(walking);
daily.setStairs(stairs);
daily.setTotalScore(totalScore);
daily.setActivityLevel(activityLevel);
dailyService.addDaily(daily);
response.sendRedirect("daily.jsp");
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
this.doGet(request, response);
}
}
selectDailyServlet
点击查看代码
package com.QixunQiu.web;
import com.QixunQiu.pojo.Daily;
import com.QixunQiu.pojo.Older;
import com.QixunQiu.pojo.User;
import com.QixunQiu.service.DailyService;
import com.QixunQiu.service.OlderService;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.annotation.*;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;
@WebServlet("/selectDailyServlet")
public class selectDailyServlet extends HttpServlet {
private OlderService olderService = new OlderService();
private DailyService dailyService = new DailyService();
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
response.setContentType("text/html;charset=utf-8");
HttpSession session = request.getSession();
User user = (User) session.getAttribute("user");
Older older=olderService.selectOlderById(user.getUserID());
List<Daily> dailyList=dailyService.selectDaily(older.getAssessmentID());
PrintWriter writer = response.getWriter();
if(!dailyList.isEmpty()){
// 登陆成功
writer.write("登陆成功");
session.setAttribute("dailyList", dailyList);
request.getRequestDispatcher("/daily.jsp").forward(request,response);
}else {
// 登陆失败
writer.write("登陆失败");
request.getRequestDispatcher("/addDaily.jsp").forward(request,response);
}
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
this.doGet(request, response);
}
}
DailyMapper.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.QixunQiu.mapper.DailyMapper">
<insert id="add" parameterType="com.QixunQiu.pojo.Daily">
INSERT INTO tb_daily (
AssessmentID,
Eating,
Bathing,
Grooming,
Dressing,
BowelControl,
BladderControl,
Toileting,
BedChairTransfer,
Walking,
Stairs,
TotalScore,
ActivityLevel
) VALUES (
#{assessmentID},
#{eating},
#{bathing},
#{grooming},
#{dressing},
#{bowelControl},
#{bladderControl},
#{toileting},
#{bedChairTransfer},
#{walking},
#{stairs},
#{totalScore},
#{activityLevel}
)
</insert>
</mapper>
addDaily.jsp
点击查看代码
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>添加日常生活活动能力评估</title>
<style>
body {
font-family: Arial, sans-serif;
margin: 20px;
}
.form-group {
margin-bottom: 15px;
}
label {
display: block;
margin-bottom: 5px;
font-weight: bold;
}
input[type="text"], select {
width: 100%;
padding: 8px;
box-sizing: border-box;
}
.submit-btn {
background-color: #4CAF50;
color: white;
padding: 10px 20px;
border: none;
cursor: pointer;
}
.submit-btn:hover {
background-color: #45a049;
}
</style>
</head>
<body>
<h1>添加日常生活活动能力评估</h1>
<form action="${pageContext.request.contextPath}/AddDailyLivingActivityServlet" method="post">
<!-- 评估编号 -->
<div class="form-group">
<label for="assessmentID">评估编号:</label>
<input type="text" id="assessmentID" name="assessmentID" required>
</div>
<!-- 进食 -->
<div class="form-group">
<label for="eating">进食:</label>
<select id="eating" name="eating" required>
<option value="10">10分 - 可独立进食（在合理的时间内独立进食准备好的食物）</option>
<option value="5">5分 - 需部分帮助（进食过程中需要一定帮助，如协助把持餐具）</option>
<option value="0">0分 - 需极大帮助或完全依赖他人，或有留置营养管</option>
</select>
</div>
<!-- 洗澡 -->
<div class="form-group">
<label for="bathing">洗澡:</label>
<select id="bathing" name="bathing" required>
<option value="5">5分 - 准备好洗澡水后，可自己独立完成洗澡过程</option>
<option value="0">0分 - 在洗澡过程中需他人帮助</option>
</select>
</div>
<!-- 修饰 -->
<div class="form-group">
<label for="grooming">修饰:</label>
<select id="grooming" name="grooming" required>
<option value="5">5分 - 可自己独立完成</option>
<option value="0">0分 - 需他人帮助</option>
</select>
</div>
<!-- 穿衣 -->
<div class="form-group">
<label for="dressing">穿衣:</label>
<select id="dressing" name="dressing" required>
<option value="10">10分 - 可独立完成</option>
<option value="5">5分 - 需部分帮助（能自己穿脱，但需他人帮助整理衣物、系扣/鞋带、拉拉链）</option>
<option value="0">0分 - 需极大帮助或完全依赖他人</option>
</select>
</div>
<!-- 大便控制 -->
<div class="form-group">
<label for="bowelControl">大便控制:</label>
<select id="bowelControl" name="bowelControl" required>
<option value="10">10分 - 可控制大便</option>
<option value="5">5分 - 偶尔失控（每周<1次），或需要他人提示</option>
<option value="0">0分 - 完全失控</option>
</select>
</div>
<!-- 小便控制 -->
<div class="form-group">
<label for="bladderControl">小便控制:</label>
<select id="bladderControl" name="bladderControl" required>
<option value="10">10分 - 可控制小便</option>
<option value="5">5分 - 偶尔失控（每天<1次，但每周>1次），或需要他人提示</option>
<option value="0">0分 - 完全失控，或留置导尿管</option>
</select>
</div>
<!-- 如厕 -->
<div class="form-group">
<label for="toileting">如厕:</label>
<select id="toileting" name="toileting" required>
<option value="10">10分 - 可独立完成</option>
<option value="5">5分 - 需部分帮助（需他人搀扶去厕所、需他人帮忙冲水或整理衣裤等）</option>
<option value="0">0分 - 需极大帮助或完全依赖他人</option>
</select>
</div>
<!-- 床椅转移 -->
<div class="form-group">
<label for="bedChairTransfer">床椅转移:</label>
<select id="bedChairTransfer" name="bedChairTransfer" required>
<option value="15">15分 - 可独立完成</option>
<option value="10">10分 - 需部分帮助（需他人搀扶或使用拐杖）</option>
<option value="5">5分 - 需极大帮助（较大程度上依赖他人搀扶和帮助）</option>
<option value="0">0分 - 完全依赖他人</option>
</select>
</div>
<!-- 平地行走 -->
<div class="form-group">
<label for="walking">平地行走:</label>
<select id="walking" name="walking" required>
<option value="15">15分 - 可独立在平地上行走45m</option>
<option value="10">10分 - 需部分帮助（因肢体残疾、平衡能力差、过度衰弱、视力等问题，在一定程度上需他人搀扶或使用拐杖、助行器等辅助用具）</option>
<option value="5">5分 - 需极大帮助（因肢体残疾、平衡能力差、过度衰弱、视力等问题，在较大程度上依赖他人搀扶，或坐在轮椅上自行移动）</option>
<option value="0">0分 - 完全依赖他人</option>
</select>
</div>
<!-- 上下楼梯 -->
<div class="form-group">
<label for="stairs">上下楼梯:</label>
<select id="stairs" name="stairs" required>
<option value="10">10分 - 可独立上下楼梯（连续上下10-15个台阶）</option>
<option value="5">5分 - 需部分帮助（需他人搀扶，或扶着楼梯、使用拐杖等）</option>
<option value="0">0分 - 需极大帮助或完全依赖他人</option>
</select>
</div>
<!-- 提交按钮 -->
<div class="form-group">
<input type="submit" class="submit-btn" value="提交">
</div>
</form>
</body>
</html>
daily.jsp
点击查看代码
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>日常生活活动能力评估列表</title>
<style>
body {
font-family: Arial, sans-serif;
background-color: #f4f4f4;
margin: 0;
padding: 0;
}
.container {
max-width: 800px;
margin: 50px auto;
padding: 20px;
background-color: #fff;
box-shadow: 0 0 10px rgba(0, 0, 0, 0.1);
text-align: center;
}
h1 {
color: #333;
}
button {
margin: 10px;
padding: 10px 20px;
font-size: 16px;
color: #fff;
background-color: #007BFF;
border: none;
border-radius: 5px;
cursor: pointer;
transition: background-color 0.3s;
}
button:hover {
background-color: #0056b3;
}
</style>
</head>
<body>
<h1>日常生活活动能力评估列表</h1>
<table>
<thead>
<tr>
<th>评估编号</th>
<th>进食</th>
<th>洗澡</th>
<th>修饰</th>
<th>穿衣</th>
<th>大便控制</th>
<th>小便控制</th>
<th>如厕</th>
<th>床椅转移</th>
<th>平地行走</th>
<th>上下楼梯</th>
<th>总分</th>
<th>活动分级</th>
</tr>
</thead>
<tbody>
<c:forEach var="daily" items="${dailyList}">
<tr>
<td>${daily.assessmentID}</td>
<td>
<c:choose>
<c:when test="${daily.eating == 10}">10分 - 可独立进食</c:when>
<c:when test="${daily.eating == 5}">5分 - 需部分帮助</c:when>
<c:when test="${daily.eating == 0}">0分 - 需极大帮助</c:when>
<c:otherwise>未知</c:otherwise>
</c:choose>
</td>
<td>
<c:choose>
<c:when test="${daily.bathing == 5}">5分 - 可独立洗澡</c:when>
<c:when test="${daily.bathing == 0}">0分 - 需帮助</c:when>
<c:otherwise>未知</c:otherwise>
</c:choose>
</td>
<td>
<c:choose>
<c:when test="${daily.grooming == 5}">5分 - 可独立修饰</c:when>
<c:when test="${daily.grooming == 0}">0分 - 需帮助</c:when>
<c:otherwise>未知</c:otherwise>
</c:choose>
</td>
<td>
<c:choose>
<c:when test="${daily.dressing == 10}">10分 - 可独立穿衣</c:when>
<c:when test="${daily.dressing == 5}">5分 - 需部分帮助</c:when>
<c:when test="${daily.dressing == 0}">0分 - 需极大帮助</c:when>
<c:otherwise>未知</c:otherwise>
</c:choose>
</td>
<td>
<c:choose>
<c:when test="${daily.bowelControl == 10}">10分 - 可控制大便</c:when>
<c:when test="${daily.bowelControl == 5}">5分 - 偶尔失控</c:when>
<c:when test="${daily.bowelControl == 0}">0分 - 完全失控</c:when>
<c:otherwise>未知</c:otherwise>
</c:choose>
</td>
<td>
<c:choose>
<c:when test="${daily.bladderControl == 10}">10分 - 可控制小便</c:when>
<c:when test="${daily.bladderControl == 5}">5分 - 偶尔失控</c:when>
<c:when test="${daily.bladderControl == 0}">0分 - 完全失控</c:when>
<c:otherwise>未知</c:otherwise>
</c:choose>
</td>
<td>
<c:choose>
<c:when test="${daily.toileting == 10}">10分 - 可独立如厕</c:when>
<c:when test="${daily.toileting == 5}">5分 - 需部分帮助</c:when>
<c:when test="${daily.toileting == 0}">0分 - 需极大帮助</c:when>
<c:otherwise>未知</c:otherwise>
</c:choose>
</td>
<td>
<c:choose>
<c:when test="${daily.bedChairTransfer == 15}">15分 - 可独立转移</c:when>
<c:when test="${daily.bedChairTransfer == 10}">10分 - 需部分帮助</c:when>
<c:when test="${daily.bedChairTransfer == 5}">5分 - 需极大帮助</c:when>
<c:when test="${daily.bedChairTransfer == 0}">0分 - 完全依赖他人</c:when>
<c:otherwise>未知</c:otherwise>
</c:choose>
</td>
<td>
<c:choose>
<c:when test="${daily.walking == 15}">15分 - 可独立行走</c:when>
<c:when test="${daily.walking == 10}">10分 - 需部分帮助</c:when>
<c:when test="${daily.walking == 5}">5分 - 需极大帮助</c:when>
<c:when test="${daily.walking == 0}">0分 - 完全依赖他人</c:when>
<c:otherwise>未知</c:otherwise>
</c:choose>
</td>
<td>
<c:choose>
<c:when test="${daily.stairs == 10}">10分 - 可独立上下楼梯</c:when>
<c:when test="${daily.stairs == 5}">5分 - 需部分帮助</c:when>
<c:when test="${daily.stairs == 0}">0分 - 需极大帮助</c:when>
<c:otherwise>未知</c:otherwise>
</c:choose>
</td>
<td>${daily.totalScore}</td>
<td>
<c:choose>
<c:when test="${daily.activityLevel == 0}">0 - 能力完好</c:when>
<c:when test="${daily.activityLevel == 1}">1 - 轻度受损</c:when>
<c:when test="${daily.activityLevel == 2}">2 - 中度受损</c:when>
<c:when test="${daily.activityLevel == 3}">3 - 重度受损</c:when>
<c:otherwise>未知</c:otherwise>
</c:choose>
</td>
</tr>
</c:forEach>
</tbody>
</table>
</body>
</html>
【推荐】国内首个AI IDE，深度理解中文开发场景，立即下载体验Trae
【推荐】编程新体验，更懂你的AI，立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包，你的智能百科全书，全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell：AI 加持，快人一步
· 没有Manus邀请码？试试免邀请码的MGX或者开源的OpenManus吧
· 无需6万激活码！GitHub神秘组织3小时极速复刻Manus，手把手教你使用OpenManus搭建本
· C#/.NET/.NET Core优秀项目和框架2025年2月简报
· DeepSeek在M芯片Mac上本地化部署
· 葡萄城 AI 搜索升级：DeepSeek 加持，客户体验更智能