2.15

老年人评估系统
package com.example.servlet;

import com.example.mapper.UserMapper;
import com.example.pojo.User;

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.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

@WebServlet("/register")
public class RegisterServlet extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
int id = Integer.parseInt(request.getParameter("id"));
String name = request.getParameter("name");
int age = Integer.parseInt(request.getParameter("age"));
String gender = request.getParameter("gender");
String contact = request.getParameter("contact");
String registrationDate = request.getParameter("registrationDate");

    User user = new User();
    user.setId(id);
    user.setName(name);
    user.setAge(age);
    user.setGender(gender);
    user.setContact(contact);
    user.setRegistrationDate(registrationDate);

    Connection connection = null;
    try {
        Class.forName("com.mysql.cj.jdbc.Driver");
        connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/example", "root", "1234");
        UserMapper mapper = new UserMapper(connection);
        if (mapper.addUser(user)) {
            response.getWriter().println("User registered successfully!");
        } else {
            response.getWriter().println("Failed to register user.");
        }
    } catch (ClassNotFoundException | SQLException e) {
        e.printStackTrace();
        response.getWriter().println("An error occurred while registering the user.");
    } catch (IOException e) {
        throw new RuntimeException(e);
    } finally {
        try {
            if (connection != null) {
                connection.close();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
    request.getRequestDispatcher("index.jsp").forward(request, response);
    AutoCloseable sqlSession = null;
    try {
        sqlSession.close();
    } catch (Exception e) {
        throw new RuntimeException(e);
    }
}
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
    this.doPost(req, resp);

}

}