wordpress怎么更换站点,个人网站需要建站群吗,php网站制作流程,wordpress密码漏洞’idea 数据库mysql5.7 数据库链接工具#xff1a;navcat,小海豚等 随着信息化时代的到来#xff0c;管理系统都趋向于智能化、系统化#xff0c;平面设计课程在线学习平台系统也不例外#xff0c;但目前国内的市场仍都使用人工管理#xff0c;市场规模越来越大#xff0c;…idea 数据库mysql5.7 数据库链接工具navcat,小海豚等 随着信息化时代的到来管理系统都趋向于智能化、系统化平面设计课程在线学习平台系统也不例外但目前国内的市场仍都使用人工管理市场规模越来越大同时信息量也越来越庞大人工管理显然已无法应对时代的变化而平面设计课程在线学习平台系统能很好地解决这一问题轻松应对平面设计课程在线学习平时的工作既能提高人力物力财力又能加快工作的效率取代人工管理是必然趋势。
本平面设计课程在线学习平台系统以ssm作为框架b/s模式以及MySql作为后台运行的数据库同时使用Tomcat用为系统的服务器。本系统主要包括以下功能模块首页个人中心学生管理教师管理课程类型管理课程学习管理试题讲解管理作业信息管理作业提交管理作业批改管理在线测试管理试题管理我的收藏管理在线讨论系统管理考试管理等模块通过这些模块的实现能够基本满足日常平面设计课程在线学习管理的操作。
本文着重阐述了平面设计课程在线学习平台系统的分析、设计与实现首先介绍开发系统和环境配置、数据库的设计接着说明功能模块的详细实现最后进行了总结。
关键词平面设计课程在线学习平台系统; ssm;MySql数据库;Tomcat;
基于ssm平面设计课程在线学习平台系统源码和论文746
演示视频 基于ssm平面设计课程在线学习平台系统源码和论文 Abstract
With the advent of the era of information technology, management systems tend to be intelligent, systematic, graphic design courses online learning platform system is no exception, but the current domestic market still use manual management, the size of the market is more and more big, at the same time, the amount of information is becoming more and more big, artificial management has clearly unable to cope with the changes of The Times, The graphic design course online learning platform system can well solve this problem, easy to cope with the usual work of graphic design course online learning, can not only improve human and material resources and financial resources, but also speed up the efficiency of work, replacing manual management is an inevitable trend. The online learning platform system of the graphic design course takes SSM as the framework, B/S mode and MySql as the database running in the background, and Tomcat is used as the server of the system. The system mainly includes the following functional modules: Home page, personal center, student management, teacher management, course type management, course learning management, test explanation management, homework information management, homework submission management, homework correcting management, online test management, test management, my collection management, online discussion, system management, examination management and other modules, Through the realization of these modules can basically meet the daily graphic design course online learning management operation. This paper focuses on the graphic design course online learning platform system analysis, design and implementation, first introduces the development system and environment configuration, database design, then explains the detailed implementation of functional modules, and finally summarized. Key words: Graphic design course online learning platform system; ssm; MySql database; Tomcat; package com.controller;import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Calendar;
import java.util.Map;
import java.util.HashMap;
import java.util.Iterator;
import java.util.Date;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import java.io.IOException;import com.utils.ValidatorUtils;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.format.annotation.DateTimeFormat;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.annotation.IgnoreAuth;import com.entity.ExamrecordEntity;
import com.entity.view.ExamrecordView;import com.service.ExamrecordService;
import com.service.TokenService;
import com.utils.PageUtils;
import com.utils.R;
import com.utils.MD5Util;
import com.utils.MPUtil;
import com.utils.CommonUtil;/*** 考试记录表* 后端接口* author * email * date 2022-01-04 15:17:01*/
RestController
RequestMapping(/examrecord)
public class ExamrecordController {Autowiredprivate ExamrecordService examrecordService;/*** 考试记录接口*/RequestMapping(/groupby)public R page2(RequestParam MapString, Object params,ExamrecordEntity examrecord, HttpServletRequest request){if(!request.getSession().getAttribute(role).toString().equals(管理员)) {examrecord.setUserid((Long)request.getSession().getAttribute(userId));}EntityWrapperExamrecordEntity ew new EntityWrapperExamrecordEntity();PageUtils page examrecordService.queryPageGroupBy(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, examrecord), params), params));return R.ok().put(data, page);}/*** 后端列表*/RequestMapping(/page)public R page(RequestParam MapString, Object params,ExamrecordEntity examrecord, HttpServletRequest request){if(!request.getSession().getAttribute(role).toString().equals(管理员)) {examrecord.setUserid((Long)request.getSession().getAttribute(userId));}EntityWrapperExamrecordEntity ew new EntityWrapperExamrecordEntity();PageUtils page examrecordService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, examrecord), params), params));return R.ok().put(data, page);}/*** 前端列表*/RequestMapping(/list)public R list(RequestParam MapString, Object params,ExamrecordEntity examrecord, HttpServletRequest request){if(!request.getSession().getAttribute(role).toString().equals(管理员)) {examrecord.setUserid((Long)request.getSession().getAttribute(userId));}EntityWrapperExamrecordEntity ew new EntityWrapperExamrecordEntity();PageUtils page examrecordService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, examrecord), params), params));return R.ok().put(data, page);}/*** 列表*/RequestMapping(/lists)public R list( ExamrecordEntity examrecord){EntityWrapperExamrecordEntity ew new EntityWrapperExamrecordEntity();ew.allEq(MPUtil.allEQMapPre( examrecord, examrecord)); return R.ok().put(data, examrecordService.selectListView(ew));}/*** 查询*/RequestMapping(/query)public R query(ExamrecordEntity examrecord){EntityWrapper ExamrecordEntity ew new EntityWrapper ExamrecordEntity();ew.allEq(MPUtil.allEQMapPre( examrecord, examrecord)); ExamrecordView examrecordView examrecordService.selectView(ew);return R.ok(查询考试记录表成功).put(data, examrecordView);}/*** 后端详情*/RequestMapping(/info/{id})public R info(PathVariable(id) Long id){ExamrecordEntity examrecord examrecordService.selectById(id);return R.ok().put(data, examrecord);}/*** 前端详情*/RequestMapping(/detail/{id})public R detail(PathVariable(id) Long id){ExamrecordEntity examrecord examrecordService.selectById(id);return R.ok().put(data, examrecord);}/*** 后端保存*/RequestMapping(/save)public R save(RequestBody ExamrecordEntity examrecord, HttpServletRequest request){examrecord.setId(new Date().getTime()new Double(Math.floor(Math.random()*1000)).longValue());//ValidatorUtils.validateEntity(examrecord);examrecord.setUserid((Long)request.getSession().getAttribute(userId));examrecordService.insert(examrecord);return R.ok();}/*** 前端保存*/RequestMapping(/add)public R add(RequestBody ExamrecordEntity examrecord, HttpServletRequest request){examrecord.setId(new Date().getTime()new Double(Math.floor(Math.random()*1000)).longValue());//ValidatorUtils.validateEntity(examrecord);examrecord.setUserid((Long)request.getSession().getAttribute(userId));examrecordService.insert(examrecord);return R.ok();}/*** 修改*/RequestMapping(/update)public R update(RequestBody ExamrecordEntity examrecord, HttpServletRequest request){//ValidatorUtils.validateEntity(examrecord);examrecordService.updateById(examrecord);//全部更新return R.ok();}/*** 删除*/RequestMapping(/delete)public R delete(RequestBody Long[] ids){examrecordService.deleteBatchIds(Arrays.asList(ids));return R.ok();}/*** 提醒接口*/RequestMapping(/remind/{columnName}/{type})public R remindCount(PathVariable(columnName) String columnName, HttpServletRequest request, PathVariable(type) String type,RequestParam MapString, Object map) {map.put(column, columnName);map.put(type, type);if(type.equals(2)) {SimpleDateFormat sdf new SimpleDateFormat(yyyy-MM-dd);Calendar c Calendar.getInstance();Date remindStartDate null;Date remindEndDate null;if(map.get(remindstart)!null) {Integer remindStart Integer.parseInt(map.get(remindstart).toString());c.setTime(new Date()); c.add(Calendar.DAY_OF_MONTH,remindStart);remindStartDate c.getTime();map.put(remindstart, sdf.format(remindStartDate));}if(map.get(remindend)!null) {Integer remindEnd Integer.parseInt(map.get(remindend).toString());c.setTime(new Date());c.add(Calendar.DAY_OF_MONTH,remindEnd);remindEndDate c.getTime();map.put(remindend, sdf.format(remindEndDate));}}WrapperExamrecordEntity wrapper new EntityWrapperExamrecordEntity();if(map.get(remindstart)!null) {wrapper.ge(columnName, map.get(remindstart));}if(map.get(remindend)!null) {wrapper.le(columnName, map.get(remindend));}if(!request.getSession().getAttribute(role).toString().equals(管理员)) {wrapper.eq(userid, (Long)request.getSession().getAttribute(userId));}int count examrecordService.selectCount(wrapper);return R.ok().put(count, count);}/*** 当重新考试时删除考生的某个试卷的所有考试记录*/RequestMapping(/deleteRecords)public R deleteRecords(RequestParam Long userid,RequestParam Long paperid){examrecordService.delete(new EntityWrapperExamrecordEntity().eq(paperid, paperid).eq(userid, userid));return R.ok();}}package com.controller;import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Calendar;
import java.util.Map;
import java.util.HashMap;
import java.util.Iterator;
import java.util.Date;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import java.io.IOException;import com.utils.ValidatorUtils;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.format.annotation.DateTimeFormat;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.annotation.IgnoreAuth;import com.entity.ZuoyetijiaoEntity;
import com.entity.view.ZuoyetijiaoView;import com.service.ZuoyetijiaoService;
import com.service.TokenService;
import com.utils.PageUtils;
import com.utils.R;
import com.utils.MD5Util;
import com.utils.MPUtil;
import com.utils.CommonUtil;/*** 作业提交* 后端接口* author * email * date 2022-01-04 15:17:01*/
RestController
RequestMapping(/zuoyetijiao)
public class ZuoyetijiaoController {Autowiredprivate ZuoyetijiaoService zuoyetijiaoService;/*** 后端列表*/RequestMapping(/page)public R page(RequestParam MapString, Object params,ZuoyetijiaoEntity zuoyetijiao, HttpServletRequest request){String tableName request.getSession().getAttribute(tableName).toString();if(tableName.equals(jiaoshi)) {zuoyetijiao.setGonghao((String)request.getSession().getAttribute(username));}if(tableName.equals(xuesheng)) {zuoyetijiao.setXuehao((String)request.getSession().getAttribute(username));}EntityWrapperZuoyetijiaoEntity ew new EntityWrapperZuoyetijiaoEntity();PageUtils page zuoyetijiaoService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, zuoyetijiao), params), params));return R.ok().put(data, page);}/*** 前端列表*/RequestMapping(/list)public R list(RequestParam MapString, Object params,ZuoyetijiaoEntity zuoyetijiao, HttpServletRequest request){EntityWrapperZuoyetijiaoEntity ew new EntityWrapperZuoyetijiaoEntity();PageUtils page zuoyetijiaoService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, zuoyetijiao), params), params));return R.ok().put(data, page);}/*** 列表*/RequestMapping(/lists)public R list( ZuoyetijiaoEntity zuoyetijiao){EntityWrapperZuoyetijiaoEntity ew new EntityWrapperZuoyetijiaoEntity();ew.allEq(MPUtil.allEQMapPre( zuoyetijiao, zuoyetijiao)); return R.ok().put(data, zuoyetijiaoService.selectListView(ew));}/*** 查询*/RequestMapping(/query)public R query(ZuoyetijiaoEntity zuoyetijiao){EntityWrapper ZuoyetijiaoEntity ew new EntityWrapper ZuoyetijiaoEntity();ew.allEq(MPUtil.allEQMapPre( zuoyetijiao, zuoyetijiao)); ZuoyetijiaoView zuoyetijiaoView zuoyetijiaoService.selectView(ew);return R.ok(查询作业提交成功).put(data, zuoyetijiaoView);}/*** 后端详情*/RequestMapping(/info/{id})public R info(PathVariable(id) Long id){ZuoyetijiaoEntity zuoyetijiao zuoyetijiaoService.selectById(id);return R.ok().put(data, zuoyetijiao);}/*** 前端详情*/RequestMapping(/detail/{id})public R detail(PathVariable(id) Long id){ZuoyetijiaoEntity zuoyetijiao zuoyetijiaoService.selectById(id);return R.ok().put(data, zuoyetijiao);}/*** 后端保存*/RequestMapping(/save)public R save(RequestBody ZuoyetijiaoEntity zuoyetijiao, HttpServletRequest request){zuoyetijiao.setId(new Date().getTime()new Double(Math.floor(Math.random()*1000)).longValue());//ValidatorUtils.validateEntity(zuoyetijiao);zuoyetijiaoService.insert(zuoyetijiao);return R.ok();}/*** 前端保存*/RequestMapping(/add)public R add(RequestBody ZuoyetijiaoEntity zuoyetijiao, HttpServletRequest request){zuoyetijiao.setId(new Date().getTime()new Double(Math.floor(Math.random()*1000)).longValue());//ValidatorUtils.validateEntity(zuoyetijiao);zuoyetijiaoService.insert(zuoyetijiao);return R.ok();}/*** 修改*/RequestMapping(/update)public R update(RequestBody ZuoyetijiaoEntity zuoyetijiao, HttpServletRequest request){//ValidatorUtils.validateEntity(zuoyetijiao);zuoyetijiaoService.updateById(zuoyetijiao);//全部更新return R.ok();}/*** 删除*/RequestMapping(/delete)public R delete(RequestBody Long[] ids){zuoyetijiaoService.deleteBatchIds(Arrays.asList(ids));return R.ok();}/*** 提醒接口*/RequestMapping(/remind/{columnName}/{type})public R remindCount(PathVariable(columnName) String columnName, HttpServletRequest request, PathVariable(type) String type,RequestParam MapString, Object map) {map.put(column, columnName);map.put(type, type);if(type.equals(2)) {SimpleDateFormat sdf new SimpleDateFormat(yyyy-MM-dd);Calendar c Calendar.getInstance();Date remindStartDate null;Date remindEndDate null;if(map.get(remindstart)!null) {Integer remindStart Integer.parseInt(map.get(remindstart).toString());c.setTime(new Date()); c.add(Calendar.DAY_OF_MONTH,remindStart);remindStartDate c.getTime();map.put(remindstart, sdf.format(remindStartDate));}if(map.get(remindend)!null) {Integer remindEnd Integer.parseInt(map.get(remindend).toString());c.setTime(new Date());c.add(Calendar.DAY_OF_MONTH,remindEnd);remindEndDate c.getTime();map.put(remindend, sdf.format(remindEndDate));}}WrapperZuoyetijiaoEntity wrapper new EntityWrapperZuoyetijiaoEntity();if(map.get(remindstart)!null) {wrapper.ge(columnName, map.get(remindstart));}if(map.get(remindend)!null) {wrapper.le(columnName, map.get(remindend));}String tableName request.getSession().getAttribute(tableName).toString();if(tableName.equals(jiaoshi)) {wrapper.eq(gonghao, (String)request.getSession().getAttribute(username));}if(tableName.equals(xuesheng)) {wrapper.eq(xuehao, (String)request.getSession().getAttribute(username));}int count zuoyetijiaoService.selectCount(wrapper);return R.ok().put(count, count);}}
