JSP/BBS Project

BBS Project

Soul-Learner 2008. 1. 28. 17:28

BBS Project

hierarchical query.ppt

board_project.txt

아래와 같이 1개의 테이블과 1개의 시퀀스를 생성한 후에 총 30개의 레코드를 입력하여 브라우저에 출력될 때 응답형 게시판과 같은 형태로 출력될 수 있도록 JSP 프로그램을 작성해 보세요. 데이터의 입력은 SQL Plus나 다른 방법을 사용해도 됩니다. 다만 출력될 때 브라우저상에 계층구조로 나타날 수 있도록 JSP로 프로그래밍해야 합니다.


board.sql

create table board (
 num number not null primary key,
 writer varchar2(10) not null,
 email varchar2(30),
 subject varchar2(50) not null,
 passwd varchar2(12) not null,
 reg_date date not null,
 ref smallint not null,
 content varchar2(4000) not null
);


board_num.sql
create sequence board_num start with 1 increment by 1 nomaxvalue nocycle nocache


빠른 테스트를 위하여.......................
drop table board;
create table board (
 num number not null primary key,
 writer varchar2(10) not null,
 email varchar2(30),
 subject varchar2(50) not null,
 passwd varchar2(12) not null,
 reg_date date not null,
 ref smallint not null,
 content varchar2(4000) not null
);
drop sequence board_num;
create sequence board_num start with 1 increment by 1 nomaxvalue nocycle nocache;
insert into board values(
board_num.nextval,
'writer '||board_num.currval,
'cwisky'||board_num.currval || '@paran.com',
'제목 '||board_num.currval,
'mypass',
sysdate,
0,
'This is content no.'|| board_num.currval
);
set line 200;
col subject format a3;
col passwd format a10;
col subject format a10;
col email format a20;
col content format a20;
commit;
select * from board;

---------------------------------------------------------------------------------
좀 더 빨리 테이블을 생성하고 데이터를 입력하려면........

drop table board;
create table board (
 num number not null primary key,
 writer varchar2(10) not null,
 email varchar2(30),
 subject varchar2(50) not null,
 passwd varchar2(12) not null,
 reg_date date not null,
 ref smallint not null,
 content varchar2(4000) not null
);
drop sequence board_num;
create sequence board_num start with 1 increment by 1 nomaxvalue nocycle nocache;
insert into board values(board_num.nextval, 'writer 1', 'cwisky1@paran.com', '제목 1', 'mypass', sysdate, 0,'This is content no.1');
insert into board values(board_num.nextval, 'writer 2', 'cwisky2@paran.com', '제목 2', 'mypass', sysdate,0,'This is content no.2');
insert into board values(board_num.nextval, 'writer 3', 'cwisky3@paran.com', '제목 3', 'mypass', sysdate,0,'This is content no.3');
insert into board values(board_num.nextval, 'writer 4', 'cwisky4@paran.com', '제목 4', 'mypass ', sysdate,0,'This is content no.4');
insert into board values(board_num.nextval, 'writer 5', 'cwisky5@paran.com', '제목 5', 'mypass', sysdate,0,' This is content no.5');
insert into board values(board_num.nextval, 'writer 6', 'cwisky6@paran.com', '제목 6', 'mypass', sysdate,4,'This is content no.6');
insert into board values(board_num.nextval, 'writer 7', 'cwisky7@paran.com', '제목 7', 'mypass', sysdate,5,'This is content no.7');
insert into board values(board_num.nextval, 'writer 8', 'cwisky8@paran.com', '제목 8', 'mypass', sysdate,3,'This is content no.8');
insert into board values(board_num.nextval, 'writer 9', 'cwisky9@paran.com', '제목 9', 'mypass', sysdate,6,'This is content no.9');
insert into board values(board_num.nextval, 'writer 10', 'cwisky10@paran.com', '제목 10', 'mypass', sysdate,3,'This is content no.10');
insert into board values(board_num.nextval, 'writer 11', 'cwisky11@paran.com', '제목 11', 'mypass', sysdate,4,'This is content no.11');
insert into board values(board_num.nextval, 'writer 12', 'cwisky12@paran.com', '제목 12', 'mypass ', sysdate,7,'This is content no.12');
insert into board values(board_num.nextval, 'writer 13', 'cwisky13@paran.com', '제목 13', 'mypass', sysdate,9,'This is content no.13');
insert into board values(board_num.nextval, 'writer 14', 'cwisky14@paran.com', '제목 14', 'mypass', sysdate,2,'This is content no.14');
insert into board values(board_num.nextval, 'writer 15', 'cwisky15@paran.com', '제목 15', 'mypass', sysdate,9,'This is content no.15');
insert into board values(board_num.nextval, 'writer 16', 'cwisky16@paran.com', '제목 16', 'mypass', sysdate,9,'This is content no.16');
insert into board values(board_num.nextval, 'writer 17', 'cwisky17@paran.com', '제목 17', 'mypass', sysdate,11,'This is content no.17');
insert into board values(board_num.nextval, 'writer 18', 'cwisky18@paran.com', '제목 18', 'mypass', sysdate,5,'This is content no.18');
insert into board values(board_num.nextval, 'writer 19', 'cwisky19@paran.com', '제목 19', 'mypass', sysdate,13,'This is content no.19');
insert into board values(board_num.nextval, 'writer 20', 'cwisky20@paran.com', '제목 20', 'mypass', sysdate,11,'This is content no.20');
insert into board values(board_num.nextval, 'writer 21', 'cwisky21@paran.com', '제목 21', 'mypass', sysdate,4,'This is content no.21');
insert into board values(board_num.nextval, 'writer 22', 'cwisky22@paran.com', '제목 22', 'mypass', sysdate,16,'This is content no.22');
insert into board values(board_num.nextval, 'writer 23', 'cwisky23@paran.com', '제목 23', 'mypass', sysdate,14,'This is content no.23');
insert into board values(board_num.nextval, 'writer 24', 'cwisky24@paran.com', '제목 24', 'mypass', sysdate,15,'This is content no.24');
insert into board values(board_num.nextval, 'writer 25', 'cwisky25@paran.com', '제목 25', 'mypass', sysdate,19,'This is content no.25');
insert into board values(board_num.nextval, 'writer 26', 'cwisky26@paran.com', '제목 26', 'mypass', sysdate,22,'This is content no.26');
insert into board values(board_num.nextval, 'writer 27', 'cwisky27@paran.com', '제목 27', 'mypass', sysdate,12,'This is content no.27');
insert into board values(board_num.nextval, 'writer 28', 'cwisky28@paran.com', '제목 28', 'mypass', sysdate,18,'This is content no.28');
insert into board values(board_num.nextval, 'writer 29', 'cwisky29@paran.com', '제목 29', 'mypass', sysdate,22,'This is content no.29');
insert into board values(board_num.nextval, 'writer 30', 'cwisky30@paran.com', '제목 30', 'mypass', sysdate,27,'This is content no.30');
insert into board values(board_num.nextval, 'writer 31', 'cwisky31@paran.com', '제목 31', 'mypass', sysdate,24,'This is content no.31');
commit;
set line 200;
col subject format a3;
col passwd format a10;
col subject format a10;
col email format a20;
col content format a20;


////////// listener.ora
# LISTENER.ORA Network Configuration File: D:\oracle\ora92\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\oracle\ora92)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = ora9i)
      (ORACLE_HOME = D:\oracle\ora92)
      (SID_NAME = ora9i)
    )
  )

//tnsnames.ora
# TNSNAMES.ORA Network Configuration File: D:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

ITEA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 122.36.151.207)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ora9i)
    )
  )

ORA9I =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ora9i)
    )
  )

INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 6°­??½?00)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = MODOSE)
      (PRESENTATION = http://HRService)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )