(수정필요)쌍용교육 -JSP수업 53일차 employee(실습 추가 및 수정버전)

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

loginForm.jsp 

login.jsp 

logout.jsp

myPage.jsp 

modifyUserForm.jsp 

modifyUser.jsp 

delete.jsp

deleteUserForm.jsp 

deleteUser.jsp update.jsp

updateForm.jsp

write.jsp

writeForm.jsp