• Java项目：springboot在线选课系统

    作者主页：夜未央5788

     简介：Java领域优质创作者、Java项目、学习资料、技术互助

    文末获取源码

    项目介绍

    后端技术包含springboot+mybatis+spring security+mysql+redis

    前端技术包含 semanticUI + thymeleaf模板引擎

    使用教程

    1.  下载项目之后 等待maven安装对应jar包
    2.  自行下载redis 并按照资源包下的application.yml要求进行配置

    3.  自行安装MySQL数据库 执行资源包下的sql文件

    使用说明

    1.  运行redis服务器
    2.  启动项目
    3.  访问localhost:8080

    4.  用户名：admin  密码：admin

    注意事项

    若导出信息时报错，则需要设置mysql,设置方式如下：

    SELECT @@sql_mode; 查看是否包含ONLY_FULL_GROUP_BY；若包含，则执行以下命令：

    SET GLOBAL sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

    SET SESSION sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

    执行完成后，再通过SELECT @@sql_mode; 来查看；
     

    注意：该方法仅用于临时修改，重启mysql后，以上设置失效。

    运行截图

     

     

     

     

     

     

    代码相关

    学生选课接口

    1. @RestController
    2. @RequestMapping("usercourse")
    3. @Api
    4. public class UserCourseController{
    5.  
    6.     @Autowired
    7.     UserCourseService userCourseService;
    8.     @Autowired
    9.     SelectableCourseDAO selectableCourseDAO;
    10.  
    11.     /**
    12.      * 选课
    13.      * @param courseId
    14.      * @param username
    15.      * @return
    16.      */
    17.     @PostMapping("choose")
    18.     @PreAuthorize("hasAuthority('student')")
    19.     public Object chooseCourse(@RequestParam("courseId") Integer courseId ,
    20.                                @RequestParam("username") String username){
    21.         Map map = new HashMap<>();
    22.         try{
    23.             return userCourseService.chooseCourse(courseId , username);
    24.         }catch(Exception e){
    25.             if(e instanceof DataIntegrityViolationException){
    26.                 map.put("msg","该课程已经被抢完啦。");
    27.             }else{
    28.                 map.put("msg","出现其他异常,选课失败!");
    29.             }
    30.             map.put("flag",false);
    31.             return JSON.toJSON(map);
    32.         }
    33.     }
    34.  
    35.     /**
    36.      * 退课
    37.      * @param courseId
    38.      * @param username
    39.      * @return
    40.      */
    41.     @PostMapping("cancel")
    42.     @PreAuthorize("hasAuthority('student')")
    43.     public Object cancelCourse(@RequestParam("courseId") Integer courseId ,
    44.                                @RequestParam("username") String username){
    45.         return userCourseService.cancelCourse(courseId,username);
    46.     }
    47.  
    48.     /**
    49.      * 获取学生所选全部课程
    50.      * @param page
    51.      * @param limit
    52.      * @param username
    53.      * @return
    54.      */
    55.     @PostMapping("studentInfo")
    56.     @PreAuthorize("hasAuthority('admin') or hasAuthority('student')")
    57.     public Object studentInfo(@RequestParam(value = "page", defaultValue = "1") int page ,
    58.                               @RequestParam(value = "limit", defaultValue = "10") int limit ,
    59.                               @RequestParam("username")String username){
    60.         try{
    61.             Map map = new HashMap<>();
    62.             PageHelper.startPage(page , limit);
    63.             List list = selectableCourseDAO.selectByUser(username);
    64.             if(list == null){
    65.                 return Msg.fail();
    66.             }
    67.             //System.out.println("=="+username+"==");
    68.             PageInfo pageInfo = new PageInfo<>(list);
    69.             map.put("totalPage" , pageInfo.getPages());  //总页数
    70.             map.put("totalCount" , pageInfo.getTotal());  //总条数
    71.             map.put("currentPage" , page);  //当前页数。
    72.             map.put("data" , pageInfo.getList()); //获得的数据量
    73.             map.put("tCase",username);
    74.             return JSON.toJSON(map);
    75.         }catch(Exception e){
    76.             e.printStackTrace();
    77.             return Msg.fail();
    78.         }
    79.     }
    80.     
    81.     //测试。
    82.     @PostMapping("cc")
    83.     public Object cc(){
    84.         Map map = new HashMap<>();
    85.         try{
    86.             selectableCourseDAO.updateMinCourseStock(1);
    87.             return true;
    88.         }catch(Exception e){
    89.             if(e instanceof DataIntegrityViolationException){
    90.                 map.put("msg","该课程已经被抢完啦。");
    91.             }else{
    92.                 map.put("msg","出现其他异常,选课失败!");
    93.             }
    94.             map.put("flag",false);
    95.             return JSON.toJSON(map);
    96.         }
    97.     }
    98. }

    课程检索接口

    1. @RestController
    2. @RequestMapping("/course")
    3. @Api
    4. public class SelectableCourseController{
    5.  
    6.     @Autowired
    7.     SelectableCourseService selectableCourseService;
    8.  
    9.     /**
    10.      * 获得全部课程
    11.      * @param page
    12.      * @param limit
    13.      * @param username
    14.      * @return
    15.      */
    16.     @PostMapping("/getAll")
    17.     public Object getAll(@RequestParam(value = "page", defaultValue = "1") int page ,
    18.                          @RequestParam(value = "limit", defaultValue = "10") int limit ,
    19.                          @RequestParam(value = "username", required = false) String username){
    20.         
    21.         return selectableCourseService.selectAll(page,limit,username);
    22.     }
    23.  
    24.     /**
    25.      * 根据课程类别搜索课程
    26.      * @param page
    27.      * @param limit
    28.      * @param username
    29.      * @param type
    30.      * @return
    31.      */
    32.     @PostMapping("/getCourseByType")
    33.     public Object getCourseByType(@RequestParam(value = "page", defaultValue = "1") int page ,
    34.                                   @RequestParam(value = "limit", defaultValue = "10") int limit ,
    35.                                   @RequestParam(value = "username", required = false) String username ,
    36.                                   @RequestParam("courseType") String type){
    37.         return  selectableCourseService.selectCoursesByType(page,limit,type , username);
    38.     }
    39.  
    40.     /**
    41.      * 根据课程所属学院名称搜索课程
    42.      * @param page
    43.      * @param limit
    44.      * @param username
    45.      * @param name
    46.      * @return
    47.      */
    48.     @PostMapping("/getCourseByCollege")
    49.     public Object getCourseByCollege(@RequestParam(value = "page", defaultValue = "1") int page ,
    50.                                      @RequestParam(value = "limit", defaultValue = "10") int limit ,
    51.                                      @RequestParam(value = "username", required = false) String username ,
    52.                                      @RequestParam("college") String name){
    53.         return selectableCourseService.selectCoursesByCollege(page,limit,name , username);
    54.     }
    55.  
    56.     /**
    57.      * 根据课程名称模糊搜索课程
    58.      * @param page
    59.      * @param limit
    60.      * @param username
    61.      * @param courseName
    62.      * @return
    63.      */
    64.     @PostMapping("selectByCourseName")
    65.     public Object selectByCourseName(@RequestParam(value = "page", defaultValue = "1") int page ,
    66.                                      @RequestParam(value = "limit", defaultValue = "10") int limit ,
    67.                                      @RequestParam(value = "username", required = false) String username ,
    68.                                      @RequestParam("courseName") String courseName){
    69.         return selectableCourseService.selectByCourseName(page,limit,courseName , username);
    70.     }
    71.  
    72.     /**
    73.      * 根据课程剩余人数查找课程
    74.      * @param page
    75.      * @param limit
    76.      * @param username
    77.      * @param count
    78.      * @return
    79.      */
    80.     @PostMapping("selectCourseByMemberCount")
    81.     public Object selectByMemberCount(@RequestParam(value = "page", defaultValue = "1") int page ,
    82.                                       @RequestParam(value = "limit", defaultValue = "10") int limit ,
    83.                                       @RequestParam(value = "username", required = false) String username ,
    84.                                       @RequestParam("count") Integer count){
    85.         return selectableCourseService.selectCoursesByMemberCount(page,limit,count,username);
    86.     }
    87.  
    88.     /**
    89.      * 隐藏课程
    90.      * @param courseId
    91.      * @return
    92.      */
    93.     @PostMapping("hideBatch")
    94.     @PreAuthorize("hasAuthority('admin')")
    95.     public Object hideBatch(Integer courseId){
    96.         try{
    97.             return selectableCourseService.hideBatch(courseId);
    98.         }catch(Exception e){
    99.             return Msg.msg("操作异常!");
    100.         }
    101.     }
    102.  
    103.     @PostMapping("/addCourseByAdmin")
    104.     @PreAuthorize("hasAuthority('admin')")
    105.     public Object addCourse(@RequestParam("courseName")String courseName,
    106.                             @RequestParam("courseType")String courseType,
    107.                             @RequestParam("collegeId")Integer collegeId,
    108.                             @RequestParam("teacher")String teacher,
    109.                             @RequestParam("score")Integer score,
    110.                             @RequestParam("stock")Integer stock,
    111.                             @RequestParam("address")String address,
    112.                             @RequestParam(value = "description",defaultValue = "")String description){
    113.         try{
    114.             return selectableCourseService.addCourse(courseName,collegeId,courseType,teacher,score,stock,address,description);
    115.         }catch(Exception e){
    116.             e.printStackTrace();
    117.             return Msg.msg("出现异常,添加课程失败!");
    118.         }
    119.     }
    120. }

    管理员接口

    1. @Controller
    2. @Api
    3. public class AdminController{
    4.  
    5.     @Autowired
    6.     AdminService adminService;
    7.     /**
    8.      * Excel表格导出接口
    9.      * http://localhost:8080/ExcelDownload
    10.      * @param response response对象
    11.      */
    12.     @GetMapping("/ExcelDownload")
    13.     @PreAuthorize("hasAuthority('admin')")
    14.     public void excelDownload(HttpServletResponse response) throws IOException{
    15.         adminService.excelOut(response);
    16.     }
    17.  
    18.     /**
    19.      * 课程管理
    20.      * @return
    21.      */
    22.     @GetMapping("/courseManage")
    23.     @PreAuthorize("hasAnyAuthority('admin')")
    24.     public String courseManage(){
    25.         return "courseManage";
    26.     }
    27.  
    28.     /**
    29.      * 添加课程
    30.      * @return
    31.      */
    32.     @GetMapping("/addCourse")
    33.     @PreAuthorize("hasAuthority('admin')")
    34.     public String addCourse(){
    35.         return "addCourse";
    36.     }
    37. }

    登录接口

    1. @Controller
    2. @Api
    3. public class LoginController{
    4.     
    5.     @Autowired
    6.     AdminService adminService;
    7.     @Autowired
    8.     UserService userService;
    9.  
    10.     @RequestMapping("/login")
    11.     public String login(){
    12.         return "login";
    13.     }
    14.  
    15.     @GetMapping("/")
    16.     public String index() {
    17.         return "success";
    18.     }
    19.     
    20.     
    21.     @GetMapping("/manager")
    22.     @PreAuthorize("hasAuthority('admin')")
    23.     public String manager(){
    24.         return "manager";
    25.     }
    26.     //@RequestMapping("/error")
    27.     //public String error(){
    28.     //    return "error";
    29.     //}
    30.     
    31.     @GetMapping("/info")
    32.     @PreAuthorize("hasAuthority('student')")
    33.     public String info(){
    34.         return "studentInfo";
    35.     }
    36.  
    37.     @GetMapping("/getCode")
    38.     @ResponseBody
    39.     public Object getCode(HttpServletRequest request) {
    40.  
    41.         /* 生成验证码字符串 */
    42.         String verifyCode = VerifyCodeUtil.generateVerifyCode(4);
    43.         String uuid = UUIDUtil.GeneratorUUIDOfSimple();
    44.         
    45.         HttpSession session = request.getSession();
    46.         session.setAttribute(uuid,verifyCode); //将验证码与生成的uuid绑定在一起
    47.         System.out.println("生成的验证码为:" + verifyCode);
    48.  
    49.         int width = 111,height = 36;
    50.  
    51.         try (ByteArrayOutputStream stream = new ByteArrayOutputStream()) {
    52.             VerifyCodeUtil.outputImage(width, height, stream, verifyCode);
    53.             return Msg.msg("data",new ImgVO("data:image/gif;base64,"+ Base64Utils.encodeToString(stream.toByteArray()),uuid));
    54.         } catch (IOException e) {
    55.             e.printStackTrace();
    56.         }
    57.         return null;
    58.     }
    59.     
    60.     public User getUser() { //为了session从获取用户信息,可以配置如下
    61.         User user = new User();
    62.         SecurityContext ctx = SecurityContextHolder.getContext();
    63.         Authentication auth = ctx.getAuthentication();
    64.         if (auth.getPrincipal() instanceof UserDetails) user = (User) auth.getPrincipal();
    65.         return user;
    66.     }
    67.  
    68.     public HttpServletRequest getRequest() {
    69.         return ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest();
    70.     }
    71. }

    如果也想学习本系统，下面领取。回复：017springboot

  • 相关阅读:
    NAT地址转换
    一个免杀项目分享
    RecAgent:A Novel Simulation Paradigm for Recommender Systems学习笔记
    吴恩达《机器学习》8-5-＞8-6:特征与直观理解I、样本与值观理解II
    OpenShift 4 - 部署 RHODS 环境，运行 AI/ML 应用（视频）
    数据结构——哈希
    基于ESP32的蓝牙鼠标键盘（一）BleKeyboard.h函数解析
    Linux上防火墙操作
    文件IO-缓冲区
    金融计量学实验报告一
  • 原文地址：https://blog.csdn.net/hanyunlong1989/article/details/125940845