dataload.sql

ibatis源码及帮助文档(IBatis源码+xsd+帮助)

INSERT INTO [Suppliers] VALUES (1, 'XYZ Pets', 'AC', '600 Avon Way', '', 'Los Angeles', 'CA', '94024', '212-947-0797')
INSERT INTO [Suppliers] VALUES (2, 'ABC Pets', 'AC', '700 Abalone Way', '', 'San Francisco', 'CA', '94024', '415-947-0797')

INSERT INTO [Categories] VALUES ('FISH', 'Fish', NULL)
INSERT INTO [Categories] VALUES ('DOGS', 'Dogs', NULL)
INSERT INTO [Categories] VALUES ('REPTILES', 'Reptiles', NULL)
INSERT INTO [Categories] VALUES ('CATS', 'Cats', NULL)
INSERT INTO [Categories] VALUES ('BIRDS', 'Birds', NULL)

INSERT INTO [Products] VALUES ('FI-SW-01', 'FISH', 'Angelfish', 'Saltwater fish from Australia')
INSERT INTO [Products] VALUES ('FI-SW-02', 'FISH', 'Tiger Shark', 'Saltwater fish from Australia')
INSERT INTO [Products] VALUES ('FI-FW-01', 'FISH', 'Koi', 'Freshwater fish from Japan')
INSERT INTO [Products] VALUES ('FI-FW-02', 'FISH', 'Goldfish', 'Freshwater fish from China')
INSERT INTO [Products] VALUES ('K9-BD-01', 'DOGS', 'Bulldog', 'Friendly dog from England')
INSERT INTO [Products] VALUES ('K9-PO-02', 'DOGS', 'Poodle', 'Cute dog from France')
INSERT INTO [Products] VALUES ('K9-DL-01', 'DOGS', 'Dalmation', 'Great dog for a fire station')
INSERT INTO [Products] VALUES ('K9-RT-01', 'DOGS', 'Golden Retriever', 'Great family dog')
INSERT INTO [Products] VALUES ('K9-RT-02', 'DOGS', 'Labrador Retriever', 'Great hunting dog')
INSERT INTO [Products] VALUES ('K9-CW-01', 'DOGS', 'Chihuahua', 'Great companion dog')
INSERT INTO [Products] VALUES ('RP-SN-01', 'REPTILES', 'Rattlesnake', 'Doubles as a watch dog')
INSERT INTO [Products] VALUES ('RP-LI-02', 'REPTILES', 'Iguana', 'Friendly green friend')
INSERT INTO [Products] VALUES ('FL-DSH-01', 'CATS', 'Manx', 'Great for reducing mouse populations')
INSERT INTO [Products] VALUES ('FL-DLH-02', 'CATS', 'Persian', 'Friendly house cat, doubles as a princess')
INSERT INTO [Products] VALUES ('AV-CB-01', 'BIRDS', 'Amazon Parrot', 'Great companion for up to 75 years')
INSERT INTO [Products] VALUES ('AV-SB-02', 'BIRDS', 'Finch', 'Great stress reliever')

INSERT INTO [Items] VALUES ('EST-1', 'FI-SW-01', 16.50, 10.00, 1, 'P', 'Large', NULL, NULL, NULL, NULL,'fish1.jpg')
INSERT INTO [Items] VALUES ('EST-2', 'FI-SW-01', 16.50, 10.00, 1, 'P', 'Small', NULL, NULL, NULL, NULL,'fish1.jpg')
INSERT INTO [Items] VALUES ('EST-3', 'FI-SW-02', 18.50, 12.00, 1, 'P', 'Toothless', NULL, NULL, NULL, NULL,'fish2.jpg')
INSERT INTO [Items] VALUES ('EST-4', 'FI-FW-01', 18.50, 12.00, 1, 'P', 'Spotted', NULL, NULL, NULL, NULL,'fish3.jpg')
INSERT INTO [Items] VALUES ('EST-5', 'FI-FW-01', 18.50, 12.00, 1, 'P', 'Spotless', NULL, NULL, NULL, NULL,'fish3.jpg')
INSERT INTO [Items] VALUES ('EST-6', 'K9-BD-01', 18.50, 12.00, 1, 'P', 'Male Adult', NULL, NULL, NULL, NULL,'dog1.jpg')
INSERT INTO [Items] VALUES ('EST-7', 'K9-BD-01', 18.50, 12.00, 1, 'P', 'Female Puppy', NULL, NULL, NULL, NULL,'dog1.jpg')
INSERT INTO [Items] VALUES ('EST-8', 'K9-PO-02', 18.50, 12.00, 1, 'P', 'Male Puppy', NULL, NULL, NULL, NULL,'dog2.jpg')
INSERT INTO [Items] VALUES ('EST-9', 'K9-DL-01', 18.50, 12.00, 1, 'P', 'Spotless Male Puppy', NULL, NULL, NULL, NULL,'dog3.jpg')
INSERT INTO [Items] VALUES ('EST-10', 'K9-DL-01', 18.50, 12.00, 1, 'P', 'Spotted Adult Female', NULL, NULL, NULL, NULL,'dog3.jpg')
INSERT INTO [Items] VALUES ('EST-11', 'RP-SN-01', 18.50, 12.00, 1, 'P', 'Venomless', NULL, NULL, NULL, NULL,'reptile1.jpg')
INSERT INTO [Items] VALUES ('EST-12', 'RP-SN-01', 18.50, 12.00, 1, 'P', 'Rattleless', NULL, NULL, NULL, NULL,'reptile1.jpg')
INSERT INTO [Items] VALUES ('EST-13', 'RP-LI-02', 18.50, 12.00, 1, 'P', 'Green Adult', NULL, NULL, NULL, NULL,'reptile2.jpg')
INSERT INTO [Items] VALUES ('EST-14', 'FL-DSH-01', 58.50, 12.00, 1, 'P', 'Tailless', NULL, NULL, NULL, NULL,'cat1.jpg')
INSERT INTO [Items] VALUES ('EST-15', 'FL-DSH-01', 23.50, 12.00, 1, 'P', 'Tailed', NULL, NULL, NULL, NULL,'cat1.jpg')
INSERT INTO [Items] VALUES ('EST-16', 'FL-DLH-02', 93.50, 12.00, 1, 'P', 'Adult Female', NULL, NULL, NULL, NULL,'cat2.jpg')
INSERT INTO [Items] VALUES ('EST-17', 'FL-DLH-02', 93.50, 12.00, 1, 'P', 'Adult Male', NULL, NULL, NULL, NULL,'cat2.jpg')
INSERT INTO [Items] VALUES ('EST-18', 'AV-CB-01', 193.50, 92.00, 1, 'P', 'Adult Male', NULL, NULL, NULL, NULL,'bird1.jpg')
INSERT INTO [Items] VALUES ('EST-19', 'AV-SB-02', 15.50, 2.00, 1, 'P', 'Adult Male', NULL, NULL, NULL, NULL,'bird2.jpg')
INSERT INTO [Items] VALUES ('EST-20', 'FI-FW-02', 5.50, 2.00, 1, 'P', 'Adult Male', NULL, NULL, NULL, NULL,'fish4.jpg')
INSERT INTO [Items] VALUES ('EST-21', 'FI-FW-02', 5.29, 1.00, 1, 'P', 'Adult Female', NULL, NULL, NULL, NULL,'fish4.jpg')
INSERT INTO [Items] VALUES ('EST-22', 'K9-RT-02', 135.50, 100.00, 1, 'P', 'Adult Male', NULL, NULL, NULL, NULL,'dog5.jpg')
INSERT INTO [Items] VALUES ('EST-23', 'K9-RT-02', 145.49, 100.00, 1, 'P', 'Adult Female', NULL, NULL, NULL, NULL,'dog5.jpg')
INSERT INTO [Items] VALUES ('EST-24', 'K9-RT-02', 255.50, 92.00, 1, 'P', 'Adult Male', NULL, NULL, NULL, NULL,'dog5.jpg')
INSERT INTO [Items] VALUES ('EST-25', 'K9-RT-02', 325.29, 90.00, 1, 'P', 'Adult Female', NULL, NULL, NULL, NULL,'dog5.jpg')
INSERT INTO [Items] VALUES ('EST-26', 'K9-CW-01', 125.50, 92.00, 1, 'P', 'Adult Male', NULL, NULL, NULL, NULL,'dog6.jpg')
INSERT INTO [Items] VALUES ('EST-27', 'K9-CW-01', 155.29, 90.00, 1, 'P', 'Adult Female', NULL, NULL, NULL, NULL,'dog6.jpg')
INSERT INTO [Items] VALUES ('EST-28', 'K9-RT-01', 155.29, 90.00, 1, 'P', 'Adult Female', NULL, NULL, NULL, NULL,'dog4.jpg')

INSERT INTO [Inventories] VALUES ('EST-1', 10000)
INSERT INTO [Inventories] VALUES ('EST-2', 10000)
INSERT INTO [Inventories] VALUES ('EST-3', 10000)
INSERT INTO [Inventories] VALUES ('EST-4', 10000)
INSERT INTO [Inventories] VALUES ('EST-5', 10000)
INSERT INTO [Inventories] VALUES ('EST-6', 10000)
INSERT INTO [Inventories] VALUES ('EST-7', 10000)
INSERT INTO [Inventories] VALUES ('EST-8', 10000)
INSERT INTO [Inventories] VALUES ('EST-9', 10000)
INSERT INTO [Inventories] VALUES ('EST-10', 10000)
INSERT INTO [Inventories] VALUES ('EST-11', 10000)
INSERT INTO [Inventories] VALUES ('EST-12', 10000)
INSERT INTO [Inventories] VALUES ('EST-13', 10000)
INSERT INTO [Inventories] VALUES ('EST-14', 10000)
INSERT INTO [Inventories] VALUES ('EST-15', 10000)
INSERT INTO [Inventories] VALUES ('EST-16', 10000)
INSERT INTO [Inventories] VALUES ('EST-17', 10000)
INSERT INTO [Inventories] VALUES ('EST-18', 10000)
INSERT INTO [Inventories] VALUES ('EST-19', 10000)
INSERT INTO [Inventories] VALUES ('EST-20', 10000)
INSERT INTO [Inventories] VALUES ('EST-21', 10000)
INSERT INTO [Inventories] VALUES ('EST-22', 10000)
INSERT INTO [Inventories] VALUES ('EST-23', 10000)
INSERT INTO [Inventories] VALUES ('EST-24', 10000)
INSERT INTO [Inventories] VALUES ('EST-25', 10000)
INSERT INTO [Inventories] VALUES ('EST-26', 10000)
INSERT INTO [Inventories] VALUES ('EST-27', 10000)
INSERT INTO [Inventories] VALUES ('EST-28', 10000)