到了我们的大熊猫国家公园的最后的一次迭代任务了,我需要做的是管理员的模块,需要的功能是人工的文章审核,文章的查询。那么思路其实也很明确了,首先我们先创建好pojo类。然后也是老样子,写Mapper和Service,我们的思路就是从数据库中获取待审核文章的list,文章待审核的话会有一个Review属性为1,我们直接就使用查询语句来写,大概得操作语句如下:
文章类:
package panda.pojo;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import java.util.Date;
import java.util.List;
@TableName("tb_article")
public class Article {
@TableId(type = IdType.AUTO)
private Integer fid;
private Integer uid;
private String username;
private String userProfilePhoto;
private String title;
private String context;
private Integer process;
private Integer ban;
private String releaseAddress;
@TableField(select = false)
private List<ArticleResource> resources;
private Date releaseTime;
private Integer resourceNum;
private Integer complete;
private Integer draft;
public Integer getResourceNum() {
return resourceNum;
}
@Override
public String toString() {
return "Article{" +
"fid=" + fid +
", uid=" + uid +
", username='" + username + '\'' +
", userProfilePhoto='" + userProfilePhoto + '\'' +
", title='" + title + '\'' +
", context='" + context + '\'' +
", process=" + process +
", ban=" + ban +
", releaseAddress='" + releaseAddress + '\'' +
", resources=" + resources +
", releaseTime=" + releaseTime +
", resourceNum=" + resourceNum +
", complete=" + complete +
", draft=" + draft +
'}';
}
public Integer getDraft() {
return draft;
}
public void setDraft(Integer draft) {
this.draft = draft;
}
public void setResourceNum(Integer resourceNum) {
this.resourceNum = resourceNum;
}
public Integer getComplete() {
return complete;
}
public void setComplete(Integer complete) {
this.complete = complete;
}
public Integer getFid() {
return fid;
}
public void setFid(Integer fid) {
this.fid = fid;
}
public Integer getUid() {
return uid;
}
public void setUid(Integer uid) {
this.uid = uid;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getUserProfilePhoto() {
return userProfilePhoto;
}
public void setUserProfilePhoto(String userProfilePhoto) {
this.userProfilePhoto = userProfilePhoto;
}
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
public String getContext() {
return context;
}
public void setContext(String context) {
this.context = context;
}
public Integer getProcess() {
return process;
}
public void setProcess(Integer process) {
this.process = process;
}
public Integer getBan() {
return ban;
}
public void setBan(Integer ban) {
this.ban = ban;
}
public String getReleaseAddress() {
return releaseAddress;
}
public void setReleaseAddress(String releaseAddress) {
this.releaseAddress = releaseAddress;
}
public List<ArticleResource> getResources() {
return resources;
}
public void setResources(List<ArticleResource> resources) {
this.resources = resources;
}
public Date getReleaseTime() {
return releaseTime;
}
public void setReleaseTime(Date releaseTime) {
this.releaseTime = releaseTime;
}
}
Service类
package panda.service.impl;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.springframework.stereotype.Service;
import panda.mapper.ArticleMapper;
import panda.pojo.Article;
import panda.service.AuditService;
import javax.annotation.Resource;
import java.util.List;
/**
* @author Kate
* @date 2023/6/24 09:59
* 概述:
* 1、
*/
@Service
public class AuditServiceImpl implements AuditService {
@Resource
ArticleMapper articleMapper;
@Override
public List<Article> list(Integer offset){
return articleMapper.listForAudit(offset);
}
}
Controller类
package panda.controller;
import commonapi.util.CommonResult;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import panda.pojo.Article;
import panda.service.AuditService;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import java.util.List;
/**
* @author Kate
* @date 2023/6/24 09:44
* 概述:
* 1、
*/
@RestController
@RequestMapping("/audit")
public class AuditController {
@Resource
AuditService auditService;
@GetMapping("/list/{offset}")
public CommonResult list(HttpServletRequest request, @PathVariable Integer offset){
List<Article> list = auditService.list(offset);
return CommonResult.success().data("list",list);
}
}
大概就实现了管理员的功能了。