学习一

完成a1表格的数据库创建与代码编译
HTML（JSP）+CSS

1. HTML (JSP) 部分
   <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>

老年人能力评估基本信息表

评估编号:

    <label for="assessmentDate">评估基准日期:</label>
    <input type="date" id="assessmentDate" name="assessmentDate" required><br><br>
    
    <label for="assessmentReason">评估原因:</label>
    <select id="assessmentReason" name="assessmentReason" required>
        <option value="1">接受服务前初评</option>
        <option value="2">接受服务后的常规评估</option>
        <option value="3">状况发生变化后的即时评估</option>
        <option value="4">因评估结果有疑问进行的复评</option>
    </select><br><br>
    <其他基本信息字段>
    <input type="submit" value="提交">
</form>

2. CSS 部分 /* styles.css */ body { font-family: Arial, sans-serif; margin: 20px; background-color: #f4f4f4; }

h1 {
color: #333;
}

label {
display: block;
margin-top: 10px;
font-weight: bold;
}

input[type="text"], input[type="date"], select {
width: 100%;
padding: 8px;
margin-top: 5px;
margin-bottom: 15px;
border: 1px solid #ccc;
border-radius: 4px;
}

input[type="submit"] {
background-color: #4CAF50;
color: white;
padding: 10px 20px;
border: none;
border-radius: 4px;
cursor: pointer;
}
input[type="submit"]:hover {
background-color: #45a049;
}

1. JavaBean (AssessmentInfo.java)
   public class AssessmentInfo {
   private String assessmentId;
   private String assessmentDate;
   private int assessmentReason;
   // 其他字段和getter/setter方法
   public String getAssessmentId() {
   return assessmentId;
   }

   public void setAssessmentId(String assessmentId) {
   this.assessmentId = assessmentId;
   }

   public String getAssessmentDate() {
   return assessmentDate;
   }

   public void setAssessmentDate(String assessmentDate) {
   this.assessmentDate = assessmentDate;
   }

   public int getAssessmentReason() {
   return assessmentReason;
   }

   public void setAssessmentReason(int assessmentReason) {
   this.assessmentReason = assessmentReason;
   }
   }

2. Servlet (AssessmentServlet.java)
   import java.io.IOException;
   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.sql.Connection;
   import java.sql.DriverManager;
   import java.sql.PreparedStatement;
   import java.sql.SQLException;
   @WebServlet("/submitAssessment")
   public class AssessmentServlet extends HttpServlet {
   private static final long serialVersionUID = 1L;
   protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
   AssessmentInfo assessmentInfo = new AssessmentInfo();
   assessmentInfo.setAssessmentId(request.getParameter("assessmentId"));
   assessmentInfo.setAssessmentDate(request.getParameter("assessmentDate"));
   assessmentInfo.setAssessmentReason(Integer.parseInt(request.getParameter("assessmentReason")));
   // 设置其他字段
   try (Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "username", "password")) {
   String sql = "INSERT INTO Assessment (AssessmentId, AssessmentDate, AssessmentReason) VALUES (?, ?, ?)";
   try (PreparedStatement pstmt = conn.prepareStatement(sql)) {
   pstmt.setString(1, assessmentInfo.getAssessmentId());
   pstmt.setString(2, assessmentInfo.getAssessmentDate());
   pstmt.setInt(3, assessmentInfo.getAssessmentReason());
   // 设置其他参数
   pstmt.executeUpdate();
   }
   } catch (SQLException e) {
   e.printStackTrace();
   }
   response.sendRedirect("success.jsp"); // 重定向到成功页面
   }
   }