假期作业6
修改信息：
点击查看代码
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page isELIgnored="false" %>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>修改</title>
<style>
/* 全局样式 */
body {
font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
background-color: #f4f7fa;
color: #333;
margin: 0;
padding: 20px;
display: flex;
justify-content: center;
align-items: center;
min-height: 100vh;
}
/* 表单容器样式 */
form {
background-color: #fff;
padding: 30px;
border-radius: 8px;
box-shadow: 0 4px 8px rgba(0, 0, 0, 0.1);
width: 100%;
max-width: 600px;
}
/* 标签样式 */
label {
display: block;
font-weight: 600;
margin-bottom: 5px;
color: #555;
}
/* 输入框样式 */
input[type="text"],
input[type="date"],
input[type="number"] {
width: 100%;
padding: 12px;
margin-bottom: 20px;
border: 1px solid #ccc;
border-radius: 4px;
box-sizing: border-box;
font-size: 16px;
}
/* 输入框聚焦样式 */
input[type="text"]:focus,
input[type="date"]:focus,
input[type="number"]:focus {
border-color: #007BFF;
outline: none;
box-shadow: 0 0 0 2px rgba(0, 123, 255, 0.25);
}
/* 提交按钮样式 */
input[type="submit"] {
background-color: #007BFF;
color: white;
padding: 12px 20px;
border: none;
border-radius: 4px;
cursor: pointer;
font-size: 16px;
transition: background-color 0.3s ease;
}
/* 提交按钮悬停样式 */
input[type="submit"]:hover {
background-color: #0056b3;
}
</style>
</head>
<body>
<form action="${pageContext.request.contextPath}/update2Servlet" method="post">
<!-- 隐藏域,提交id -->
<input type="hidden" name="assessmentId" value="${base.assessmentId}">
<!-- 评估日期 -->
<label for="assessmentDate">评估日期:</label>
<input type="date" id="assessmentDate" name="assessmentDate" value="${base.assessmentDate}" required>
<!-- 评估原因 -->
<label for="assessmentReason">评估原因:</label>
<input type="number" id="assessmentReason" name="assessmentReason" value="${base.assessmentReason}" required>
<!-- 姓名 -->
<label for="name">姓名:</label>
<input type="text" id="name" name="name" value="${base.name}" required>
<!-- 性别 -->
<label for="gender">性别:</label>
<input type="text" id="gender" name="gender" value="${base.gender}" required>
<!-- 出生日期 -->
<label for="birthDate">出生日期:</label>
<input type="date" id="birthDate" name="birthDate" value="${base.birthDate}" required>
<!-- 身份证号 -->
<label for="idCard">身份证号:</label>
<input type="text" id="idCard" name="idCard" value="${base.idCard}" required>
<!-- 社保卡号 -->
<label for="socialCard">社保卡号:</label>
<input type="text" id="socialCard" name="socialCard" value="${base.socialCard}" required>
<!-- 民族 -->
<label for="ethnicity">民族:</label>
<input type="text" id="ethnicity" name="ethnicity" value="${base.ethnicity}" required>
<!-- 文化程度 -->
<label for="educationLevel">文化程度:</label>
<input type="number" id="educationLevel" name="educationLevel" value="${base.educationLevel}" required>
<!-- 宗教信仰 -->
<label for="religious">宗教信仰:</label>
<input type="number" id="religious" name="religious" value="${base.religious}" required>
<!-- 婚姻状况 -->
<label for="maritalStatus">婚姻状况:</label>
<input type="number" id="maritalStatus" name="maritalStatus" value="${base.maritalStatus}" required>
<!-- 居住情况 -->
<label for="livingCondition">居住情况:</label>
<input type="number" id="livingCondition" name="livingCondition" value="${base.livingCondition}" required>
<!-- 医疗费用支付方式 -->
<label for="medicalPayment">医疗费用支付方式:</label>
<input type="number" id="medicalPayment" name="medicalPayment" value="${base.medicalPayment}" required>
<!-- 经济来源 -->
<label for="economicSource">经济来源:</label>
<input type="number" id="economicSource" name="economicSource" value="${base.economicSource}" required>
<!-- 痴呆情况 -->
<label for="dementia">痴呆情况:</label>
<input type="number" id="dementia" name="dementia" value="${base.dementia}" required>
<!-- 精神疾病情况 -->
<label for="mentalIllness">精神疾病情况:</label>
<input type="number" id="mentalIllness" name="mentalIllness" value="${base.mentalIllness}" required>
<!-- 慢性疾病 -->
<label for="chronicDiseases">慢性疾病:</label>
<input type="text" id="chronicDiseases" name="chronicDiseases" value="${base.chronicDiseases}" required>
<!-- 跌倒情况 -->
<label for="fall">跌倒情况:</label>
<input type="number" id="fall" name="fall" value="${base.fall}" required>
<!-- 走失情况 -->
<label for="gettingLost">走失情况:</label>
<input type="number" id="gettingLost" name="gettingLost" value="${base.gettingLost}" required>
<!-- 噎食情况 -->
<label for="choking">噎食情况:</label>
<input type="number" id="choking" name="choking" value="${base.choking}" required>
<!-- 自杀情况 -->
<label for="suicide">自杀情况:</label>
<input type="number" id="suicide" name="suicide" value="${base.suicide}" required>
<!-- 其他信息 -->
<label for="otherInfo">其他信息:</label>
<input type="text" id="otherInfo" name="otherInfo" value="${base.otherInfo}" required>
<!-- 信息提供者姓名 -->
<label for="informantName">信息提供者姓名:</label>
<input type="text" id="informantName" name="informantName" value="${base.informantName}" required>
<!-- 信息提供者与老人关系 -->
<label for="relationship">信息提供者与老人关系:</label>
<input type="text" id="relationship" name="relationship" value="${base.relationship}" required>
<!-- 联系人姓名 -->
<label for="contactName">联系人姓名:</label>
<input type="text" id="contactName" name="contactName" value="${base.contactName}" required>
<!-- 联系人电话 -->
<label for="contactPhone">联系人电话:</label>
<input type="text" id="contactPhone" name="contactPhone" value="${base.contactPhone}" required>
<input type="submit" value="提交">
</form>
</body>
</html>
servlet1：
点击查看代码
package com.vivy.web;
import com.vivy.pojo.Base;
import com.vivy.service.BaseService;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.annotation.*;
import java.io.IOException;
import java.util.List;
@WebServlet("/update1Servlet")
public class update1Servlet extends HttpServlet {
private BaseService service = new BaseService();
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
response.setContentType("text/html;charset=utf-8");
//# = new String(classId.getBytes(StandardCharsets.ISO_8859_1),StandardCharsets.UTF_8);
String assessmentId = request.getParameter("id");
Base base = service.selectOne(assessmentId);
request.setAttribute("base",base);
request.getRequestDispatcher("/updateBase.jsp").forward(request,response);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
this.doGet(request, response);
}
}
servlet2：
点击查看代码
package com.vivy.web;
import com.vivy.pojo.Base;
import com.vivy.service.BaseService;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.annotation.*;
import java.io.IOException;
@WebServlet("/update2Servlet")
public class update2Servlet extends HttpServlet {
private BaseService service = new BaseService();
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
response.setContentType("text/html;charset=utf-8");
//# = new String(classId.getBytes(StandardCharsets.ISO_8859_1),StandardCharsets.UTF_8);
Base base = new Base();
base.setAssessmentId( request.getParameter("assessmentId"));
base.setAssessmentDate(request.getParameter("assessmentDate"));
base.setAssessmentReason(Integer.valueOf(request.getParameter("assessmentReason")));
base.setName(request.getParameter("name"));
base.setGender(request.getParameter("gender"));
base.setBirthDate(request.getParameter("birthDate"));
base.setIdCard(request.getParameter("idCard"));
base.setSocialCard(request.getParameter("socialCard"));
base.setEthnicity(request.getParameter("ethnicity"));
base.setEducationLevel(Integer.valueOf(request.getParameter("educationLevel")));
base.setReligious(Integer.valueOf(request.getParameter("religious")));
base.setMaritalStatus(Integer.valueOf(request.getParameter("maritalStatus")));
base.setLivingCondition(Integer.valueOf(request.getParameter("livingCondition")));
base.setMedicalPayment(Integer.valueOf(request.getParameter("medicalPayment")));
base.setEconomicSource(Integer.valueOf(request.getParameter("economicSource")));
base.setDementia(Integer.valueOf(request.getParameter("dementia")));
base.setMentalIllness(Integer.valueOf(request.getParameter("mentalIllness")));
base.setChronicDiseases(request.getParameter("chronicDiseases"));
base.setFall(Integer.valueOf(request.getParameter("fall")));
base.setGettingLost(Integer.valueOf(request.getParameter("gettingLost")));
base.setChoking(Integer.valueOf(request.getParameter("choking")));
base.setSuicide(Integer.valueOf(request.getParameter("suicide")));
base.setOtherInfo(request.getParameter("otherInfo"));
base.setInformantName(request.getParameter("informantName"));
base.setRelationship(request.getParameter("relationship"));
base.setContactName(request.getParameter("contactName"));
base.setContactPhone(request.getParameter("contactPhone"));
service.update(base);
request.getRequestDispatcher("/selectAllServlet").forward(request,response);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
this.doGet(request, response);
}
}
mapper：
点击查看代码
package com.vivy.mapper;
import com.vivy.pojo.Base;
import java.util.List;
public interface BaseMapper {
void add(Base base);
List<Base> selectAll();
void update(Base base);
}
xml:
点击查看代码
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!--接口全路径名-->
<mapper namespace="com.vivy.mapper.BaseMapper">
<insert id="add" parameterType="com.vivy.pojo.Base">
INSERT INTO tb_base (
assessmentId, assessmentDate, assessmentReason, name, gender, birthDate,
idCard, socialCard, ethnicity, educationLevel, religious, maritalStatus,
livingCondition, medicalPayment, economicSource, dementia, mentalIllness,
chronicDiseases, fall, gettingLost, choking, suicide, otherInfo,
informantName, relationship, contactName, contactPhone
) VALUES (
#{assessmentId}, #{assessmentDate}, #{assessmentReason}, #{name}, #{gender}, #{birthDate},
#{idCard}, #{socialCard}, #{ethnicity}, #{educationLevel}, #{religious}, #{maritalStatus},
#{livingCondition}, #{medicalPayment}, #{economicSource}, #{dementia}, #{mentalIllness},
#{chronicDiseases}, #{fall}, #{gettingLost}, #{choking}, #{suicide}, #{otherInfo},
#{informantName}, #{relationship}, #{contactName}, #{contactPhone}
)
</insert>
<select id="selectAll" resultType="com.vivy.pojo.Base">
SELECT * FROM tb_base
</select>
<update id="update">
update tb_base
<set>
<if test="assessmentDate != null and assessmentDate != '' ">
assessmentDate = #{assessmentDate},
</if>
<if test="assessmentReason != null">
assessmentReason = #{assessmentReason},
</if>
<if test="name != null and name != '' ">
name = #{name},
</if>
<if test="gender != null and gender != '' ">
gender = #{gender},
</if>
<if test="birthDate != null and birthDate != '' ">
birthDate = #{birthDate},
</if>
<if test="idCard != null and idCard != '' ">
idCard = #{idCard},
</if>
<if test="socialCard != null and socialCard != '' ">
socialCard = #{socialCard},
</if>
<if test="ethnicity != null and ethnicity != '' ">
ethnicity = #{ethnicity},
</if>
<if test="educationLevel != null">
educationLevel = #{educationLevel},
</if>
<if test="religious != null">
religious = #{religious},
</if>
<if test="maritalStatus != null">
maritalStatus = #{maritalStatus},
</if>
<if test="livingCondition != null">
livingCondition = #{livingCondition},
</if>
<if test="medicalPayment != null">
medicalPayment = #{medicalPayment},
</if>
<if test="economicSource != null">
economicSource = #{economicSource},
</if>
<if test="dementia != null">
dementia = #{dementia},
</if>
<if test="mentalIllness != null">
mentalIllness = #{mentalIllness},
</if>
<if test="chronicDiseases != null and chronicDiseases != '' ">
chronicDiseases = #{chronicDiseases},
</if>
<if test="fall != null">
fall = #{fall},
</if>
<if test="gettingLost != null">
gettingLost = #{gettingLost},
</if>
<if test="choking != null">
choking = #{choking},
</if>
<if test="suicide != null">
suicide = #{suicide},
</if>
<if test="otherInfo != null and otherInfo != '' ">
otherInfo = #{otherInfo},
</if>
<if test="informantName != null and informantName != '' ">
informantName = #{informantName},
</if>
<if test="relationship != null and relationship != '' ">
relationship = #{relationship},
</if>
<if test="contactName != null and contactName != '' ">
contactName = #{contactName},
</if>
<if test="contactPhone != null and contactPhone != '' ">
contactPhone = #{contactPhone},
</if>
</set>
where assessmentId = #{assessmentId};
</update>
</mapper>
浙公网安备 33010602011771号