customers.sql

struts框架的jsf组件的核心实用例子集合

CREATE TABLE Customers (
   Cust_ID INT,
   Name CHAR(30),
   Phone_Number CHAR(15),
   Street_Address CHAR(30),
   City CHAR(30),
   State CHAR(15)
)

INSERT INTO Customers VALUES (1, 'William Dupont', '[phone]', 
   '801 Oak Street', 'Eugene', 'Nebraska')

INSERT INTO Customers VALUES (2, 'Anna Keeney', '[phone]', 
   '86 East Amherst Street', 'Buffalo', 'New York')

INSERT INTO Customers VALUES (3, 'Mariko Randor', '[phone]', 
   '923 Maple Street', 'Springfield', 'Tennessee')

INSERT INTO Customers VALUES (4,  'John Wilson', '[phone]', 
   '8122 Genessee Street', 'El Reno', 'Oklahoma')

INSERT INTO Customers VALUES (5,  'Lynn Seckinger', '[phone]', 
   '712 Kehr Street', 'Kent', 'Washington')

INSERT INTO Customers VALUES (6,  'Richard Tattersall', '[phone]', 
   '21 South Park Drive', 'Dallas', 'Texas')

INSERT INTO Customers VALUES (7,  'Gabriella Sarintia', '[phone]', 
   '81123 West Seneca Street', 'Denver', 'Colorado')

INSERT INTO Customers VALUES (8,  'Lisa Hartwig', '[phone]', 
   '6652 Sheridan Drive', 'Sheridan', 'Wyoming')

INSERT INTO Customers VALUES (9,  'Shirley Jones', '[phone]', 
   '2831 Main Street', 'Butte', 'Montana')

INSERT INTO Customers VALUES (10, 'Bill Sprague', '[phone]', 
   '1043 Cherry Street', 'Cheektowaga', 'New York')

INSERT INTO Customers VALUES (11, 'Greg Doench', '[phone]', 
   '99 Oak Street', 'Upper Saddle River', 'New Jersey')

INSERT INTO Customers VALUES (12, 'Solange Nadeau', '[phone]', 
   '177 Rue St. Catherine', 'Montreal', 'Quebec')

INSERT INTO Customers VALUES (13, 'Heather McGann', '[phone]', 
   '7192 913 West Park', 'Buloxie', 'Mississippi')

INSERT INTO Customers VALUES (14, 'Roy Martin', '[phone]', 
   '5571 North Olean Avenue', 'White River', 'Arkansas')

INSERT INTO Customers VALUES (15, 'Claude Loubier', '[phone]', 
   '1003 Rue de la Montagne', 'St. Marguerite de Lingwick', 'Quebec')

INSERT INTO Customers VALUES (16, 'Dan Woodard', '[phone]', 
   '2993 Tonawonda Street', 'Springfield', 'Missouri')

INSERT INTO Customers VALUES (17, 'Ron Dunlap', '[phone]', 
   '5579 East Seneca Street', 'Kansas City', 'Kansas')

INSERT INTO Customers VALUES (18, 'Keith Frankart', '[phone]', 
   '88124 Milpidas Lane', 'Springfield', 'Maryland')

INSERT INTO Customers VALUES (19, 'Andre Nadeau', '[phone]', 
   '94219 Rue Florence', 'St. Marguerite de Lingwick', 'Quebec')

INSERT INTO Customers VALUES (20, 'Horace Celestin', '[phone]', 
   '99423 Spruce Street', 'Ann Arbor', 'Michigan')