基于MySQL，servlet，jsp简单的作业管理系统

一、数据库设计
这里设计三张数据表分别来存储学生信息，作业信息，以及学生提交作业的新信息。



二、代码展示
controller，servlet方法

package com.controller;

import com.dao.AssignmentInfoDao;
import com.model.AssignmentInfo;

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.util.Date;

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

        req.setCharacterEncoding("utf-8");

        AssignmentInfo ass = new AssignmentInfo();
        ass.setId(Long.parseLong(req.getParameter("id")));
        ass.setQuestion(req.getParameter("question"));
        Date date = new Date();
        ass.setReleaseTime(date);

        boolean res = AssignmentInfoDao.addAssignmentInfo(ass);

        req.setAttribute("isOK",res);
        req.setAttribute("type","addAssignment");
        req.getRequestDispatcher("result.jsp").forward(req,resp);
    }
}

package com.controller;

import com.dao.StudentInfoDao;
import com.model.StudentInfo;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;

public class A