下面是第二个功能：老年人能力定期评估
下面是mysql语句：
点击查看代码
create table dailystate(
number varchar(20),
jinshi int,
xizao int,
xiushi int,
chuanyi int,
dabian int,
xiaobian int,
ruce int,
chuangyi int,
zoulu int,
shanglouti int
);
create table mentalstate(
number varchar(20),
renzhi int,
gongji int,
yiyv int
);
create table feelstate(
number varchar(20),
yishi int,
shili int,
tinli int,
goutong int
);
create table publicstate(
number varchar(20),
shenghuo int,
gongzuo int,
shikong int,
renwu int,
shejiao int
);
点击查看代码
package work.pojo;
public class dailystate {
private String number;
private int jinshi;
private int xizao;
private int xiushi;
private int chuanyi;
private int dabian;
private int xiaobian;
private int ruce;
private int chuangyi;
private int zoulu;
private int shanglouti;
@Override
public String toString() {
return "dailystate{" +
"number='" + number + '\'' +
", jinshi=" + jinshi +
", xizao=" + xizao +
", xiushi=" + xiushi +
", chuanyi=" + chuanyi +
", dabian=" + dabian +
", xiaobian=" + xiaobian +
", ruce=" + ruce +
", chuangyi=" + chuangyi +
", zoulu=" + zoulu +
", shanglouti=" + shanglouti +
'}';
}
public String getNumber() {
return number;
}
public void setNumber(String number) {
this.number = number;
}
public int getJinshi() {
return jinshi;
}
public void setJinshi(int jinshi) {
this.jinshi = jinshi;
}
public int getXizao() {
return xizao;
}
public void setXizao(int xizao) {
this.xizao = xizao;
}
public int getXiushi() {
return xiushi;
}
public void setXiushi(int xiushi) {
this.xiushi = xiushi;
}
public int getChuanyi() {
return chuanyi;
}
public void setChuanyi(int chuanyi) {
this.chuanyi = chuanyi;
}
public int getDabian() {
return dabian;
}
public void setDabian(int dabian) {
this.dabian = dabian;
}
public int getXiaobian() {
return xiaobian;
}
public void setXiaobian(int xiaobian) {
this.xiaobian = xiaobian;
}
public int getRuce() {
return ruce;
}
public void setRuce(int ruce) {
this.ruce = ruce;
}
public int getChuangyi() {
return chuangyi;
}
public void setChuangyi(int chuangyi) {
this.chuangyi = chuangyi;
}
public int getZoulu() {
return zoulu;
}
public void setZoulu(int zoulu) {
this.zoulu = zoulu;
}
public int getShanglouti() {
return shanglouti;
}
public void setShanglouti(int shanglouti) {
this.shanglouti = shanglouti;
}
}
点击查看代码
package work.pojo;
public class mentalstate {
private String number;
private int renzhi;
private int gongji;
private int yiyv;
@Override
public String toString() {
return "mentalstate{" +
"number='" + number + '\'' +
", renzhi=" + renzhi +
", gongji=" + gongji +
", yiyv=" + yiyv +
'}';
}
public String getNumber() {
return number;
}
public void setNumber(String number) {
this.number = number;
}
public int getRenzhi() {
return renzhi;
}
public void setRenzhi(int renzhi) {
this.renzhi = renzhi;
}
public int getGongji() {
return gongji;
}
public void setGongji(int gongji) {
this.gongji = gongji;
}
public int getYiyv() {
return yiyv;
}
public void setYiyv(int yiyv) {
this.yiyv = yiyv;
}
}
点击查看代码
package work.pojo;
public class feelstate {
private String number;
private int yishi;
private int shili;
private int tinli;
private int goutong;
@Override
public String toString() {
return "feelstate{" +
"number='" + number + '\'' +
", yishi=" + yishi +
", shili=" + shili +
", tinli=" + tinli +
", goutong=" + goutong +
'}';
}
public String getNumber() {
return number;
}
public void setNumber(String number) {
this.number = number;
}
public int getYishi() {
return yishi;
}
public void setYishi(int yishi) {
this.yishi = yishi;
}
public int getShili() {
return shili;
}
public void setShili(int shili) {
this.shili = shili;
}
public int getTinli() {
return tinli;
}
public void setTinli(int tinli) {
this.tinli = tinli;
}
public int getGoutong() {
return goutong;
}
public void setGoutong(int goutong) {
this.goutong = goutong;
}
}
点击查看代码
package work.pojo;
public class publicstate {
private String number;
private int shenghuo;
private int gongzuo;
private int shikong;
private int renwu;
private int shejiao;
@Override
public String toString() {
return "publicstate{" +
"number='" + number + '\'' +
", shenghuo=" + shenghuo +
", hongzuo=" + gongzuo +
", shikong=" + shikong +
", renwu=" + renwu +
", shejiao=" + shejiao +
'}';
}
public String getNumber() {
return number;
}
public void setNumber(String number) {
this.number = number;
}
public int getShenghuo() {
return shenghuo;
}
public void setShenghuo(int shenghuo) {
this.shenghuo = shenghuo;
}
public int getShikong() {
return shikong;
}
public void setShikong(int shikong) {
this.shikong = shikong;
}
public int getGongzuo() {
return gongzuo;
}
public void setGongzuo(int gongzuo) {
this.gongzuo = gongzuo;
}
public int getRenwu() {
return renwu;
}
public void setRenwu(int renwu) {
this.renwu = renwu;
}
public int getShejiao() {
return shejiao;
}
public void setShejiao(int shejiao) {
this.shejiao = shejiao;
}
}
点击查看代码
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>老年人能力定期评估</title>
<style>
body {
background-color: rgba(220, 220, 220, 0.32);
font-family: Arial, sans-serif;
}
a {
display: inline-block;
width: 330px;
height: 80px;
background-color: dodgerblue;
color: white;
text-decoration: none;
text-align: center;
line-height: 80px;
font-size: 20px;
margin: 5px;
border-radius: 8px;
}
a:hover {
background-color: lightskyblue;
}
.select {
background-color: lightskyblue;
}
.search-container {
position: absolute;
top: 10px;
right: 10px;
}
.search-container input[type="text"] {
padding: 8px;
font-size: 16px;
border: 1px solid #ccc;
border-radius: 4px;
}
.search-container button {
padding: 8px;
font-size: 16px;
background-color: dodgerblue;
color: white;
border: none;
border-radius: 4px;
cursor: pointer;
}
.search-container button:hover {
background-color: lightskyblue;
}
.select {
background-color: lightskyblue;
}
.select1{
background-color: lightskyblue;
}
.div2 {
display: flex;
justify-content: space-around;
align-items: center;
height: 100px;
background-color: #e1e0e0;
padding: 0 20px;
}
.div2 p {
font-size: 18px;
color: #333;
margin: 0;
padding: 10px 20px;
background-color: #f0f0f0;
border-radius: 8px;
box-shadow: 0 2px 4px rgba(0, 0, 0, 0.1);
}
l{
font-size: 18px;
color: #5b5a5a;
margin: 0;
padding: 10px 20px;
background-color: lightskyblue;
border-radius: 8px;
box-shadow: 0 2px 4px rgba(0, 0, 0, 0.1);
}
input[type="submit"] {
padding: 10px 20px;
background-color: dodgerblue;
color: white;
border: none;
border-radius: 4px;
cursor: pointer;
font-size: 16px;
background-position: center bottom;
}
input[type="submit"]:hover {
background-color: lightskyblue;
}
</style>
</head>
<body>
<div class="div1">
<img src="https://www.jkheb2030.org.cn/Content/peixun/img/logo.png" >
</div>
<div class="search-container">
<input type="text" placeholder="搜索..." name="search" id="search">
<button type="submit">搜索</button>
</div>
<a href="informationadd.html">老年人信息导入</a>
<a class="select" >老年人能力定期评估</a>
<a href="select1.html">能力评估数据多条件查询</a>
<a href="ability.html">能力数据统计</a>
<a href="enter.html">能力数据导出</a>
<div class="div2">
<l>日常生活活动评估</l>
<p>精神状态评估</p>
<p>感知觉与沟通评估</p>
<p>社会参与评估</p>
</div>
<form action="/work-demo/assessment1" method="post">
<h1>老年人能力评估表</h1>
<h2>日常生活活动评估</h2>
<hr>
<p>请输入身份证号码:<input type="text" name="number" id="number"></p>
<hr>
<h3>1.进食(指用餐具将食物由容器送到口中、咀嚼、吞咽等过程)</h3>
<p>10 分，可独立进食（在合理的时间内独立进食准备好的食物）</p>
<p>5 分， 需部分帮助（进食过程中需要一定帮助，如协助把持餐具）</p>
<p>0 分， 需极大帮助或完全依赖他人，或有留置营养管</p>
打分:
<label><input type="radio" name="jinshi" value="10">10分</label>
<label><input type="radio" name="jinshi" value="5">5分</label>
<label><input type="radio" name="jinshi" value="0">0分</label>
<hr>
<h3>2.洗澡</h3>
<p>5 分， 准备好洗澡水后，可自己独立完成洗澡过程</p>
<p>0 分， 需他人帮助 </p>
打分:
<label><input type="radio" name="xizao" value="5">5分</label>
<label><input type="radio" name="xizao" value="0">0分</label>
<hr>
<h3>3.修饰(指洗脸、刷牙、梳头、刮脸等)</h3>
<p>5 分， 可自己独立完成</p>
<p>0 分， 需他人帮助</p>
打分:
<label><input type="radio" name="xiushi" value="5">5分</label>
<label><input type="radio" name="xiushi" value="0">0分</label>
<hr>
<h3>4.穿衣(指穿脱衣服、系扣、拉拉链、穿脱鞋袜、系鞋带)</h3>
<p>10 分，可独立完成</p>
<p>5 分， 需部分帮助（能自己穿脱，但需他人帮助整理衣物、系扣/鞋带、拉拉链） </p>
<p>0 分， 需极大帮助或完全依赖他人</p>
打分:
<label><input type="radio" name="chuanyi" value="10">10分</label>
<label><input type="radio" name="chuanyi" value="5">5分</label>
<label><input type="radio" name="chuanyi" value="0">0分</label>
<hr>
<h3>5.大便控制</h3>
<p>10 分，可控制大便</p>
<p>5 分， 偶尔失控（每周<1 次），或需要他人提示</p>
<p>0 分， 完全失控</p>
打分:
<label><input type="radio" name="dabian" value="10">10分</label>
<label><input type="radio" name="dabian" value="5">5分</label>
<label><input type="radio" name="dabian" value="0">0分</label>
<hr>
<h3>6.小便控制</h3>
<p>10 分，可控制小便</p>
<p>5 分， 偶尔失控（每天<1 次，但每周>1 次），或需要他人提示</p>
<p>0 分， 完全失控，或留置导尿管</p>
打分:
<label><input type="radio" name="xiaobian" value="10">10分</label>
<label><input type="radio" name="xiaobian" value="5">5分</label>
<label><input type="radio" name="xiaobian" value="0">0分</label>
<hr>
<h3>7.如厕（包括去厕所、解开衣裤、擦净、整理衣裤、冲水）</h3>
<p>10 分，可独立完成</p>
<p>5 分， 需部分帮助（需他人搀扶去厕所、需他人帮忙冲水或整理衣裤等）</p>
<p>0 分， 需极大帮助或完全依赖他人</p>
打分:
<label><input type="radio" name="ruce" value="10">10分</label>
<label><input type="radio" name="ruce" value="5">5分</label>
<label><input type="radio" name="ruce" value="0">0分</label>
<hr>
<h3>8.床椅转移</h3>
<p>15 分，可独立完成</p>
<p>10 分，需部分帮助（需他人搀扶或使用拐杖） </p>
<p>5 分， 需极大帮助（较大程度上依赖他人搀扶和帮助） </p>
<p>0 分， 完全依赖他人</p>
打分:
<label><input type="radio" name="chuangyi" value="15">15分</label>
<label><input type="radio" name="chuangyi" value="10">10分</label>
<label><input type="radio" name="chuangyi" value="5">5分</label>
<label><input type="radio" name="chuangyi" value="0">0分</label>
<hr>
<h3>9.平地走路</h3>
<p>15 分，可独立在平地上行走 45m</p>
<p>10 分，需部分帮助（因肢体残疾、平衡能力差、过度衰弱、视力等问题，在一定程度上需他人地搀扶或使用拐杖、助行器等辅助用具）</p>
<p>5 分， 需极大帮助（因肢体残疾、平衡能力差、过度衰弱、视力等问题，在较大程度上依赖他人搀扶，或坐在轮椅上自行移动） </p>
<p>0 分， 完全依赖他人</p>
打分:
<label><input type="radio" name="zoulu" value="15">15分</label>
<label><input type="radio" name="zoulu" value="10">10分</label>
<label><input type="radio" name="zoulu" value="5">5分</label>
<label><input type="radio" name="zoulu" value="0">0分</label>
<hr>
<h3>10.上下楼梯</h3>
<p>10 分，可独立上下楼梯（连续上下 10-15 个台阶）</p>
<p>5 分， 需部分帮助（需他人搀扶，或扶着楼梯、使用拐杖等）</p>
<p>0 分， 需极大帮助或完全依赖他人</p>
打分:
<label><input type="radio" name="shanglouti" value="10">10分</label>
<label><input type="radio" name="shanglouti" value="5">5分</label>
<label><input type="radio" name="shanglouti" value="0">0分</label><br>
<br><input type="submit" value="下一项" class="submit">
</form>
</body>
</html>
点击查看代码
package work.web;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import work.mapper.UserMapper;
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.io.InputStream;
import java.io.Writer;
@WebServlet("/assessment1")
public class assessment1 extends HttpServlet {
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
this.doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding("UTF-8"); // 解决乱码问题
resp.setContentType("text/html;charset=utf-8");
String number = req.getParameter("number");
int jinshi=Integer.parseInt(req.getParameter("jinshi"));
int xizao=Integer.parseInt(req.getParameter("xizao"));
int xiushi=Integer.parseInt(req.getParameter("xiushi"));
int chuanyi=Integer.parseInt(req.getParameter("chuanyi"));
int dabian=Integer.parseInt(req.getParameter("dabian"));
int xiaobian=Integer.parseInt(req.getParameter("xiaobian"));
int ruce=Integer.parseInt(req.getParameter("ruce"));
int chuangyi=Integer.parseInt(req.getParameter("chuangyi"));
int zoulu=Integer.parseInt(req.getParameter("zoulu"));
int shanglouti=Integer.parseInt(req.getParameter("shanglouti"));
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
SqlSession sqlSession = sqlSessionFactory.openSession();
UserMapper usermapper = sqlSession.getMapper(UserMapper.class);
int a=usermapper.assessment1add(number,jinshi,xizao,xiushi,chuanyi,dabian,xiaobian,ruce,chuangyi,zoulu,shanglouti);
Writer writer=resp.getWriter();
sqlSession.commit();
sqlSession.close();
if(a>0){
writer.write("<html><body>");
writer.write("<p>1秒后将跳转到精神状态评估表...</p>");
writer.write("<script type='text/javascript'>");
writer.write("setTimeout(function() { window.location.href = './assessment2.html'; }, 1000);");
writer.write("</script>");
writer.write("</body></html>");
}else
{
writer.write("<html><body>");
writer.write("<h2>添加失败，请重新输入</h2>");
writer.write("<p>3秒后将跳转到主界面...</p>");
writer.write("<script type='text/javascript'>");
writer.write("setTimeout(function() { window.location.href = './screen.html'; }, 3000);");
writer.write("</script>");
writer.write("</body></html>");
}
}
}
点击查看代码
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>精神状态评估</title>
<style>
body {
background-color: rgba(220, 220, 220, 0.32);
font-family: Arial, sans-serif;
}
a {
display: inline-block;
width: 330px;
height: 80px;
background-color: dodgerblue;
color: white;
text-decoration: none;
text-align: center;
line-height: 80px;
font-size: 20px;
margin: 5px;
border-radius: 8px;
}
a:hover {
background-color: lightskyblue;
}
.select {
background-color: lightskyblue;
}
.search-container {
position: absolute;
top: 10px;
right: 10px;
}
.search-container input[type="text"] {
padding: 8px;
font-size: 16px;
border: 1px solid #ccc;
border-radius: 4px;
}
.search-container button {
padding: 8px;
font-size: 16px;
background-color: dodgerblue;
color: white;
border: none;
border-radius: 4px;
cursor: pointer;
}
.search-container button:hover {
background-color: lightskyblue;
}
.select {
background-color: lightskyblue;
}
.select1{
background-color: lightskyblue;
}
.div2 {
display: flex;
justify-content: space-around;
align-items: center;
height: 100px;
background-color: #e1e0e0;
padding: 0 20px;
}
.div2 p {
font-size: 18px;
color: #333;
margin: 0;
padding: 10px 20px;
background-color: #f0f0f0;
border-radius: 8px;
box-shadow: 0 2px 4px rgba(0, 0, 0, 0.1);
}
l{
font-size: 18px;
color: #5b5a5a;
margin: 0;
padding: 10px 20px;
background-color: lightskyblue;
border-radius: 8px;
box-shadow: 0 2px 4px rgba(0, 0, 0, 0.1);
}
input[type="submit"] {
padding: 10px 20px;
background-color: dodgerblue;
color: white;
border: none;
border-radius: 4px;
cursor: pointer;
font-size: 16px;
background-position: center bottom;
}
input[type="submit"]:hover {
background-color: lightskyblue;
}
</style>
</head>
<body>
<div class="div1">
<img src="https://www.jkheb2030.org.cn/Content/peixun/img/logo.png" >
</div>
<div class="search-container">
<input type="text" placeholder="搜索..." name="search" id="search">
<button type="submit">搜索</button>
</div>
<a href="informationadd.html">老年人信息导入</a>
<a class="select1" >老年人能力定期评估</a>
<a href="select1.html">能力评估数据多条件查询</a>
<a href="ability.html">能力数据统计</a>
<a href="enter.html">能力数据导出</a>
<div class="div2">
<p>日常生活活动评估</p>
<l>精神状态评估</l>
<p>感知觉与沟通评估</p>
<p>社会参与评估</p>
</div>
<form action="/work-demo/assessment2" method="post">
<h1>老年人能力评估表</h1>
<h2>精神状态评估</h2>
<hr>
<p>请输入身份证号码:<input type="text" name="number" id="number"></p>
<hr>
<h3>1.认知功能</h3>
<h3>测验:</h3>
<h3>“我说三样东西，请重复一遍，并记住，一会儿会问您”：苹果、手表、国旗</h3>
<h3>(1)画钟测验：“请您在这儿画一个圆形的时钟，在时钟上标出 10 点 45 分” </h3>
<h3>(2)回忆词语：“现在请您告诉我，刚才我要您记住的三样东西是什么？”
答：_______、________、________（不必按顺序）</h3>
<p>0 分，画钟正确（画出一个闭锁圆，指针位置准确），且能回忆出 2-3 个词 </p>
<p>1 分，画钟错误（画的圆不闭锁，或指针位置不准确），或只回忆出 0-1 个词</p>
<p>2 分，已确诊为认知障碍，如老年痴呆</p>
打分:
<label><input type="radio" name="renzhi" value="0">0分</label>
<label><input type="radio" name="renzhi" value="1">1分</label>
<label><input type="radio" name="renzhi" value="2">2分</label>
<hr>
<h3>2.攻击行为</h3>
<p>0 分，无身体攻击行为（如打/踢/推/咬/抓/摔东西）和语言攻击行为（如骂人、语言威胁、尖叫） </p>
<p>1 分，每月有几次身体攻击行为，或每周有几次语言攻击行为</p>
<p>2 分，每周有几次身体攻击行为，或每日有语言攻击行为</p>
打分:
<label><input type="radio" name="gongji" value="0">0分</label>
<label><input type="radio" name="gongji" value="1">1分</label>
<label><input type="radio" name="gongji" value="2">2分</label>
<hr>
<h3>3.抑郁症状</h3>
<p>0 分，无</p>
<p>1 分，情绪低落、不爱说话、不爱梳洗、不爱活动</p>
<p>2 分，有自杀念头或自杀行为</p>
打分:
<label><input type="radio" name="yiyv" value="0">0分</label>
<label><input type="radio" name="yiyv" value="1">1分</label>
<label><input type="radio" name="yiyv" value="2">2分</label>
<br><br><input type="submit" value="下一项" class="submit">
</form>
</body>
</html>
点击查看代码
package work.web;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import work.mapper.UserMapper;
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.io.InputStream;
import java.io.Writer;
@WebServlet("/assessment2")
public class assessment2 extends HttpServlet {
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
this.doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding("UTF-8"); // 解决乱码问题
resp.setContentType("text/html;charset=utf-8");
String number = req.getParameter("number");
int renzhi=Integer.parseInt(req.getParameter("renzhi"));
int gongji=Integer.parseInt(req.getParameter("gongji"));
int yiyv=Integer.parseInt(req.getParameter("yiyv"));
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
SqlSession sqlSession = sqlSessionFactory.openSession();
UserMapper usermapper = sqlSession.getMapper(UserMapper.class);
int a=usermapper.assessment2add(number,renzhi,gongji,yiyv);
Writer writer = resp.getWriter();
sqlSession.commit();
sqlSession.close();
if(a>0){
writer.write("<html><body>");
writer.write("<p>1秒后将跳转到感知觉与沟通评估表...</p>");
writer.write("<script type='text/javascript'>");
writer.write("setTimeout(function() { window.location.href = './assessment3.html'; }, 1000);");
writer.write("</script>");
writer.write("</body></html>");
}else
{
writer.write("<html><body>");
writer.write("<h2>添加失败，请重新输入</h2>");
writer.write("<p>3秒后将跳转到主界面...</p>");
writer.write("<script type='text/javascript'>");
writer.write("setTimeout(function() { window.location.href = './screen.html'; }, 3000);");
writer.write("</script>");
writer.write("</body></html>");
}
}
}
点击查看代码
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>感知觉与沟通评估</title>
<style>
body {
background-color: rgba(220, 220, 220, 0.32);
font-family: Arial, sans-serif;
}
a {
display: inline-block;
width: 330px;
height: 80px;
background-color: dodgerblue;
color: white;
text-decoration: none;
text-align: center;
line-height: 80px;
font-size: 20px;
margin: 5px;
border-radius: 8px;
}
a:hover {
background-color: lightskyblue;
}
.select {
background-color: lightskyblue;
}
.search-container {
position: absolute;
top: 10px;
right: 10px;
}
.search-container input[type="text"] {
padding: 8px;
font-size: 16px;
border: 1px solid #ccc;
border-radius: 4px;
}
.search-container button {
padding: 8px;
font-size: 16px;
background-color: dodgerblue;
color: white;
border: none;
border-radius: 4px;
cursor: pointer;
}
.search-container button:hover {
background-color: lightskyblue;
}
.select {
background-color: lightskyblue;
}
.select1{
background-color: lightskyblue;
}
.div2 {
display: flex;
justify-content: space-around;
align-items: center;
height: 100px;
background-color: #e1e0e0;
padding: 0 20px;
}
.div2 p {
font-size: 18px;
color: #333;
margin: 0;
padding: 10px 20px;
background-color: #f0f0f0;
border-radius: 8px;
box-shadow: 0 2px 4px rgba(0, 0, 0, 0.1);
}
l{
font-size: 18px;
color: #5b5a5a;
margin: 0;
padding: 10px 20px;
background-color: lightskyblue;
border-radius: 8px;
box-shadow: 0 2px 4px rgba(0, 0, 0, 0.1);
}
input[type="submit"] {
padding: 10px 20px;
background-color: dodgerblue;
color: white;
border: none;
border-radius: 4px;
cursor: pointer;
font-size: 16px;
background-position: center bottom;
}
input[type="submit"]:hover {
background-color: lightskyblue;
}
</style>
</head>
<body>
<div class="div1">
<img src="https://www.jkheb2030.org.cn/Content/peixun/img/logo.png" >
</div>
<div class="search-container">
<input type="text" placeholder="搜索..." name="search" id="search">
<button type="submit">搜索</button>
</div>
<a href="informationadd.html">老年人信息导入</a>
<a class="select" >老年人能力定期评估</a>
<a href="select1.html">能力评估数据多条件查询</a>
<a href="ability.html">能力数据统计</a>
<a href="enter.html">能力数据导出</a>
<div class="div2">
<p>日常生活活动评估</p>
<p>精神状态评估</p>
<l>感知觉与沟通评估</l>
<p>社会参与评估</p>
</div>
<form action="/work-demo/assessment3" method="post">
<h1>老年人能力评估表</h1>
<h2>精神状态评估</h2>
<hr>
<p>请输入身份证号码:<input type="text" name="number" id="number"></p>
<hr>
<h3>1.意识水平</h3>
<p>0 分，神志清醒，对周围环境警觉</p>
<p>1 分，嗜睡，表现为睡眠状态过度延长。当呼唤或推动其肢体时可唤醒，并能进行正确的交谈或执行指令，停止刺激后又继续入睡</p>
<p>2 分，昏睡，一般的外界刺激不能使其觉醒，给予较强烈的刺激时可有短时的意识清醒，醒后可简短回答提问，当刺激减弱后又很快进入睡眠状态</p>
<p>3 分，昏迷，处于浅昏迷时对疼痛刺激有回避和痛苦表情；处于深昏迷时对刺激无反应（若评定为昏迷，直接评定为重度失能，可不进行以下项目的评估）</p>
打分:
<label><input type="radio" name="yishi" value="0">0分</label>
<label><input type="radio" name="yishi" value="1">1分</label>
<label><input type="radio" name="yishi" value="2">2分</label>
<label><input type="radio" name="yishi" value="3">3分</label>
<hr>
<h3>2.视力（若平日带老花镜或近视镜，应在佩戴眼镜的情况下评估）</h3>
<p>0 分，能看清书报上的标准字体</p>
<p>1 分，能看清楚大字体，但看不清书报上的标准字体</p>
<p>2 分，视力有限，看不清报纸大标题，但能辨认物体</p>
<p>3 分，辨认物体有困难，但眼睛能跟随物体移动，只能看到光、颜色和形状 </p>
<p>4 分，没有视力，眼睛不能跟随物体移动 </p>
打分:
<label><input type="radio" name="shili" value="0">0分</label>
<label><input type="radio" name="shili" value="1">1分</label>
<label><input type="radio" name="shili" value="2">2分</label>
<label><input type="radio" name="shili" value="3">3分</label>
<label><input type="radio" name="shili" value="4">4分</label>
<hr>
<h3>3.听力（若平时佩戴助听器，应在佩戴助听器的情况下评估 ）</h3>
<p>0 分，可正常交谈，能听到电视、电话、门铃的声音</p>
<p>1 分，在轻声说话或说话距离超过 2 米时听不清</p>
<p>2 分，正常交流有些困难，需在安静的环静或大声说话才能听到</p>
<p>3 分，讲话者大声说话或说话很慢，才能部分听见</p>
<p>4 分，完全听不见</p>
打分:
<label><input type="radio" name="tinli" value="0">0分</label>
<label><input type="radio" name="tinli" value="1">1分</label>
<label><input type="radio" name="tinli" value="2">2分</label>
<label><input type="radio" name="tinli" value="3">3分</label>
<label><input type="radio" name="tinli" value="4">4分</label>
<hr>
<h3>4.沟通交流（包括非语言沟通）</h3>
<p>0 分，无困难，能与他人正常沟通和交流</p>
<p>1 分，能够表达自己的需要及理解别人的话，但需要增加时间或给予帮助</p>
<p>2 分，表达需要或理解有困难，需频繁重复或简化口头表达</p>
<p>3 分，不能表达需要或理解他人的话</p>
打分:
<label><input type="radio" name="goutong" value="0">0分</label>
<label><input type="radio" name="goutong" value="1">1分</label>
<label><input type="radio" name="goutong" value="2">2分</label>
<label><input type="radio" name="goutong" value="3">3分</label>
<br><br><input type="submit" value="下一项" class="submit">
</form>
</body>
</html>
点击查看代码
package work.web;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import work.mapper.UserMapper;
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.io.InputStream;
import java.io.Writer;
@WebServlet("/assessment3")
public class assessment3 extends HttpServlet {
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
this.doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding("UTF-8"); // 解决乱码问题
resp.setContentType("text/html;charset=utf-8");
String number = req.getParameter("number");
int yishi = Integer.parseInt(req.getParameter("yishi"));
int shili = Integer.parseInt(req.getParameter("shili"));
int tinli = Integer.parseInt(req.getParameter("tinli"));
int goutong = Integer.parseInt(req.getParameter("goutong"));
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
SqlSession sqlSession = sqlSessionFactory.openSession();
UserMapper usermapper = sqlSession.getMapper(UserMapper.class);
int a=usermapper.assessment3add(number,yishi,shili,tinli,goutong);
Writer writer=resp.getWriter();
sqlSession.commit();
sqlSession.close();
if(a>0){
writer.write("<html><body>");
writer.write("<p>1秒后将跳转到社会参与评估表...</p>");
writer.write("<script type='text/javascript'>");
writer.write("setTimeout(function() { window.location.href = './assessment4.html'; }, 1000);");
writer.write("</script>");
writer.write("</body></html>");
}else
{
writer.write("<html><body>");
writer.write("<h2>添加失败，请重新输入</h2>");
writer.write("<p>3秒后将跳转到主界面...</p>");
writer.write("<script type='text/javascript'>");
writer.write("setTimeout(function() { window.location.href = './screen.html'; }, 3000);");
writer.write("</script>");
writer.write("</body></html>");
}
}
}
点击查看代码
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>社会参与评估</title>
<style>
body {
background-color: rgba(220, 220, 220, 0.32);
font-family: Arial, sans-serif;
}
a {
display: inline-block;
width: 330px;
height: 80px;
background-color: dodgerblue;
color: white;
text-decoration: none;
text-align: center;
line-height: 80px;
font-size: 20px;
margin: 5px;
border-radius: 8px;
}
a:hover {
background-color: lightskyblue;
}
.select {
background-color: lightskyblue;
}
.search-container {
position: absolute;
top: 10px;
right: 10px;
}
.search-container input[type="text"] {
padding: 8px;
font-size: 16px;
border: 1px solid #ccc;
border-radius: 4px;
}
.search-container button {
padding: 8px;
font-size: 16px;
background-color: dodgerblue;
color: white;
border: none;
border-radius: 4px;
cursor: pointer;
}
.search-container button:hover {
background-color: lightskyblue;
}
.select {
background-color: lightskyblue;
}
.select1{
background-color: lightskyblue;
}
.div2 {
display: flex;
justify-content: space-around;
align-items: center;
height: 100px;
background-color: #e1e0e0;
padding: 0 20px;
}
.div2 p {
font-size: 18px;
color: #333;
margin: 0;
padding: 10px 20px;
background-color: #f0f0f0;
border-radius: 8px;
box-shadow: 0 2px 4px rgba(0, 0, 0, 0.1);
}
l{
font-size: 18px;
color: #5b5a5a;
margin: 0;
padding: 10px 20px;
background-color: lightskyblue;
border-radius: 8px;
box-shadow: 0 2px 4px rgba(0, 0, 0, 0.1);
}
input[type="submit"] {
padding: 10px 20px;
background-color: dodgerblue;
color: white;
border: none;
border-radius: 4px;
cursor: pointer;
font-size: 16px;
background-position: center bottom;
}
input[type="submit"]:hover {
background-color: lightskyblue;
}
</style>
</head>
<body>
<div class="div1">
<img src="https://www.jkheb2030.org.cn/Content/peixun/img/logo.png" >
</div>
<div class="search-container">
<input type="text" placeholder="搜索..." name="search" id="search">
<button type="submit">搜索</button>
</div>
<a href="informationadd.html">老年人信息导入</a>
<a class="select" >老年人能力定期评估</a>
<a href="select1.html">能力评估数据多条件查询</a>
<a href="ability.html">能力数据统计</a>
<a href="enter.html">能力数据导出</a>
<div class="div2">
<p>日常生活活动评估</p>
<p>精神状态评估</p>
<p>感知觉与沟通评估</p>
<l>社会参与评估</l>
</div>
<form action="/work-demo/assessment4" method="post">
<h1>老年人能力评估表</h1>
<h2>精神状态评估</h2>
<hr>
<p>请输入身份证号码:<input type="text" name="number" id="number"></p>
<hr>
<h3>1.生活能力</h3>
<p>0 分，除个人生活自理外（如饮食、洗漱、穿戴、二便），能料理家务（如做饭、洗衣）或当家管理事务</p>
<p>1 分，除个人生活自理外，能做家务，但欠好，家庭事务安排欠条理</p>
<p>2 分，个人生活能自理；只有在他人帮助下才能做些家务，但质量不好 </p>
<p>3 分，个人基本生活事务能自理（如饮食、二便），在督促下可洗漱</p>
<p>4 分，个人基本生活事务（如饮食、二便）需要部分帮助或完全依赖他人帮助</p>
打分:
<label><input type="radio" name="shenghuo" value="0">0分</label>
<label><input type="radio" name="shenghuo" value="1">1分</label>
<label><input type="radio" name="shenghuo" value="2">2分</label>
<label><input type="radio" name="shenghuo" value="3">3分</label>
<label><input type="radio" name="shenghuo" value="4">4分</label>
<hr>
<h3>2.工作能力</h3>
<p>0 分，原来熟练的脑力工作或体力技巧性工作可照常进行</p>
<p>1 分，原来熟练的脑力工作或体力技巧性工作能力有所下降</p>
<p>2 分，原来熟练的脑力工作或体力技巧性工作明显不如以往，部分遗忘 </p>
<p>3 分，对熟练工作只有一些片段保留，技能全部遗忘</p>
<p>4 分，对以往的知识或技能全部磨灭</p>
打分:
<label><input type="radio" name="gongzuo" value="0">0分</label>
<label><input type="radio" name="gongzuo" value="1">1分</label>
<label><input type="radio" name="gongzuo" value="2">2分</label>
<label><input type="radio" name="gongzuo" value="3">3分</label>
<label><input type="radio" name="gongzuo" value="4">4分</label>
<hr>
<h3>3.时间/空间定向</h3>
<p>0 分，时间观念（年、月、日、时）清楚；可单独出远门，能很快掌握新环境的方位</p>
<p>1 分，时间观念有些下降，年、月、日清楚，但有时相差几天；可单独来往于近街，知道现住地的名称和方位，但不知回家路线</p>
<p>2 分，时间观念较差，年、月、日不清楚，可知上半年或下半年；只能单独在家附近行动，对现住地只知名称，不知道方位 </p>
<p>3 分，时间观念很差，年、月、日不清楚，可知上午或下午；只能在左邻右舍间串门，对现住地不知名称和方位</p>
<p>4 分，无时间观念；不能单独外出</p>
打分:
<label><input type="radio" name="shikong" value="0">0分</label>
<label><input type="radio" name="shikong" value="1">1分</label>
<label><input type="radio" name="shikong" value="2">2分</label>
<label><input type="radio" name="shikong" value="3">3分</label>
<label><input type="radio" name="shikong" value="4">4分</label>
<hr>
<h3>4.人物定向</h3>
<p>0 分，知道周围人们的关系，知道祖孙、叔伯、姑姨、侄子侄女等称谓的意义；可分辨陌生人的大致年龄和身份，可用适当称呼</p>
<p>1 分，只知家中亲密近亲的关系，不会分辨陌生人的大致年龄，不能称呼陌生人</p>
<p>2 分，只能称呼家中人，或只能照样称呼，不知其关系，不辨辈分</p>
<p>3 分，只认识常同住的亲人，可称呼子女或孙子女，可辨熟人和生人</p>
<p>4 分，只认识保护人，不辨熟人和生人</p>
打分:
<label><input type="radio" name="renwu" value="0">0分</label>
<label><input type="radio" name="renwu" value="1">1分</label>
<label><input type="radio" name="renwu" value="2">2分</label>
<label><input type="radio" name="renwu" value="3">3分</label>
<label><input type="radio" name="renwu" value="4">4分</label>
<hr>
<h3>5.社会交往能力</h3>
<p>0 分，参与社会，在社会环境有一定的适应能力，待人接物恰当 </p>
<p>1 分，能适应单纯环境，主动接触人，初见面时难让人发现智力问题，不能理解隐喻语</p>
<p>2 分，脱离社会，可被动接触，不会主动待人，谈话中很多不适词句，容易上当受骗</p>
<p>3 分，勉强可与人交往，谈吐内容不清楚，表情不恰当 </p>
<p>4 分，难以与人接触</p>
打分:
<label><input type="radio" name="shejiao" value="0">0分</label>
<label><input type="radio" name="shejiao" value="1">1分</label>
<label><input type="radio" name="shejiao" value="2">2分</label>
<label><input type="radio" name="shejiao" value="3">3分</label>
<label><input type="radio" name="shejiao" value="4">4分</label>
<br><br><input type="submit" value="提交" class="submit">
</form>
</body>
</html>
点击查看代码
package work.web;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import work.mapper.UserMapper;
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.io.InputStream;
import java.io.Writer;
@WebServlet("/assessment4")
public class assessment4 extends HttpServlet {
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
this.doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding("UTF-8"); // 解决乱码问题
resp.setContentType("text/html;charset=utf-8");
String number = req.getParameter("number");
int shenghuo = Integer.parseInt(req.getParameter("shenghuo"));
int gongzuo = Integer.parseInt(req.getParameter("gongzuo"));
int shikong = Integer.parseInt(req.getParameter("shikong"));
int renwu = Integer.parseInt(req.getParameter("renwu"));
int shejiao = Integer.parseInt(req.getParameter("shejiao"));
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
SqlSession sqlSession = sqlSessionFactory.openSession();
UserMapper usermapper = sqlSession.getMapper(UserMapper.class);
int a = usermapper.assessment4add(number, shenghuo, gongzuo, shikong, renwu, shejiao);
Writer writer = resp.getWriter();
sqlSession.commit();
sqlSession.close();
if (a > 0) {
// 创建一个表单并自动提交以跳转到answer Servlet
writer.write("<html><body>");
writer.write("<form id='redirectForm' action='/work-demo/answer' method='post'>");
writer.write("<input type='hidden' name='number' value='" + number + "' />");
writer.write("</form>");
writer.write("<script type='text/javascript'>");
writer.write("document.getElementById('redirectForm').submit();");
writer.write("</script>");
writer.write("</body></html>");
} else {
writer.write("<html><body>");
writer.write("<h2>添加失败，请重新输入</h2>");
writer.write("<p>3秒后将跳转到主界面...</p>");
writer.write("<script type='text/javascript'>");
writer.write("setTimeout(function() { window.location.href = './screen.html'; }, 3000);");
writer.write("</script>");
writer.write("</body></html>");
}
}
}
点击查看代码
package work.web;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import work.mapper.UserMapper;
import work.pojo.dailystate;
import work.pojo.feelstate;
import work.pojo.mentalstate;
import work.pojo.publicstate;
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.io.InputStream;
import java.io.PrintWriter;
import java.util.List;
@WebServlet("/answer")
public class answer extends HttpServlet {
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
this.doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding("UTF-8"); // 解决乱码问题
resp.setContentType("text/html;charset=utf-8");
String number = req.getParameter("number");
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
SqlSession sqlSession = sqlSessionFactory.openSession();
UserMapper usermapper = sqlSession.getMapper(UserMapper.class);
List<dailystate> d = usermapper.selectdailystate(number);
List<mentalstate> m = usermapper.selectmentalstate(number);
List<feelstate> f = usermapper.selectfeelstate(number);
List<publicstate> p = usermapper.selectpublicstate(number);
dailystate dd=d.get(0);
mentalstate mm=m.get(0);
feelstate ff=f.get(0);
publicstate pp=p.get(0);
int yishi=ff.getYishi();
int shili=ff.getShili();
int tinli=ff.getTinli();
int goutong=ff.getGoutong();
int d1 = dd.getJinshi() + dd.getXizao() + dd.getXiushi() + dd.getChuanyi() + dd.getDabian() + dd.getXiaobian() + dd.getRuce() + dd.getChuangyi() + dd.getZoulu() + dd.getShanglouti();
int m1 = mm.getRenzhi() + mm.getGongji() + mm.getYiyv();
int f1 = ff.getYishi() + ff.getShili() + ff.getTinli() + ff.getGoutong();
int p1 = pp.getShenghuo() + pp.getGongzuo() + pp.getShikong() + pp.getRenwu() + pp.getShejiao();
int d2=0,m2=0,f2=0,p2=0;
String d3="能力完好",m3="能力完好",f3="能力完好",p3="能力完好";
if(d1==100)
{
d2=0;
d3="能力完好";
}
if(d1>=65&&d1<=95)
{
d2=1;
d3="轻度受损";
}
if(d1>=45&&d1<=60)
{
d2=2;
d3="中度受损";
}
if(d1>=0&&d1<=40)
{
d2=3;
d3="重度受损";
}
if(m1==0)
{
m2=0;
m3="能力完好";
}
if(m1==1)
{
m2=1;
m3="轻度受损";
}
if(m1>=2&&m1<=3)
{
m2=2;
m3="中度受损";
}
if(m1>=4&&m1<=6)
{
m2=3;
m3="重度受损";
}
if(yishi==0&&(shili==0||shili==1)&&(tinli==0||tinli==1)&&goutong==0)
{
f2=0;
f3="能力完好";
}
if((yishi==0&&(shili==2||tinli==2))||goutong==1)
{
f2=1;
f3="轻度受损";
}
if(((yishi==0&&(shili==3||tinli==3))||goutong==2)||(yishi==1&&(shili>=3||tinli>=3)&&goutong>=2))
{
f2=2;
f3="中度受损 ";
}
if((((yishi==0||yishi==1)&&(shili==4||tinli==4))||goutong==3)||yishi==2||yishi==3)
{
f2=3;
f3="重度受损";
}
if(p1>=0&&p1<=2)
{
p2=0;
p3="能力完好";
}
if(p1>=3&&p1<=7)
{
p2=1;
p3="轻度受损";
}
if(p1>=8&&p1<=13)
{
p2=2;
p3="中度受损";
}
if(p1>=14&&p1<=20)
{
p2=3;
p3="重度受损";
}
PrintWriter writer = resp.getWriter();
writer.println("<!DOCTYPE html>");
writer.println("<html lang='en'>");
writer.println("<head>");
writer.println(" <meta charset='UTF-8'>");
writer.println(" <title>社会参与评估结果</title>");
writer.println("<style>");
writer.println(" table {");
writer.println(" width: 100%;");
writer.println(" border-collapse: collapse;");
writer.println(" margin: 20px 0;");
writer.println(" }");
writer.println(" th, td {");
writer.println(" padding: 12px;");
writer.println(" text-align: center;");
writer.println(" border: 1px solid #ddd;");
writer.println(" }");
writer.println(" th {");
writer.println(" background-color: dodgerblue;");
writer.println(" color: white;");
writer.println(" }");
writer.println(" tr:nth-child(even) {");
writer.println(" background-color: #f2f2f2;");
writer.println(" }");
writer.println(" tr:hover {");
writer.println(" background-color: #ddd;");
writer.println(" }");
writer.println(" h2 {");
writer.println(" color: #333;");
writer.println(" margin-top: 20px;");
writer.println(" }"+
" body {\n" +
" background-color: rgba(220, 220, 220, 0.32);\n" +
" font-family: Arial, sans-serif;\n" +
" }\n" +
" a {\n" +
" display: inline-block;\n" +
" width: 330px;\n" +
" height: 80px;\n" +
" background-color: dodgerblue;\n" +
" color: white;\n" +
" text-decoration: none;\n" +
" text-align: center;\n" +
" line-height: 80px;\n" +
" font-size: 20px;\n" +
" margin: 5px;\n" +
" border-radius: 8px;\n" +
" }\n" +
" a:hover {\n" +
" background-color: lightskyblue;\n" +
" }\n" +
" .select {\n" +
" background-color: lightskyblue;\n" +
" }\n" +
" .search-container {\n" +
" position: absolute;\n" +
" top: 10px;\n" +
" right: 10px;\n" +
" }\n" +
" .search-container input[type=\"text\"] {\n" +
" padding: 8px;\n" +
" font-size: 16px;\n" +
" border: 1px solid #ccc;\n" +
" border-radius: 4px;\n" +
" }\n" +
" .search-container button {\n" +
" padding: 8px;\n" +
" font-size: 16px;\n" +
" background-color: dodgerblue;\n" +
" color: white;\n" +
" border: none;\n" +
" border-radius: 4px;\n" +
" cursor: pointer;\n" +
" }\n" +
" .search-container button:hover {\n" +
" background-color: lightskyblue;\n" +
" }\n" +
" .select {\n" +
" background-color: lightskyblue;\n" +
" }\n" +
" .select1{\n" +
" background-color: lightskyblue;\n" +
" }\n" +
" .div2 {\n" +
" display: flex;\n" +
" justify-content: space-around;\n" +
" align-items: center;\n" +
" height: 100px;\n" +
" background-color: #e1e0e0;\n" +
" padding: 0 20px;\n" +
" }\n" +
" .div2 p {\n" +
" font-size: 18px;\n" +
" color: #333;\n" +
" margin: 0;\n" +
" padding: 10px 20px;\n" +
" background-color: #f0f0f0;\n" +
" border-radius: 8px;\n" +
" box-shadow: 0 2px 4px rgba(0, 0, 0, 0.1);\n" +
" }\n" +
" l{\n" +
" font-size: 18px;\n" +
" color: #5b5a5a;\n" +
" margin: 0;\n" +
" padding: 10px 20px;\n" +
" background-color: lightskyblue;\n" +
" border-radius: 8px;\n" +
" box-shadow: 0 2px 4px rgba(0, 0, 0, 0.1);\n" +
" }\n" +
" input[type=\"submit\"] {\n" +
" padding: 10px 20px;\n" +
" background-color: dodgerblue;\n" +
" color: white;\n" +
" border: none;\n" +
" border-radius: 4px;\n" +
" cursor: pointer;\n" +
" font-size: 16px;\n" +
" background-position: center bottom;\n" +
" }\n" +
" input[type=\"submit\"]:hover {\n" +
" background-color: lightskyblue;\n" +
" }\n" +
" </style>\n" +
"</head>\n" +
"<body>\n" +
"<div class=\"div1\">\n" +
" <img src=\"https://www.jkheb2030.org.cn/Content/peixun/img/logo.png\" >\n" +
"</div>\n" +
"<div class=\"search-container\">\n" +
" <input type=\"text\" placeholder=\"搜索...\" name=\"search\" id=\"search\">\n" +
" <button type=\"submit\">搜索</button>\n" +
"</div>\n" +
"<a href=\"informationadd.html\">老年人信息导入</a>\n" +
"<a class=\"select\">老年人能力定期评估</a>\n" +
"<a href=\"select1.html\">能力评估数据多条件查询</a>\n" +
"<a href=\"ability.html\">能力数据统计</a>\n" +
"<a href=\"enter.html\">能力数据导出</a>\n" +
"<div class=\"div2\">\n" +
" <l>日常生活活动评估</l>\n" +
" <l>精神状态评估</l>\n" +
" <l>感知觉与沟通评估</l>\n" +
" <l>社会参与评估</l>\n" +
"</div>");
writer.println("<h2>查询结果:</h2>");
writer.println("<table>");
writer.println(" <tr><th>进食</th><th>洗澡</th><th>修饰</th><th>穿衣</th><th>大便控制</th><th>小便控制</th><th>如厕</th><th>床椅转移</th><th>平地行走</th><th>上下楼梯</th><th>日常生活活动总分</th>分级<th></th><th>分级名称</th></tr>");
writer.println(" <tr>");
writer.println(" <td>" + dd.getJinshi() + "</td>");
writer.println(" <td>" + dd.getXizao() + "</td>");
writer.println(" <td>" + dd.getXiushi() + "</td>");
writer.println(" <td>" + dd.getChuanyi() + "</td>");
writer.println(" <td>" + dd.getDabian() + "</td>");
writer.println(" <td>" + dd.getXiaobian() + "</td>");
writer.println(" <td>" + dd.getRuce() + "</td>");
writer.println(" <td>" + dd.getChuangyi() + "</td>");
writer.println(" <td>" + dd.getZoulu() + "</td>");
writer.println(" <td>" + dd.getShanglouti() + "</td>");
writer.println(" <td>" + d1 + "</td>");
writer.println(" <td>" + d2 + "</td>");
writer.println(" <td>" + d3 + "</td>");
writer.println(" </tr>");
writer.println("</table>");
writer.println("<table>");
writer.println(" <tr><th>认知功能</th><th>攻击行为</th><th>抑郁症状</th><th>精神状态分级</th><th>分级</th><th>分级名称</th></tr>");
writer.println(" <tr>");
writer.println(" <td>" + mm.getRenzhi() + "</td>");
writer.println(" <td>" + mm.getGongji() + "</td>");
writer.println(" <td>" + mm.getYiyv() + "</td>");
writer.println(" <td>" + m1 + "</td>");
writer.println(" <td>" + m2 + "</td>");
writer.println(" <td>" + m3 + "</td>");
writer.println(" </tr>");
writer.println("</table>");
writer.println("<table>");
writer.println(" <tr><th>意识水平</th><th>视力</th><th>听力</th><th>沟通交流</th><th>分级</th><th>分级名称</th></tr>");
writer.println(" <tr>");
writer.println(" <td>" + ff.getYishi() + "</td>");
writer.println(" <td>" + ff.getShili() + "</td>");
writer.println(" <td>" + ff.getTinli() + "</td>");
writer.println(" <td>" + ff.getGoutong() + "</td>");
writer.println(" <td>" + f2 + "</td>");
writer.println(" <td>" + f3 + "</td>");
writer.println(" </tr>");
writer.println("</table>");
writer.println("<table>");
writer.println(" <tr><th>生活能力</th><th>工作能力</th><th>时间/空间定向</th><th>人物定向</th><th>社会交往能力</th><th>社会参与总分</th><th>分级</th><th>分级名称</th></tr>");
writer.println(" <tr>");
writer.println(" <td>" + pp.getShenghuo() + "</td>");
writer.println(" <td>" + pp.getGongzuo() + "</td>");
writer.println(" <td>" + pp.getShikong() + "</td>");
writer.println(" <td>" + pp.getRenwu() + "</td>");
writer.println(" <td>" + pp.getShejiao() + "</td>");
writer.println(" <td>" + p1 + "</td>");
writer.println(" <td>" + p2 + "</td>");
writer.println(" <td>" + p3 + "</td>");
writer.println(" </tr>");
writer.println("</table>");
writer.println("</body>");
writer.println("</html>");
sqlSession.commit();
sqlSession.close();
}
}
浙公网安备 33010602011771号