老年人能力评估部分修改

表:

create database testsystem;
use testsystem;
drop table plan,people,informat;
create table plan(
  number text,
  date date,
  reason text
);
create table people(
  name text,
  sex text,
  birthday date,
  idnumber varbinary(18),
    socialid varbinary(9),
    nation text,
    education text,
    religion text,
    marriage text,
    reside text,
    medical text,
    income text,
    stupid text,
    mental text,
    chronic text,
    tumble text,
    lost text,
    dysphoria text,
    suicide text,
    other text,
  number text
);
create table informat(
  name text,
  relation text,
  contacts text,
  phone text,
  number text,
    idnumber VARBINARY(18)
);
drop table daily,mood,perception,social;
create table daily(
  eat varbinary(2),
  bath varbinary(2),
  wash varbinary(2),
  cloth varbinary(2),
  stool varbinary(2),
  urinal varbinary(2),
  toilet varbinary(2),
    move varbinary(2),
    walk varbinary(2),
    floor varbinary(2),
    total varbinary(3),
    level varbinary(1),
  number text,
    idnumber varbinary(18)
);

Dao:

import data.*;

import java.sql.*;
import java.util.ArrayList;
import java.util.List;

public class Dao {
    public Connection getConnection()throws SQLException ,ClassNotFoundException{
        Class.forName("com.mysql.jdbc.Driver");
        String url = "jdbc:mysql://localhost:3306/testsystem";
        String user = "root";
        String password = "123456";
        return DriverManager.getConnection(url, user, password);
    }

    public boolean index(indexdata data,String type)throws SQLException ,ClassNotFoundException{
        String sql = "select * from user where id=? and type=?";
        try(Connection conn=getConnection(); PreparedStatement ps=conn.prepareStatement(sql)){
            ps.setString(1,data.getId());
            ps.setString(2,type);
            ResultSet rs=ps.executeQuery();
            while(rs.next())
                if(data.getPassword().equals(rs.getString("password"))) return true;
            return false;
        }
    }

    public boolean registe(String id,String password,String type)throws SQLException ,ClassNotFoundException{
        if(id==null||password==null) return false;
        String sql = "insert into user values(?,?,?)";
        try(Connection conn=getConnection(); PreparedStatement ps=conn.prepareStatement(sql)){
            ps.setString(1,id);
            ps.setString(2,password);
            ps.setString(3,type);
            return ps.executeUpdate()>0;
        }
    }

    public boolean addplan(plandata data)throws SQLException ,ClassNotFoundException{
        if(data==null||data.getNumber().length()!=10) return false;
        String sql1="select * from plan where number=?";
        try(Connection conn=getConnection(); PreparedStatement ps=conn.prepareStatement(sql1)){
            ps.setString(1,data.getNumber());
            ResultSet rs=ps.executeQuery();
            if(rs.next()) {
                if(rs.getString("number").equals(data.getNumber())) return false;
            }
        }
        String sql2 = "insert into plan values(?,?,?)";
        try(Connection conn=getConnection(); PreparedStatement ps=conn.prepareStatement(sql2)){
            ps.setString(1,data.getNumber());
            ps.setDate(2,data.getDate());
            ps.setString(3,data.getReason());
            return ps.executeUpdate()>0;
        }
    }

    public boolean addpeople(peopledata data)throws SQLException ,ClassNotFoundException{
        if(data==null||data.getNumber().length()!=10||data.getIdnumber().length()!=18||data.getSocialid().length()!=9) return false;
        String sql1="select * from people where number=?";
        try(Connection conn=getConnection(); PreparedStatement ps=conn.prepareStatement(sql1)){
            ps.setString(1,data.getNumber());
            ResultSet rs=ps.executeQuery();
            if(rs.next()) {
                if(rs.getString("number").equals(data.getNumber())) return false;
            }
        }
        String sql2 = "insert into people values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
        try(Connection conn=getConnection(); PreparedStatement ps=conn.prepareStatement(sql2)){
            ps.setString(1,data.getName());
            ps.setString(2,data.getSex());
            ps.setDate(3,data.getBirthday());
            ps.setString(4,data.getIdnumber());
            ps.setString(5,data.getSocialid());
            ps.setString(6,data.getNation());
            ps.setString(7,data.getEducation());
            ps.setString(8,data.getReligion());
            ps.setString(9,data.getMarriage());
            ps.setString(10, data.getReside());
            ps.setString(11,data.getMedical());
            ps.setString(12,data.getIncome());
            ps.setString(13,data.getStupid());
            ps.setString(14,data.getMental());
            ps.setString(15,data.getChronic());
            ps.setString(16,data.getTumble());
            ps.setString(17,data.getLost());
            ps.setString(18,data.getDysphoria());
            ps.setString(19,data.getSuicide());
            ps.setString(20,data.getOther());
            ps.setString(21,data.getNumber());
            return ps.executeUpdate()>0;
        }
    }

    public boolean addinformat(informatdata data)throws SQLException ,ClassNotFoundException{
        if(data==null||data.getNumber().length()!=10||data.getPhone().length()!=11||data.getIdnumber().length()!=18) return false;
        String sql1="select * from informat where number=?";
        try(Connection conn=getConnection(); PreparedStatement ps=conn.prepareStatement(sql1)){
            ps.setString(1,data.getNumber());
            ResultSet rs=ps.executeQuery();
            if(rs.next()) {
                if(rs.getString("number").equals(data.getNumber())) return false;
            }
        }
        String sql2 = "insert into informat values(?,?,?,?,?,?)";
        try(Connection conn=getConnection(); PreparedStatement ps=conn.prepareStatement(sql2)){
            ps.setString(1,data.getName());
            ps.setString(2,data.getRelation());
            ps.setString(3,data.getContacts());
            ps.setString(4,data.getPhone());
            ps.setString(5,data.getNumber());
            ps.setString(6,data.getIdnumber());
            return ps.executeUpdate()>0;
        }
    }

    public List<plandata> checkplan(String number) throws SQLException, ClassNotFoundException {
        String sql;
        if(number.isEmpty()) sql="select * from plan";
        else sql="select * from plan where number=?";
        List<plandata> list = new ArrayList<>();
        try (Connection conn = getConnection(); PreparedStatement ps = conn.prepareStatement(sql)) {
            if(!number.isEmpty()) ps.setString(1,number);
            ResultSet rs=ps.executeQuery();
            while(rs.next()){
                plandata data=new plandata(rs.getString("number"),
                        rs.getDate("date"),
                        rs.getString("reason"));
                list.add(data);
            }
            return list;
        }
    }

    public List<peopledata> checkpeople(String type,String number)throws SQLException,ClassNotFoundException{
        String sql;
        if(type.equals("评估员")||type.equals("管理员")) {
            if (number.isEmpty()) sql = "select * from people";
            else sql = "select * from people where number=?";
        }else sql = "select * from people where idnumber=?";
        try(Connection conn=getConnection(); PreparedStatement ps=conn.prepareStatement(sql)){
            if(!number.isEmpty()) ps.setString(1,number);
            ResultSet rs=ps.executeQuery();
            List<peopledata> list=new ArrayList<>();
            while(rs.next()){
                peopledata data=new peopledata(rs.getString("name"),
                        rs.getString("sex"),
                        rs.getDate("birthday"),
                        rs.getString("idnumber"),
                        rs.getString("socialid"),
                        rs.getString("nation"),
                        rs.getString("education"),
                        rs.getString("religion"),
                        rs.getString("marriage"),
                        rs.getString("reside"),
                        rs.getString("medical"),
                        rs.getString("income"),
                        rs.getString("stupid"),
                        rs.getString("mental"),
                        rs.getString("chronic"),
                        rs.getString("tumble"),
                        rs.getString("lost"),
                        rs.getString("dysphoria"),
                        rs.getString("suicide"),
                        rs.getString("other"),
                        rs.getString("number"));
                list.add(data);
            }
            return list;
        }
    }

    public List<informatdata> checkinformat(String type,String number)throws SQLException,ClassNotFoundException{
        String sql;
        if(type.equals("评估员")||type.equals("管理员")) {
            if (number.isEmpty()) sql = "select * from informat";
            else sql = "select * from informat where number=?";
        }else sql = "select * from informat where idnumber=?";
        try(Connection conn=getConnection(); PreparedStatement ps=conn.prepareStatement(sql)){
            if(!number.isEmpty()) ps.setString(1,number);
            ResultSet rs=ps.executeQuery();
            List<informatdata> list=new ArrayList<>();
            while(rs.next()){
                informatdata data=new informatdata(rs.getString("name"),
                        rs.getString("relation"),
                        rs.getString("contacts"),
                        rs.getString("phone"),
                        rs.getString("number"),
                        rs.getString("idnumber"));
                list.add(data);
            }
            return list;
        }
    }

    public boolean deleteplan(String number) throws SQLException, ClassNotFoundException {
        String sqlPlan = "DELETE FROM plan WHERE number = ?";
        String sqlPeople = "DELETE FROM people WHERE number = ?";
        String sqlInformat = "DELETE FROM informat WHERE number = ?";
        String sqlDaily = "DELETE FROM daily WHERE number = ?";
        String sqlMood = "DELETE FROM mood WHERE number = ?";
        String sqlPerception = "DELETE FROM perception WHERE number = ?";
        String sqlSocial = "DELETE FROM social WHERE number = ?";

        try (Connection conn = getConnection()) {
            conn.setAutoCommit(false);
            
            try (PreparedStatement psPlan = conn.prepareStatement(sqlPlan);
                 PreparedStatement psPeople = conn.prepareStatement(sqlPeople);
                 PreparedStatement psInformat = conn.prepareStatement(sqlInformat);
                 PreparedStatement psDaily = conn.prepareStatement(sqlDaily);
                 PreparedStatement psMood = conn.prepareStatement(sqlMood);
                 PreparedStatement psPerception = conn.prepareStatement(sqlPerception);
                 PreparedStatement psSocial = conn.prepareStatement(sqlSocial)) {

                psPlan.setString(1, number);
                psPeople.setString(1, number);
                psInformat.setString(1, number);
                psDaily.setString(1, number);
                psMood.setString(1, number);
                psPerception.setString(1, number);
                psSocial.setString(1, number);

                int rowsDeletedPlan = psPlan.executeUpdate();
                int rowsDeletedPeople = psPeople.executeUpdate();
                int rowsDeletedInformat = psInformat.executeUpdate();
                int rowsDeletedDaily = psDaily.executeUpdate();
                int rowsDeletedMood = psMood.executeUpdate();
                int rowsDeletedPerception = psPerception.executeUpdate();
                int rowsDeletedSocial = psSocial.executeUpdate();

                conn.commit();

                return rowsDeletedPlan > 0 || rowsDeletedPeople > 0 || rowsDeletedInformat > 0 ||
                        rowsDeletedDaily > 0 || rowsDeletedMood > 0 || rowsDeletedPerception > 0 ||
                        rowsDeletedSocial > 0;
            } catch (SQLException e) {
                conn.rollback();
                throw e;
            }
        }
    }
    /*
    public boolean deletepeople(String number)throws SQLException,ClassNotFoundException{
        String sql="delete from people where number=?";
        try(Connection conn=getConnection(); PreparedStatement ps=conn.prepareStatement(sql)){
            ps.setString(1,number);
            return ps.executeUpdate()>0;
        }
    }

    public boolean deleteinformat(String number)throws SQLException,ClassNotFoundException{
        String sql="delete from informat where number=?";
        try(Connection conn=getConnection(); PreparedStatement ps=conn.prepareStatement(sql)){
            ps.setString(1,number);
            return ps.executeUpdate()>0;
        }
    }
    */
    public boolean editplan(plandata data)throws SQLException,ClassNotFoundException{
        String sql="update plan set date=?,reason=? where number=?";
        try(Connection conn=getConnection(); PreparedStatement ps=conn.prepareStatement(sql)){
            ps.setDate(1,data.getDate());
            ps.setString(2,data.getReason());
            ps.setString(3,data.getNumber());
            return ps.executeUpdate()>0;
        }
    }

    public boolean editpeople(peopledata data)throws SQLException,ClassNotFoundException{
        String sql="update people set name=?,sex=?,birthday=?,idnumber=?,socialid=?,nation=?,education=?,religion=?,marriage=?," +
                "reside=?,medical=?,income=?,stupid=?,mental=?,chronic=?,tumble=?,lost=?,dysphoria=?,suicide=?,other=? where number=?";
        try(Connection conn=getConnection(); PreparedStatement ps=conn.prepareStatement(sql)){
            ps.setString(1,data.getName());
            ps.setString(2,data.getSex());
            ps.setDate(3,data.getBirthday());
            ps.setString(4,data.getIdnumber());
            ps.setString(5,data.getSocialid());
            ps.setString(6,data.getNation());
            ps.setString(7,data.getEducation());
            ps.setString(8,data.getReligion());
            ps.setString(9,data.getMarriage());
            ps.setString(10, data.getReside());
            ps.setString(11,data.getMedical());
            ps.setString(12,data.getIncome());
            ps.setString(13,data.getStupid());
            ps.setString(14,data.getMental());
            ps.setString(15,data.getChronic());
            ps.setString(16,data.getTumble());
            ps.setString(17,data.getLost());
            ps.setString(18,data.getDysphoria());
            ps.setString(19,data.getSuicide());
            ps.setString(20,data.getOther());
            ps.setString(21,data.getNumber());
            return ps.executeUpdate()>0;
        }
    }

    public boolean editinformat(informatdata data)throws SQLException,ClassNotFoundException{
        String sql="update informat set name=?,relation=?,contacts=?,phone=? where number=?";
        try(Connection conn=getConnection(); PreparedStatement ps=conn.prepareStatement(sql)){
            ps.setString(1,data.getName());
            ps.setString(2,data.getRelation());
            ps.setString(3,data.getContacts());
            ps.setString(4,data.getPhone());
            ps.setString(5,data.getNumber());
            return ps.executeUpdate()>0;
        }
    }

    public boolean adddaily(dailydata data)throws SQLException,ClassNotFoundException{
        String sql1="select number from people where idnumber=?";
        String number = "";
        try(Connection conn=getConnection(); PreparedStatement ps=conn.prepareStatement(sql1)) {
            ps.setString(1, data.getIdnumber());
            ResultSet rs = ps.executeQuery();
            if (rs.next()) {
                number = rs.getString("number");
            }
        }
        String sql = "insert into daily values(?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
        try (Connection conn = getConnection(); PreparedStatement ps = conn.prepareStatement(sql)) {
            ps.setInt(1, data.getEat());
            ps.setInt(2, data.getBath());
            ps.setInt(3, data.getWash());
            ps.setInt(4, data.getCloth());
            ps.setInt(5, data.getStool());
            ps.setInt(6, data.getUrinal());
            ps.setInt(7, data.getToilet());
            ps.setInt(8, data.getWalk());
            ps.setInt(9, data.getMove());
            ps.setInt(10, data.getFloor());
            ps.setInt(11, data.getTotal());
            ps.setInt(12, data.getLevel());
            ps.setString(13, number);
            ps.setString(14, data.getIdnumber());
            return ps.executeUpdate()>0;
        }
    }

    public boolean addmood(mooddata data)throws SQLException,ClassNotFoundException{
        String sql1="select number from people where idnumber=?";
        String number = "";
        try(Connection conn=getConnection(); PreparedStatement ps=conn.prepareStatement(sql1)) {
            ps.setString(1, data.getIdnumber());
            ResultSet rs = ps.executeQuery();
            if (rs.next()) {
                number = rs.getString("number");
            }
        }
        String sql = "insert into mood values(?,?,?,?,?,?,?)";
        try (Connection conn = getConnection(); PreparedStatement ps = conn.prepareStatement(sql)) {
            ps.setInt(1, data.getCogintion());
            ps.setInt(2, data.getAttack());
            ps.setInt(3,data.getDepression());
            ps.setInt(4, data.getTotal());
            ps.setInt(5, data.getLevel());
            ps.setString(6, number);
            ps.setString(7, data.getIdnumber());
            return ps.executeUpdate()>0;
        }
    }

    public boolean addperception(perceptiondata data)throws SQLException,ClassNotFoundException{
        String sql1="select number from people where idnumber=?";
        String number = "";
        try(Connection conn=getConnection(); PreparedStatement ps=conn.prepareStatement(sql1)) {
            ps.setString(1, data.getIdnumber());
            ResultSet rs = ps.executeQuery();
            if (rs.next()) {
                number = rs.getString("number");
            }
        }
        String sql = "insert into perception values(?,?,?,?,?,?,?)";
        try (Connection conn = getConnection(); PreparedStatement ps = conn.prepareStatement(sql)) {
            ps.setInt(1, data.getConsciousness());
            ps.setInt(2, data.getVision());
            ps.setInt(3,data.getHearing());
            ps.setInt(4, data.getCommunication());
            ps.setInt(5,data.getLevel());
            ps.setString(6,number);
            ps.setString(7, data.getIdnumber());
            return ps.executeUpdate()>0;
        }
    }

    public boolean addsocial(socialdata data)throws SQLException,ClassNotFoundException{
        String sql1="select number from people where idnumber=?";
        String number = "";
        try(Connection conn=getConnection(); PreparedStatement ps=conn.prepareStatement(sql1)) {
            ps.setString(1, data.getIdnumber());
            ResultSet rs = ps.executeQuery();
            if (rs.next()) {
                number = rs.getString("number");
            }
        }
        String sql = "insert into social values(?,?,?,?,?,?,?,?,?)";
        try (Connection conn = getConnection(); PreparedStatement ps = conn.prepareStatement(sql)) {
            ps.setInt(1, data.getLive());
            ps.setInt(2, data.getWork());
            ps.setInt(3,data.getTimespace());
            ps.setInt(4, data.getRelation());
            ps.setInt(5,data.getSocialing());
            ps.setInt(6, data.getTotal());
            ps.setInt(7,data.getLevel());
            ps.setString(8, number);
            ps.setString(9, data.getIdnumber());
            return ps.executeUpdate()>0;
        }
    }

    public boolean addsummary(summarydata data)throws SQLException,ClassNotFoundException{
        String sql1="select number from people where idnumber=?";
        String number = "";
        try(Connection conn=getConnection(); PreparedStatement ps=conn.prepareStatement(sql1)) {
            ps.setString(1, data.getIdnumber());
            ResultSet rs = ps.executeQuery();
            if (rs.next()) {
                number = rs.getString("number");
            }
        }
        String sql="insert into summary values(?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
        try(Connection conn=getConnection(); PreparedStatement ps=conn.prepareStatement(sql)) {
            ps.setInt(1,data.getLevel1());
            ps.setInt(2,data.getLevel2());
            ps.setInt(3,data.getLevel3());
            ps.setInt(4,data.getLevel4());
            ps.setInt(5,data.getLevel5());
            ps.setInt(6,data.getLevel6());
            ps.setInt(7,data.getLevel7());
            ps.setString(8,data.getName1());
            ps.setString(9,data.getName2());
            ps.setDate(10,data.getDate1());
            ps.setString(11,data.getName3());
            ps.setDate(12,data.getDate2());
            ps.setString(13, data.getIdnumber());
            ps.setString(14, number);
            return ps.executeUpdate()>0;
        }
    }

    public List<summarydata> checksummary(String type,String number)throws SQLException,ClassNotFoundException{
        String sql;
        if(type.equals("评估员")||type.equals("管理员")) {
            if (number.isEmpty()) sql = "select * from summary";
            else sql = "select * from summary where number=?";
        }else sql = "select * from summary where idnumber=?";
        try(Connection conn=getConnection(); PreparedStatement ps=conn.prepareStatement(sql)) {
            if(!number.isEmpty()) ps.setString(1, number);
            ResultSet rs = ps.executeQuery();
            List<summarydata> list=new ArrayList<>();
            while(rs.next()){
                summarydata data=new summarydata(
                        rs.getInt("level1"),
                        rs.getInt("level2"),
                        rs.getInt("level3"),
                        rs.getInt("level4"),
                        rs.getInt("level5"),
                        rs.getInt("level6"),
                        rs.getInt("level7"),
                        rs.getString("name1"),
                        rs.getString("name2"),
                        rs.getDate("date1"),
                        rs.getString("name3"),
                        rs.getDate("date2"),
                        rs.getString("idnumber"),
                        rs.getString("number")
                        );
                list.add(data);
            }
            return list;
        }
    }

    public boolean adduser(indexdata data,String type) throws SQLException,ClassNotFoundException{
        String sql="insert into user values(?,?,?)";
        try(Connection conn=getConnection();PreparedStatement ps= conn.prepareStatement(sql)){
            ps.setString(1,data.getId());
            ps.setString(2,data.getPassword());
            ps.setString(3,type);
            return ps.executeUpdate()>0;
        }
    }

}

operator:

<%@ 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: center;
            max-width: 100%;
            margin: 0 auto;
        }
        h2 {
            font-size: 1.5em;
            margin-bottom: 20px;
        }
        a {
            display: inline-block;
            margin: 10px 0;
            color: #007BFF;
            text-decoration: none;
            font-size: 16px;
            padding: 10px 20px;
            background-color: #f1f1f1;
            border-radius: 4px;
            transition: background-color 0.3s ease;
        }
        a:hover {
            background-color: #d1d1d1;
            text-decoration: none;
        }
    </style>
</head>
<body>
<div class="container">
    <h2>操作界面</h2>
<%
    String type = (String) session.getAttribute("type");
    String idnumber=(String) session.getAttribute("id");
    if("管理员".equals(type)){%>
    <a href="adduser.jsp" target="_blank">添加评估员</a>
    <a href="checkplan.jsp?" target="_blank">查看老年人能力评估基本信息表</a>
<%} else if ("评估员".equals(type)) {%>
    <a href="addplan.jsp" target="_blank">填写信息</a>
    <a href="adddaily.jsp" target="_blank">能力评估</a>
    <a href="checkplan.jsp?" target="_blank">查看老年人能力评估基本信息表</a>
<%}%>
    <a href="checkpeople.jsp?idnumber=<%=idnumber%>&type=<%=type%>"  target="_blank" >查看被评估者的基本信息表</a>
    <a href="checkinformat.jsp?idnumber=<%=idnumber%>&type=<%=type%>" target="_blank">查看信息提供者及联系人信息表</a>
    <a href="checksummary.jsp?idnumber=<%=idnumber%>&type=<%=type%>" target="_blank">查看老年人能力评估结果</a>
</div>
</body>
</html>

checksummary:

<%@ 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);
        }
        .scrollable-container {
            max-height: 500px;
            overflow-y: auto;
        }
    </style>
</head>
<body>
<div class="container">
    <h2>查看信息提供者及联系人信息表</h2>
    <form action="checksummary" 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 class="scrollable-container">
        <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>

import data.summarydata;

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;
import java.util.List;
@WebServlet("/checksummary")
public class checksummary extends HttpServlet {
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.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);
    }

}

checkpeople:

import data.peopledata;

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;
import java.util.List;

@WebServlet("/checkpeople")
public class checkpeople extends HttpServlet {
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.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<peopledata> data=dao.checkpeople(type,number);
            request.setAttribute("data", data);
        } catch (SQLException | ClassNotFoundException e) {
            e.printStackTrace();
        }
        request.getRequestDispatcher("checkpeople.jsp").forward(request, response);
    }
}

checkinformat:

import data.informatdata;

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;
import java.util.List;

@WebServlet("/checkinformat")
public class checkinformat 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<informatdata> data=dao.checkinformat(type,number);
            request.setAttribute("data", data);
        } catch (SQLException | ClassNotFoundException e) {
            e.printStackTrace();
        }
        request.getRequestDispatcher("checkinformat.jsp").forward(request,response);
    }
}

posted @ 2025-02-15 21:52  sword_kong  阅读(9)  评论(0)    收藏  举报