뉴스관리라는 것이 있음.
근데 공지사항이랑 다른 용도겠지?
게시판이랑은 뭐가 다른건가...
조회
SELECT NEWS_ID, NEWS_SJ, NEWS_CN, NEWS_ORIGIN, NTCE_DE, ATCH_FILE_ID, FRST_REGIST_PNTTM, FRST_REGISTER_ID,
LAST_UPDT_PNTTM LAST_UPDUSR_PNTTM, LAST_UPDUSR_ID FROM COMTNNEWSINFO WHERE 1=1 ORDER BY NEWS_ID
DESC LIMIT 10 OFFSET 0
저장버튼 눌렀을 때
INSERT INTO COMTNNEWSINFO (NEWS_ID , NEWS_SJ , NEWS_CN , NEWS_ORIGIN , NTCE_DE , ATCH_FILE_ID
, FRST_REGIST_PNTTM , FRST_REGISTER_ID , LAST_UPDT_PNTTM , LAST_UPDUSR_ID) VALUES ( 'NEWS_000000000000001'
, '첫번째 뉴스' , '첫번째 뉴스입니다.' , 'http://nobang.tistory.com' , '20181012' , NULL , sysdate() , 'USRCNFRM_00000000000'
, sysdate() , 'USRCNFRM_00000000000' )
내용보기
SELECT NEWS_ID, NEWS_SJ, NEWS_CN, NEWS_ORIGIN, NTCE_DE, ATCH_FILE_ID , DATE_FORMAT(FRST_REGIST_PNTTM,'%Y-%m-%d')
FRST_REGIST_PNTTM , FRST_REGISTER_ID, DATE_FORMAT(LAST_UPDT_PNTTM,'%Y-%m-%d') LAST_UPDT_PNTTM
, LAST_UPDUSR_ID FROM COMTNNEWSINFO WHERE NEWS_ID='NEWS_000000000000001'
