dataloadhsql.sql

基于struts框架的web开发应用实例

40, 'CD40', NULL, 20.99, 17.99, 17.99, 'Just Another Band From LA');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
41, 'CD41', NULL, 20.99, 17.99, 17.99, 'Waka / Jawaka');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
42, 'CD42', NULL, 20.99, 17.99, 17.99, 'The Grand Wazoo');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
43, 'CD43', NULL, 20.99, 17.99, 17.99, 'Roxy and Elsewhere');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
44, 'CD44', NULL, 20.99, 17.99, 17.99, 'Apostrophe (*)');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
45, 'CD45', NULL, 20.99, 17.99, 17.99, 'One Size Fits All');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
46, 'CD46', NULL, 20.99, 17.99, 17.99, 'Bongo Fury');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
47, 'CD47', NULL, 20.99, 17.99, 17.99, 'Zoot Allures');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
48, 'CD48', NULL, 20.99, 17.99, 17.99, 'Zappa In New York');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
49, 'CD49', NULL, 20.99, 17.99, 17.99, 'Studio Tan');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
50, 'CD50', NULL, 20.99, 17.99, 17.99, 'Sleep Dirt');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
51, 'CD51', NULL, 20.99, 17.99, 17.99, 'Orchestral Favorties');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
52, 'CD52', NULL, 20.99, 17.99, 17.99, 'Tinsel Town Rebellion');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
53, 'CD53', NULL, 20.99, 17.99, 17.99, 'Ship Arriving Too Late To Save A Drowning Witch');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
54, 'CD54', NULL, 20.99, 17.99, 17.99, 'Baby SnakesBaby Snakes');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
55, 'CD55', NULL, 20.99, 17.99, 17.99, 'Them Or Us');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
56, 'CD56', NULL, 20.99, 17.99, 17.99, 'Francesco Zappa');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
57, 'CD57', NULL, 20.99, 17.99, 17.99, 'Old Masters I ');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
58, 'CD58', NULL, 20.99, 17.99, 17.99, 'Old Masters II');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
59, 'CD59', NULL, 20.99, 17.99, 17.99, 'Old Masters III');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
60, 'CD60', NULL, 20.99, 17.99, 17.99, 'FZ Meets The Mothers Of Prevention');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
61, 'CD61', NULL, 20.99, 17.99, 17.99, 'Jazz From Hell');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
62, 'CD62', NULL, 20.99, 17.99, 17.99, 'Guitar');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
63, 'CD63', NULL, 20.99, 17.99, 17.99, 'Boulez Conducts Zappa: The Perfect Stranger');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
64, 'CD64', NULL, 20.99, 17.99, 17.99, 'Make a Jazz Noise Here');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
65, 'CD65', NULL, 20.99, 17.99, 17.99, 'Playground Psychotics ');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
66, 'CD66', NULL, 20.99, 17.99, 17.99, 'You Can''t Do That on Stage Anymore Vol. 4');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
67, 'CD67', NULL, 20.99, 17.99, 17.99, 'You Can''t Do That on Stage Anymore Vol. 5');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
68, 'CD68', NULL, 20.99, 17.99, 17.99, 'You Can''t Do That on Stage Anymore Vol. 6');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
69, 'CD69', NULL, 20.99, 17.99, 17.99, 'Ahead of Their Time ');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
70, 'CD70', NULL, 20.99, 17.99, 17.99, 'The Yellow Shark');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
71, 'CD71', NULL, 20.99, 17.99, 17.99, 'Frank Zappa The Lost Episodes ');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
72, 'CD72', NULL, 20.99, 17.99, 17.99, 'L鋞her ');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
73, 'CD73', NULL, 20.99, 17.99, 17.99, 'FZ Plays FZ A Memorial Tribute');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
74, 'CD74', NULL, 20.99, 17.99, 17.99, 'Have I Offended Someone ?');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
75, 'CD75', NULL, 15.99, 12.99, 12.99, 'Mu');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
76, 'CD76', NULL, 16.99, 13.99, 13.99, 'Flee Past''s Ape Elf');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
77, 'CD77', NULL, 15.99, 12.99, 12.99, 'Trout Mask Replica');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
78, 'CD78', NULL, 14.99, 11.99, 11.99, 'Safe As Milk');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
79, 'CD79', NULL, 16.99, 13.99, 13.99, 'Strictly Personal');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
80, 'CD80', NULL, 16.99, 13.99, 13.99, 'The Mirror Man Sessions');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
81, 'CD81', NULL, 17.99, 14.99, 14.99, 'Lick My Decals Off Baby');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
82, 'CD82', NULL, 16.99, 13.99, 13.99, 'Spotlight Kid / Clear Spot');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
83, 'CD83', NULL, 16.99, 13.99, 13.99, 'Shiny Beast');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
84, 'CD84', NULL, 17.99, 14.99, 14.99, 'Doc At The Radar Station');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
85, 'CD85', NULL, 16.99, 13.99, 13.99, 'Ice Cream For Crow');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
86, 'CD86', NULL, 18.99, 15.99, 15.99, 'I May Be Hungry But I Sure Ain''t Weird');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
87, 'CD87', NULL, 16.99, 13.99, 13.99, 'Bridges To Babylon');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
88, 'CD88', NULL, 18.99, 15.99, 15.99, 'Voodoo Lounge');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
89, 'CD89', NULL, 15.99, 12.99, 12.99, 'Steel Wheels');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
90, 'CD90', NULL, 17.99, 14.99, 14.99, 'Machine Head');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
91, 'CD91', 'Written solely with longtime collaborator Reeves Gabrels, this could be one of Bowies most autobiographical albums to date.'
, 20.99, 16.99, 9.99, 'hours...');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
92, 'CD92', 'This extraordinary singer-songwriter explores the death of her own child in heartbreaking compositions.'
, 20.99, 17.99, 17.99, 'Somewhere Between Heaven and Earth');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
93, 'CD93', 'Dont miss this double album of Maidens Top 20 of all time! Includes an Ed Hunter CD-ROM!'
, 21.99, 18.99, 18.99, 'Ed Hunter');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
94, 'CD94', '...One of the decades most playful, tuneful, and thoughtful alternative-pop efforts..--Barry Walters, The Advocate'
, 22.99, 19.99, 19.99, 'Brompton''s Cocktail');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
95, 'CD95', 'The Bacon Brothers return with songs that chronicle lifes joys and pains.'
, 24.95, 20.99, 20.99, 'Getting There');