240705 11주차 금요일 - 미니 프로젝트 쇼핑몰 제작 02

jdbc07_shoppingmall.zip

0.43MB

UploadTest.java

0.00MB

 

데이터베이스 테이블

 

create table basket(
id nvarchar2(100),
pcode nvarchar2(100),
pname nvarchar2(100),
price number,
count number
)

create table customer(
id nvarchar2(100),
name nvarchar2(100),
pw nvarchar2(100),
birthday date
)

create table product(
productimage nvarchar2(100),
pcode nvarchar2(100),
pname nvarchar2(100),
price number,
info  nvarchar2(100),
factory  nvarchar2(100),
groups  nvarchar2(100),
inven  number,
state nvarchar2(100)
)

create table ship(
order_number number,
name nvarchar2(100),
shipdate date,
country nvarchar2(100),
post_number number,
address nvarchar2(100),
phone number,
order_password nvarchar2(100)
)

create table order_history(
id nvarchar2(100),
order_number number,
pname nvarchar2(100),
price number,
count number
)
commit;