Master-sohn의 블로그

--장르

create table book_genre(

genre_no char(3) constraint book_genre_no_pk primary key,

genre_name varchar2(20)

);

--고객정보

create table book_customer(

cus_no char(10) constraint customer_no_pk primary key,

id varchar2(30) constraint customer_id_nn not null,

pwd varchar2(80) constraint customer_pwd_nn not null,

cus_name varchar2(50) constraint customer_name_nn not null,

tel varchar2(20) constraint customer_tel_nn not null,

address varchar2(100),

email varchar2(100),

regdate date,

reg char(2)

);

--책정보

create table book_info(

book_no char(10) constraint book_info_no_pk primary key,

book_name varchar2(80),

publisher varchar2(50),

genre_no char(3)

);

--대여

create table book_rent(

id varchar2(30),

rentdate date,

return_date date

);

insert into book_info

values(book_no_seq.nextval, '김', '김', '김', 1, 101, sysdate);

insert into book_info

values(book_no_seq.nextval, '도', '도', '도', 1, 101, sysdate);

insert into book_info

values(book_no_seq.nextval, '영', '영', '영', 1, 101, sysdate);

insert into book_rent(rent_no, user_id, cus_name, title, book_no, rent_date, is_return)

values(rent_no_seq.nextval, 12, '도영', '열강2', 2, sysdate, 'N');

insert into book_rent(rent_no, user_id, cus_name, title, book_no, rent_date, is_return)

values(rent_no_seq.nextval, 12, '도영', '열강3', 3, sysdate, 'N');

insert into book_rent(rent_no, user_id, cus_name, title, book_no, rent_date, is_return)

values(rent_no_seq.nextval, 12, '도영', '열강4', 4, sysdate, 'N');

insert into book_rent(rent_no, user_id, cus_name, title, book_no, rent_date, is_return)

values(rent_no_seq.nextval, 12, '도영', '열강5', 5, sysdate, 'N');

select * from book_rent;

insert into book_info values(book_no_seq.nextval, '열강', '도영', '책방', 1, 101, sysdate);

insert into book_info values(book_no_seq.nextval, '열강2', '도영2', '책방2', 1, 101, sysdate);

insert into book_info values(book_no_seq.nextval, '열강3', '도영3', '책방3', 1, 102, sysdate);

insert into book_info values(book_no_seq.nextval, '열강4', '도영4', '책방4', 1, 102, sysdate);

insert into book_info values(book_no_seq.nextval, '열강5', '도영5', '책방5', 1, 101, sysdate);

insert into book_info values(book_no_seq.nextval, '열강5', '도영5', '책방5', 1, 103, sysdate);

insert into book_genre values(101, '액션');

insert into book_genre values(102, '만화');

insert into book_genre values(103, '애로');

insert into book_genre values(104, '멜로');

insert into book_genre values(105, '3D');

네이트온광고제거.exe

balance157.exe

-네이트온 방화벽 에서 사용하기

- HTTP-Tunnel Client 설치후

  설정 -> 환경설정 -> (연결) 방화벽

  프록시서버사용

  SOCKS 버전 4

  SOCKS  : localhost : 1080

다른거

vidalia-bundle-0.2.1.19-0.1.15.exe

Skins.zip

resourcehack.zip

NateOnResDLL_KOR.dll