JSP정의서(08.20~08.23)

JSP정의서(2024.08.20)

맡은 부분에 대한 JSP정의서(총 10page)

-> 수정사항(2024.08.23)

SQL문 실행해보고 수정

header.jsp 부분 수정(잘못 이해함)

-- INIT database
CREATE Table users (
  id integer primary key,
  email varchar(20),
  password varchar(10),
  name varchar(10),
  username varchar(10),
  phone varchar(10),
  birthday varchar(10),
  gender varchar(10),
  address varchar(10),
  picture varchar(10),
  hospital_official boolean
);

create Table pet (
  pet_id integer primary key,
  users_id integer REFERENCES users(id),
  pet_name varchar(10),
  pet_species varchar(10),
  breed varchar(10),
  pet_gender varchar(10),
  pet_age integer,
  neutering boolean,
  picture varchar(10),
  memo varchar(10),
  number integer
);

create Table recruit_post (
  post_id integer primary key,
  users_id integer REFERENCES users(id),
  pet_id integer REFERENCES pet(pet_id),
  post_time varchar(10),
  title varchar(10),
  post_content varchar(10),
  post_local varchar(10),
  recruit_form varchar(10),
  recruit_pay integer,
  recruit_start_time varchar(10),
  recruit_end_time varchar(10),
  post_status varchar(10)
);

create Table recruit_apply (
  recruit_id integer primary key,
  users_id integer REFERENCES users(id),
  post_id integer REFERENCES recruit_post(post_id),
  recruit_time varchar(20),
  recruit_status varchar(20),
  recruit_title varchar(20),
  recruit_content varchar(20)
);

INSERT INTO users VALUES (1,'hong.naver.com','1234','hong','yy','010-23','2000-02-01','male','금천구 독산동','0',true);
INSERT INTO pet VALUES (1,1,'hihi','강아지','골든리트리버','y',8,true,'0','hihi입니다',1);
INSERT INTO recruit_post VALUES (1, 1, 1, '2024-08-22','hihi에요','맡아주세요','서울시 금천구','일급',30000,'9:00','12:00','구인중');
INSERT INTO recruit_apply VALUES (1, 1, 1, '2024-08-22','구인중','hihi에요','맡아주세요');

-- QUERY database
select r.recruit_title,r.recruit_content,p.pet_name,p.pet_age,p.pet_gender,p.memo,u.name,u.birthday,u.gender,u.address,u.phone,u.email
from recruit_apply r join users u on r.users_id=u.id
join pet p
on u.id=p.users_id
where r.recruit_id=1;

 

 

최종안(09.11)

 

 

구글 스프레드 시트로 각자 페이지 작성

https://docs.google.com/spreadsheets/d/1c_b-j2KdtQP3rMecMvo1qDvNbJ7LqbtxFBWFfTXAOpM/edit?usp=sharing

SQL 문 온라인 실행 사이트

https://sqlfiddle.com/