学习四

对a2表格后台搭建
Servlet (AssessmentServlet.java)
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

@WebServlet("/submitAssessmentInfo")
public class AssessmentServlet extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
AssesseeInfo assesseeInfo = new AssesseeInfo();
assesseeInfo.setName(request.getParameter("name"));
assesseeInfo.setGender(Integer.parseInt(request.getParameter("gender")));
assesseeInfo.setBirthDate(request.getParameter("birthDate"));
// 设置其他字段（后补）

    try (Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "username", "password")) {
        String sql = "INSERT INTO AssesseeInfo (Name, Gender, BirthDate) VALUES (?, ?, ?)";
        try (PreparedStatement pstmt = conn.prepareStatement(sql)) {
            pstmt.setString(1, assesseeInfo.getName());
            pstmt.setInt(2, assesseeInfo.getGender());
            pstmt.setString(3, assesseeInfo.getBirthDate());
            // 设置其他参数（后补）
            pstmt.executeUpdate();
        }
    } catch (SQLException e) {
        e.printStackTrace();
    }

    response.sendRedirect("success.jsp"); // 重定向到成功页面
}

}