老年人能力评估8
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>填写感知觉与沟通评估表</title>
<meta charset="UTF-8">
<style>
body {
font-family: 'Arial', sans-serif;
background-color: #f4f4f9;
margin: 0;
padding: 0;
display: flex;
justify-content: center;
align-items: center;
height: 100vh;
background-image: url("117a94c5-8e45-42c8-947f-6085fb41242b.jpg");
background-size: cover;
background-position: center;
}
.container {
background-color: rgba(255, 255, 255, 0.9);
padding: 20px;
border-radius: 8px;
box-shadow: 0 0 10px rgba(0, 0, 0, 0.1);
width: 300px;
text-align: left;
max-width: 100%;
margin: 0 auto;
}
h2 {
font-size: 1.5em;
margin-bottom: 20px;
}
.form-group {
margin-bottom: 15px;
}
.form-group label {
display: inline-block;
width: 120px;
font-weight: bold;
vertical-align: top;
}
.form-group input,
.form-group select {
width: calc(100% - 130px);
padding: 8px;
border: 1px solid #ccc;
border-radius: 4px;
box-sizing: border-box;
vertical-align: top;
}
.form-group select {
width: calc(100% - 130px + 15px);
}
.form-group input[type="text"],
.form-group input[type="date"] {
width: calc(100% - 130px);
}
.form-group input[type="submit"] {
width: 100%;
padding: 10px;
background-color: #007BFF;
color: white;
border: none;
border-radius: 4px;
cursor: pointer;
font-size: 16px;
transition: background-color 0.3s ease;
}
.form-group input[type="submit"]:hover {
background-color: #0056b3;
}
</style>
</head>
<body>
<form action="addperception" method="post">
<div class="container">
<h2>填写感知觉与沟通评估表</h2>
<div class="form-group">
<label for="consciousness">意识水平：</label>
<select name="consciousness" id="consciousness">
<option value="0">0 分，神志清醒</option>
<option value="1">1 分，嗜睡</option>
<option value="2">2 分，昏睡</option>
<option value="3">3 分，昏迷</option>
</select>
</div>
<div class="form-group">
<label for="vision">视力：</label>
<select name="vision" id="vision">
<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>
</div>
<div class="form-group">
<label for="hearing">听力：</label>
<select name="hearing" id="hearing">
<option value="0">0 分，可正常交谈</option>
<option value="1">1 分，在轻声说话或说话距离超过 2 米时听不清</option>
<option value="2">2 分，正常交流有些困难，需在安静的环境或大声说话才能听到</option>
<option value="3">3 分，讲话者大声说话或说话很慢，才能部分听见</option>
<option value="4">4 分，完全听不见</option>
</select>
</div>
<div class="form-group">
<label for="communication">沟通交流：</label>
<select name="communication" id="communication">
<option value="0">0 分，无困难，能与他人正常沟通和交流</option>
<option value="1">1 分，能够表达自己的需要及理解别人的话，但需要增加时间或给予帮助</option>
<option value="2">2 分，表达需要或理解有困难，需频繁重复或简化口头表达</option>
<option value="3">3 分，不能表达需要或理解他人的话</option>
</select>
</div>
<%
String idnumber=(String)session.getAttribute("idnumber");
%>
<input name="idnumber" type="hidden" value="<%=idnumber%>">
<div class="form-group">
<input type="submit" value="提交">
</div>
</div>
</form>
</body>
</html>
```plaintext
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>填写社会参与评估表</title>
<meta charset="UTF-8">
<style>
body {
font-family: 'Arial', sans-serif;
background-color: #f4f4f9;
margin: 0;
padding: 0;
display: flex;
justify-content: center;
align-items: center;
height: 100vh;
background-image: url("117a94c5-8e45-42c8-947f-6085fb41242b.jpg");
background-size: cover;
background-position: center;
}
.container {
background-color: rgba(255, 255, 255, 0.9);
padding: 20px;
border-radius: 8px;
box-shadow: 0 0 10px rgba(0, 0, 0, 0.1);
width: 300px;
text-align: left;
max-width: 100%;
margin: 0 auto;
}
h2 {
font-size: 1.5em;
margin-bottom: 20px;
}
.form-group {
margin-bottom: 15px;
}
.form-group label {
display: inline-block;
width: 120px;
font-weight: bold;
vertical-align: top;
}
.form-group input,
.form-group select {
width: calc(100% - 130px);
padding: 8px;
border: 1px solid #ccc;
border-radius: 4px;
box-sizing: border-box;
vertical-align: top;
}
.form-group select {
width: calc(100% - 130px + 15px);
}
.form-group input[type="text"],
.form-group input[type="date"] {
width: calc(100% - 130px);
}
.form-group input[type="submit"] {
width: 100%;
padding: 10px;
background-color: #007BFF;
color: white;
border: none;
border-radius: 4px;
cursor: pointer;
font-size: 16px;
transition: background-color 0.3s ease;
}
.form-group input[type="submit"]:hover {
background-color: #0056b3;
}
</style>
</head>
<body>
<form action="addsocial" method="post">
<div class="container">
<h2>填写社会参与评估表</h2>
<div class="form-group">
<label for="live">生活能力：</label>
<select name="live" id="live">
<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>
</div>
<div class="form-group">
<label for="work">工作能力：</label>
<select name="work" id="work">
<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>
</div>
<div class="form-group">
<label for="timespace">时间/空间定向：</label>
<select name="timespace" id="timespace">
<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>
</div>
<div class="form-group">
<label for="relation">人物定向：</label>
<select name="relation" id="relation">
<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>
</div>
<div class="form-group">
<label for="socialing">社会交往能力：</label>
<select name="socialing" id="socialing">
<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>
</div>
<%
String idnumber=(String)session.getAttribute("idnumber");
%>
<input name="idnumber" type="hidden" value="<%=idnumber%>">
<div class="form-group">
<input type="submit" value="提交">
</div>
</div>
</form>
</body>
</html>
```plaintext
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<meta charset="UTF-8">
<title>老年人能力评估表</title>
<style>
body {
font-family: 'Arial', sans-serif;
background-color: #f4f4f9;
margin: 0;
padding: 0;
display: flex;
justify-content: center;
align-items: center;
height: 100vh;
background-image: url("117a94c5-8e45-42c8-947f-6085fb41242b.jpg");
background-size: cover;
background-position: center;
}
.container {
background-color: rgba(255, 255, 255, 0.9);
padding: 20px;
border-radius: 8px;
box-shadow: 0 0 10px rgba(0, 0, 0, 0.1);
width: 300px;
text-align: left;
max-width: 100%;
margin: 0 auto;
}
h2 {
font-size: 1.5em;
margin-bottom: 20px;
}
.form-group {
margin-bottom: 15px;
}
.form-group label {
display: inline-block;
width: 120px;
font-weight: bold;
vertical-align: top;
}
.form-group input,
.form-group select {
width: calc(100% - 130px);
padding: 8px;
border: 1px solid #ccc;
border-radius: 4px;
box-sizing: border-box;
vertical-align: top;
}
.form-group select {
width: calc(100% - 130px + 15px);
}
.form-group input[type="text"],
.form-group input[type="date"] {
width: calc(100% - 130px);
}
.form-group input[type="submit"] {
width: 100%;
padding: 10px;
background-color: #007BFF;
color: white;
border: none;
border-radius: 4px;
cursor: pointer;
font-size: 16px;
transition: background-color 0.3s ease;
}
</style>
</head>
<body>
<form action="addsummary" method="post">
<div class="container">
<h2>填写老年人能力评估报告</h2>
<div class="form-group">
<label for="level1">日常生活活动：</label>
<select id="level1" name="level1">
<option value="0">0级</option>
<option value="1">1级</option>
<option value="2">2级</option>
<option value="3">3级</option>
</select>
</div>
<div class="form-group">
<label for="level2">精神状态：</label>
<select id="level2" name="level2">
<option value="0">0级</option>
<option value="1">1级</option>
<option value="2">2级</option>
<option value="3">3级</option>
</select>
</div>
<div class="form-group">
<label for="level3">感知觉与沟通：</label>
<select id="level3" name="level3">
<option value="0">0级</option>
<option value="1">1级</option>
<option value="2">2级</option>
<option value="3">3级</option>
</select>
</div>
<div class="form-group">
<label for="level4">社会参与：</label>
<select id="level4" name="level4">
<option value="0">0级</option>
<option value="1">1级</option>
<option value="2">2级</option>
<option value="3">3级</option>
</select>
</div>
<div class="form-group">
<label for="name1">老年人姓名：</label>
<input type="text" id="name1" name="name1" placeholder="请输入老年人姓名">
</div>
<div class="form-group">
<label for="level5">最终等级：</label>
<select id="level5" name="level5">
<option value="0">能力完好</option>
<option value="1">轻度失能</option>
<option value="2">中度失能</option>
<option value="3">重度失能</option>
</select>
</div>
<div class="form-group">
<label for="name2">评估员签名：</label>
<input type="text" id="name2" name="name2" placeholder="请输入评估员签名">
</div>
<div class="form-group">
<label for="date1">评估日期：</label>
<input type="date" id="date1" name="date1">
</div>
<div class="form-group">
<label for="name3">信息提供者签名：</label>
<input type="text" id="name3" name="name3" placeholder="请输入信息提供者签名">
</div>
<div class="form-group">
<label for="date2">信息提供日期：</label>
<input type="date" id="date2" name="date2">
</div>
<div class="form-group">
<label for="idnumber">被评估者的身份证号：</label>
<input name="idnumber" type="text" id="idnumber">
</div>
<div class="form-group">
<input type="submit" value="提交">
</div>
<div class="form-group">
<h3>老年人能力初步等级划分标准</h3>
<p>0 能力完好：日常生活活动、精神状态、感知觉与沟通分级均为 0，社会参与分级为 0 或 1</p>
<p>1 轻度失能：日常生活活动分级为 0，但精神状态、感知觉与沟通中至少一项分级为 1 及以上，或社会参与的分级为 2； 或日常生活活动分级为 1，精神状态、感知觉与沟通、社会参与中至少有一项的分级为 0 或 1</p>
<p>2 中度失能：日常生活活动分级为 1，但精神状态、感知觉与沟通、社会参与均为 2，或有一项为 3； 或日常生活活动分级为 2，且精神状态、感知觉与沟通、社会参与中有 1-2 项的分级为 1 或 2</p>
<p>3 重度失能：日常生活活动的分级为 3； 或日常生活活动、精神状态、感知觉与沟通、社会参与分级均为 2； 或日常生活活动分级为 2，且精神状态、感知觉与沟通、社会参与中至少有一项分级为 3</p>
<img src="img.png" alt="老年人能力评估结果判定卡" style="width: auto;height: auto">
</div>
</div>
</form>
</body>
</html>```plaintext
<%@ page import="data.summarydata" %>
<%@ page import="java.util.List" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>查看老年人能力评估结果</title>
<meta charset="UTF-8">
<style>
body {
font-family: Arial, sans-serif;
background-color: #f4f4f9;
margin: 0;
padding: 0;
display: flex;
justify-content: center;
align-items: center;
height: 100vh;
background-image: url("117a94c5-8e45-42c8-947f-6085fb41242b.jpg");
background-size: cover;
background-position: center;
}
.container {
background-color: rgba(255, 255, 255, 0.9);
padding: 20px;
border-radius: 8px;
box-shadow: 0 0 10px rgba(0, 0, 0, 0.1);
width: 80%;
max-width: 800px;
text-align: left;
position: absolute;
top: 20px;
left: 20px;
}
h2 {
font-size: 1.0em;
margin-bottom: 20px;
}
form {
margin-bottom: 20px;
}
label {
display: inline-block;
width: 150px;
margin-right: 10px;
font-weight: bold;
}
input[type="text"], input[type="submit"] {
padding: 8px;
border: 1px solid #ccc;
border-radius: 4px;
box-sizing: border-box;
}
table {
width: 100%;
border-collapse: collapse;
margin-top: 20px;
font-size:0.8em;
}
th, td {
padding: 10px;
text-align: left;
border: 1px solid #ddd;
}
th {
background-color: #f2f2f2;
font-weight: bold;
}
tr:nth-child(even) {
background-color: #f9f9f9;
}
tr:hover {
background-color: #eaeaea;
}
.delete-form {
display: inline-block;
}
.delete-form input[type="submit"], .edit-form input[type="submit"] {
background-color: #dc3545;
color: white;
border: none;
border-radius: 4px;
padding: 6px 12px;
cursor: pointer;
transition: background-color 0.3s ease;
}
.delete-form input[type="submit"]:hover, .edit-form input[type="submit"]:hover {
background-color: #c82333;
}
.edit-form select {
padding: 8px;
border: 1px solid #ccc;
border-radius: 4px;
box-sizing: border-box;
width: calc(100% - 162px);
}
</style>
</head>
<body>
<div class="container">
<h2>查看信息提供者及联系人信息表</h2>
<form action="checkinformat" method="get">
<%
String type=request.getParameter("type");
String idnumber=request.getParameter("idnumber");
if(type.equals("评估员")||type.equals("管理员")){%>
<label for="checknumber">评估编号：</label>
<input name="number" type="text" id="checknumber">
<%}else{%>
<input name="idnumber" type="hidden" value="<%=idnumber%>">
<%}%>
<input name="type" type="hidden" value="<%=type%>">
<input type="submit" value="查看">
</form>
<table>
<tbody>
<%
List<summarydata> data = (List<summarydata>) request.getAttribute("data");
if (data != null && !data.isEmpty())
for (summarydata d : data) { %>
<tr>
<th colspan="2">C.1 一级指标</th>
</tr>
<tr>
<th>分级</th>
<th></th>
</tr>
<tr>
<td>C.1.1 日常生活活动：</td>
<td><%=d.getLevel1()%>级</td>
</tr>
<tr>
<td>C.1.2 精神状态：</td>
<td><%=d.getLevel2()%>级</td>
</tr>
<tr>
<td>C.1.3 感知觉与沟通：</td>
<td><%=d.getLevel3()%>级</td>
</tr>
<tr>
<td>C.1.4 社会参与：</td>
<td><%=d.getLevel4()%>级</td>
</tr>
<tr>
<td colspan="2">C.2 老年人能力初步等级</td>
</tr>
<tr>
<td><%=d.getLevel5()%> <%
if (d.getLevel5() == 0) {%>
能力完好
<% } else if (d.getLevel5() == 1) {%>
轻度失能
<% } else if (d.getLevel5() == 2) {%>
中度失能
<% } else if (d.getLevel5() == 3) {%>
重度失能
<% }%>
</td>
</tr>
<tr>
<td colspan="2">C.3 等级变更条款</td>
</tr>
<tr>
<td colspan="2">
<%=d.getLevel6()%>
<% if (d.getLevel6() == 1) {%>
有认知障碍/痴呆、精神疾病者，在原有能力级别上提高一个等级
<% } else if (d.getLevel6() == 2) {%>
近 30 天内发生过 2 次及以上跌倒、噎食、自杀、走失者，在原有能力级别上提高一个等级；
<% } else if (d.getLevel6() == 3) {%>
处于昏迷状态者，直接评定为重度失能
<% } else if (d.getLevel6() == 4) {%>
有认知障碍/痴呆、精神疾病者，在原有能力级别上提高一个等级
<% }%>
</td>
</tr>
<tr>
<td colspan="2">C.4 老年人能力最终等级</td>
</tr>
<tr>
<td><%=d.getLevel7()%> <%
if (d.getLevel7() == 0) {%>
能力完好
<% } else if (d.getLevel7() == 1) {%>
轻度失能
<% } else if (d.getLevel7() == 2) {%>
中度失能
<% } else if (d.getLevel7() == 3) {%>
重度失能
<% }%>
</td>
</tr>
<tr>
<td>评估员签名</td>
<td><%=d.getName1()%>、<%=d.getName2()%></td>
</tr>
<tr>
<td>日期</td>
<td><%=d.getDate1()%></td>
</tr>
<tr>
<td>信息提供者签名</td>
<td><%=d.getName3()%></td>
</tr>
<tr>
<td>日期</td>
<td><%=d.getDate2()%></td>
</tr>
<% } %>
</tbody>
</table>
</div>
</body>
</html>
```plaintext
import data.perceptiondata;
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;
import java.sql.SQLException;
@WebServlet("/addperception")
public class addperception extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
int consciousness = Integer.parseInt(request.getParameter("consciousness"));
int vision= Integer.parseInt(request.getParameter("vision"));
int hearing= Integer.parseInt(request.getParameter("hearing"));
int communication= Integer.parseInt(request.getParameter("communication"));
int level= Integer.parseInt(request.getParameter("level"));
String idnumber= request.getParameter("idnumber");
perceptiondata data=new perceptiondata(consciousness,vision,hearing,communication,level,"",idnumber);
Dao dao=new Dao();
try {
if(dao.addperception(data)) {
request.getSession().setAttribute("idnumber",idnumber);
response.sendRedirect("addsocial.jsp");
}
else {
request.getRequestDispatcher("addperception.jsp").forward(request, response);
}
} catch (SQLException | ClassNotFoundException e) {
throw new ServletException(e);
}
}
}
```plaintext
import data.socialdata;
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;
import java.sql.SQLException;
@WebServlet("/addsocial")
public class addsocial extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
int live=Integer.parseInt(request.getParameter("live"));
int work=Integer.parseInt(request.getParameter("work"));
int timespace=Integer.parseInt(request.getParameter("timespace"));
int relation=Integer.parseInt(request.getParameter("relation"));
int socialing=Integer.parseInt(request.getParameter("socialing"));
int total=Integer.parseInt(request.getParameter("total"));
int level=Integer.parseInt(request.getParameter("level"));
String idnumber=request.getParameter("idnumber");
socialdata data=new socialdata(live,work,timespace,relation,socialing,total,level,"",idnumber);
Dao dao=new Dao();
try {
if(dao.addsocial(data)) {
response.sendRedirect("addsummary.jsp");
}
else {
request.getRequestDispatcher("addsocial.jsp").forward(request, response);
}
} catch (SQLException | ClassNotFoundException e) {
throw new ServletException(e);
}
}
}
```plaintext
import java.sql.SQLException;
import java.sql.Date;
@WebServlet("/addsummary")
public class addsummary extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
int level1 = Integer.parseInt(request.getParameter("level1"));
int level2 = Integer.parseInt(request.getParameter("level2"));
int level3 = Integer.parseInt(request.getParameter("level3"));
int level4 = Integer.parseInt(request.getParameter("level4"));
int level5 = Integer.parseInt(request.getParameter("level5"));
int level6 = Integer.parseInt(request.getParameter("level6"));
int level7 = Integer.parseInt(request.getParameter("level7"));
String name1=request.getParameter("name1");
String name2=request.getParameter("name2");
Date date1=Date.valueOf(request.getParameter("date1"));
String name3=request.getParameter("name3");
Date date2=Date.valueOf(request.getParameter("date2"));
String idnumber=request.getParameter("idnumber");
summarydata data=new summarydata(level1,level2,level3,level4,level5,level6,level7,name1,name2,date1,name3,date2,idnumber,"");
Dao dao=new Dao();
try {
if(dao.addsummary(data)) {
response.sendRedirect("operator.jsp");
}
else {
request.getRequestDispatcher("addsummary.jsp").forward(request, response);
}
} catch (SQLException | ClassNotFoundException e) {
throw new ServletException(e);
}
}
}
```plaintext
import java.sql.SQLException;
import java.sql.Date;
@WebServlet("/addsummary")
public class addsummary extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
int level1 = Integer.parseInt(request.getParameter("level1"));
int level2 = Integer.parseInt(request.getParameter("level2"));
int level3 = Integer.parseInt(request.getParameter("level3"));
int level4 = Integer.parseInt(request.getParameter("level4"));
int level5 = Integer.parseInt(request.getParameter("level5"));
int level6 = Integer.parseInt(request.getParameter("level6"));
int level7 = Integer.parseInt(request.getParameter("level7"));
String name1=request.getParameter("name1");
String name2=request.getParameter("name2");
Date date1=Date.valueOf(request.getParameter("date1"));
String name3=request.getParameter("name3");
Date date2=Date.valueOf(request.getParameter("date2"));
String idnumber=request.getParameter("idnumber");
summarydata data=new summarydata(level1,level2,level3,level4,level5,level6,level7,name1,name2,date1,name3,date2,idnumber,"");
Dao dao=new Dao();
try {
if(dao.addsummary(data)) {
response.sendRedirect("operator.jsp");
}
else {
request.getRequestDispatcher("addsummary.jsp").forward(request, response);
}
} catch (SQLException | ClassNotFoundException e) {
throw new ServletException(e);
}
}
}
```plaintext
import java.io.IOException;
import java.sql.SQLException;
import java.util.List;
@WebServlet("/checksummary")
public class checksummary extends HttpServlet {
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
String type = request.getParameter("type");
String number;
if(type.equals("评估员")||type.equals("管理员")) number = request.getParameter("number");
else number = request.getParameter("idnumber");
Dao dao = new Dao();
try {
List<summarydata> data=dao.checksummary(type,number);
request.setAttribute("data", data);
} catch (SQLException | ClassNotFoundException e) {
e.printStackTrace();
}
request.getRequestDispatcher("checksummary.jsp").forward(request, response);
}
}
补全了大部功能，准备进行个人网站的建设
浙公网安备 33010602011771号