[쉽게 배우는 JSP 웹 프로그래밍] 15장 웹 쇼핑몰 예제 코드

WebMarket/WebContent/resources/sql/product.sql

CREATE TABLE IF NOT EXISTS product(
	p_id VARCHAR(10) NOT NULL,
	p_name VARCHAR(10),
	p_unitPrice INTEGER,
	p_description TEXT,
	p_manufacturer VARCHAR(20),
	p_unitsInStock LONG,
	p_condition VARCHAR(20),
	p_fileName VARCHAR(20),
	PRIMARY KEY (p_id)
)default CHARSET=utf8;

Alt + X 를 실행해도 eclipse에 Result 결과가 안나오는데 

DESC product; 명령어를 실행하면 product 테이블에 요소가 잘 들어간 것을 볼 수 있다

 

WebMarket/WebContent/resources/sql/insert.sql

INSERT INTO product VALUES('P1234', 'iPhone 6s', 800000, '1334X750 Renina HD display, 8-megapixel iSight Camera', 'Smart Phone', 'Apple', 1000, 'new', 'P1234.png');
INSERT INTO product VALUES('P1235', 'LG PC gram', 1500000, '3.3-inch,IPS LED display, 5rd Generation Intel Core processors',
'Notebook', 'LG', 1000, 'new', 'P1235.png');
INSERT INTO product VALUES('P1236', 'Galaxy Tab', 900000, '3.3-inch, 212.8*125.6*6.6mm. Super AMOLED display, Octa-Core processor',
'Tablet', 'Samsung', 1000, 'new', 'P1236.png');