老年人能力评估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);
    }

}

补全了大部功能,准备进行个人网站的建设

posted @ 2025-02-08 22:35  sword_kong  阅读(18)  评论(0)    收藏  举报