02. TABLE 생성, Domain ~ Service

1. TABLE 생성

CREATE TABLE TBL_REPLY (

  rno int NOT NULL AUTO_INCREMENT,

  bno int not null default 0,

  replytext varchar(1000) not null,

  replyer varchar(50) not null,

  regdate TIMESTAMP NOT NULL DEFAULT now(),

  updatedate TIMESTAMP NOT NULL DEFAULT now(),

  primary key(rno)

);

 

[외래키 추가]

alter table tbl_reply add constraint fk_board

foreign key (bno) references tbl_board (bno);

 

2. Domain

ReplyVO.java

3. SQL

4. DAO

ReplyDAO.java

ReplyDAOImpl.java

5. Service

ReplyService.java

ReplyServiceImpl.java