登陆页面
注册
学生信息查询
学生信息增加
学生信息删除
学生成绩增加
学生成绩删除
学生成绩查询
学生信息综合查询
学生信息单独查询
用户管理
登陆页面
技术描述
开发工具: Idea/Eclipse
数据库: mysql
Jar包仓库: Jar包
前段框架:jquery/Jsp
后端框架: Jsp/Servlet
资料说明
基于JSP+Servlet+MySQL+Layui的高校学生信息管理系统,包含管理员角色。整体功能包含学生信息增加,学生信息删除,学生信息修改,学生信息查询,学生成绩增加,学生成绩修改,学生成绩删除,学生信息综合查询,用户管理等。
package controller;
import domain.Student;
import domain.StudentAllInfo;
import service.StudentAllInfoService;
import service.impl.StudentAllInfoServiceImpl;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.List;
@WebServlet(name = "studentAllInfoServlet",urlPatterns = {"/studentAllInfo"})
public class StudentAllInfoServlet extends BaseServlet{
private StudentAllInfoService studentAllInfoService=new StudentAllInfoServiceImpl();
public void studentAllInfo(HttpServletRequest request, HttpServletResponse response) throws Exception{
List<StudentAllInfo> studentAllInfoList = studentAllInfoService.studentAllInfo();
System.out.println(studentAllInfoList);
if (studentAllInfoList != null) {
request.setAttribute("studentAllInfoList", studentAllInfoList);
} else {
request.setAttribute("msg", "无数据");
}
request.getRequestDispatcher("/pages/studentAllInfo/studentAllInfo.jsp").forward(request, response);
}
public void findStudentAllInfoById(HttpServletRequest request, HttpServletResponse response) throws Exception {
String id=request.getParameter("id");
StudentAllInfo studentAllInfo = studentAllInfoService.findStudentAllInfoById(id);
if (studentAllInfo!=null) {
request.setAttribute("student",studentAllInfo);
} else {
request.setAttribute("stuMsgError","查询失败,可能无id");
}
request.getRequestDispatcher("/pages/studentAllInfo/singleStudentInfo.jsp").forward(request, response);
}
}
package service;
import domain.Student;
import java.util.List;
public interface StudentService {
List<Student> queryAllStudent();
int insertStudentInfo(Student student);
int delStudentInfo(String id);
int updateStudentInfo(Student student);
Student findStudentInfoById(String id);
}