2023.11.13

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.PreparedStatement;
import java.sql.SQLException;
@WebServlet("/guanliwork")
public class guanliwork extends HttpServlet {
    private static final String jdbcURL = "jdbc:mysql://localhost:3306/mydatabase";
    private static final String jdbcUsername = "root";
    private static final String jdbcPassword = "123456";

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String teacher_number =request.getParameter("teacher_number");
        String teacher_name =request.getParameter("teacher_name");
        String gender =request.getParameter("gender");
        String department =request.getParameter("department");
        String title =request.getParameter("title");

        try {
            Connection connection = DriverManager.getConnection(jdbcURL, jdbcUsername, jdbcPassword);
            String insertQuery = "INSERT INTO teachers(teacher_number, teacher_name, gender, department, title) VALUES(?,?,?,?,?)";
            PreparedStatement preparedStatement = connection.prepareStatement(insertQuery);
            preparedStatement.setString(1, teacher_number);
            preparedStatement.setString(2, teacher_name);
            preparedStatement.setString(3, gender);
            preparedStatement.setString(4, department);
            preparedStatement.setString(5, title);
            preparedStatement.executeUpdate();
            preparedStatement.close();
            connection.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        String student_number = request.getParameter("student_number");
        String student_name =request.getParameter("student_name");
        String sgender = request.getParameter("gender");
        String class_name =request.getParameter("class_name");
        String major =request.getParameter("major");
        try {
            Connection connection = DriverManager.getConnection(jdbcURL, jdbcUsername, jdbcPassword);
            String insertQuery = "INSERT INTO students(student_number, student_name, gender, class_name, major) VALUES(?,?,?,?,?)";
            PreparedStatement preparedStatement = connection.prepareStatement(insertQuery);
            preparedStatement.setString(1, student_number);
            preparedStatement.setString(2, student_name);
            preparedStatement.setString(3, sgender);
            preparedStatement.setString(4, class_name);
            preparedStatement.setString(5, major);
            preparedStatement.executeUpdate();
            preparedStatement.close();
            connection.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }

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

<%--
  Created by IntelliJ IDEA.
  User: 郑天羽
  Date: 2023/11/13
  Time: 14:43
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE  html>
<html>
<head>
    <title>首页</title>
</head>
<body>
<h1>首页</h1>
<ul>
    <li><a href="teacher.jsp">教师功能页</a> </li>
    <li><a href="student.jsp">学生功能页</a> </li>
    <li><a href="guanli.jsp">管理员功能页</a> </li>
</ul>
</body>
</html>

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>管理员功能页面</title>
</head>
<body>
<form action="guanliwork" method="post">
    <h1>添加教师信息 </h1>
    <label for="teacher_number">工号：</label>
    <input type="text" id="teacher_number" name="teacher_number" required>
    <br>
    <label for="teacher_name">教师姓名：</label>
    <input type="text" id="teacher_name" name="teacher_name" required>
    <br>
    <label for="gender">教师性别：</label>
    <input type="text" id="gender" name="gender" required>
    <br>
    <label for="department">教师所在学院：</label>
    <input type="text" id="department" name="department" required>
    <br>
    <label for="title">教师岗位：</label>
    <input type="text" id="title" name="title" required>
    <br>
    <h2>添加学生信息</h2>
    <label for="student_number">学号：</label>
    <input type="text" id="student_number" name="student_number" required>
    <br>
    <label for="student_name">学生姓名：</label>
    <input type="text" id="student_name" name="student_name" required>
    <br>
    <label for="sgender">学生性别：</label>
    <input type="text" id="sgender" name="sgender" required>
    <br>
    <label for="class_name">班级：</label>
    <input type="text" id="class_name" name="class_name" required>
    <br>
    <label for="major">专业：</label>
    <input type="text" id="major" name="major" required>
    <br>
    <input type="submit" value="提交">
</form>
</body>
</html>