基于java+springboot+mybatis+mysql的在线论坛管理系统

package cn.bestzuo.zuoforum.controller; import cn.bestzuo.zuoforum.common.ForumResult; import cn.bestzuo.zuoforum.common.LayuiFlowResult; import cn.bestzuo.zuoforum.pojo.*; import cn.bestzuo.zuoforum.pojo.vo.*; import cn.bestzuo.zuoforum.service.*; import com.github.pagehelper.PageHelper; import com.github.pagehelper.PageInfo; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.*; import org.thymeleaf.util.StringUtils; import java.util.ArrayList; import java.util.Collections; import java.util.List; import java.util.regex.Pattern; /** * 用户主页Controller */ @Controller public class UserIndexController { @Autowired private CollectionService collectionService; @Autowired private UserInfoService userInfoService; @Autowired private QuestionService questionService; @Autowired private CommentService commentService; @Autowired private FollowService followService; @Autowired private CommentLikeService commentLikeService; @Autowired private UserRateService userRateService; /** * 查询对应的用户名 * * @param token * @return */ @RequestMapping("/user/{token}") public String userIndex(@PathVariable(value = "token") String token, Model model) { if (token == null) { return "404"; } //根据用户ID查询对应的用户信息 int uid = Integer.parseInt(token); //查询用户ID UserInfo userInfo = userInfoService.selectUserInfoByUid(uid); if (userInfo == null) { return "404"; } //保存用户信息 model.addAttribute("username", userInfo.getUsername()); return "user/user"; } /** * 获取首页用户信息 * * @param username * @return */ @RequestMapping("/getUserIndexInfo") @ResponseBody public ForumResult getMyIndexInfo(@RequestParam("username") String username) { //后端校验数据 if (StringUtils.isEmpty(username)) { return new ForumResult(400, "用户名不能为空", null); } //后台查询数据库信息 UserInfo userInfoByName = userInfoService.getUserInfoByName(username); if (userInfoByName == null) { return new ForumResult(400, "用户不存在", null); } //封装VO对象 UserIndexInfoVO vo = new UserIndexInfoVO(); vo.setId(userInfoByName.getUId()); vo.setUsername(username); vo.setAvatar(userInfoByName.getAvatar()); vo.setSex(userInfoByName.getSex()); UserRate userRate = userRateService.selectRateById(userInfoByName.getUId()); vo.setRate(userRate == null ? 0 : userRate.getRate()); try { //查询我关注的人数 List<Follow> follows = followService.selectFollowByUsername(username); vo.setFollow(follows.size()); //查询关注我的人数 List<Follow> fans = followService.selectFansByUsername(username); vo.setFans(fans.size()); //查询我发布的问题数 List<Question> questions = questionService.getAllQuestionsByPublisher(username); vo.setQuestionNum(questions.size()); //查询我收获的点赞数 List<CommentLike> commentLikes = commentLikeService.selectCommentLikeByUsername(username); vo.setLikeCount(commentLikes.size()); return new ForumResult(200, "查询成功", vo); } catch (Exception e) { e.printStackTrace(); return new ForumResult(500, "查询失败", null); } } /** * 获取我的问题信息 * * @return */ @RequestMapping("/getMyQuestions") @ResponseBody public LayuiFlowResult getMyQuestions(@RequestParam("page") Integer page, @RequestParam("username") String username) { //后端校验数据 if (StringUtils.isEmpty(username)) { return new LayuiFlowResult(400, "用户名不能为空", null,0); } //后台查询数据库信息 UserInfo userInfoByName = userInfoService.getUserInfoByName(username); if (userInfoByName == null) { return new LayuiFlowResult(400, "用户不存在", null,0); } //查询问题信息 PageHelper.startPage(page,5); List<Question> questions = questionService.getAllQuestionsByPublisher(username); PageInfo<Question> pageInfo = new PageInfo<>(questions); if (pageInfo.getList().size() == 0) { return new LayuiFlowResult(200, "查询成功", null,0); } else { List<UserIndexQuestionVO> res = new ArrayList<>(); for (Question question : pageInfo.getList()) { res.add(convertQuestionToVO(question)); } return new LayuiFlowResult(200, "查询成功", res,pageInfo.getPages()); } } /** * 将Question信息转换成前端VO * * @param question * @return */ private UserIndexQuestionVO convertQuestionToVO(Question question) { UserIndexQuestionVO vo = new UserIndexQuestionVO(); vo.setId(question.getId()); vo.setTitle(question.getTitle()); vo.setCommentCount(question.getCommentCount()); vo.setLikeCount(question.getLikeCount()); vo.setGmtCreate(question.getGmtCreate()); vo.setViewCount(question.getViewCount()); String text = Html2Text(question.getDescription()); if (text.length() > 20) { vo.setDescription(text.substring(0, 20) + "..."); } else vo.setDescription(text); return vo; } //从html中提取纯文本 private String Html2Text(String inputString) { String htmlStr = inputString; // 含html标签的字符串 String textStr = ""; Pattern p_script; java.util.regex.Matcher m_script; Pattern p_style; java.util.regex.Matcher m_style; Pattern p_html; java.util.regex.Matcher m_html; try { String regEx_script = "<[\\s]*?script[^>]*?>[\\s\\S]*?<[\\s]*?\\/[\\s]*?script[\\s]*?>"; // 定义script的正则表达式{或<script[^>]*?>[\\s\\S]*?<\\/script> String regEx_style = "<[\\s]*?style[^>]*?>[\\s\\S]*?<[\\s]*?\\/[\\s]*?style[\\s]*?>"; // 定义style的正则表达式{或<style[^>]*?>[\\s\\S]*?<\\/style> String regEx_html = "<[^>]+>"; // 定义HTML标签的正则表达式 p_script = Pattern.compile(regEx_script, Pattern.CASE_INSENSITIVE); m_script = p_script.matcher(htmlStr); htmlStr = m_script.replaceAll(""); // 过滤script标签 p_style = Pattern.compile(regEx_style, Pattern.CASE_INSENSITIVE); m_style = p_style.matcher(htmlStr); htmlStr = m_style.replaceAll(""); // 过滤style标签 p_html = Pattern.compile(regEx_html, Pattern.CASE_INSENSITIVE); m_html = p_html.matcher(htmlStr); htmlStr = m_html.replaceAll(""); // 过滤html标签 textStr = htmlStr; } catch (Exception e) { System.err.println("Html2Text: " + e.getMessage()); } //剔除空格行 textStr = textStr.replaceAll("[ ]+", " "); textStr = textStr.replaceAll("(?m)^\\s*$(\\n|\\r\\n)", ""); return textStr;// 返回文本字符串 } /** * 获取我的评论信息 * * @return */ @RequestMapping("/getMyCommentInfo") @ResponseBody public LayuiFlowResult getMyComments(@RequestParam("page")Integer page, @RequestParam("username") String username) { //后端数据校验 if (StringUtils.isEmpty(username)) {