[세미 프로젝트] 4. GUI 제작 및 테이블, DTO 설계, 추상메서드

일시 : 2021년 3월 13일(토) 오후 2시 30분 4차 회의

시간 : 4시간

내용 : GUI 제작 및 테이블, DTO 설계, 추상메서드

 

토요일 팀원 모두 강의실에 같이 바로바로 의견나누며 GUI와 테이블 제작해보기 위해 모였습니다.

김미연님과 홍영의님이 GUI를 제작하셨고 이건님, 윤하늘님, 윤상필 3명이서 테이블 구성 및 추상메서드를

정의해보았습니다.

 

-------고객정보 테이블
create table customer(
cnum number,
cname varchar2(35)constraint customer_cname_nn not null, 
cphone varchar2(30) constraint customer_cphone_nn not null, 
caddr varchar2(100),
constraint customer_cnum_pk primary key(cnum),
constraint customer_cphone_uq unique(cphone)
 );
create sequence customer_seq
increment by 1
start with 1;
--------관리자 계정
insert into customer values(customer_seq.nextval,'admin','kosmo7979','');   --마지막 칸에 null값이 들어간다
--------관리자 계정 확인
select cnum 고객번호, cname 고객명, cphone 고객연락처, caddr 주소 from customer;
/*  -- 실행 오류
insert into customer 
(cnum,cname,cphone)
values(customer_seq.nextval,'kosmo79','kosmo7979');
*/
-------제품 테이블
create table product(
pronum number,
proname varchar2(100) constraint product_proname_nn not null,
proprice number(20) constraint product_proprice_nn not null,
prostock number(7) constraint product_prostock_nn not null,
constraint product_pronum_pk primary key(pronum),
constraint product_proname_uq unique(proname)
);
create sequence product_seq
increment by 1
start with 1;

-------제품 입력
insert into product values(product_seq.nextval,'새우깡', 1500, 150);
insert into product values(product_seq.nextval,'자갈치', 1500, 150);
insert into product values(product_seq.nextval,'감자깡', 1500, 150);
insert into product values(product_seq.nextval,'고구마깡', 1500, 150);
insert into product values(product_seq.nextval,'치토스', 1500, 150);
insert into product values(product_seq.nextval,'바나나킥', 1500, 150);
insert into product values(product_seq.nextval,'홈런볼', 1500, 150);
insert into product values(product_seq.nextval,'커피', 1200, 150);
insert into product values(product_seq.nextval,'홍차', 800, 150);
insert into product values(product_seq.nextval,'프링글스', 4500, 150);
insert into product values(product_seq.nextval,'핫바', 1800, 150);
insert into product values(product_seq.nextval,'떢볶이', 3500, 150);
insert into product values(product_seq.nextval,'뿌셔뿌셔', 1500, 150);
insert into product values(product_seq.nextval,'빼빼로', 1000, 150);
insert into product values(product_seq.nextval,'사이다', 1200, 150);
insert into product values(product_seq.nextval,'콜라', 1400, 150);
insert into product values(product_seq.nextval,'환타', 1100, 150);
insert into product values(product_seq.nextval,'맥콜', 800, 150);
insert into product values(product_seq.nextval,'여명', 4500, 150);
insert into product values(product_seq.nextval,'햇반', 2500, 150);
insert into product values(product_seq.nextval,'삼각김밥', 1200, 150);
insert into product values(product_seq.nextval,'김밥', 2000, 150);
insert into product values(product_seq.nextval,'샌드위치', 2000, 150);
insert into product values(product_seq.nextval,'도시락', 4800, 150);
insert into product values(product_seq.nextval,'손톱깍이', 2800, 150);
insert into product values(product_seq.nextval,'소독약', 1600, 150);
insert into product values(product_seq.nextval,'라면', 800, 150);
insert into product values(product_seq.nextval,'타이레놀', 3000, 150);
insert into product values(product_seq.nextval,'문화상품권', 10000, 150);
insert into product values(product_seq.nextval,'핸드폰 충전기', 7000, 150);
commit;

--제품입력 확인
select pronum 상품코드, proname 상품명, proprice 가격, prostock 수량 from product;

 

0123456