//BoardBean.java
package kojh.db.beans;

public class BoardBean
{
    int id;
    String name;
    String mail;
    String subject;
    String created_date;
    int hits;
    String memo;
    //이클립스의 자동 setter/getter 생성 기능을 이용하자~
    //개인적으로는 { 를 항상 함수명 다음 라인에 코딩하지만, 분량을 줄이고자 이어 붙였다..
    public int getId()  {
        return id;
    }
    public void setId(int id)  {
        this.id = id;
    }
    public String getName()  {
        return name;
    }
    public void setName(String name)  {
        this.name = name;
    }
    public String getMail()  {
        return mail;
    }
    public void setMail(String mail)  {
        this.mail = mail;
    }
    public String getSubject()  {
        return subject;
    }
    public void setSubject(String subject)  {
        this.subject = subject;
    }
    public int getHits()  {        return hits;
    }
    public void setHits(int hits)  {
        this.hits = hits;
    }
    public String getMemo()  {
        return memo;
    }
    public void setMemo(String memo)  {
        this.memo = memo;
    }
    public String getCreated_date()  {
        return created_date;
    }
    public void setCreated_date(String created_date)  {
        this.created_date = created_date;
    }
}

// BoardMapper.java
package kojh.spring.mappers;
import java.util.ArrayList;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Update;
import org.apache.ibatis.annotations.Delete;
import kojh.db.beans.BoardBean;

public interface BoardMapper
{
    final String SELECT_PAGE =
       "SELECT * FROM ( SELECT  ID,SUBJECT,NAME, CREATED_DATE, "+
       "MAIL,MEMO,HITS, ceil( rownum / #{rowsPerPage} ) as page "+
       "FROM SPRING_BOARD  ORDER BY ID DESC ) WHERE page = #{page}";

    final String SELECT_BY_ID =
        "SELECT ID,SUBJECT,NAME,CREATED_DATE,MAIL,MEMO,HITS"+
        "from SPRING_BOARD WHERE ID=#{id}";

    final String SELECT_CNT_BY_SUBJECT =
        "SELECT COUNT(1) FROM SPRING_BOARD WHERE"+
        "SUBJECT LIKE '%'||'${searchThis}'||'%'";

    final String SELECT_ROWS_BY_SUBJECT =
        "SELECT * FROM (SELECT ID,SUBJECT,NAME,"+
        "CREATED_DATE, MAIL,MEMO,HITS, "+
        "ceil( rownum / #{rowsPerPage}) as page FROM SPRING_BOARD "+
        "WHERE SUBJECT LIKE '%'||'${likeThis}'||'%' ORDER BY ID DESC) "+
        "WHERE page = #{page}";

    final String SELECT_CNT_ALL = "SELECT count(1) FROM SPRING_BOARD";

    final String INSERT =
        "INSERT INTO SPRING_BOARD (ID,SUBJECT,NAME,CREATED_DATE,MAIL,"+
        "MEMO) VALUES( SEQ_ID.NEXTVAL,#{subject}, #{name},"+
        "SYSDATE, #{mail}, #{memo})";

    final String UPDATE_BY_ID =
        "UPDATE SPRING_BOARD SET SUBJECT= #{subject},MAIL= #{mail},"+
        "MEMO= #{memo} WHERE ID= #{id}";

    final String DELETE_BY_ID= "DELETE FROM SPRING_BOARD WHERE ID=#{id}";

    //BoardBean 의 속성들과 동일한 이름으로 #{mail} 등을 지정해야한다.
    @Select(SELECT_PAGE)
    @Results(value = {
            @Result(property="id", column="ID"),
            @Result(property="subject", column="SUBJECT"),
            @Result(property="name", column="NAME"),
            @Result(property="created_date", column="CREATED_DATE"),
            @Result(property="mail", column="MAIL"),
            @Result(property="memo", column="MEMO"),
            @Result(property="hits", column="HITS")
        })
    ArrayList<BoardBean> getList(@Param("page") int page, @Param("rowsPerPage") int rowsPerPage);

    @Select(SELECT_BY_ID)
    @Results(value = {
            @Result(property="id", column="ID"),
            @Result(property="subject", column="SUBJECT"),
            @Result(property="name", column="NAME"),
            @Result(property="created_date", column="CREATED_DATE"),
            @Result(property="mail", column="MAIL"),
            @Result(property="memo", column="MEMO"),
            @Result(property="hits", column="HITS")
        })
    BoardBean getSpecificRow(@Param("id") String id);

    // 전체 글 갯수를 조회
    @Select(SELECT_CNT_ALL)
    int getTotalCnt();

    // 해당 주제의 관련글 갯수를 조회
    @Select(SELECT_CNT_BY_SUBJECT)
    int getTotalCntBySubject(@Param("searchThis") String includingThis);

    //해당 주제의 관련글 조회
    @Select(SELECT_ROWS_BY_SUBJECT)
    @Results(value = {
            @Result(property="id", column="ID"),
            @Result(property="subject", column="SUBJECT"),
            @Result(property="name", column="NAME"),
            @Result(property="created_date", column="CREATED_DATE"),
            @Result(property="mail", column="MAIL"),
            @Result(property="memo", column="MEMO"),
            @Result(property="hits", column="HITS")
        })
    public ArrayList<BoardBean> getSearchedList(@Param("page") int page,
                                                @Param("rowsPerPage") int rowsPerPage,
                                                @Param("likeThis") String strSearchThis);

    @Insert(INSERT)
    //@Options(useGeneratedKeys = true, keyProperty = "id")
    void insertBoard (BoardBean boardBean);

    @Update(UPDATE_BY_ID)
    void updateBoard (@Param("id") int id,@Param("subject") String subject, @Param("mail") String mail,@Param("memo") String memo);

    @Delete(DELETE_BY_ID)
    void deleteSpecificRow(@Param("id") int id);
}

package kojh.spring.board;

import java.util.ArrayList;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import kojh.db.beans.BoardBean;
import kojh.spring.mappers.BoardMapper;

@Component
public class BoardService //직접 구현함~~ 원래는 interface로 정의 하는게 좋아요~
{
    @Autowired
    private BoardMapper boardMapper;

    public ArrayList<BoardBean> getList(int nStartPage, int list_num) {
        return this.boardMapper.getList(nStartPage, list_num);
    }
    public BoardBean getSpecificRow(String id) {
        return this.boardMapper.getSpecificRow(id);
    }

    public int getTotalCnt() {
        int nCnt = 0;
        nCnt= this.boardMapper.getTotalCnt();
        return nCnt;
    }

    public int getTotalCntBySubject(String search) {
        int nCnt = 0;
        nCnt= this.boardMapper.getTotalCntBySubject(search) ;
        return nCnt;
    }

    public void insertBoard (BoardBean boardBean) {
        boardMapper.insertBoard(boardBean);
    }

    public void updateBoard (BoardBean boardBean) {
        boardMapper.updateBoard(boardBean.getId(),
            boardBean.getSubject(), boardBean.getMail(), boardBean.getMemo());
    }

    public void deleteRow(int id)  {
        this.boardMapper.deleteSpecificRow(id);
    }

    public ArrayList<BoardBean> getSearchedList(int nStartPage, int list_num,
                                                                                        String strSearchThis)  {
        return this.boardMapper.getSearchedList(nStartPage, list_num, strSearchThis);
    }
}

//BbsController.java
package kojh.spring.board;

import kojh.db.beans.BoardBean;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;

@Controller
public class BbsController
{
    @Autowired
    BoardService boardService;

    private static final Logger logger = LoggerFactory.getLogger(HomeController.class);

    ////////////////////////////////////////////////////////////////////////////////////////////////////
    @RequestMapping(value = "/show_write_form", method = RequestMethod.GET)
    public String show_write_form( Model model)
    {
        logger.info("show_write_form called!!");
        // 객체를 전달해서 값을 얻어와야 함!!!
        model.addAttribute("boardBeanObjToWrite", new BoardBean());
        return "writeBoard";
    }

    ////////////////////////////////////////////////////////////////////////////////////////////////////
    @RequestMapping(value = "/DoWriteBoard", method = RequestMethod.POST)
    public String DoWriteBoard( BoardBean boardBeanObjToWrite,
                                Model model)
    {
        logger.info("DoWriteBoard called!!");
        logger.info("memo=["+boardBeanObjToWrite.getMemo()+"]");
        boardService.insertBoard(boardBeanObjToWrite);
        model.addAttribute("totalCnt", new Integer(boardService.getTotalCnt()) );
        model.addAttribute("current_page", "1" ); //글을 작성후에는 처음 페이지로 돌아간다
        model.addAttribute("boardList", boardService.getList( 1, 2));
        return "listSpecificPage";
    }

    ////////////////////////////////////////////////////////////////////////////////////////////////////
    //개별 목록 조회
    @RequestMapping(value = "/viewWork", method = RequestMethod.GET)
    public String viewWork    (
                                @RequestParam("memo_id") String memo_id,
                                @RequestParam("current_page") String current_page,
                                @RequestParam("searchStr") String searchStr,
                                Model model
                            )
    {
        logger.info("viewWork called!!");
        logger.info("memo_id=["+ memo_id+"] current_page=["+current_page+
              "] searchStr=["+searchStr+"]");

        model.addAttribute("memo_id", memo_id );
        model.addAttribute("current_page", current_page );
        model.addAttribute("searchStr", searchStr );
        model.addAttribute("boardData", boardService.getSpecificRow(memo_id) );
        return "viewMemo";
    }

    ////////////////////////////////////////////////////////////////////////////////////////////////////
    // 특정 페이지에서 작업중 목록으로 나올경우, 이전 페이지 번호를 참조해서
    // 해당 페이지 출력
    @RequestMapping(value = "/listSpecificPageWork", method = RequestMethod.GET)
    public String listSpecificPageWork    (
                                @RequestParam("current_page") String pageForView,
                                Model model
                            )
    {
        logger.info("listSpecificPageWork called!!");
        logger.info("current_page=["+pageForView+"]");
        model.addAttribute("totalCnt", new Integer(boardService.getTotalCnt()) );
        model.addAttribute("current_page", pageForView );
        model.addAttribute("boardList", boardService.getList( Integer.parseInt(pageForView), 2));
        return "listSpecificPage";
    }

    ////////////////////////////////////////////////////////////////////////////////////////////////////
    // 특정 페이지 수정을 위한 내용 출력
    @RequestMapping(value = "/listSpecificPageWork_to_update", method = RequestMethod.GET)
    public String listSpecificPageWork_to_update    (
                                @RequestParam("memo_id") String memo_id,
                                @RequestParam("current_page") String current_page,
                                Model model
                            )
    {
        logger.info("listSpecificPageWork_to_update called!!");
        logger.info("memo_id=["+ memo_id+"] current_page=["+current_page+"]");
        model.addAttribute("memo_id", memo_id );
        model.addAttribute("current_page", current_page );
        model.addAttribute("boardData", boardService.getSpecificRow(memo_id) );
        return "viewMemoForUpdate";
    }

    ////////////////////////////////////////////////////////////////////////////////////////////////////
    //개별 row 업데이트
    @RequestMapping(value = "/DoUpdateBoard", method = RequestMethod.POST)
    public String DoUpdateBoard(
                                BoardBean boardBeanObjToUpdate,
                                @RequestParam("memo_id") int memo_id, //String,int 둘다 작동됨
                                @RequestParam("current_page") String current_page,
                                Model model)
    {
        logger.info("DoUpdateBoard called!!");
        logger.info("listSpecificPageWork_to_update called!!");
        //boardBeanObjToUpdate.getId() 가 0이다! 값을 설정하지 않았기 때문이다. 대신,memo_id 를 이용하자
        logger.info("memo_id=["+ memo_id+""+"/"+boardBeanObjToUpdate.getId()+"] current_page=["+current_page+"]");
        logger.info("memo=["+boardBeanObjToUpdate.getMemo()+"]");

        boardBeanObjToUpdate.setId(memo_id); // 약간의 꼼수...
        boardService.updateBoard(    boardBeanObjToUpdate    );
        model.addAttribute("totalCnt", new Integer(boardService.getTotalCnt()) );
        model.addAttribute("current_page", current_page );
        model.addAttribute("boardList", boardService.getList( Integer.parseInt(current_page), 2));
        return "listSpecificPage";
    }

    ////////////////////////////////////////////////////////////////////////////////////////////////////
    // 삭제 DeleteSpecificRow
    @RequestMapping(value = "/DeleteSpecificRow", method = RequestMethod.GET)
    public String DeleteSpecificRow(@RequestParam("memo_id") int memo_id,
                                    @RequestParam("current_page") String current_page,
                                    Model model)
    {
        logger.info("DeleteSpecificRow called!!");
        logger.info("memo_id=[" + memo_id + "] current_page=[" + current_page + "]");
        boardService.deleteRow(memo_id);
        //다시 페이지를 조회한다.
        model.addAttribute("totalCnt", new Integer(boardService.getTotalCnt()) );
        model.addAttribute("current_page", current_page);
        model.addAttribute("boardList", boardService.getList( Integer.parseInt(current_page), 2));
        return "listSpecificPage";
    }

    ////////////////////////////////////////////////////////////////////////////////////////////////////
    @RequestMapping(value = "/searchWithSubject", method = RequestMethod.POST)
    public String searchWithSubject    (    @RequestParam("searchStr") String searchStr,
                                        Model model    )
    {
        //redirection...
        return listSearchedSpecificPageWork("1", searchStr, model);//처음에는 1 페이지만 보여줌
    }

    ////////////////////////////////////////////////////////////////////////////////////////////////////
    // 검색된 상태에서 특정 페이지로 이동하기
    @RequestMapping(value = "/listSearchedSpecificPageWork", method = RequestMethod.GET)
    public String listSearchedSpecificPageWork    (    @RequestParam("pageForView") String pageForView,
                                                    @RequestParam("searchStr") String searchStr,
                                                    Model model )
    {
        logger.info("listSearchedSpecificPageWork called!!");
        logger.info("pageForView=["+pageForView+"]");
        logger.info("searchStr=["+searchStr+"]");

        model.addAttribute("totalCnt", new Integer( boardService.getTotalCntBySubject(searchStr) ) );
        model.addAttribute("searchedList",
            boardService.getSearchedList(Integer.parseInt(pageForView),2, searchStr) );
        model.addAttribute("pageForView", Integer.parseInt(pageForView) );
        model.addAttribute("searchStr", searchStr );
        return "listSearchedPage";
    }
}

//PageNumberingManager.java
package kojh.spring.board;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

public class PageNumberingManager
{
    private static final PageNumberingManager pageNumberingManager =
            new PageNumberingManager();

    private static final Logger logger =
            LoggerFactory.getLogger(PageNumberingManager.class);

    private PageNumberingManager()    { }

    public  static PageNumberingManager getInstance()
    {
        return pageNumberingManager ;
    }

    public int getTotalPage(int total_cnt, int rowsPerPage)
    {
        logger.info("getTotalPage called!!");
        int total_pages = 0;
        if ((total_cnt % rowsPerPage) == 0)
            total_pages = total_cnt / rowsPerPage;
        else
            total_pages = (total_cnt / rowsPerPage) + 1;
        logger.info("getTotalPage return total_pages="+total_pages);
        return total_pages;
    }

    //게시판의 block처리 추가 필요 (이전/다음 블럭 버튼 처리)
    public int getPageBlock(int curPage, int pagePerBlock)
    {
        int block = 0;
        if ((curPage % pagePerBlock) == 0)
        {
           block = curPage / pagePerBlock;
        }
        else
        {
           block = curPage / pagePerBlock + 1;
        }
        return block;
    }

    // block 에 속한 첫번째 페이지 계산
    public int getFirstPageInBlock(int block, int pagePerBlock)
    {
        return ( ( block - 1 ) * pagePerBlock + 1 ) ;
    }

    // block 에 속한 마지막 페이지 계산
    public int getLastPageInBlock(int block, int pagePerBlock)
    {
        return ( block * pagePerBlock);
    }

    //... 기타 등등...
}