代码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);
}
}

}