基于javaweb+mysql的springboot在线学习系统(java+springboot+mybatis+vue+mysql+redis)
运行环境
Java≥8、MySQL≥5.7、Node.js≥10
开发工具
后端:eclipse/idea/myeclipse/sts等均可配置运行
前端:WebStorm/VSCode/HBuilderX等均可
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SpringBoot在线学习系统(java+springboot+mybatis+vue+mysql+redis)
一、项目运行 环境配置:
Jdk1.8 + Tomcat8.5 + Mysql + HBuilderX(Webstorm也行)+ Eclispe(IntelliJ IDEA,Eclispe,MyEclispe,Sts都支持)。
项目技术:
Spring + SpringBoot+ mybatis + Maven + Vue 等等组成,B/S模式 + Maven管理等等。
if (ip.indexOf(",") > 0) {
ip = ip.substring(0, ip.indexOf(","));
}
}
} catch (Exception e) {
ip = "";
}
return ip;
}
}
@Slf4j
public class LoginTicketInterceptor implements HandlerInterceptor {
@Resource
private UserService userService;
@Resource
private HostHolder hostHolder;
/**
* 调用时间:Controller方法处理之前
* 执行顺序:链式 Interceptor 情况下,Interceptor 按照声明的顺序一个接一个执行
* 若返回 false,则中断执行,注意:不会进入 afterCompletion
@ControllerAdvice
@RestController
public class CommonAdvice {
private static Logger logger = LoggerFactory.getLogger(CommonAdvice.class);
/**
* 原始异常处理
*/
@ExceptionHandler(Exception.class)
@ResponseStatus(HttpStatus.INTERNAL_SERVER_ERROR)
String handleExceptionForErrorOne(Exception e, HttpServletRequest request) {
logger.info("Exception message:{}", e.getMessage());
logger.info("Exception from:{}", e.getCause());
logger.info("Exception print:{}", e);
return SystemUtil.getJSONString(HttpStatus.INTERNAL_SERVER_ERROR.value(), e.getMessage());
}
/**
* 自定义全局异常处理
*/
@ExceptionHandler(GlobalException.class)
String handleExceptionForErrorTwo(GlobalException e, HttpServletRequest request) {
logger.info("MyException message:{}", e.getMessage());
logger.info("MyException from:{}", e.getCause());
logger.info("MyException print:{}", e);
return SystemUtil.getJSONString(e.getCode(), e.getMessage());
}
}
/**
*/
@RestController
@RequestMapping("/subject")
int total = favoriteService.getCountOfFavoriteByUidOrTitle(uid, searchContent);
return SystemUtil.getJSONString(200, "", new HashMap<String, Object>() {{
put("total", total);
put("favoriteList", voList);
}});
}
}
//全局异常处理
@ControllerAdvice
@RestController
public class CommonAdvice {
private static Logger logger = LoggerFactory.getLogger(CommonAdvice.class);
/**
* 原始异常处理
*/
@ExceptionHandler(Exception.class)
@ResponseStatus(HttpStatus.INTERNAL_SERVER_ERROR)
String handleExceptionForErrorOne(Exception e, HttpServletRequest request) {
logger.info("Exception message:{}", e.getMessage());
logger.info("Exception from:{}", e.getCause());
logger.info("Exception print:{}", e);
return SystemUtil.getJSONString(HttpStatus.INTERNAL_SERVER_ERROR.value(), e.getMessage());
}
/**
* 自定义全局异常处理
*/
@ExceptionHandler(GlobalException.class)
/**
*/
@RestController
@RequestMapping("/subject")
public class SubjectController {
@Resource
private SubjectService subjectService;
/**
* 获取所有课程列表
*/
@GetMapping("/all")
public String getAllSubject() {
List<Subject> subjectList = subjectService.getAllSubject();
return SystemUtil.getJSONString(200, "", new HashMap<String, Object>() {{
put("subjectList", subjectList);
}});
}
/**
* 读取 execl 数据并插入到数据库中
*/
@PostMapping("/add")
public String addSubject(MultipartFile file) {
subjectService.saveSubject(file, subjectService);
return SystemUtil.getJSONString(200, "上传成功!");
}
}
boolean isOk = postService.updatePost(post);
int code = isOk ? 200 : 2300;
String msg = isOk ? "更新成功!" : "更新失败!";
return SystemUtil.getJSONString(code, msg);
}
/**
* 删除帖子,当前用户为登录的用户
*/
@DeleteMapping("/del/{id}")
public String delPost(@PathVariable("id") Integer id) {
boolean isOk = postService.delPostById(id);
int code = isOk ? 200 : 2300;
String msg = isOk ? "删除帖子成功!" : "删除帖子失败!";
return SystemUtil.getJSONString(code, msg);
}
}
/**
*/
@RestController
@RequestMapping("/favorite")
public class FavoriteController {
@Resource
private FavoriteService favoriteService;
@Resource
private HostHolder hostHolder;
/**
* 添加或取消收藏,传个课程id即可,用户id从后台获取
*/
@GetMapping("/change")
public String addFavorite(Integer subjectId) {
Map<String, Object> res = favoriteService.changeFavorite(subjectId, hostHolder.getUser().getId());
return SystemUtil.getJSONString((Integer) res.get("code"), (String) res.get("msg"));
}
/**
* 删除收藏
*/
@DeleteMapping("/delete/{id}")
@Slf4j
public class LoginTicketInterceptor implements HandlerInterceptor {
@Resource
private UserService userService;
@Resource
private HostHolder hostHolder;
/**
* 调用时间:Controller方法处理之前
* 执行顺序:链式 Interceptor 情况下,Interceptor 按照声明的顺序一个接一个执行
* 若返回 false,则中断执行,注意:不会进入 afterCompletion
*/
@Override
public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws Exception {
log.info("LoginTicketInterceptor -> preHandle,url:" + request.getServletPath());
// 从 cookie 中获取凭证
String ticket = CookieUtil.getValue(request, "ticket");
if (ticket != null) {
// 查询凭证
LoginTicket loginTicket = userService.findLoginTicket(ticket);
// 检查凭证是否有效
if (loginTicket != null && loginTicket.getStatus() == 0 && loginTicket.getExpired().after(new Date())) {
User user = userService.getUserById(loginTicket.getUserId());
// 在本次请求中持有用户,将用户暂存到某个线程中
hostHolder.setUser(user);
log.info("LoginTicketInterceptor -> preHandle,loginTicket:" + loginTicket);
return true;
}
}
ResponseUtil.out(response, new JSONObject() {{
put("code", 2000);
put("msg", "你还没有登录哦!");
}});
return false;
}
// 在 controller 之后,模板之前执行
@Override
public void postHandle(HttpServletRequest request, HttpServletResponse response, Object handler, ModelAndView modelAndView) throws Exception {
}
/**
public String uploadHeader(MultipartFile file) {
String fileName;
if (file == null || (fileName = file.getOriginalFilename()) == null) {
return SystemUtil.getJSONString(2013, "您还没有选择图片!");
}
String suffix = fileName.substring(fileName.lastIndexOf("."));
if (StringUtils.isBlank(suffix) || !imgExtends.contains(suffix.toLowerCase())) {
return SystemUtil.getJSONString(2013, "图片格式不正确!");
}
// 生成随机文件名
String newFileName = SystemUtil.generateUUID() + suffix;
// 构建上传文件的存放 "文件夹" 路径
File fileDir = new File(imgUploadPath);
if (!fileDir.exists()) {
// 递归生成文件夹
fileDir.mkdirs();
}
// 确定文件存放的路径
File dest = new File(fileDir.getAbsolutePath() + "/" + newFileName);
try {
// 存储文件
file.transferTo(dest);
} catch (IOException e) {
logger.error("上传图片失败: " + e.getMessage());
throw new RuntimeException("上传图片失败,服务器发生异常!", e);
}
// 讨论区中的图片链接(web访问路径)
// http://localhost:8006/post/imgLoader/xxx.png
String headerUrl = domain + "/post/imgLoader/" + newFileName;
return SystemUtil.getJSONString(200, "上传成功!", new HashMap<String, Object>() {{
put("imgUrl", headerUrl);
}});
}
/**
* 获取讨论区上传的图片
*/
@GetMapping("/imgLoader/{filename}")
public void getUserHeader(@PathVariable("filename") String filename, HttpServletResponse response) {
filename = imgUploadPath + "/" + filename;
String suffix = filename.substring(filename.lastIndexOf("."));
response.setContentType("image/" + suffix);
try (
// java 7 写在这里会自动添加finally代码块来关闭流
int total = favoriteService.getCountOfFavoriteByUidOrTitle(uid, searchContent);
return SystemUtil.getJSONString(200, "", new HashMap<String, Object>() {{
put("total", total);
put("favoriteList", voList);
}});
}
}
//全局异常处理
@ControllerAdvice
@RestController
public class CommonAdvice {
private static Logger logger = LoggerFactory.getLogger(CommonAdvice.class);
/**
* 原始异常处理
*/
@ExceptionHandler(Exception.class)
@ResponseStatus(HttpStatus.INTERNAL_SERVER_ERROR)
String handleExceptionForErrorOne(Exception e, HttpServletRequest request) {
logger.info("Exception message:{}", e.getMessage());
logger.info("Exception from:{}", e.getCause());
logger.info("Exception print:{}", e);
return SystemUtil.getJSONString(HttpStatus.INTERNAL_SERVER_ERROR.value(), e.getMessage());
}
/**
* 自定义全局异常处理
*/
@ExceptionHandler(GlobalException.class)
String handleExceptionForErrorTwo(GlobalException e, HttpServletRequest request) {
logger.info("MyException message:{}", e.getMessage());
logger.info("MyException from:{}", e.getCause());
logger.info("MyException print:{}", e);
return SystemUtil.getJSONString(e.getCode(), e.getMessage());
}
*/
@DeleteMapping("/delete/{id}")
public String delNote(@PathVariable("id") Integer id) {
boolean isOk = noteService.removeById(id);
int code = isOk ? 200 : 2400;
String msg = isOk ? "删除成功!" : "删除失败!";
return SystemUtil.getJSONString(code, msg);
}
}
@RestController
public class LoginController {
private static final Logger logger = LoggerFactory.getLogger(LoginController.class);
@Value("${onlinelearning.path.upload.file}")
private String fileUploadPath;
@Value("${onlinelearning.path.domain}")
private String domain;
@Resource
private HostHolder hostHolder;
@Resource
private NoteService noteService;
/**
* 分页查询出所有用户上传的笔记
*/
@GetMapping("/all/{pageIndex}")
public String getPageOfNote(@PathVariable("pageIndex") Integer pageIndex) {
IPage<Note> list = noteService.getPageOfNote(pageIndex);
return SystemUtil.getJSONString(200, "", new HashMap<String, Object>() {{
put("total", list.getTotal());
put("noteList", list.getRecords());
}});
}
/**
* 上传笔记
*/
@PostMapping("/add")
public String uploadHeader(MultipartFile file) {
String fileName;
if (file == null || (fileName = file.getOriginalFilename()) == null) {
return SystemUtil.getJSONString(2013, "您还没有选择文件!");
}
String suffix = fileName.substring(fileName.lastIndexOf("."));
if (StringUtils.isBlank(suffix)) {
return SystemUtil.getJSONString(2013, "文件格式不正确!");
}
// 生成随机文件名
String newFileName = SystemUtil.generateUUID() + suffix;
// 构建上传文件的存放 "文件夹" 路径
File fileDir = new File(fileUploadPath);
if (!fileDir.exists()) {
// 递归生成文件夹
fileDir.mkdirs();
}
throw new RuntimeException("上传图片失败,服务器发生异常!", e);
}
// 讨论区中的图片链接(web访问路径)
// http://localhost:8006/post/imgLoader/xxx.png
String headerUrl = domain + "/post/imgLoader/" + newFileName;
return SystemUtil.getJSONString(200, "上传成功!", new HashMap<String, Object>() {{
put("imgUrl", headerUrl);
}});
}
/**
* 获取讨论区上传的图片
*/
@GetMapping("/imgLoader/{filename}")
public void getUserHeader(@PathVariable("filename") String filename, HttpServletResponse response) {
filename = imgUploadPath + "/" + filename;
String suffix = filename.substring(filename.lastIndexOf("."));
response.setContentType("image/" + suffix);
try (
// java 7 写在这里会自动添加finally代码块来关闭流
FileInputStream fis = new FileInputStream(filename);
OutputStream os = response.getOutputStream()
) {
byte[] buffer = new byte[1024];
int b = 0;
while ((b = fis.read(buffer)) != -1) {
os.write(buffer, 0, b);
}
} catch (IOException e) {
logger.error("读取图片失败: " + e.getMessage());
}
}
/**
* 发表帖子,传来2个字段:content 和 pictures(非必须,因为我这边给了默认值)
*/
@PostMapping("/add")
public String addPost(@RequestBody Post post) {
User user = hostHolder.getUser();
post.setUid(user.getId());
boolean isOk = postService.save(post);
int code = isOk ? 200 : 2300;
String msg = isOk ? "发表成功!" : "发表失败!";
return SystemUtil.getJSONString(code, msg);
}
/**
* 分页获取帖子列表,按照更新时间倒叙排,只需要传页码,搜索字段非必须
*/
*/
@PostMapping("/imgUpload")
public String uploadHeader(MultipartFile file) {
String fileName;
if (file == null || (fileName = file.getOriginalFilename()) == null) {
return SystemUtil.getJSONString(2013, "您还没有选择图片!");
}
String suffix = fileName.substring(fileName.lastIndexOf("."));
if (StringUtils.isBlank(suffix) || !imgExtends.contains(suffix.toLowerCase())) {
return SystemUtil.getJSONString(2013, "图片格式不正确!");
}
// 生成随机文件名
String newFileName = SystemUtil.generateUUID() + suffix;
// 构建上传文件的存放 "文件夹" 路径
File fileDir = new File(imgUploadPath);
if (!fileDir.exists()) {
// 递归生成文件夹
fileDir.mkdirs();
}
// 确定文件存放的路径
File dest = new File(fileDir.getAbsolutePath() + "/" + newFileName);
try {
// 存储文件
file.transferTo(dest);
} catch (IOException e) {
logger.error("上传图片失败: " + e.getMessage());
throw new RuntimeException("上传图片失败,服务器发生异常!", e);
}
// 讨论区中的图片链接(web访问路径)
// http://localhost:8006/post/imgLoader/xxx.png
String headerUrl = domain + "/post/imgLoader/" + newFileName;
return SystemUtil.getJSONString(200, "上传成功!", new HashMap<String, Object>() {{
put("imgUrl", headerUrl);
}});
}
/**
* 获取讨论区上传的图片
*/
@GetMapping("/imgLoader/{filename}")
public void getUserHeader(@PathVariable("filename") String filename, HttpServletResponse response) {
}
// 确定文件存放的路径
File dest = new File(fileDir.getAbsolutePath() + "/" + newFileName);
try {
// 存储文件
file.transferTo(dest);
} catch (IOException e) {
logger.error("上传文件失败: " + e.getMessage());
throw new RuntimeException("上传文件失败,服务器发生异常!", e);
}
// 笔记下载路径
// http://localhost:8006/note/download/xxxxx.pdf
User user = hostHolder.getUser();
String downloadUrl = domain + "/note/download/" + newFileName;
Note note = new Note();
note.setUid(user.getId());
note.setUsername(user.getUsername());
note.setFilename(fileName);
note.setDownloadUrl(downloadUrl);
noteService.save(note);
return SystemUtil.getJSONString(200, "上传成功!");
}
/**
* 下载笔记
*/
@GetMapping("/download/{fileId}")
public void downloadNote(@PathVariable("fileId") String fileId, String filename,
HttpServletResponse resp) {
String filePath = fileUploadPath + "/" + fileId;
try (
// java 7 写在这里会自动添加finally代码块来关闭流
FileInputStream fis = new FileInputStream(filePath);
OutputStream os = resp.getOutputStream()
) {
// 服务器存放路径
resp.setCharacterEncoding("UTF-8");
resp.setContentType("application/octet-stream"); //告诉浏览器输出内容为流
resp.addHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(filename, "UTF-8"));
byte[] buffer = new byte[1024];
int b = 0;
while ((b = fis.read(buffer)) != -1) {
os.write(buffer, 0, b);
}
} catch (Exception e) {
logger.error("读取文件失败: " + e.getMessage());
}
}
/**
* 删除笔记
*/
response.addCookie(cookie);
res.put("userInfo", map.get("userInfo"));
return SystemUtil.getJSONString(200, "登录成功!", res);
} else {
return SystemUtil.getJSONString(2011, (String) map.get("errMsg"));
}
}
/**
* 用户注册
*/
@PostMapping("/register")
public String register(@RequestBody User user) {
Map<String, Object> map = userService.register(user);
if (map.isEmpty()) {
return SystemUtil.getJSONString(200, "注册成功");
} else {
return SystemUtil.getJSONString(2008, (String) map.get("errMsg"));
}
}
/**
* 登出
*/
@GetMapping("/logout")
public void logout(@CookieValue("ticket") String ticket) {
userService.logout(ticket);
}
}
public class HttpIpUtils {
/**
* 真实ip地址
*/
public static String getClientIp(HttpServletRequest request) {
String ip = request.getHeader("X-Forwarded-For");
if (!StringUtils.isEmpty(ip) && !"unKnown".equalsIgnoreCase(ip)) {
//多次反向代理后会有多个ip值,第一个ip才是真实ip
int index = ip.indexOf(",");
if (index != -1) {
return ip.substring(0, index);
} else {
return ip;
}
}
for (Object o : paramsArray) {
paramsValue.append(o).append(" ");
}
}
String ip = HttpIpUtils.getClientIp(request);
log.info("URLParamName:" + paramsName);
log.info("URLParamValue:" + paramsValue);
log.info("URL:{},HTTP_METHOD:{},IP:{},Method:{}", request.getRequestURL().toString(), request.getMethod(), ip, joinPoint.getSignature().getDeclaringTypeName() + "." + joinPoint.getSignature().getName());
}
}
/**
*/
@RestController
@RequestMapping("/comment")
public class CommentController {
@Resource
private CommentService commentService;
@Resource
private PostService postService;
/**
* 添加评论
*/
@PostMapping("/add")
public String addComment(@RequestBody Comment comment) {
boolean isOk = commentService.save(comment);
//重新查询一下插入的评论信息
Comment one = isOk ? commentService.getById(comment.getId()) : null;
if (isOk) {
/**
*/
@RestController
@RequestMapping("/favorite")
public class FavoriteController {
@Resource
private FavoriteService favoriteService;
@Resource
private HostHolder hostHolder;
/**
* 添加或取消收藏,传个课程id即可,用户id从后台获取
*/
@GetMapping("/change")
public String addFavorite(Integer subjectId) {
Map<String, Object> res = favoriteService.changeFavorite(subjectId, hostHolder.getUser().getId());
return SystemUtil.getJSONString((Integer) res.get("code"), (String) res.get("msg"));
}
/**
* 删除收藏
*/
@DeleteMapping("/delete/{id}")
public String delFavorite(@PathVariable("id") Integer id) {
boolean isOk = favoriteService.delFavoriteById(id);
int code = isOk ? 200 : 2300;
String msg = isOk ? "删除成功!" : "删除失败!";
return SystemUtil.getJSONString(code, msg);
}
/**
* 分页查询出当前登录用户的收藏,当前登录的用户 uid 从 HostHolder 中取,可有模糊搜索共用一个接口
*/
@GetMapping("/all")
public String getPageOfFavorite(Integer pageIndex, String searchContent) {
Integer uid = hostHolder.getUser().getId();
List<PageOfFavoriteResultVO> voList = favoriteService.pageOfFavoriteByUidOrTitle(uid, pageIndex, searchContent);
int total = favoriteService.getCountOfFavoriteByUidOrTitle(uid, searchContent);
return SystemUtil.getJSONString(200, "", new HashMap<String, Object>() {{
put("total", total);
put("favoriteList", voList);
}});
}
}
/**
*/
@RestController
@RequestMapping("/note")
public class NoteController {
private static final Logger logger = LoggerFactory.getLogger(NoteController.class);
@Value("${onlinelearning.path.upload.file}")
private String fileUploadPath;
@Value("${onlinelearning.path.domain}")
private String domain;
@Resource
private HostHolder hostHolder;
@Resource
private NoteService noteService;
/**
* 分页查询出所有用户上传的笔记
*/
@GetMapping("/all/{pageIndex}")
public String getPageOfNote(@PathVariable("pageIndex") Integer pageIndex) {
IPage<Note> list = noteService.getPageOfNote(pageIndex);
return SystemUtil.getJSONString(200, "", new HashMap<String, Object>() {{
put("total", list.getTotal());
put("noteList", list.getRecords());
}});
}
/**
* 上传笔记
*/
@PostMapping("/add")
public String uploadHeader(MultipartFile file) {
String fileName;
if (file == null || (fileName = file.getOriginalFilename()) == null) {
return SystemUtil.getJSONString(2013, "您还没有选择文件!");
}
String suffix = fileName.substring(fileName.lastIndexOf("."));