学生管理系统【Servlet+jsp】

实体

Course.java

package bean;

public class Course {
    private int course_id;
    private String course_name;
    private String course_code;
    private int credits;
    private String department;

    public int getCourse_id() {
        return course_id;
    }

    public void setCourse_id(int course_id) {
        this.course_id = course_id;
    }

    public String getCourse_name() {
        return course_name;
    }

    public void setCourse_name(String course_name) {
        this.course_name = course_name;
    }

    public String getCourse_code() {
        return course_code;
    }

    public void setCourse_code(String course_code) {
        this.course_code = course_code;
    }

    public int getCredits() {
        return credits;
    }

    public void setCredits(int credits) {
        this.credits = credits;
    }

    public String getDepartment() {
        return department;
    }

    public void setDepartment(String department) {
        this.department = department;
    }

    @Override
    public String toString() {
        return "Course{" +
                "course_id=" + course_id +
                ", course_name='" + course_name + '\'' +
                ", course_code='" + course_code + '\'' +
                ", credits=" + credits +
                ", department='" + department + '\'' +
                '}';
    }
}

Student.java

package bean;

import java.util.Date;

        public class Student {
            private int student_id;
            private String first_name;
            private String last_name;
            private String date_of_birth;
            private String gender;
            private String email;
            private String phone_number;
            private String address;
            private String created_at;

    public Student() {
    }


    public int getStudent_id() {
        return student_id;
    }

    public void setStudent_id(int student_id) {
        this.student_id = student_id;
    }

    public String getFirst_name() {
        return first_name;
    }

    public void setFirst_name(String first_name) {
        this.first_name = first_name;
    }

    public String getLast_name() {
        return last_name;
    }

    @Override
    public String toString() {
        return "Student{" +
                "student_id=" + student_id +
                ", first_name='" + first_name + '\'' +
                ", last_name='" + last_name + '\'' +
                ", date_of_birth=" + date_of_birth +
                ", gender='" + gender + '\'' +
                ", email='" + email + '\'' +
                ", phone_number='" + phone_number + '\'' +
                ", address='" + address + '\'' +
                ", created_at='" + created_at + '\'' +
                '}';
    }

    public void setLast_name(String last_name) {
        this.last_name = last_name;
    }

    public String getDate_of_birth() {
        return date_of_birth;
    }

    public void setDate_of_birth(String date_of_birth) {
        this.date_of_birth = date_of_birth;
    }

    public String getGender() {
        return gender;
    }

    public void setGender(String gender) {
        this.gender = gender;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public String getPhone_number() {
        return phone_number;
    }

    public void setPhone_number(String phone_number) {
        this.phone_number = phone_number;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public String getCreated_at() {
        return created_at;
    }

    public void setCreated_at(String created_at) {
        this.created_at = created_at;
    }

    public Student(int student_id, String first_name, String last_name, String date_of_birth, String gender, String email, String phone_number, String address, String created_at) {
        this.student_id = student_id;
        this.first_name = first_name;
        this.last_name = last_name;
        this.date_of_birth = date_of_birth;
        this.gender = gender;
        this.email = email;
        this.phone_number = phone_number;
        this.address = address;
        this.created_at = created_at;
    }
}

Teacher.java

package bean;

public class Teacher {
    private int teacher_id;
    private String first_name;
    private String last_name;
    private String email;
    private String phone_number;
private String department;

    public Teacher() {
    }

    public Teacher(int teacher_id, String first_name, String last_name, String email, String phone_number, String department) {
        this.teacher_id = teacher_id;
        this.first_name = first_name;
        this.last_name = last_name;
        this.email = email;
        this.phone_number = phone_number;
        this.department = department;
    }

    public int getTeacher_id() {
        return teacher_id;
    }

    public void setTeacher_id(int teacher_id) {
        this.teacher_id = teacher_id;
    }

    public String getFirst_name() {
        return first_name;
    }

    public void setFirst_name(String first_name) {
        this.first_name = first_name;
    }

    public String getLast_name() {
        return last_name;
    }

    public void setLast_name(String last_name) {
        this.last_name = last_name;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public String getPhone_number() {
        return phone_number;
    }

    public void setPhone_number(String phone_number) {
        this.phone_number = phone_number;
    }

    public String getDepartment() {
        return department;
    }

    public void setDepartment(String department) {
        this.department = department;
    }
}

Grade.java

package bean;

public class Grade {
    private int gradeId;
    private int studentId;
    private int courseId;

    public Grade(int i, int studentId, int courseId, double grade) {
    }

    public int getGradeId() {
        return gradeId;
    }

    public void setGradeId(int gradeId) {
        this.gradeId = gradeId;
    }

    public int getStudentId() {
        return studentId;
    }

    public void setStudentId(int studentId) {
        this.studentId = studentId;
    }

    public int getCourseId() {
        return courseId;
    }

    public void setCourseId(int courseId) {
        this.courseId = courseId;
    }

    public double getGrade() {
        return grade;
    }

    public void setGrade(double grade) {
        this.grade = grade;
    }

    private double grade;
}

Servlet

CourseServlet

package servlet;

import bean.Course;
import dao.CoursesDaoImpl;

import javax.servlet.ServletContext;
import javax.servlet.http.*;

import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;

@WebServlet("/CourseServlet")
public class CourseServlet extends HttpServlet {
    private static final long serialVersionUID = 1L;
    CoursesDaoImpl coursesDao = new CoursesDaoImpl();
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("UTF-8");
        // 设置响应的字符编码
        response.setCharacterEncoding("UTF-8");
        String action = request.getParameter("action");

        if (action == null) {
            action = "list";
        }

        switch (action) {
            case "list":
                listCourses(request, response);
                break;
            case "add":
                addCourse(request, response);
                break;
            case "edit":
                editCourse(request, response);
                break;
            case "update":
                updateCourse(request, response);
                break;
            case "delete":
                deleteCourse(request, response);
                break;
            default:
                listCourses(request, response);
        }
    }
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("UTF-8");
        // 设置响应的字符编码
        response.setCharacterEncoding("UTF-8");
        String action = request.getParameter("action");

        if (action == null) {
            action = "list";
        }

        switch (action) {
            case "list":
                listCourses(request, response);
                break;
            case "add":
                addCourse(request, response);
                break;
            case "edit":

                editCourse(request, response);
                break;
            case "update":
                updateCourse(request, response);
                break;
            case "delete":
                deleteCourse(request, response);
                break;
            default:
                listCourses(request, response);
        }
    }
    private void listCourses(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        List<Course> courses = new ArrayList<>();
        courses = coursesDao.list();
        System.out.println(courses.get(0));
        ServletContext application = this.getServletContext();
        application.setAttribute("courses", courses);
        request.getRequestDispatcher("courseList.jsp").forward(request,response);

    }

    private void addCourse(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // 从请求参数中获取课程信息并插入到数据库中
        Course course = new Course();
        course.setCourse_name( request.getParameter("courseName"));
        course.setCourse_code(  request.getParameter("courseCode"));
        course.setCredits(Integer.parseInt(request.getParameter("credits")));
        course.setDepartment(request.getParameter("department"));
        coursesDao.insert(course);
        // 重定向到课程列表页面
        response.sendRedirect("CourseServlet?action=list");
    }

    private void editCourse(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        int courseId = Integer.parseInt(request.getParameter("courseId"));
        Course byId = coursesDao.findById(courseId);
        ServletContext application = this.getServletContext();
        application.setAttribute("course",byId);
        response.sendRedirect("edit-course.jsp");

    }

    private void updateCourse(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        Course course = new Course();
        request.setCharacterEncoding("utf-8");
        course.setCourse_name( request.getParameter("courseName"));
        course.setCourse_code(request.getParameter("courseCode"));
        course.setCredits(Integer.parseInt(request.getParameter("credits")));
        course.setDepartment(request.getParameter("department"));
        course.setCourse_id(Integer.parseInt(request.getParameter("courseId")));
        System.out.println(course);

        coursesDao.update(course);
        response.sendRedirect("CourseServlet?action=list");
    }

    private void deleteCourse(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // 从请求参数中获取要删除的课程ID并从数据库中删除该课程
        int courseId = Integer.parseInt(request.getParameter("courseId"));
        coursesDao.delete(courseId);
        // 重定向到课程列表页面
        response.sendRedirect("CourseServlet?action=list");
    }
}

StudentServlet

package servlet;
import bean.Course;
import bean.Student;
import dao.StudentDaoImpl;

import javax.servlet.*;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.*;
import java.io.IOException;
import java.sql.*;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
@WebServlet("/StudentServlet")
public class StudentServlet extends HttpServlet {
    StudentDaoImpl studentDao = new StudentDaoImpl();
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("UTF-8");
        // 设置响应的字符编码
        response.setCharacterEncoding("UTF-8");
        String action = request.getParameter("action");
        if ("add".equals(action)) {
            try {
                addStudent(request, response);
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
        } else if ("delete".equals(action)) {
            try {
                deleteStudent(request, response);
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
        } else if ("update".equals(action)) {
            try {
                updateStudent(request, response);
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
        } else if ("list".equals(action)) {
            try {
                listStudents(request, response);
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
        }else if ("edit".equals(action)) {
            editStudent(request, response);
        }else if ("login".equals(action)) {
            loginStudent(request, response);
        }
    }




    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("UTF-8");
        // 设置响应的字符编码
        response.setCharacterEncoding("UTF-8");
        String action = request.getParameter("action");
        if ("add".equals(action)) {
            try {
                addStudent(request, response);
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
        } else if ("delete".equals(action)) {
            try {
                deleteStudent(request, response);
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
        } else if ("update".equals(action)) {
            try {
                updateStudent(request, response);
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
        } else if ("list".equals(action)) {
            try {
                listStudents(request, response);
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
        }else if ("edit".equals(action)) {
            editStudent(request, response);
        }
    }
    private void editStudent(HttpServletRequest request, HttpServletResponse response) throws IOException {
        int id = Integer.parseInt(request.getParameter("studentId"));
        Student byId = studentDao.findById(id);
        ServletContext application = this.getServletContext();
        application.setAttribute("student",byId);
        response.sendRedirect("edit-student.jsp");
    }
    private void addStudent(HttpServletRequest request, HttpServletResponse response) throws SQLException, IOException {
        Student student = new Student();
        student.setStudent_id(Integer.parseInt(request.getParameter("studentId")));
        student.setFirst_name(request.getParameter("firstName"));
        student.setLast_name(request.getParameter("lastName"));
        student.setAddress(request.getParameter("address"));
        student.setGender(request.getParameter("gender"));
        student.setPhone_number(request.getParameter("phoneNumber"));
        student.setDate_of_birth(request.getParameter("dateOfBirth"));
        student.setEmail(request.getParameter("email"));
        student.setCreated_at(String.valueOf(new Date()));
        studentDao.insert(student);
        response.sendRedirect("StudentServlet?action=list");
    }
    private void deleteStudent(HttpServletRequest request, HttpServletResponse response) throws SQLException, IOException {
        int studentId = Integer.parseInt(request.getParameter("studentId"));
        studentDao.delete(studentId);
        response.sendRedirect("StudentServlet?action=list");

    }
    private void updateStudent(HttpServletRequest request, HttpServletResponse response) throws SQLException, IOException {
        request.setCharacterEncoding("UTF-8");
        Student student = new Student();
        System.out.println(request.getParameter("firstName"));
        student.setStudent_id(Integer.parseInt(request.getParameter("studentId")));
        student.setFirst_name(request.getParameter("firstName"));
        student.setLast_name(request.getParameter("lastName"));
        student.setAddress(request.getParameter("address"));
        student.setPhone_number(request.getParameter("phoneNumber"));
        student.setDate_of_birth(request.getParameter("dateOfBirth"));
        student.setEmail(request.getParameter("email"));
        student.setCreated_at(String.valueOf(new Date()));
        studentDao.update(student);
        response.sendRedirect("StudentServlet?action=list");
    }
    private void listStudents(HttpServletRequest request, HttpServletResponse response) throws SQLException, ServletException, IOException {
        List<Student> list = studentDao.list();
        ServletContext application = this.getServletContext();
        application.setAttribute("students", list);
        request.getRequestDispatcher("students.jsp").forward(request,response);

    }
    private void loginStudent(HttpServletRequest request, HttpServletResponse response) throws IOException {
        String username = request.getParameter("username");
        String password = request.getParameter("password");
        if (username.equals("admin")&&password.equals("admin"))
        response.sendRedirect("StudentServlet?action=list");
    }
}

TeacherServlet

package servlet;

import bean.Teacher;
import dao.TearcherDaoImpl;

import java.io.IOException;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
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("/TeacherServlet")
public class TeacherServlet extends HttpServlet {
    TearcherDaoImpl tearcherDao = new TearcherDaoImpl();
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("UTF-8");
        // 设置响应的字符编码
        response.setCharacterEncoding("UTF-8");
        String action = request.getParameter("action");
        if ("add".equals(action)) {
            String firstName = request.getParameter("firstName");
            String lastName = request.getParameter("lastName");
            String email = request.getParameter("email");
            String phoneNumber = request.getParameter("phoneNumber");
            addTeacher(firstName, lastName, email, phoneNumber);
        } else if ("update".equals(action)) {
            int teacherId = Integer.parseInt(request.getParameter("teacherId"));
            String firstName = request.getParameter("firstName");
            String lastName = request.getParameter("lastName");
            String email = request.getParameter("email");
            String phoneNumber = request.getParameter("phoneNumber");
            updateTeacher(teacherId, firstName, lastName, email, phoneNumber);
        }

        response.sendRedirect("TeacherServlet");
    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("UTF-8");
        // 设置响应的字符编码
        response.setCharacterEncoding("UTF-8");
        String action = request.getParameter("action");
        if ("delete".equals(action)) {
            int teacherId = Integer.parseInt(request.getParameter("teacherId"));
            deleteTeacher(teacherId);
        }
        List<Teacher> teachers = getTeacherList();
        request.setAttribute("teachers", teachers);
        request.getRequestDispatcher("teacher-list.jsp").forward(request, response);
    }

    private void addTeacher(String firstName, String lastName, String email, String phoneNumber) {
        Teacher teacher = new Teacher(0,firstName,lastName,email,phoneNumber,"");
        tearcherDao.insertTeacher(teacher);
    }

    private void updateTeacher(int teacherId, String firstName, String lastName, String email, String phoneNumber) {
    Teacher teacher = new Teacher(teacherId,firstName,lastName,email,phoneNumber,"");
    tearcherDao.updateTeacher(teacher);
    }

    private void deleteTeacher(int teacherId) {
        tearcherDao.deleteTeacher(teacherId);
    }

    private List<Teacher> getTeacherList() {
        List<Teacher> teachers = tearcherDao.listAllTeachers();

        return teachers;
    }
}