基于javaweb+mysql的jsp+servlet简单学生信息管理系统(java+servlet+mysql+jsp+bootstrap)

基于javaweb+mysql的jsp+servlet简单学生信息管理系统(java+servlet+mysql+jsp+bootstrap)

私信源码获取及调试交流

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

基于javaweb+mysql的JSP+Servlet简单学生信息管理系统(java+servlet+mysql+jsp+bootstrap)

登录：

admin 123456

学生信息增删改查管理

@WebServlet(name = "UpdateServlet")
public class UpdateServlet extends HttpServlet {

    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

        Student student = new Student();

        int id = Integer.parseInt(req.getParameter("id"));
        int studentID = Integer.parseInt(req.getParameter("studentID"));
        String name = req.getParameter("name");
        int age = Integer.parseInt(req.getParameter("age"));
        String sex = req.getParameter("radio");

        student.setId(id);
        student.setStudentID(studentID);
        student.setName(name);
        student.setAge(age);
        student.setSex(sex);

        new StudentDAO().update(student);
        System.out.println("UpdateServlet!!");
        resp.sendRedirect("ListServlet");
    }
}

@WebServlet(name = "AddServlet")
public class AddServlet extends HttpServlet {
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

        Student student = new Student();

@WebServlet(name = "LoginServlet")
public class RegisterServlet extends HttpServlet {
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException{
        String username = req.getParameter("username");
        String password = req.getParameter("password");
        User user = new UserDAO().getUser(username);
        System.out.println(username+"+"+password);
        System.out.println(user.getUsername()+"+"+user.getPassword());
        if (user.getUsername() == null){
            user.setUsername(username);
            user.setPassword(password);
            new UserDAO().addUser(user);
            System.out.println("注册成功！");
            resp.sendRedirect("login.jsp");
        }else {
            req.setAttribute("flag","false");//用户已存在
            req.getRequestDispatcher("/register.jsp").forward(req,resp);
        }

    }
}

@WebServlet(name = "UpdateServlet")
public class UpdateServlet extends HttpServlet {

    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

        Student student = new Student();

        int id = Integer.parseInt(req.getParameter("id"));
        int studentID = Integer.parseInt(req.getParameter("studentID"));
        String name = req.getParameter("name");

    public void destroy() {
    }
}

@WebServlet(name = "LoginServlet")
public class LoginServlet extends HttpServlet {
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException{

        String username = req.getParameter("username");
        String password = req.getParameter("password");
        User user = new UserDAO().getUser(username);

        HttpSession session = req.getSession();

        if (user.getUsername() == null){//若用户不存在
            req.setAttribute("flag","null");
            req.getRequestDispatcher("/login.jsp").forward(req,resp);
        }else {
            if ( password.equals(user.getPassword()) ){
                //登陆成功
                session.setAttribute("username",username);//将用户名用于session域进行权限检查
                System.out.println("登陆成功！session："+session.getAttribute("username"));

                if (username!=null){
                    Cookie c = new Cookie("user",username);
                    c.setMaxAge(60);//有效时间60s
                    resp.addCookie(c);//将Cookie对象保存到客户端
                }

                resp.sendRedirect("/ListServlet");
            }else {
                req.setAttribute("flag","false");
                req.getRequestDispatcher("/login.jsp").forward(req,resp);

        ArrayList<Student> students = new StudentDAO().getStudent(type,content);

        Gson gson = new Gson();
        String json = gson.toJson(students);//解析数据生成Json
        for (Student s : students){
            System.out.println("查询结果："+s.getName()+s.getStudentID());
        }

        response.setCharacterEncoding("UTF-8");
        response.setContentType("application/json");

        System.out.println("JSON："+json);
        PrintWriter out = response.getWriter();
        out.print(json);
        out.flush();
        out.close();
    }
}

@WebServlet(name = "ListServlet")
public class ListServlet extends HttpServlet {

    private StudentDAO studentDAO = new StudentDAO();

    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

        // 获取分页参数
        int start = 0;
        int count = 10;

        try {
            start = Integer.parseInt(req.getParameter("page.start"));
            count = Integer.parseInt(req.getParameter("page.count"));
        } catch (Exception e) {
        }

        student.setName(name);
        student.setAge(age);
        student.setSex(sex);

        new StudentDAO().update(student);
        System.out.println("UpdateServlet!!");
        resp.sendRedirect("ListServlet");
    }
}

@WebServlet(name = "AddServlet")
public class AddServlet extends HttpServlet {
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

        Student student = new Student();

        // 直接从表单中获取数据
        int studentID = Integer.parseInt(req.getParameter("studentID"));
        String name = req.getParameter("name");
        int age = Integer.parseInt(req.getParameter("age"));
        String sex = req.getParameter("radio");

        student.setStudentID(studentID);
        student.setName(name);
        student.setAge(age);
        student.setSex(sex);

        new StudentDAO().add(student);
        resp.sendRedirect("ListServlet");  // 这里可以理解为刷新，重新请求
    }
}

        String content = request.getParameter("content");
        String type = request.getParameter("type");
        System.out.println("内容为："+content+" 类型为："+type);
        ArrayList<Student> students = new StudentDAO().getStudent(type,content);

        Gson gson = new Gson();
        String json = gson.toJson(students);//解析数据生成Json
        for (Student s : students){
            System.out.println("查询结果："+s.getName()+s.getStudentID());
        }

        response.setCharacterEncoding("UTF-8");
        response.setContentType("application/json");

        System.out.println("JSON："+json);
        PrintWriter out = response.getWriter();
        out.print(json);
        out.flush();
        out.close();
    }
}

@WebServlet(name = "ListServlet")
public class ListServlet extends HttpServlet {

    private StudentDAO studentDAO = new StudentDAO();

    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

        // 获取分页参数
        int start = 0;
        int count = 10;

        try {

        int studentID = Integer.parseInt(req.getParameter("studentID"));
        String name = req.getParameter("name");
        int age = Integer.parseInt(req.getParameter("age"));
        String sex = req.getParameter("radio");

        student.setStudentID(studentID);
        student.setName(name);
        student.setAge(age);
        student.setSex(sex);

        new StudentDAO().add(student);
        resp.sendRedirect("ListServlet");  // 这里可以理解为刷新，重新请求
    }
}

@WebServlet(name = "LogoutServlet")
public class LogoutServlet extends HttpServlet {
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException{
        HttpSession session = req.getSession();
        System.out.println("已登录用户为："+session.getAttribute("username"));
        session.removeAttribute("username");
        System.out.println("已退出登录");
        resp.sendRedirect("/login.jsp");
    }
}

@WebServlet(name = "EditStudent")
public class EditServlet extends HttpServlet {

@WebServlet(name = "LoginServlet")
public class RegisterServlet extends HttpServlet {
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException{
        String username = req.getParameter("username");
        String password = req.getParameter("password");
        User user = new UserDAO().getUser(username);
        System.out.println(username+"+"+password);
        System.out.println(user.getUsername()+"+"+user.getPassword());
        if (user.getUsername() == null){
            user.setUsername(username);
            user.setPassword(password);
            new UserDAO().addUser(user);
            System.out.println("注册成功！");
            resp.sendRedirect("login.jsp");
        }else {
            req.setAttribute("flag","false");//用户已存在
            req.getRequestDispatcher("/register.jsp").forward(req,resp);
        }

    }
}

@WebServlet(name = "UpdateServlet")
public class UpdateServlet extends HttpServlet {

@WebServlet(name = "AddServlet")
public class AddServlet extends HttpServlet {
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

        Student student = new Student();

        // 直接从表单中获取数据
        int studentID = Integer.parseInt(req.getParameter("studentID"));
        String name = req.getParameter("name");
        int age = Integer.parseInt(req.getParameter("age"));
        String sex = req.getParameter("radio");

        student.setStudentID(studentID);
        student.setName(name);
        student.setAge(age);
        student.setSex(sex);

        new StudentDAO().add(student);
        resp.sendRedirect("ListServlet");  // 这里可以理解为刷新，重新请求
    }
}

@WebServlet(name = "LogoutServlet")
public class LogoutServlet extends HttpServlet {
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException{
        HttpSession session = req.getSession();
        System.out.println("已登录用户为："+session.getAttribute("username"));
        session.removeAttribute("username");
        System.out.println("已退出登录");
        resp.sendRedirect("/login.jsp");
    }
}

        List<Student> students = studentDAO.list(page.getStart(), page.getCount());
        int total = studentDAO.getTotal();
        page.setTotal(total);
        //List<Student> students = studentDAO.list();
        req.setAttribute("students", students);
        req.setAttribute("page", page);
        System.out.println("ListServlet!!");
        req.getRequestDispatcher("/list.jsp").forward(req, resp);
    }
}

@WebServlet(name = "LoginServlet")
public class RegisterServlet extends HttpServlet {
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException{
        String username = req.getParameter("username");
        String password = req.getParameter("password");
        User user = new UserDAO().getUser(username);
        System.out.println(username+"+"+password);
        System.out.println(user.getUsername()+"+"+user.getPassword());
        if (user.getUsername() == null){
            user.setUsername(username);
            user.setPassword(password);
            new UserDAO().addUser(user);
            System.out.println("注册成功！");
            resp.sendRedirect("login.jsp");
        }else {
            req.setAttribute("flag","false");//用户已存在
            req.getRequestDispatcher("/register.jsp").forward(req,resp);
        }

    }
}

    public void init(FilterConfig config) throws ServletException {
    }

    public void destroy() {
    }
}

@WebServlet(name = "LoginServlet")
public class LoginServlet extends HttpServlet {
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException{

        String username = req.getParameter("username");
        String password = req.getParameter("password");
        User user = new UserDAO().getUser(username);

        HttpSession session = req.getSession();

        if (user.getUsername() == null){//若用户不存在
            req.setAttribute("flag","null");
            req.getRequestDispatcher("/login.jsp").forward(req,resp);
        }else {
            if ( password.equals(user.getPassword()) ){
                //登陆成功
                session.setAttribute("username",username);//将用户名用于session域进行权限检查
                System.out.println("登陆成功！session："+session.getAttribute("username"));

                if (username!=null){
                    Cookie c = new Cookie("user",username);
                    c.setMaxAge(60);//有效时间60s
                    resp.addCookie(c);//将Cookie对象保存到客户端
                }

                resp.sendRedirect("/ListServlet");
            }else {
                req.setAttribute("flag","false");
                req.getRequestDispatcher("/login.jsp").forward(req,resp);
            }

    }

    public void destroy() {
    }
}

@WebServlet(name = "LoginServlet")
public class LoginServlet extends HttpServlet {
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException{

        String username = req.getParameter("username");
        String password = req.getParameter("password");
        User user = new UserDAO().getUser(username);

        HttpSession session = req.getSession();

        if (user.getUsername() == null){//若用户不存在
            req.setAttribute("flag","null");
            req.getRequestDispatcher("/login.jsp").forward(req,resp);
        }else {
            if ( password.equals(user.getPassword()) ){
                //登陆成功
                session.setAttribute("username",username);//将用户名用于session域进行权限检查
                System.out.println("登陆成功！session："+session.getAttribute("username"));

                if (username!=null){
                    Cookie c = new Cookie("user",username);
                    c.setMaxAge(60);//有效时间60s
                    resp.addCookie(c);//将Cookie对象保存到客户端
                }

@WebServlet(name = "LogoutServlet")
public class LogoutServlet extends HttpServlet {
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException{
        HttpSession session = req.getSession();
        System.out.println("已登录用户为："+session.getAttribute("username"));
        session.removeAttribute("username");
        System.out.println("已退出登录");
        resp.sendRedirect("/login.jsp");
    }
}

@WebServlet(name = "EditStudent")
public class EditServlet extends HttpServlet {

    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

        int id = Integer.parseInt(req.getParameter("id"));
        Student student = new StudentDAO().get(id);

        req.setAttribute("student", student);
        req.getRequestDispatcher("edit.jsp").forward(req, resp);
    }
}

@WebServlet(name = "DeleteStudent")
public class DeleteServlet extends HttpServlet {

    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

        int id = Integer.parseInt(req.getParameter("id"));
        new StudentDAO().delete(id);

        String username = req.getParameter("username");
        String password = req.getParameter("password");
        User user = new UserDAO().getUser(username);

        HttpSession session = req.getSession();

        if (user.getUsername() == null){//若用户不存在
            req.setAttribute("flag","null");
            req.getRequestDispatcher("/login.jsp").forward(req,resp);
        }else {
            if ( password.equals(user.getPassword()) ){
                //登陆成功
                session.setAttribute("username",username);//将用户名用于session域进行权限检查
                System.out.println("登陆成功！session："+session.getAttribute("username"));

                if (username!=null){
                    Cookie c = new Cookie("user",username);
                    c.setMaxAge(60);//有效时间60s
                    resp.addCookie(c);//将Cookie对象保存到客户端
                }

                resp.sendRedirect("/ListServlet");
            }else {
                req.setAttribute("flag","false");
                req.getRequestDispatcher("/login.jsp").forward(req,resp);
            }
        }
    }
}

@WebServlet(name = "SearchServlet")

@WebServlet(name = "SearchServlet")
public class SearchServlet extends HttpServlet {
    protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String content = request.getParameter("content");
        String type = request.getParameter("type");
        System.out.println("内容为："+content+" 类型为："+type);
        ArrayList<Student> students = new StudentDAO().getStudent(type,content);

        Gson gson = new Gson();
        String json = gson.toJson(students);//解析数据生成Json
        for (Student s : students){
            System.out.println("查询结果："+s.getName()+s.getStudentID());
        }

        response.setCharacterEncoding("UTF-8");
        response.setContentType("application/json");

        System.out.println("JSON："+json);
        PrintWriter out = response.getWriter();
        out.print(json);
        out.flush();
        out.close();
    }
}

}

@WebServlet(name = "LoginServlet")
public class RegisterServlet extends HttpServlet {
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException{
        String username = req.getParameter("username");
        String password = req.getParameter("password");
        User user = new UserDAO().getUser(username);
        System.out.println(username+"+"+password);
        System.out.println(user.getUsername()+"+"+user.getPassword());
        if (user.getUsername() == null){
            user.setUsername(username);
            user.setPassword(password);
            new UserDAO().addUser(user);
            System.out.println("注册成功！");
            resp.sendRedirect("login.jsp");
        }else {
            req.setAttribute("flag","false");//用户已存在
            req.getRequestDispatcher("/register.jsp").forward(req,resp);
        }

    }
}

        resp.sendRedirect("ListServlet");
    }
}

@WebServlet(name = "AddServlet")
public class AddServlet extends HttpServlet {
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

        Student student = new Student();

        // 直接从表单中获取数据
        int studentID = Integer.parseInt(req.getParameter("studentID"));
        String name = req.getParameter("name");
        int age = Integer.parseInt(req.getParameter("age"));
        String sex = req.getParameter("radio");

        student.setStudentID(studentID);
        student.setName(name);
        student.setAge(age);
        student.setSex(sex);

        new StudentDAO().add(student);
        resp.sendRedirect("ListServlet");  // 这里可以理解为刷新，重新请求
    }
}

                chain.doFilter(req, resp);//放行
                return;
            }else{
                // 跳转到登陆页面
                System.out.println("拦截！");
                servletResponse.sendRedirect("/login.jsp");
            }
        } else {
            // 已经登陆,继续此次请求
            chain.doFilter(req, resp);
        }
    }

    public void init(FilterConfig config) throws ServletException {
    }

    public void destroy() {
    }
}

@WebServlet(name = "LoginServlet")
public class LoginServlet extends HttpServlet {
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException{

        String username = req.getParameter("username");
        String password = req.getParameter("password");
        User user = new UserDAO().getUser(username);

        HttpSession session = req.getSession();

        if (user.getUsername() == null){//若用户不存在
            req.setAttribute("flag","null");
            req.getRequestDispatcher("/login.jsp").forward(req,resp);
        }else {
            if ( password.equals(user.getPassword()) ){
                //登陆成功
                session.setAttribute("username",username);//将用户名用于session域进行权限检查
                System.out.println("登陆成功！session："+session.getAttribute("username"));