基于SSM的教务管理系统设计与实现（附源码下载地址）

JDK1.8 + Maven3.6.3 + MySQL5.7 + Tomcat9.0

package com.cya.controller;

import org.apache.shiro.SecurityUtils;
import org.apache.shiro.authc.UsernamePasswordToken;
import org.apache.shiro.subject.Subject;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;

import com.cya.entity.Userlogin;

/**
 * @author 公众号【IT学长】
 * @version 微信搜索“IT学长”,30多套项目源码、百G Java大厂面试题免费领取 2022-10-6
 */

@Controller
public class LoginController {

 // 登录跳转
 @RequestMapping(value = "/login", method = { RequestMethod.GET })
 public String loginUI() throws Exception {
  return "../../login";
 }

 // 登录表单处理
 @RequestMapping(value = "/login", method = { RequestMethod.POST })
 public String login(Userlogin userlogin) throws Exception {

  // Shiro实现登录
  UsernamePasswordToken token = new UsernamePasswordToken(userlogin.getUsername(), userlogin.getPassword());
  Subject subject = SecurityUtils.getSubject();

  subject.login(token);

  if (subject.hasRole("admin")) {
   return "redirect:/admin/index";
  } else if (subject.hasRole("teacher")) {
   return "redirect:/teacher/index";
  } else if (subject.hasRole("student")) {
   return "redirect:/student/index";
  }

  return "/login";
 }

}

package com.cya.service.impl;

import com.cya.entity.*;
import com.cya.mapper.CollegeMapper;
import com.cya.mapper.CourseMapper;
import com.cya.mapper.CourseMapperCustom;
import com.cya.mapper.SelectedcourseMapper;
import com.cya.service.CourseService;

import org.apache.commons.beanutils.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * @author 公众号【IT学长】
 * @version 微信搜索“IT学长”,30多套项目源码、百G Java大厂面试题免费领取 2022-10-6
 */

@Service
public class CourseServiceImpl implements CourseService {

 @Autowired
 private CourseMapper courseMapper;

 @Autowired
 private CourseMapperCustom courseMapperCustom;

 @Autowired
 private CollegeMapper collegeMapper;

 @Autowired
 private SelectedcourseMapper selectedcourseMapper;

 public void upadteById(Integer id, CourseCustom courseCustom) throws Exception {
  courseMapper.updateByPrimaryKey(courseCustom);
 }

 public Map<String, Object> removeById(Integer id) throws Exception {

  Map<String, Object> resMap = new HashMap<String, Object>();
  // 自定义查询条件
  SelectedcourseExample example = new SelectedcourseExample();
  SelectedcourseExample.Criteria criteria = example.createCriteria();
  criteria.andCourseidEqualTo(id);
  criteria.andMarkIsNull();
  List<Selectedcourse> list = selectedcourseMapper.selectByExample(example);

  if (list.size() == 0) {
   courseMapper.deleteByPrimaryKey(id);
   resMap.put("status", true);
   resMap.put("message", "删除成功");
  } else {
   List<String> tempList = new ArrayList<String>();
   for (Selectedcourse selectedcourse : list) {
    tempList.add(selectedcourse.getStudentid().toString());
   }
   // 根据课程号查授课教师
   Course course = courseMapper.selectByPrimaryKey(id);
   resMap.put("status", false);
   resMap.put("message", tempList);
   if (course != null) {
    resMap.put("teacherID", course.getTeacherid());
   }
  }

  return resMap;
 }

 public List<CourseCustom> findByPaging(Integer toPageNo) throws Exception {
  PagingVO pagingVO = new PagingVO();
  pagingVO.setToPageNo(toPageNo);

  List<CourseCustom> list = courseMapperCustom.findByPaging(pagingVO);
  return list;
 }

 public Boolean save(CourseCustom couseCustom) throws Exception {
  Course course = courseMapper.selectByPrimaryKey(couseCustom.getCourseid());
  if (course == null) {
   courseMapper.insert(couseCustom);
   return true;
  }
  return false;
 }

 public int getCountCouse() throws Exception {
  // 自定义查询对象
  CourseExample courseExample = new CourseExample();
  // 通过criteria构造查询条件
  CourseExample.Criteria criteria = courseExample.createCriteria();
  criteria.andCoursenameIsNotNull();

  return courseMapper.countByExample(courseExample);
 }

 public CourseCustom findById(Integer id) throws Exception {
  Course course = courseMapper.selectByPrimaryKey(id);
  CourseCustom courseCustom = null;
  if (course != null) {
   courseCustom = new CourseCustom();
   BeanUtils.copyProperties(courseCustom, course);
  }

  return courseCustom;
 }

 public List<CourseCustom> findByName(String name, Integer teacherId) throws Exception {
  CourseExample courseExample = new CourseExample();
  // 自定义查询条件
  CourseExample.Criteria criteria = courseExample.createCriteria();

  criteria.andCoursenameLike("%" + name + "%");

  if (teacherId != null) {
   criteria.andTeacheridEqualTo(teacherId);
  }

  List<Course> list = courseMapper.selectByExample(courseExample);

  List<CourseCustom> courseCustomList = null;

  if (list != null) {
   courseCustomList = new ArrayList<CourseCustom>();
   for (Course c : list) {
    CourseCustom courseCustom = new CourseCustom();
    // 类拷贝
    org.springframework.beans.BeanUtils.copyProperties(c, courseCustom);
    // 获取课程名
    College college = collegeMapper.selectByPrimaryKey(c.getCollegeid());
    courseCustom.setcollegeName(college.getCollegename());

    courseCustomList.add(courseCustom);
   }
  }

  return courseCustomList;
 }

 public List<CourseCustom> findByTeacherID(Integer id) throws Exception {
  CourseExample courseExample = new CourseExample();
  // 自定义查询条件
  CourseExample.Criteria criteria = courseExample.createCriteria();
  // 根据教师id查课程
  criteria.andTeacheridEqualTo(id);

  List<Course> list = courseMapper.selectByExample(courseExample);
  List<CourseCustom> courseCustomList = null;

  if (list.size() > 0) {
   courseCustomList = new ArrayList<CourseCustom>();
   for (Course c : list) {
    CourseCustom courseCustom = new CourseCustom();
    // 类拷贝
    BeanUtils.copyProperties(courseCustom, c);
    // 获取课程名
    College college = collegeMapper.selectByPrimaryKey(c.getCollegeid());
    courseCustom.setcollegeName(college.getCollegename());

    courseCustomList.add(courseCustom);
   }
  }

  return courseCustomList;
 }
}

 //查询个人信息
    @RequestMapping(value = "/teacherInfo")
    public String teacherInfo(Model model) throws Exception {
     
     Subject subject = SecurityUtils.getSubject();
        String username = (String) subject.getPrincipal();
        TeacherCustom teacherCustom = teacherService.findById(Integer.parseInt(username));
        
        if (teacherCustom == null) {
            throw new CustomException("未找到此教师信息") ;
        }
        model.addAttribute("teacher", teacherCustom);

        return "teacher/teacherInfo";
    }

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.cya.mapper.NoticeMapper">

 <resultMap id="BaseResultMap" type="com.cya.entity.Notice">
  <id column="id" property="id" jdbcType="INTEGER" />
  <result column="title" property="title" jdbcType="VARCHAR" />
  <result column="date" property="date" jdbcType="TIMESTAMP" />
  <result column="content" property="content"
   jdbcType="LONGVARCHAR" />
  <result column="type" property="type" jdbcType="VARCHAR" />
 </resultMap>

 <sql id="Example_Where_Clause">
  <where>
   <foreach collection="oredCriteria" item="criteria"
    separator="or">
    <if test="criteria.valid">
     <trim prefix="(" suffix=")" prefixOverrides="and">
      <foreach collection="criteria.criteria" item="criterion">
       <choose>
        <when test="criterion.singleValue">
         and ${criterion.condition} #{criterion.value}
        </when>
        <when test="criterion.betweenValue">
         and ${criterion.condition} #{criterion.value} and
         #{criterion.secondValue}
        </when>
        <when test="criterion.listValue">
         and ${criterion.condition}
         <foreach collection="criterion.value" item="listItem"
          open="(" close=")" separator=",">
          #{listItem}
         </foreach>
        </when>
       </choose>
      </foreach>
     </trim>
    </if>
   </foreach>
  </where>
 </sql>

 <sql id="Base_Column_List">
  id, title, date, content, type
 </sql>

 <select id="selectByExample" resultMap="BaseResultMap"
  parameterType="com.cya.entity.NoticeExample">
  select
  <if test="distinct">
   distinct
  </if>
  <include refid="Base_Column_List" />
  from notice
  <if test="_parameter != null">
   <include refid="Example_Where_Clause" />
  </if>
  <if test="orderByClause != null">
   order by ${orderByClause}
  </if>
 </select>

 <select id="selectByPrimaryKey" resultMap="BaseResultMap"
  parameterType="java.lang.Integer">
  select
  <include refid="Base_Column_List" />
  from notice
  where id = #{id,jdbcType=INTEGER}
 </select>


 <delete id="deleteByPrimaryKey"
  parameterType="java.lang.Integer">
  delete from notice
  where id = #{id,jdbcType=INTEGER}
 </delete>

 <insert id="insert" parameterType="com.cya.entity.Notice">
  insert into notice (id, title, date, content, type)
  values (
  #{id,jdbcType=INTEGER},
  #{title,jdbcType=VARCHAR},
  #{date,jdbcType=TIMESTAMP},
  #{content,jdbcType=LONGVARCHAR},
  #{type,jdbcType=VARCHAR}
  )
 </insert>
 <insert id="insertSelective"
  parameterType="com.cya.entity.Notice">
  insert into notice
  <trim prefix="(" suffix=")" suffixOverrides=",">
   <if test="id != null">
    id,
   </if>
   <if test="title != null">
    title,
   </if>
   <if test="date != null">
    date,
   </if>
   <if test="content != null">
    content,
   </if>
   <if test="type != null">
    type,
   </if>
  </trim>
  <trim prefix="values (" suffix=")" suffixOverrides=",">
   <if test="id != null">
    #{id,jdbcType=INTEGER},
   </if>
   <if test="title != null">
    #{title,jdbcType=VARCHAR},
   </if>
   <if test="date != null">
    #{date,jdbcType=TIMESTAMP},
   </if>
   <if test="content != null">
    #{content,jdbcType=LONGVARCHAR},
   </if>
   <if test="type != null">
    #{type,jdbcType=VARCHAR},
   </if>
  </trim>
 </insert>

 <select id="countByExample"
  parameterType="com.cya.entity.NoticeExample"
  resultType="java.lang.Integer">
  select count(*) from notice
  <if test="_parameter != null">
   <include refid="Example_Where_Clause" />
  </if>
 </select>

 <update id="updateByPrimaryKeySelective"
  parameterType="com.cya.entity.Notice">
  update notice
  <set>
   <if test="title != null">
    title = #{title,jdbcType=VARCHAR},
   </if>
   <if test="date != null">
    date = #{date,jdbcType=TIMESTAMP},
   </if>
   <if test="content != null">
    content = #{content,jdbcType=LONGVARCHAR},
   </if>
   <if test="type != null">
    type = #{type,jdbcType=VARCHAR},
   </if>
  </set>
  where id = #{id,jdbcType=INTEGER}
 </update>
 <update id="updateByPrimaryKey"
  parameterType="com.cya.entity.Notice">
  update notice
  set title = #{title,jdbcType=VARCHAR},
  date = #{date,jdbcType=TIMESTAMP},
  content = #{content,jdbcType=LONGVARCHAR},
  type = #{type,jdbcType=VARCHAR}
  where id = #{id,jdbcType=INTEGER}
 </update>
</mapper>