상품, 장바구니 DB 연결 | 상품 삭제시 장바구니 내역도 함께 삭제

-상품 DB-

create table shop2(shopnum smallint auto_increment primary key,
category varchar(30),
sangpum varchar(50),
photo varchar(50),
price int,
ipgoday varchar(20))

-장바구니 DB-

create table cart(idx smallint auto_increment primary key,
shopnum int references shop2(shopnum) on delete cascade,
num int references member(num) on delete cascade,
cnt int,
cartday date)

https://icandoitprogramming.tistory.com/entry/60-JspMineProject-shop2%ED%8F%B4%EB%8D%94-%EC%87%BC%ED%95%91%EB%AA%B0-%EC%87%BC%ED%95%91%EB%AA%B0%EC%83%81%EC%84%B8%ED%8E%98%EC%9D%B4%EC%A7%80-%EC%9E%A5%EB%B0%94%EA%B5%AC%EB%8B%88-%EB%8B%B4%EA%B8%B0?category=972002 

60. JspMineProject -> shop2폴더 -> 쇼핑몰, 쇼핑몰상세페이지, 장바구니 담기