table.sql
--사원관리
create table semployee(
num number primary key,
id varchar2(12) unique not null,
name varchar2(30) not null,
passwd varchar2(12) not null,
salary number(8) not null,
job varchar2(30) not null,
reg_date date default sysdate not null
);
create sequence semployee_seq;
--사원게시판
create table story(
snum number not null, --프라이머리 키
title varchar2(150) not null,
content clob not null,
ip varchar2(30) not null,
num number not null, --포린키(외래키)
reg_date date default sysdate not null,
constraint story_pk primary key (snum),
constraint story_fk foreign key (num) references semployee (num)
);
create sequence story_seq;
kr.story.vo => 패키지
StoryVO
kr.story.dao => 패키지
StoryDAO
main.jsp
registerUserForm.jsp
registerUser.jsp
detail.jsp
comfirmId.jsp
list.jsp
login.jsp
logout.jsp
myPage.jsp
modifyUser.jsp
delete.jsp
deleteUser.jsp update.jsp
updateForm.jsp
write.jsp
writeForm.jsp
