본문 바로가기

JSP(Java Server Page)

MVC1 패턴을 이용한 간단한 게시판 구현


mvc1.jar


//테이블 설계

//게시판 테이블

create table tb_board1(

board_no number primary key,

board_title varchar2(50) not null,

board_write varchar2(50) not null,

board_content varchar2(1000) not null,

board_regdate date,

group_no number

)


//시퀀스

CREATE SEQUENCE board_seq

    INCREMENT BY 1

    START WITH 1

    NOMAXVALUE

    NOCYCLE

    NOCACHE;


//댓글 테이블

create table tb_comment(

comment_no number primary key,

comment_wirter varchar2(50),

comment_content varchar2(200),

comment_regdate date,

board_no number

)