dataloadmysql.sql

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

INSERT INTO STOREFRONT_ALBUM ( PRODUCT_ID, GENRE_ID, ARTIST_ID, NAME, LARGE_IMAGE_URL, SMALL_IMAGE_URL, LABEL ) VALUES (
71, 22, 2, 'Frank Zappa The Lost Episodes ', NULL, NULL, 'Ryco Disc');
INSERT INTO STOREFRONT_ALBUM ( PRODUCT_ID, GENRE_ID, ARTIST_ID, NAME, LARGE_IMAGE_URL, SMALL_IMAGE_URL, LABEL ) VALUES (
72, 22, 2, 'Lather ', NULL, NULL, 'Ryco Disc');
INSERT INTO STOREFRONT_ALBUM ( PRODUCT_ID, GENRE_ID, ARTIST_ID, NAME, LARGE_IMAGE_URL, SMALL_IMAGE_URL, LABEL ) VALUES (
73, 22, 2, 'FZ Plays FZ A Memorial Tribute', NULL, NULL, 'Ryco Disc');
INSERT INTO STOREFRONT_ALBUM ( PRODUCT_ID, GENRE_ID, ARTIST_ID, NAME, LARGE_IMAGE_URL, SMALL_IMAGE_URL, LABEL ) VALUES (
74, 22, 2, 'Have I Offended Someone ?', NULL, NULL, 'Ryco Disc');
INSERT INTO STOREFRONT_ALBUM ( PRODUCT_ID, GENRE_ID, ARTIST_ID, NAME, LARGE_IMAGE_URL, SMALL_IMAGE_URL, LABEL ) VALUES (
75, 22, 11, 'Mu', NULL, NULL, 'Carey Records');
INSERT INTO STOREFRONT_ALBUM ( PRODUCT_ID, GENRE_ID, ARTIST_ID, NAME, LARGE_IMAGE_URL, SMALL_IMAGE_URL, LABEL ) VALUES (
76, 22, 10, 'Flee Past''s Ape Elf', NULL, NULL, 'Carey Records');
INSERT INTO STOREFRONT_ALBUM ( PRODUCT_ID, GENRE_ID, ARTIST_ID, NAME, LARGE_IMAGE_URL, SMALL_IMAGE_URL, LABEL ) VALUES (
77, 22, 9, 'Trout Mask Replica', NULL, NULL, 'Carey Records');
INSERT INTO STOREFRONT_ALBUM ( PRODUCT_ID, GENRE_ID, ARTIST_ID, NAME, LARGE_IMAGE_URL, SMALL_IMAGE_URL, LABEL ) VALUES (
78, 22, 9, 'Safe As Milk', NULL, NULL, 'Carey Records');
INSERT INTO STOREFRONT_ALBUM ( PRODUCT_ID, GENRE_ID, ARTIST_ID, NAME, LARGE_IMAGE_URL, SMALL_IMAGE_URL, LABEL ) VALUES (
79, 22, 9, 'Strictly Personal', NULL, NULL, 'Carey Records');
INSERT INTO STOREFRONT_ALBUM ( PRODUCT_ID, GENRE_ID, ARTIST_ID, NAME, LARGE_IMAGE_URL, SMALL_IMAGE_URL, LABEL ) VALUES (
80, 22, 9, 'The Mirror Man Sessions', NULL, NULL, 'Carey Records');
INSERT INTO STOREFRONT_ALBUM ( PRODUCT_ID, GENRE_ID, ARTIST_ID, NAME, LARGE_IMAGE_URL, SMALL_IMAGE_URL, LABEL ) VALUES (
81, 22, 9, 'Lick My Decals Off Baby', NULL, NULL, 'Carey Records');
INSERT INTO STOREFRONT_ALBUM ( PRODUCT_ID, GENRE_ID, ARTIST_ID, NAME, LARGE_IMAGE_URL, SMALL_IMAGE_URL, LABEL ) VALUES (
82, 22, 9, 'Spotlight Kid / Clear Spot', NULL, NULL, 'Carey Records');
INSERT INTO STOREFRONT_ALBUM ( PRODUCT_ID, GENRE_ID, ARTIST_ID, NAME, LARGE_IMAGE_URL, SMALL_IMAGE_URL, LABEL ) VALUES (
83, 22, 9, 'Shiny Beast', NULL, NULL, 'Carey Records');
INSERT INTO STOREFRONT_ALBUM ( PRODUCT_ID, GENRE_ID, ARTIST_ID, NAME, LARGE_IMAGE_URL, SMALL_IMAGE_URL, LABEL ) VALUES (
84, 22, 9, 'Doc At The Radar Station', NULL, NULL, 'Carey Records');
INSERT INTO STOREFRONT_ALBUM ( PRODUCT_ID, GENRE_ID, ARTIST_ID, NAME, LARGE_IMAGE_URL, SMALL_IMAGE_URL, LABEL ) VALUES (
85, 22, 9, 'Ice Cream For Crow', NULL, NULL, 'Carey Records');
INSERT INTO STOREFRONT_ALBUM ( PRODUCT_ID, GENRE_ID, ARTIST_ID, NAME, LARGE_IMAGE_URL, SMALL_IMAGE_URL, LABEL ) VALUES (
86, 22, 9, 'I May Be Hungry But I Sure Ain''t Weird', NULL, NULL, 'Carey Records');
INSERT INTO STOREFRONT_ALBUM ( PRODUCT_ID, GENRE_ID, ARTIST_ID, NAME, LARGE_IMAGE_URL, SMALL_IMAGE_URL, LABEL ) VALUES (
87, 21, 3, 'Bridges To Babylon', NULL, NULL, 'Columbia House');
INSERT INTO STOREFRONT_ALBUM ( PRODUCT_ID, GENRE_ID, ARTIST_ID, NAME, LARGE_IMAGE_URL, SMALL_IMAGE_URL, LABEL ) VALUES (
88, 21, 3, 'Voodoo Lounge', NULL, NULL, 'Columbia House');
INSERT INTO STOREFRONT_ALBUM ( PRODUCT_ID, GENRE_ID, ARTIST_ID, NAME, LARGE_IMAGE_URL, SMALL_IMAGE_URL, LABEL ) VALUES (
89, 21, 3, 'Steel Wheels', NULL, NULL, 'Columbia House');
INSERT INTO STOREFRONT_ALBUM ( PRODUCT_ID, GENRE_ID, ARTIST_ID, NAME, LARGE_IMAGE_URL, SMALL_IMAGE_URL, LABEL ) VALUES (
90, 21, 3, 'Machine Head', NULL, NULL, 'Columbia House');
INSERT INTO STOREFRONT_ALBUM ( PRODUCT_ID, GENRE_ID, ARTIST_ID, NAME, LARGE_IMAGE_URL, SMALL_IMAGE_URL, LABEL ) VALUES (
91, 22, 12, 'hours...', NULL, 'images/bowie.jpg', 'Columbia House');
INSERT INTO STOREFRONT_ALBUM ( PRODUCT_ID, GENRE_ID, ARTIST_ID, NAME, LARGE_IMAGE_URL, SMALL_IMAGE_URL, LABEL ) VALUES (
92, 22, 13, 'Somewhere Between Heaven and Earth', NULL, 'images/cindy_bullens.jpg', 'Columbia House');
INSERT INTO STOREFRONT_ALBUM ( PRODUCT_ID, GENRE_ID, ARTIST_ID, NAME, LARGE_IMAGE_URL, SMALL_IMAGE_URL, LABEL ) VALUES (
93, 21, 14, 'Ed Hunter', NULL, 'images/iron_maiden.jpg', 'Columbia House');
INSERT INTO STOREFRONT_ALBUM ( PRODUCT_ID, GENRE_ID, ARTIST_ID, NAME, LARGE_IMAGE_URL, SMALL_IMAGE_URL, LABEL ) VALUES (
94, 22, 15, 'Brompton''s Cocktail', NULL, 'images/meg_hentges.jpg', 'Columbia House');
INSERT INTO STOREFRONT_ALBUM ( PRODUCT_ID, GENRE_ID, ARTIST_ID, NAME, LARGE_IMAGE_URL, SMALL_IMAGE_URL, LABEL ) VALUES (
95, 22, 16, 'Getting There', NULL, 'images/bacon_bros.jpg', 'Columbia House');






INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
1, 'CD1', NULL, 3.5, 3.25, 3.25, NULL);
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
2, 'cD2', NULL, 35, 20, 18.99, NULL);
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
3, 'cD3', NULL, 1500, 1375, 1375, NULL);
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
4, 'CD4', NULL, 850, 800, 799.99, NULL);
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
5, 'cD5', NULL, 10, 8, 7.95, NULL);
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
6, 'CD6', NULL, 19.95, 18, 18, NULL);
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
7, 'CD7', NULL, 50, 25, 25, NULL);
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
8, 'CD8', NULL, 10, 7, 7, NULL);
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
9, 'CD9', NULL, 25, 9, 9, NULL);
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
10, 'CD10', NULL, 50, 9, 9, NULL);
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
11, 'CD11', NULL, 5, 1, 1, NULL);
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
12, 'CD12', NULL, 2, 2, 2, NULL);
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
13, 'CD13', NULL, 12.95, 12.99, 12.99, NULL);
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
14, 'CD14', NULL, 15.95, 8.99, 8.99, NULL);
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
15, 'CD15', NULL, 12.95, 11.99, 11.99, NULL);
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
16, 'CD16', NULL, 9.95, 8.99, 8.99, NULL);
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
17, 'CD17', NULL, 11.95, 10.99, 9.99, NULL);
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
18, 'CD18', NULL, 15.99, 12.99, 12.99, 'Let It Be');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
19, 'CD19', NULL, 15.99, 12.99, 12.99, 'Hootenanny');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
20, 'CD20', NULL, 15.99, 12.99, 12.99, 'Stink');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
21, 'CD21', NULL, 15.99, 12.99, 12.99, 'When The Shit Hits The Fans');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
22, 'CD22', NULL, 16.99, 13.99, 13.99, 'Early Recordings');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
23, 'CD23', NULL, 16.99, 13.99, 13.99, 'You Can''t Do That on Stage Anymore Vol. 3');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
24, 'CD24', NULL, 16.99, 13.99, 13.99, 'Hot Rats');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
25, 'CD25', NULL, 16.99, 13.99, 13.99, 'Weasels Ripped My Flesh');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
26, 'CD26', NULL, 17.99, 14.99, 14.99, 'Civilization Phase III');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
27, 'CD27', NULL, 17.99, 14.99, 14.99, 'Does Humor Belong In Music');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
28, 'CD28', NULL, 17.99, 14.99, 14.99, 'The Best Band You Never Heard In Your Life');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
29, 'CD29', NULL, 17.99, 14.99, 14.99, 'Broadway The Hard Way');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
30, 'CD30', NULL, 17.99, 14.99, 14.99, '200 Motels');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
31, 'CD31', NULL, 20.99, 17.99, 17.99, 'Absolutely Free');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
32, 'CD32', NULL, 20.99, 17.99, 17.99, 'Freak Out');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
33, 'CD33', NULL, 19.99, 16.99, 16.99, 'We are Only In It For The Money');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
34, 'CD34', NULL, 20.99, 17.99, 17.99, 'Lumpy Gravy');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
35, 'CD35', NULL, 20.99, 17.99, 17.99, 'Crusing With Ruben and The Jets');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
36, 'CD36', NULL, 20.99, 17.99, 17.99, 'Uncle Meat');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
37, 'CD37', NULL, 20.99, 17.99, 17.99, 'Burnt Weeny Sandwich');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
38, 'CD38', NULL, 20.99, 17.99, 17.99, 'Chunga''s Revenge');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (
39, 'CD39', NULL, 20.99, 17.99, 17.99, 'Fillmore East, June 1971');
INSERT INTO STOREFRONT_PRODUCT ( PRODUCT_ID, SKU, DESCRIPTION, MSRP_PRICE, DERIVED_PRICE,
DERIVED_SALES_PRICE, NAME ) VALUES (