IT社区|基于SpringBoot的IT社区平台

视频模块如图5-9、5-10,该模块通过阿里云第三方视频点播服务来完成，通过获取阿里云oss的endpoint，keyid，keysecret，bucketname进行绑定，获取第三方api来实现具体的功能。用户发布视频后，同样需要管理员来审核。

文章管理模块如图5-13、5-14，该模块主要是对文章表、评论表进行sql操作，文章显示，逻辑删除，重新发布等操作，包括转发的文章，同时也包括评论语句。该模块是对文章表，评论表的基本sql语句操作。

public Result item(@RequestParam(defaultValue = "0L", name = "userId") Long userId, @RequestParam("thatId") Long thatId) {

        // 保存收藏、关注、粉丝、动态、转发、评论、消息数
        int collectionCount = collectionService.count(new QueryWrapper().eq("user_id", thatId));
        int attentionCount = attentionService.count(new QueryWrapper().eq("this_id", thatId));
        int fansCount = attentionService.count(new QueryWrapper().eq("that_id", thatId));
        int essayCount = essayService.count(new QueryWrapper().eq("user_id", thatId));
        int forwardCount = forwardService.count(new QueryWrapper().eq("user_id", thatId));
        int commentCount = commentService.count(new QueryWrapper().eq("user_id", thatId));
        int messageCount = messageService.count(new QueryWrapper().eq("this_id", thatId));
        int newsCount = newsService.count(new QueryWrapper().eq("user_id", thatId).eq("zt", MapUtil.YFB));
        int videoCount = videoService.count(new QueryWrapper

try {
            //accessKeyId, accessKeySecret
            //fileName：上传文件原始名称
            String fileName = file.getOriginalFilename();
            //title：上传之后显示名称
            String title = fileName.substring(0, fileName.lastIndexOf("."));
            //inputStream：上传文件输入流
            InputStream inputStream = file.getInputStream();
            UploadStreamRequest request = new UploadStreamRequest(ConstantProperties.ACCESS_KEY_ID, ConstantProperties.ACCESS_KEY_SECRET, title, fileName, inputStream);

            UploadVideoImpl uploader = new UploadVideoImpl();
            UploadStreamResponse response = uploader.uploadStream(request);

            String videoId;
            if (response.isSuccess()) {
                videoId = response.getVideoId();
            } else {
                //如果设置回调URL无效，不影响视频上传，可以返回VideoId同时会返回错误码。
                // 其他情况上传失败时，VideoId为空，此时需要根据返回错误码分析具体错误原因
                videoId = response.getVideoId();
            }
            return videoId;
        } catch (Exception e) {
            e.printStackTrace();
            return null;
        }

package com.superb.controller;


import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.superb.common.MapUtil;
import com.superb.entity.Message;
import com.superb.entity.News;
import com.superb.entity.Record;
import com.superb.entity.Video;
import com.superb.service.MessageService;
import com.superb.service.OssService;
import com.superb.service.RecordAdminService;
import com.superb.service.VideoService;
import com.superb.util.Result;
import com.superb.util.Utils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import org.springframework.web.multipart.MultipartFile;

import java.util.Map;

/**
 * 

 *  前端控制器
 * 
 *

 */
@RestController
@RequestMapping("/video")
public class VideoController {

    @Autowired
    private OssService ossService;

    @Autowired
    private VideoService videoService;


    /**
     * 视频列表 已发布
     * @param current
     * @param size
     * @return
     */
    @GetMapping("/list")
    public Result list(@RequestParam(defaultValue = "1", name = "current") Integer current,
                       @RequestParam(defaultValue = "10", name = "size") Integer size){
        Page