[MVC게시판] 게시판 목록 출력

게시판 리스트

/* Oracle */

CREATE TABLE BOARD
(
  BOARDNO    NUMBER,
  PARENTSNO  NUMBER                             DEFAULT 0,
  TITLE      VARCHAR2(100 BYTE),
  CONTENTS   VARCHAR2(4000 BYTE),
  HIT_CNT    NUMBER                             DEFAULT 0,
  DEL_YN     VARCHAR2(1 BYTE)                   DEFAULT 'N',
  REG_DATE   DATE                               DEFAULT SYSDATE,
  WRITER     VARCHAR2(30 BYTE),
  DEPTH      NUMBER                             DEFAULT 0,
  STEP       NUMBER                             DEFAULT 0,
  PASSWORD   NUMBER                             DEFAULT 0,
  REG_IP     VARCHAR2(100 BYTE)
)

COMMENT ON TABLE BOARD IS '게시판';
 
COMMENT ON COLUMN BOARD.BOARDNO IS '게시글 번호';
 
COMMENT ON COLUMN BOARD.PARENTSNO IS '부모글 번호';
 
COMMENT ON COLUMN BOARD.TITLE IS '게시글 제목';
 
COMMENT ON COLUMN BOARD.CONTENTS IS '게시글 내용';
 
COMMENT ON COLUMN BOARD.HIT_CNT IS '게시글 조회수';
 
COMMENT ON COLUMN BOARD.DEL_YN IS '게시글 삭제구분';
 
COMMENT ON COLUMN BOARD.REG_DATE IS '게시글 생성일자';
 
COMMENT ON COLUMN BOARD.WRITER IS '게시글 생성자 ID';
 
COMMENT ON COLUMN BOARD.DEPTH IS '게시글 답글  순서';
 
COMMENT ON COLUMN BOARD.STEP IS '게시글 답글 정렬';
 
COMMENT ON COLUMN BOARD.PASSWORD IS '게시글 비밀번호';
 
COMMENT ON COLUMN BOARD.REG_IP IS '게시글 작성자 IP';

BoardController.java

/* 

VO 객체를 쓰지 않고 Map 객체를 쓴다.

CommandMap 선언

리스트 출력을 하기에 List<Map<String,Object>>선언을 해준다.

selectBoardList설정을 하러 가보자.

 */

@Controller
public class BoardController {
    
    @Resource(name="boardService")
    private BoardService boardService;
 
    /**
      * @Method Name : indexView
      * @작성일 : 2016. 8. 3.
      * @작성자 : bin
      * @변경이력 : 
      * @Method 설명 : 게시판 리스트
      * @return
      */
    
    @RequestMapping(value="/board/list.do")
    public ModelAndView indexView(CommandMap commandMap){
        System.out.println("================index==============");
        commandMap.put("data", "this is test word");
        System.out.println("show data()...." + commandMap.get("data").toString());
        System.out.println("show map size()...." + commandMap.getMap().size());
        
        List<Map<String,Object>> list = boardService.selectBoardList(commandMap.getMap());
//        System.out.println("commandMap :" + commandMap.getMap().toString());
        
        ModelAndView mv = new ModelAndView("/board/list");
        mv.addObject("data", commandMap.get("data"));
        mv.addObject("map",list);
        return mv;
    }

BoardService.java

/* 

interface  선언

@Service 어노테이션 선언

 */

@Service
public interface BoardService {
    
    //게시판 리스트
    List<Map<String, Object>> selectBoardList(Map<String, Object> map);

BoardServiceImpl.java

/* 

implements BoardService를 해준다.

@Service 어노테이션 선언

@Resource(name="boardDAO") 리소스 선언

 */

@Service("boardService")
public class BoardServiceImpl implements BoardService {
 
    @Resource(name="boardDAO")
    private BoardDAO boardDAO;
    
    @Override
    public List<Map<String, Object>> selectBoardList(Map<String, Object> map) {
        return (List<Map<String, Object>>) boardDAO.selectBoardList(map);
    }

BoardDAO.java

/* 

extends  AbstraceDAO를 해준다.

@Repository어노테이션 선언

 */

@Repository("boardDAO")
public class BoardDAO extends AbstractDAO {
 
    @SuppressWarnings("unchecked")
    public List<Map<String, Object>> selectBoardList(Map<String, Object> map) {
        return (List<Map<String, Object>>) selectList("board.selectBoardList", map);
    }

Board_SQL.xml

/* 

paramterType="hashmap"

resultType="hashmap"

 */

    <!-- 게시판 리스트 출력 -->
    <select id="selectBoardList" parameterType="hashmap" resultType="hashmap">
 
    SELECT *
    FROM board 
    ORDER by BOARDNO DESC
    
    </select>

Result