board-mapper.xml 1) 조회수 증가 조회 UPDATE BOARD SET COUNT = COUNT+1 WHERE BOARD_NO = ? AND STATUS = 'Y' 2) 게시판 조회 SELECT BOARD_NO, CATEGORY_NAME, BOARD_TITLE, BOARD_CONTENT, USER_ID, CREATE_DATE FROM BOARD B LEFT JOIN CATEGORY USING (CATEGORY_NO) JOIN MEMBER ON (BOARD_WRITER = USER_NO) WHERE BOARD_NO = ? AND B.STATUS = 'Y' 3) 사진 목록 조회 SELECT FILE_NO, ORIGIN_NAME, CHANGE_NAME, FILE_PATH FROM ATTACHMEN..