2020.11.20고급자바 ibatis , log 생성해서 호텔룸만들기 과제

1. 테이블 생성밑 데이터 입력 

create table room ( room_no number not null , room_kind varchar2(100) not null , customer varchar2(50) DEFAULT '-' , status varchar2(100) 

,     constraint pk_room primary key (room_no) ) 

insert into room ( room_no , room_kind , status ) values(201 , '싱글룸' , 'out' );

insert into room ( room_no , room_kind , status ) values(202 , '싱글룸' , 'out' );

insert into room ( room_no , room_kind , status ) values(203 , '싱글룸' , 'out' );

insert into room ( room_no , room_kind , status ) values(204 , '싱글룸' , 'out' );

insert into room ( room_no , room_kind , status ) values(205 , '싱글룸' , 'out' );

insert into room ( room_no , room_kind , status ) values(206 , '싱글룸' , 'out' );

insert into room ( room_no , room_kind , status ) values(207 , '싱글룸' , 'out' );

insert into room ( room_no , room_kind , status ) values(208 , '싱글룸' , 'out' );

insert into room ( room_no , room_kind , status ) values(209 , '싱글룸' , 'out' );

insert into room ( room_no , room_kind , status ) values(301 , '더블룸' , 'out' );

insert into room ( room_no , room_kind , status ) values(302 , '더블룸' , 'out' );

insert into room ( room_no , room_kind , status ) values(303 , '더블룸' , 'out' );

insert into room ( room_no , room_kind , status ) values(304 , '더블룸' , 'out' );

insert into room ( room_no , room_kind , status ) values(305 , '더블룸' , 'out' );

insert into room ( room_no , room_kind , status ) values(306 , '더블룸' , 'out' );

insert into room ( room_no , room_kind , status ) values(307 , '더블룸' , 'out' );

insert into room ( room_no , room_kind , status ) values(308 , '더블룸' , 'out' );

insert into room ( room_no , room_kind , status ) values(309 , '더블룸' , 'out' );

insert into room ( room_no , room_kind , status ) values(401 , '스위트룸' , 'out' );

insert into room ( room_no , room_kind , status ) values(402 , '스위트룸' , 'out' );

insert into room ( room_no , room_kind , status ) values(403 , '스위트룸' , 'out' );

insert into room ( room_no , room_kind , status ) values(404 , '스위트룸' , 'out' );

insert into room ( room_no , room_kind , status ) values(405 , '스위트룸' , 'out' );

insert into room ( room_no , room_kind , status ) values(406 , '스위트룸' , 'out' );

insert into room ( room_no , room_kind , status ) values(407 , '스위트룸' , 'out' );

insert into room ( room_no , room_kind , status ) values(408 , '스위트룸' , 'out' );

insert into room ( room_no , room_kind , status ) values(409 , '스위트룸' , 'out' );

2. 코드 log 생성 전 

구글드라이브 - 코드

3. log 생성 후