books.sql

来自「《j2ee经典实例详解》的源代码。原书无附带光盘。介绍的是一个在线银行系统的例子」· SQL 代码 · 共 45 行

DROP TABLE books;

CREATE TABLE books
(id VARCHAR(8),
surname VARCHAR(24),
first_name VARCHAR(24),
title VARCHAR(96),
price FLOAT,
onSale BOOLEAN,
year INT,
description VARCHAR(30),
inventory INT);


DELETE FROM books;

INSERT INTO books VALUES('201', 'Duke', '',
 'My Early Years: Growing up on *7',
 30.75, true, 1995, 'What a cool book.', 20);

INSERT INTO books VALUES('202', 'Jeeves', '',
 'Web Servers for Fun and Profit', 40.75, false,
 2000, 'What a cool book.', 20);

INSERT INTO books VALUES('203', 'Masterson', 'Webster',
 'Web Components for Web Developers',
 27.75, true, 2000, 'What a cool book.', 20);

INSERT INTO books VALUES('205', 'Novation', 'Kevin',
 'From Oak to Java: The Revolution of a Language',
 10.75, false, 1998, 'What a cool book.', 20);

INSERT INTO books VALUES('206', 'Gosling', 'James',
 'Java Intermediate Bytecodes', 30.95, false,
 2000, 'What a cool book.', 20);

INSERT INTO books VALUES('207', 'Thrilled', 'Ben',
 'The Green Project: Programming for Consumer Devices',
 30.00, false, 1998, 'What a cool book', 20);

INSERT INTO books VALUES('208', 'Tru', 'Itzal',
 'Duke: A Biography of the Java Evangelist',
 45.00, true, 2001, 'What a cool book.', 20);