sonichsqldatabase.script

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

INSERT INTO STOREFRONT_ALBUM VALUES(38,22,2,'Chunga''s Revenge',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(39,22,2,'Fillmore East, June 1971',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(40,22,2,'Just Another Band From LA',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(41,22,2,'Waka / Jawaka',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(42,22,2,'The Grand Wazoo',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(43,22,2,'Roxy and Elsewhere',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(44,22,2,'Apostrophe (*)',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(45,22,2,'One Size Fits All',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(46,22,2,'Bongo Fury',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(47,22,2,'Zoot Allures',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(48,22,2,'Zappa In New York',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(49,22,2,'Studio Tan',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(50,22,2,'Sleep Dirt',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(51,22,2,'Orchestral Favorties',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(52,22,2,'Tinsel Town Rebellion',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(53,22,2,'Ship Arriving Too Late To Save A Drowning Witch',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(54,22,2,'Baby SnakesBaby Snakes',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(55,22,2,'Them Or Us',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(56,22,2,'Francesco Zappa',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(57,22,2,'Old Masters I ',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(58,22,2,'Old Masters II',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(59,22,2,'Old Masters III',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(60,22,2,'FZ Meets The Mothers Of Prevention',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(61,22,2,'Jazz From Hell',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(62,22,2,'Guitar',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(63,22,2,'Boulez Conducts Zappa: The Perfect Stranger',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(64,22,2,'Make a Jazz Noise Here',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(65,22,2,'Playground Psychotics ',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(66,22,2,'You Can''t Do That on Stage Anymore Vol. 4',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(67,22,2,'You Can''t Do That on Stage Anymore Vol. 5',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(68,22,2,'You Can''t Do That on Stage Anymore Vol. 6',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(69,22,2,'Ahead of Their Time ',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(70,22,2,'The Yellow Shark',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(71,22,2,'Frank Zappa The Lost Episodes ',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(72,22,2,'Lather ',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(73,22,2,'FZ Plays FZ A Memorial Tribute',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(74,22,2,'Have I Offended Someone ?',NULL,NULL,'Ryco Disc')
INSERT INTO STOREFRONT_ALBUM VALUES(75,22,11,'Mu',NULL,NULL,'Carey Records')
INSERT INTO STOREFRONT_ALBUM VALUES(76,22,10,'Flee Past''s Ape Elf',NULL,NULL,'Carey Records')
INSERT INTO STOREFRONT_ALBUM VALUES(77,22,9,'Trout Mask Replica',NULL,NULL,'Carey Records')
INSERT INTO STOREFRONT_ALBUM VALUES(78,22,9,'Safe As Milk',NULL,NULL,'Carey Records')
INSERT INTO STOREFRONT_ALBUM VALUES(79,22,9,'Strictly Personal',NULL,NULL,'Carey Records')
INSERT INTO STOREFRONT_ALBUM VALUES(80,22,9,'The Mirror Man Sessions',NULL,NULL,'Carey Records')
INSERT INTO STOREFRONT_ALBUM VALUES(81,22,9,'Lick My Decals Off Baby',NULL,NULL,'Carey Records')
INSERT INTO STOREFRONT_ALBUM VALUES(82,22,9,'Spotlight Kid / Clear Spot',NULL,NULL,'Carey Records')
INSERT INTO STOREFRONT_ALBUM VALUES(83,22,9,'Shiny Beast',NULL,NULL,'Carey Records')
INSERT INTO STOREFRONT_ALBUM VALUES(84,22,9,'Doc At The Radar Station',NULL,NULL,'Carey Records')
INSERT INTO STOREFRONT_ALBUM VALUES(85,22,9,'Ice Cream For Crow',NULL,NULL,'Carey Records')
INSERT INTO STOREFRONT_ALBUM VALUES(86,22,9,'I May Be Hungry But I Sure Ain''t Weird',NULL,NULL,'Carey Records')
INSERT INTO STOREFRONT_ALBUM VALUES(87,21,3,'Bridges To Babylon',NULL,NULL,'Columbia House')
INSERT INTO STOREFRONT_ALBUM VALUES(88,21,3,'Voodoo Lounge',NULL,NULL,'Columbia House')
INSERT INTO STOREFRONT_ALBUM VALUES(89,21,3,'Steel Wheels',NULL,NULL,'Columbia House')
INSERT INTO STOREFRONT_ALBUM VALUES(90,21,3,'Machine Head',NULL,NULL,'Columbia House')
INSERT INTO STOREFRONT_ALBUM VALUES(91,22,12,'hours...',NULL,'images/bowie.jpg','Columbia House')
INSERT INTO STOREFRONT_ALBUM VALUES(92,22,13,'Somewhere Between Heaven and Earth',NULL,'images/cindy_bullens.jpg','Columbia House')
INSERT INTO STOREFRONT_ALBUM VALUES(93,21,14,'Ed Hunter',NULL,'images/iron_maiden.jpg','Columbia House')
INSERT INTO STOREFRONT_ALBUM VALUES(94,22,15,'Brompton''s Cocktail',NULL,'images/meg_hentges.jpg','Columbia House')
INSERT INTO STOREFRONT_ALBUM VALUES(95,22,16,'Getting There',NULL,'images/bacon_bros.jpg','Columbia House')
INSERT INTO STOREFRONT_PRODUCT VALUES(1,'CD1',NULL,3.5,3.25,3.25,NULL)
INSERT INTO STOREFRONT_PRODUCT VALUES(2,'cD2',NULL,35,20,18.99,NULL)
INSERT INTO STOREFRONT_PRODUCT VALUES(3,'cD3',NULL,1500,1375,1375,NULL)
INSERT INTO STOREFRONT_PRODUCT VALUES(4,'CD4',NULL,850,800,799.99,NULL)
INSERT INTO STOREFRONT_PRODUCT VALUES(5,'cD5',NULL,10,8,7.95,NULL)
INSERT INTO STOREFRONT_PRODUCT VALUES(6,'CD6',NULL,19.95,18,18,NULL)
INSERT INTO STOREFRONT_PRODUCT VALUES(7,'CD7',NULL,50,25,25,NULL)
INSERT INTO STOREFRONT_PRODUCT VALUES(8,'CD8',NULL,10,7,7,NULL)
INSERT INTO STOREFRONT_PRODUCT VALUES(9,'CD9',NULL,25,9,9,NULL)
INSERT INTO STOREFRONT_PRODUCT VALUES(10,'CD10',NULL,50,9,9,NULL)
INSERT INTO STOREFRONT_PRODUCT VALUES(11,'CD11',NULL,5,1,1,NULL)
INSERT INTO STOREFRONT_PRODUCT VALUES(12,'CD12',NULL,2,2,2,NULL)
INSERT INTO STOREFRONT_PRODUCT VALUES(13,'CD13',NULL,12.95,12.99,12.99,NULL)
INSERT INTO STOREFRONT_PRODUCT VALUES(14,'CD14',NULL,15.95,8.99,8.99,NULL)
INSERT INTO STOREFRONT_PRODUCT VALUES(15,'CD15',NULL,12.95,11.99,11.99,NULL)
INSERT INTO STOREFRONT_PRODUCT VALUES(16,'CD16',NULL,9.95,8.99,8.99,NULL)
INSERT INTO STOREFRONT_PRODUCT VALUES(17,'CD17',NULL,11.95,10.99,9.99,NULL)
INSERT INTO STOREFRONT_PRODUCT VALUES(18,'CD18',NULL,15.99,12.99,12.99,'Let It Be')
INSERT INTO STOREFRONT_PRODUCT VALUES(19,'CD19',NULL,15.99,12.99,12.99,'Hootenanny')
INSERT INTO STOREFRONT_PRODUCT VALUES(20,'CD20',NULL,15.99,12.99,12.99,'Stink')
INSERT INTO STOREFRONT_PRODUCT VALUES(21,'CD21',NULL,15.99,12.99,12.99,'When The Shit Hits The Fans')
INSERT INTO STOREFRONT_PRODUCT VALUES(22,'CD22',NULL,16.99,13.99,13.99,'Early Recordings')
INSERT INTO STOREFRONT_PRODUCT VALUES(23,'CD23',NULL,16.99,13.99,13.99,'You Can''t Do That on Stage Anymore Vol. 3')
INSERT INTO STOREFRONT_PRODUCT VALUES(24,'CD24',NULL,16.99,13.99,13.99,'Hot Rats')
INSERT INTO STOREFRONT_PRODUCT VALUES(25,'CD25',NULL,16.99,13.99,13.99,'Weasels Ripped My Flesh')
INSERT INTO STOREFRONT_PRODUCT VALUES(26,'CD26',NULL,17.99,14.99,14.99,'Civilization Phase III')
INSERT INTO STOREFRONT_PRODUCT VALUES(27,'CD27',NULL,17.99,14.99,14.99,'Does Humor Belong In Music')
INSERT INTO STOREFRONT_PRODUCT VALUES(28,'CD28',NULL,17.99,14.99,14.99,'The Best Band You Never Heard In Your Life')
INSERT INTO STOREFRONT_PRODUCT VALUES(29,'CD29',NULL,17.99,14.99,14.99,'Broadway The Hard Way')
INSERT INTO STOREFRONT_PRODUCT VALUES(30,'CD30',NULL,17.99,14.99,14.99,'200 Motels')
INSERT INTO STOREFRONT_PRODUCT VALUES(31,'CD31',NULL,20.99,17.99,17.99,'Absolutely Free')
INSERT INTO STOREFRONT_PRODUCT VALUES(32,'CD32',NULL,20.99,17.99,17.99,'Freak Out')
INSERT INTO STOREFRONT_PRODUCT VALUES(33,'CD33',NULL,19.99,16.99,16.99,'We are Only In It For The Money')
INSERT INTO STOREFRONT_PRODUCT VALUES(34,'CD34',NULL,20.99,17.99,17.99,'Lumpy Gravy')
INSERT INTO STOREFRONT_PRODUCT VALUES(35,'CD35',NULL,20.99,17.99,17.99,'Crusing With Ruben and The Jets')
INSERT INTO STOREFRONT_PRODUCT VALUES(36,'CD36',NULL,20.99,17.99,17.99,'Uncle Meat')
INSERT INTO STOREFRONT_PRODUCT VALUES(37,'CD37',NULL,20.99,17.99,17.99,'Burnt Weeny Sandwich')
INSERT INTO STOREFRONT_PRODUCT VALUES(38,'CD38',NULL,20.99,17.99,17.99,'Chunga''s Revenge')
INSERT INTO STOREFRONT_PRODUCT VALUES(39,'CD39',NULL,20.99,17.99,17.99,'Fillmore East, June 1971')
INSERT INTO STOREFRONT_PRODUCT VALUES(40,'CD40',NULL,20.99,17.99,17.99,'Just Another Band From LA')
INSERT INTO STOREFRONT_PRODUCT VALUES(41,'CD41',NULL,20.99,17.99,17.99,'Waka / Jawaka')
INSERT INTO STOREFRONT_PRODUCT VALUES(42,'CD42',NULL,20.99,17.99,17.99,'The Grand Wazoo')
INSERT INTO STOREFRONT_PRODUCT VALUES(43,'CD43',NULL,20.99,17.99,17.99,'Roxy and Elsewhere')
INSERT INTO STOREFRONT_PRODUCT VALUES(44,'CD44',NULL,20.99,17.99,17.99,'Apostrophe (*)')
INSERT INTO STOREFRONT_PRODUCT VALUES(45,'CD45',NULL,20.99,17.99,17.99,'One Size Fits All')
INSERT INTO STOREFRONT_PRODUCT VALUES(46,'CD46',NULL,20.99,17.99,17.99,'Bongo Fury')
INSERT INTO STOREFRONT_PRODUCT VALUES(47,'CD47',NULL,20.99,17.99,17.99,'Zoot Allures')
INSERT INTO STOREFRONT_PRODUCT VALUES(48,'CD48',NULL,20.99,17.99,17.99,'Zappa In New York')
INSERT INTO STOREFRONT_PRODUCT VALUES(49,'CD49',NULL,20.99,17.99,17.99,'Studio Tan')
INSERT INTO STOREFRONT_PRODUCT VALUES(50,'CD50',NULL,20.99,17.99,17.99,'Sleep Dirt')
INSERT INTO STOREFRONT_PRODUCT VALUES(51,'CD51',NULL,20.99,17.99,17.99,'Orchestral Favorties')
INSERT INTO STOREFRONT_PRODUCT VALUES(52,'CD52',NULL,20.99,17.99,17.99,'Tinsel Town Rebellion')
INSERT INTO STOREFRONT_PRODUCT VALUES(53,'CD53',NULL,20.99,17.99,17.99,'Ship Arriving Too Late To Save A Drowning Witch')
INSERT INTO STOREFRONT_PRODUCT VALUES(54,'CD54',NULL,20.99,17.99,17.99,'Baby SnakesBaby Snakes')
INSERT INTO STOREFRONT_PRODUCT VALUES(55,'CD55',NULL,20.99,17.99,17.99,'Them Or Us')
INSERT INTO STOREFRONT_PRODUCT VALUES(56,'CD56',NULL,20.99,17.99,17.99,'Francesco Zappa')
INSERT INTO STOREFRONT_PRODUCT VALUES(57,'CD57',NULL,20.99,17.99,17.99,'Old Masters I ')
INSERT INTO STOREFRONT_PRODUCT VALUES(58,'CD58',NULL,20.99,17.99,17.99,'Old Masters II')
INSERT INTO STOREFRONT_PRODUCT VALUES(59,'CD59',NULL,20.99,17.99,17.99,'Old Masters III')
INSERT INTO STOREFRONT_PRODUCT VALUES(60,'CD60',NULL,20.99,17.99,17.99,'FZ Meets The Mothers Of Prevention')
INSERT INTO STOREFRONT_PRODUCT VALUES(61,'CD61',NULL,20.99,17.99,17.99,'Jazz From Hell')
INSERT INTO STOREFRONT_PRODUCT VALUES(62,'CD62',NULL,20.99,17.99,17.99,'Guitar')
INSERT INTO STOREFRONT_PRODUCT VALUES(63,'CD63',NULL,20.99,17.99,17.99,'Boulez Conducts Zappa: The Perfect Stranger')
INSERT INTO STOREFRONT_PRODUCT VALUES(64,'CD64',NULL,20.99,17.99,17.99,'Make a Jazz Noise Here')
INSERT INTO STOREFRONT_PRODUCT VALUES(65,'CD65',NULL,20.99,17.99,17.99,'Playground Psychotics ')
INSERT INTO STOREFRONT_PRODUCT VALUES(66,'CD66',NULL,20.99,17.99,17.99,'You Can''t Do That on Stage Anymore Vol. 4')
INSERT INTO STOREFRONT_PRODUCT VALUES(67,'CD67',NULL,20.99,17.99,17.99,'You Can''t Do That on Stage Anymore Vol. 5')
INSERT INTO STOREFRONT_PRODUCT VALUES(68,'CD68',NULL,20.99,17.99,17.99,'You Can''t Do That on Stage Anymore Vol. 6')
INSERT INTO STOREFRONT_PRODUCT VALUES(69,'CD69',NULL,20.99,17.99,17.99,'Ahead of Their Time ')
INSERT INTO STOREFRONT_PRODUCT VALUES(70,'CD70',NULL,20.99,17.99,17.99,'The Yellow Shark')
INSERT INTO STOREFRONT_PRODUCT VALUES(71,'CD71',NULL,20.99,17.99,17.99,'Frank Zappa The Lost Episodes ')
INSERT INTO STOREFRONT_PRODUCT VALUES(72,'CD72',NULL,20.99,17.99,17.99,'L\u00e4ther ')
INSERT INTO STOREFRONT_PRODUCT VALUES(73,'CD73',NULL,20.99,17.99,17.99,'FZ Plays FZ A Memorial Tribute')
INSERT INTO STOREFRONT_PRODUCT VALUES(74,'CD74',NULL,20.99,17.99,17.99,'Have I Offended Someone ?')
INSERT INTO STOREFRONT_PRODUCT VALUES(75,'CD75',NULL,15.99,12.99,12.99,'Mu')
INSERT INTO STOREFRONT_PRODUCT VALUES(76,'CD76',NULL,16.99,13.99,13.99,'Flee Past''s Ape Elf')
INSERT INTO STOREFRONT_PRODUCT VALUES(77,'CD77',NULL,15.99,12.99,12.99,'Trout Mask Replica')
INSERT INTO STOREFRONT_PRODUCT VALUES(78,'CD78',NULL,14.99,11.99,11.99,'Safe As Milk')
INSERT INTO STOREFRONT_PRODUCT VALUES(79,'CD79',NULL,16.99,13.99,13.99,'Strictly Personal')
INSERT INTO STOREFRONT_PRODUCT VALUES(80,'CD80',NULL,16.99,13.99,13.99,'The Mirror Man Sessions')
INSERT INTO STOREFRONT_PRODUCT VALUES(81,'CD81',NULL,17.99,14.99,14.99,'Lick My Decals Off Baby')
INSERT INTO STOREFRONT_PRODUCT VALUES(82,'CD82',NULL,16.99,13.99,13.99,'Spotlight Kid / Clear Spot')
INSERT INTO STOREFRONT_PRODUCT VALUES(83,'CD83',NULL,16.99,13.99,13.99,'Shiny Beast')
INSERT INTO STOREFRONT_PRODUCT VALUES(84,'CD84',NULL,17.99,14.99,14.99,'Doc At The Radar Station')
INSERT INTO STOREFRONT_PRODUCT VALUES(85,'CD85',NULL,16.99,13.99,13.99,'Ice Cream For Crow')
INSERT INTO STOREFRONT_PRODUCT VALUES(86,'CD86',NULL,18.99,15.99,15.99,'I May Be Hungry But I Sure Ain''t Weird')
INSERT INTO STOREFRONT_PRODUCT VALUES(87,'CD87',NULL,16.99,13.99,13.99,'Bridges To Babylon')
INSERT INTO STOREFRONT_PRODUCT VALUES(88,'CD88',NULL,18.99,15.99,15.99,'Voodoo Lounge')
INSERT INTO STOREFRONT_PRODUCT VALUES(89,'CD89',NULL,15.99,12.99,12.99,'Steel Wheels')
INSERT INTO STOREFRONT_PRODUCT VALUES(90,'CD90',NULL,17.99,14.99,14.99,'Machine Head')
INSERT INTO STOREFRONT_PRODUCT 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 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 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 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 VALUES(95,'CD95','The Bacon Brothers return with songs that chronicle lifes joys and pains.',24.95,20.99,20.99,'Getting There')