老年人能力评估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);
}
}
补全了大部功能,准备进行个人网站的建设