学生成绩管理系统
一、项目演示
学生成绩管理系统
二、项目介绍
语言: Java 数据库:MySQL
技术栈 : Javaweb + Spring + Servlet + JSP
系统角色:管理员、教师、学生
管理员:登录、个人页面,成绩、学生、教师、课程的添加和查看,查询全部账号信息
教师:登录、个人信息展示,修改个人信息,成绩、学生、课程添加和查看
学生:注册、登录、个人信息展示,修改个人信息,成绩信息查看
三、9000字项目文档
四、部分功能截图
五、部分代码展示
package service.Impl;
import java.util.List;
import dao.Impl.ScoreDaoImpl;
import model.PageBean;
import model.Score;
import model.ScoreCou;
import service.ScoreService;
public class ScoreServiceImpl implements ScoreService{
private ScoreDaoImpl scoreDaoImpl=new ScoreDaoImpl();
public int addScore(Score score) {
int rs=scoreDaoImpl.addScore(score);
return rs;
}
public int deleteScore(int scoreID) {
int rs=scoreDaoImpl.deleteScore(scoreID);
return rs;
}
public int editCos(Score score) {
int rs=scoreDaoImpl.editCos(score);
return rs;
}
public List findAll() {
List rs=scoreDaoImpl.findAll();
return rs;
}
public List findOne(String stuNum) {
List rs=scoreDaoImpl.findOne(stuNum);
return rs;
}
public List selectScore(int scoreID) {
List rs=scoreDaoImpl.selectScore(scoreID);
return rs;
}
public Score selectScoreInfo(Score score) {
Score rs=scoreDaoImpl.selectScoreInfo(score);
return rs;
}
public PageBean scoreListPage(int pageNo, int pageCount, String stuNum) {
PageBean rs=scoreDaoImpl.scoreListPage(pageNo, pageCount, stuNum);
return rs;
}
public PageBean scoreListPage(int pageNo, int pageCount) {
PageBean rs=scoreDaoImpl.scoreListPage(pageNo, pageCount);
return rs;
}
public List findStuOne(String stuNum, String courseName) {
List rs=scoreDaoImpl.findStuOne(stuNum, courseName);
return rs;
}
public double findStuSc(String stuNum) {
double sum=0;
List rs=scoreDaoImpl.findOne(stuNum);
for(int i=0;i<rs.size();i++){
ScoreCou scu=(ScoreCou) rs.get(i);
sum+=scu.getScoreGrade();
}
return sum;
}
public PageBean selectScoreSum(int pageNo, int pageCount) {
PageBean rs=scoreDaoImpl.selectScoreSum(pageNo, pageCount);
return rs;
}
public PageBean selectStuScore(int pageNo, int pageCount, Score score) {
PageBean rs=scoreDaoImpl.selectStuScore(pageNo, pageCount, score);
return rs;
}
public PageBean selectTeaScore(int pageNo, int pageCount, String teaName, Score score) {
PageBean rs=scoreDaoImpl.selectTeaScore(pageNo, pageCount, teaName, score);
return rs;
}
}
package servlet.student;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.springframework.util.StringUtils;
import service.Impl.StudentServiceImpl;
import service.Impl.UserServiceImpl;
import model.Student;
import model.User;
public class ServletRegistersStudent extends HttpServlet{
private User user;
private Student student;
private UserServiceImpl userServiceImpl = new UserServiceImpl();
private StudentServiceImpl studentServiceImpl =new StudentServiceImpl();
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String stuNum = request.getParameter("stuNum");
if(StringUtils.isEmpty(stuNum)) {
request.setAttribute("msg", "学号不能为空!");
request.getRequestDispatcher("register/register.jsp").forward(request, response);
}
String stuName = request.getParameter("stuName");
if(StringUtils.isEmpty(stuName)) {
request.setAttribute("msg", "姓名不能为空!");
request.getRequestDispatcher("register/register.jsp").forward(request, response);
}
String pwd = request.getParameter("password");
if(StringUtils.isEmpty(pwd)) {
request.setAttribute("msg", "密码不能为空!");
request.getRequestDispatcher("register/register.jsp").forward(request, response);
}
String stuSex = request.getParameter("stuSex");
if(StringUtils.isEmpty(stuSex)) {
request.setAttribute("msg", "性别不能为空!");
request.getRequestDispatcher("register/register.jsp").forward(request, response);
}
if(StringUtils.isEmpty(request.getParameter("stuAge"))) {
request.setAttribute("msg", "年龄不能为空!");
request.getRequestDispatcher("register/register.jsp").forward(request, response);
}
int stuAge = Integer.parseInt(request.getParameter("stuAge"));
if(StringUtils.isEmpty(request.getParameter("stuClass"))) {
request.setAttribute("msg", "班级不能为空!");
request.getRequestDispatcher("register/register.jsp").forward(request, response);
}
String stuClass = request.getParameter("stuClass");
if(StringUtils.isEmpty(request.getParameter("major"))) {
request.setAttribute("msg", "专业不能为空!");
request.getRequestDispatcher("register/register.jsp").forward(request, response);
}
String major = request.getParameter("major");
if(StringUtils.isEmpty(request.getParameter("department"))) {
request.setAttribute("msg", "专业不能为空!");
request.getRequestDispatcher("register/register.jsp").forward(request, response);
}
String department = request.getParameter("department");
if(StringUtils.isEmpty(request.getParameter("phone"))) {
request.setAttribute("msg", "手机不能为空!");
request.getRequestDispatcher("register/register.jsp").forward(request, response);
}
String phone = request.getParameter("phone");
int roleID = Integer.parseInt(request.getParameter("role"));
user = new User(stuNum, stuName, pwd, phone, roleID);
student = new Student(stuNum, stuName, stuSex, stuAge, stuClass, major,
department);
int rsUser=userServiceImpl.addUser(user);
int rsStu=studentServiceImpl.addStu(student);
if(rsStu>0 && rsUser>0){
request.setAttribute("massage", "注册成功!!");
request.getRequestDispatcher("login/login.jsp").forward(request, response);
}else{
request.setAttribute("msg", "注册失败!!");
request.getRequestDispatcher("register/register.jsp").forward(request, response);
}
}
}
package servlet;
import java.io.IOException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import service.Impl.CourseServiceImpl;
import dao.Impl.CourseDaoImpl;
import model.Course;
import model.Student;
import model.User;
public class ServletaddCourse extends HttpServlet{
private Course course;
private ServletFindAllCos servletFindAllCos=new ServletFindAllCos();
private CourseServiceImpl courseServiceImpl=new CourseServiceImpl();
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
if(request.getParameter("courseName").isEmpty()
|| request.getParameter("courseCredit").isEmpty()
|| request.getParameter("courseHours").isEmpty()
|| request.getParameter("courseTea").isEmpty()
|| request.getParameter("courseDate").isEmpty()){
request.setAttribute("msg", "请填写全部字段!!");
request.getRequestDispatcher("admin/addCourse.jsp").forward(request, response);
}
String courseName = request.getParameter("courseName");
int courseCredit = Integer.parseInt(request.getParameter("courseCredit"));
int courseHours = Integer.parseInt(request.getParameter("courseHours"));
String courseTea = request.getParameter("courseTea");
String coDate = request.getParameter("courseDate");
Date courseDate=null;
try {
courseDate = new SimpleDateFormat("yyyy-MM-dd").parse(request.getParameter("courseDate"));
} catch (ParseException e) {
e.printStackTrace();
}
// System.out.println(courseDate);
course=new Course(courseName,courseCredit,courseHours,courseTea,courseDate);
//new Course( courseName, courseCredit, courseHours,
// courseTea, courseDate);
//验证是否存在该教师课程
Course cos=courseServiceImpl.selectOneCos(course);
if(cos==null){
int rs=courseServiceImpl.addCos(course,coDate);
if(rs>0){
request.setAttribute("msg", "添加成功!!");
servletFindAllCos.doGet(request, response);
// request.getRequestDispatcher("admin/addCourse.jsp").forward(request, response);
}else{
request.setAttribute("msg", "添加失败!!");
request.getRequestDispatcher("admin/addCourse.jsp").forward(request, response);
}
}else{
request.setAttribute("msg", "该课程已录入,请重新输入!!");
request.getRequestDispatcher("admin/addCourse.jsp").forward(request, response);
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
package servlet;
import java.io.IOException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import service.Impl.ScoreServiceImpl;
import dao.Impl.ScoreDaoImpl;
import model.Score;
public class ServletaddScore extends HttpServlet{
private Score score;
private ServletFindAllScore servletFindAllScore=new ServletFindAllScore();
private ScoreServiceImpl scoreServiceImpl=new ScoreServiceImpl();
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
if(request.getParameter("stuNum").isEmpty()
|| request.getParameter("stuName").isEmpty()
|| request.getParameter("stuClass").isEmpty()
|| request.getParameter("courseName").isEmpty()
|| request.getParameter("scoreGrade").isEmpty()
|| request.getParameter("major").isEmpty()
){
request.setAttribute("msg", "请填写全部字段!!");
request.getRequestDispatcher("admin/addScore.jsp").forward(request, response);
}
String stuNum = request.getParameter("stuNum");
String stuName = request.getParameter("stuName");
String stuClass = request.getParameter("stuClass");
String courseName = request.getParameter("courseName");
double scoreGrade=Double.parseDouble(request.getParameter("scoreGrade"));
String major = request.getParameter("major");
score=new Score(stuNum,stuName,stuClass,courseName,scoreGrade,major);
Score scor=scoreServiceImpl.selectScoreInfo(score);
if(scor==null){
int rs=scoreServiceImpl.addScore(score);
if(rs>0){
request.setAttribute("msg", "添加成功!!");
servletFindAllScore.doGet(request, response);
// request.getRequestDispatcher("admin/addCourse.jsp").forward(request, response);
}else{
request.setAttribute("msg", "添加失败!!");
request.getRequestDispatcher("admin/addScore.jsp").forward(request, response);
}
}else{
request.setAttribute("msg", "该生的本门课成绩已录入,请重新录入!!");
request.getRequestDispatcher("admin/addScore.jsp").forward(request, response);
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
package servlet;
import java.io.IOException;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import service.Impl.StudentServiceImpl;
import service.Impl.UserServiceImpl;
import model.Student;
import model.User;
public class ServletaddStudent extends HttpServlet {
private User user;
private Student student;
private UserServiceImpl userServiceImpl = new UserServiceImpl();
private StudentServiceImpl studentServiceImpl =new StudentServiceImpl();
private ServletFindAllStu findStu=new ServletFindAllStu();
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
if(request.getParameter("stuNum").isEmpty()
|| request.getParameter("stuName").isEmpty()
|| request.getParameter("password").isEmpty()
|| request.getParameter("stuSex").isEmpty()
|| request.getParameter("stuAge").isEmpty()
|| request.getParameter("stuClass").isEmpty()
|| request.getParameter("major").isEmpty()
|| request.getParameter("department").isEmpty()
|| request.getParameter("phone").isEmpty()
){
request.setAttribute("msg", "请填写全部字段!!");
request.getRequestDispatcher("admin/addStudent.jsp").forward(request, response);
}
String stuNum = request.getParameter("stuNum");
String stuName = request.getParameter("stuName");
String pwd = request.getParameter("password");
String stuSex = request.getParameter("stuSex");
int stuAge = Integer.parseInt(request.getParameter("stuAge"));
String stuClass = request.getParameter("stuClass");
String major = request.getParameter("major");
String department = request.getParameter("department");
String phone = request.getParameter("phone");
int roleID = Integer.parseInt(request.getParameter("role"));
user = new User(stuNum, stuName, pwd, phone, roleID);
student = new Student(stuNum, stuName, stuSex, stuAge, stuClass, major,
department);
//验证是否存在该学生
User rs=userServiceImpl.login(user);
if(rs.getUserID()==0){
int rsUser=userServiceImpl.addUser(user);
int rsStu=studentServiceImpl.addStu(student);
if(rsStu>0 && rsUser>0){
request.setAttribute("msg", "添加成功!!");
findStu.doGet(request, response);
/*List list=studentDaoImpl.findAll();
request.setAttribute("list", list);
request.getRequestDispatcher("admin/studentAllInfo.jsp").forward(request, response);*/
}else{
request.setAttribute("msg", "添加失败!!");
request.getRequestDispatcher("admin/addStudent.jsp").forward(request, response);
}
}else{
request.setAttribute("msg", "该学号已存在,请重新录入!!");
request.getRequestDispatcher("admin/addStudent.jsp").forward(request, response);
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
六、底部获取项目源码带9000字文档(9.9¥带走)
有问题,或者需要协助调试运行项目的也可以