代码8

.

老人基础信息增删改查

package cn.edu.tyut.demo13;

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

@WebServlet("/zhiyuanaddservlet")
public class zhiyuanaddservlet extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws IOException {
request.setCharacterEncoding("utf-8");

    String jobid = request.getParameter("jobid");
    String  name= request.getParameter("name");
    String  sex= request.getParameter("sex");
    String  birthday= request.getParameter("birthday");
    String  department= request.getParameter("department");
    String role = request.getParameter("role");
    String password= request.getParameter("password");



    try (Connection connection = Database.getConnection();
         PreparedStatement statement = connection.prepareStatement("INSERT INTO zhiyuan (jobid,name,sex,birthday,department,role,password) VALUES (?,?, ?,?,?,?,?)")) {

        statement.setString(1, jobid);
        statement.setString(2, name);
        statement.setString(3, sex);
        statement.setString(4, birthday);
        statement.setString(5, department);
        statement.setString(6, role);
        statement.setString(7, password);

        int rowsAffected = statement.executeUpdate();
        if (rowsAffected > 0) {
            //提示录入成功

            response.sendRedirect("guanliyuan.jsp");

        } else {
            response.sendRedirect("zhiyuanadd.jsp");
        }
    } catch (SQLException | ClassNotFoundException e) {
        throw new RuntimeException(e);
    }
}

}