Spring 게시판 프로젝트 (4) 인기게시판 만들기.

상황 : 메인페이지를 만들었는데 생각보다 시간이 남았고 백엔드 쪽에 시간이 추가가 필요 

-> : 내가 인기게시판을 만들어서 백엔드에 걸리는 시간을 줄이자.

 

VO

// Source code is decompiled from a .class file using FernFlower decompiler.
package domain.popularity.vo;

import java.util.Date;

public class BoardPopularityVO {
   private String tableName;
   private String id;
   private String title;
   private String content;
   private int viewCount;
   private String pictureFile;
   private String userId;
   private String deleteYn;
   private Date createdDate;
   private Date modifiedDate;

   public BoardPopularityVO() {
   }

   public String getTableName() {
      return this.tableName;
   }

   public void setTableName(String tableName) {
      this.tableName = tableName;
   }

   public String getId() {
      return this.id;
   }

   public void setId(String id) {
      this.id = id;
   }

   public String getTitle() {
      return this.title;
   }

   public void setTitle(String title) {
      this.title = title;
   }

   public String getContent() {
      return this.content;
   }

   public void setContent(String content) {
      this.content = content;
   }

   public int getViewCount() {
      return this.viewCount;
   }

   public void setViewCount(int viewCount) {
      this.viewCount = viewCount;
   }

   public String getPictureFile() {
      return this.pictureFile;
   }

   public void setPictureFile(String pictureFile) {
      this.pictureFile = pictureFile;
   }

   public String getUserId() {
      return this.userId;
   }

   public void setUserId(String userId) {
      this.userId = userId;
   }

   public String getDeleteYn() {
      return this.deleteYn;
   }

   public void setDeleteYn(String deleteYn) {
      this.deleteYn = deleteYn;
   }

   public Date getCreatedDate() {
      return this.createdDate;
   }

   public void setCreatedDate(Date createdDate) {
      this.createdDate = createdDate;
   }

   public Date getModifiedDate() {
      return this.modifiedDate;
   }

   public void setModifiedDate(Date modifiedDate) {
      this.modifiedDate = modifiedDate;
   }
}

 

 

DAO

package domain.popularity.dao;

import domain.job.vo.BoardJobVO;
import domain.popularity.vo.BoardPopularityVO;
import java.util.List;

public interface BoardPopularityDAO {
   List<BoardJobVO> test();

   List<BoardPopularityVO> selectTopViewedPosts();

   BoardPopularityVO selectPostByIdAndTable(String var1, String var2);
}

 

혹시나 참고하실분은

컨트롤러나 쿼리.XML 같은 소스코드가 긴 부분은 여기 깃허브에서 확인해주시면 감사합니다.

https://github.com/xogus3492/dogFoot

GitHub - xogus3492/dogFoot: kosmo 중간 프로젝트