学生选课系统带数据库 SSM

package com.zxc.service.impl; import com.zxc.dao.CourseDao; import com.zxc.dao.UserDao; import com.zxc.model.*; import com.zxc.service.CourseService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.util.ArrayList; import java.util.List; @Service public class CourseServiceImpl implements CourseService { @Autowired private CourseDao courseDao; @Autowired private UserDao userDao; @Override public List<Course> queryAllById(int id,int stuid) { List<Course> course_list= courseDao.queryCourseById(id); List<Integer> stu_courselist=courseDao.queryCourseIdByStuId(stuid); for(Course c:course_list){ c.setIsChoose(0); for(int i:stu_courselist){ if(c.getClassId()==i){ c.setIsChoose(1); break; } } c.setTeaName(courseDao.selectTeaNameByTeaId(id)); c.setClassLimitInsName(new ArrayList<>()); List<Integer> limit_list=courseDao.selectInsIdByClassId(c.getClassId()); for(Integer i:limit_list){ c.getClassLimitInsName().add(courseDao.selectNameByInsId(i)); } } return course_list; } @Override public List<String> queryInsNameByCourse(int id) { List<String> insNameList=new ArrayList<>(); List<Integer> insIdList=courseDao.queryInsIdByCourseId(id); for(int i:insIdList){ insNameList.add(courseDao.selectNameByInsId(i)); } return insNameList; } @Override public List<Institution> queryAllIns() { return courseDao.queryAllIns(); } @Override public int insertCourse(String name,String num,int teaid) { Course course=new Course(); course.setClassName(name); course.setClassNum(Integer.parseInt(num)); course.setClassChooseNum(0); course.setTeaId(teaid); courseDao.insertCourse(course); return course.getClassId(); } @Override public void insertInsLimit(String det,int classId) { String[] insList=det.split(","); for(String in:insList){ Course_limit course_limit=new Course_limit(); course_limit.setClassId(classId); course_limit.setInsId(Integer.parseInt(in)); courseDao.insertInsLimit(course_limit); } } @Override public Course queryInfoById(int id) { return courseDao.queryCourseInfoById(id); } @Override public List<Integer> selectCourseLimit(int classId) { return courseDao.selectCourseLimit(classId); } @Override public int updateCourse(String name,String num,int teaid,String id) { Course course=new Course(); course.setTeaId(teaid); course.setClassChooseNum(0); course.setClassNum(Integer.parseInt(num)); course.setClassName(name); course.setClassId(Integer.parseInt(id)); courseDao.updateCourse(course); return course.getClassId(); } @Override public void updateInsLimit(String det, int classId) { String[] insList=det.split(","); courseDao.deleteInsLimit(classId); for(String ins:insList){ Course_limit course_limit=new Course_limit(); course_limit.setClassId(classId); course_limit.setInsId(Integer.parseInt(ins)); courseDao.insertInsLimit(course_limit); } } @Override public void deleteCourse(int id) { courseDao.deleteCourseById(id); //解除选课表关联 courseDao.deleteStuByClassId(id); //解除学院限制表关联 courseDao.deleteLimitByClassId(id); } @Override public List<Student> queryStuByCourseId(int id) { List<Student> stu_list=new ArrayList<>(); List<Course_choose> id_list=courseDao.queryStuIdByCourseId(id); for(Course_choose i:id_list){ Student student=userDao.selectStuById(i.getStuId()); student.setTempScore(i.getScore()); student.setClassName(courseDao.selectCourseByClassId(id).getClassName()); stu_list.add(student); } return stu_list; } @Override public void updateScore(int classId, int stuId, int score) { Course_choose course_choose=new Course_choose(); course_choose.setStuId(stuId); course_choose.setClassId(classId); course_choose.setScore(score); courseDao.updateScore(course_choose); } @Override public List<Student> queryStuByStuId(int classid, int stuid) { List<Student> stu_list=new ArrayList<>(); List<Course_choose> id_list=courseDao.queryStuIdByCourseId(classid); for(Course_choose i:id_list){ Student student=userDao.selectStuById(i.getStuId()); student.setTempScore(i.getScore()); if(student.getStuId()==stuid){ stu_list.add(student); } } return stu_list; } @Override public List<Course> queryAllCourse(int stuid){ List<Course> course_list= courseDao.queryAllCourse(); List<Integer> stu_courselist=courseDao.queryCourseIdByStuId(stuid); for(Course c:course_list){ c.setClassLimitInsName(new ArrayList<>()); List<Integer> limit_list=courseDao.selectInsIdByClassId(c.getClassId()); for(Integer i:limit_list){ c.getClassLimitInsName().add(courseDao.selectNameByInsId(i)); } c.setTeaName(courseDao.selectTeaNameByTeaId(c.getTeaId())); c.setIsChoose(0); for(int i:stu_courselist){ if(c.getClassId()==i){ c.setIsChoose(1); break; } } } return course_list; } @Override public Course queryCourse(int id) { Course course=courseDao.selectCourseByClassId(id); List<Integer> limit_list=courseDao.selectInsIdByClassId(id); course.setClassLimitInsName(new ArrayList<>()); for(Integer i:limit_list){ course.getClassLimitInsName().add(courseDao.selectNameByInsId(i)); } course.setTeaName(courseDao.selectTeaNameByTeaId(course.getTeaId())); return course; } @Override public void chooseSuccess(int classId, int stuId) { courseDao.addChooseNum(classId); Course_choose course_choose=new Course_choose(); course_choose.setScore(0); course_choose.setClassId(classId); course_choose.setStuId(stuId); courseDao.addCourseChoose(course_choose); } @Override public boolean checkStuIns(int classId, int stuId) { int stu_insId=userDao.selectStuById(stuId).getInsId(); List<Integer> class_insId=courseDao.queryInsIdByCourseId(classId); for(int i:class_insId){ if(stu_insId==i) return true; } return false; } @Override public void deleteCourseChoose(int stuId, int classId) { courseDao.downChooseNum(classId); Course_choose course_choose=new Course_choose(); course_choose.setStuId(stuId); course_choose.setClassId(classId); courseDao.deleteCourseChoose(course_choose); } @Override public List<Course> queryStuCourse(int stuId) { List<Integer> classid_list=courseDao.queryCourseIdByStuId(stuId); List<Course> course_list=new ArrayList<>(); for(int i:classid_list){ Course course=courseDao.queryCourseInfoById(i); course.setTeaName(courseDao.selectTeaNameByTeaId(course.getTeaId())); Course_choose course_choose=new Course_choose(); course_choose.setClassId(i); course_choose.setStuId(stuId); course.setScore(courseDao.selectScore(course_choose)); course_