Question
Database: insert into customer values (2094936, Charlie Vasquez, 1982-10-24, Keller, 556 E Weddell Dr, Sunnyvale, CA, 5633.67); insert into customer values (6705923, Nelson Robinson, 1971-10-16,
Database:
insert into customer values (2094936, "Charlie Vasquez", "1982-10-24", "Keller", "556 E Weddell Dr", "Sunnyvale", "CA", 5633.67); insert into customer values (6705923, "Nelson Robinson", "1971-10-16", "Burke", "1811 S Lake Pl", "Ontario", "CA", 5076.63); insert into customer values (9565824, "Doyle Holloway", "1972-06-03", "Garcia", "610 Us Highway 41", "Schererville", "IN", 1239.65); insert into customer values (2947923, "Kathy Chambers", "1964-08-13", "Figueroa", "436 Atwells Ave", "Providence", "RI", 5165.96); insert into customer values (5292552, "Douglas Cobb", "1985-02-11", "Price", "2175 Stone Ave", "San Jose", "CA", 4637.39); insert into customer values (8245122, "Vivian Rowe", "1958-01-31", "Herrera", "6835 26th St", "Rio Linda", "CA", 4532.77); insert into customer values (1174415, "Edward Hines", "1956-03-04", "Fox", "175 5th Ave", "New York", "NY", 1146.19); insert into customer values (6817950, "Judy Andrews", "1984-09-03", "West", "2223 Woodbridge Ave", "Edison", "NJ", 6907.76); insert into customer values (1479110, "David Rodriquez", "1971-04-21", "Leonard", "3706 Us Highway 20w W", "Monroeville", "OH", 4179.87); insert into customer values (5427964, "Caleb Mitchell", "1984-03-04", "Abbott", "3030 Elmore Park Rd", "Memphis", "TN", 6956.52); insert into customer values (6930650, "Alfredo Sparks", "1973-12-07", "Stanley", "345 Boniface Pky", "Anchorage", "AK", 3091.73); insert into customer values (7467160, "Roger Obrien", "1955-06-05", "Nash", "615 Bloomfield Ave", "Bloomfield", "NJ", 2206.47); insert into customer values (5292452, "Hubert Hunt", "1955-06-29", "Flowers", "318 Us Highway 9", "Englishtown", "NJ", 1389.45); insert into customer values (5816220, "Shelley Gregory", "1985-09-24", "Curry", "127 Ark Rd", "Mount Laurel", "NJ", 2222.61); insert into customer values (6143060, "Gina West", "1953-12-15", "Brooks", "1275 Boardman Canfield Rd", "Youngstown", "OH", 5407.35); insert into customer values (5661372, "Glenda Mccormick", "1969-10-27", "James", "4550 N Brady St", "Davenport", "IA", 5000.79); insert into customer values (9779525, "Rick Kennedy", "1981-04-26", "Greer", "1 Hanover Rd", "Florham Park", "NJ", 3628.86); insert into customer values (7669998, "Pam Hughes", "1986-08-04", "Ford", "1020 W Hamilton St", "Allentown", "PA", 6805.12); insert into customer values (2698811, "Kyle Mendez", "1962-03-20", "Wise", "201 Kings Hwy Sh", "Cherry Hill", "NJ", 2799.41); insert into customer values (2289245, "Ross Daniel", "1958-08-19", "Dawson", "844 Paoli Pike", "West Chester", "PA", 2187.98); insert into customer values (4953715, "Elena Logan", "1972-04-30", "Lewis", "1035 N Washington Ave", "Scranton", "PA", 4072.40); insert into customer values (5768508, "Austin Herrera", "1956-08-18", "Blake", "937 Youngstown Warren Rd", "Niles", "OH", 1846.80); insert into customer values (9299947, "Ellis Nash", "1971-12-13", "Paul", "300 Se Riverside Dr", "Evansville", "IN", 6280.97); insert into customer values (3470329, "Julia Graham", "1988-11-27", "Davis", "6000 S Marginal Rd", "Cleveland", "OH", 1194.89); insert into customer values (7303720, "Brett Brock", "1988-08-11", "Hayes", "2040 Market St", "Philadelphia", "PA", 5475.26); insert into customer values (9914212, "Peter Simpson", "1988-12-22", "Lowe", "720 E Morehead St", "Charlotte", "NC", 5566.15);
Write a java program that reads a request line sent by the client. The request line is in the following format: customerid The program retrieves the required information from the database, performs the necessary computations, and returns formatted output similar to the following example. 2689881 Katherine Owens Purchase report for Date Product Price Quantity Amount 2016-01-01 Jif Reduced Fat Peanut Butter Creamy 2016-01-01 Kraft Deluxe Macaroni & Cheese Four Cheese 2016-01-08 Scrubbing Bubbles Wipes Canister 2016-01-08 Nestle Toll House Morsels Semi-Sweet Chocolate 2016-01-09 Joy Liquid - Twist of Lime 2016-01-14 Simply Organic Crushed Red Pepper 2016-01-21 Clorox Disinfecting Wipes Lemon Fresh 2016-01-21 Ziploc Freezer Bags 4.29 2.00 3.09 2.69 1.87 2.19 5.99 3.99 2 1 4 10 3 4 1 3 8.58 2.00 12.36 26.90 5.61 8.76 5.99 11.97 Write a java program that reads a request line sent by the client. The request line is in the following format: customerid The program retrieves the required information from the database, performs the necessary computations, and returns formatted output similar to the following example. 2689881 Katherine Owens Purchase report for Date Product Price Quantity Amount 2016-01-01 Jif Reduced Fat Peanut Butter Creamy 2016-01-01 Kraft Deluxe Macaroni & Cheese Four Cheese 2016-01-08 Scrubbing Bubbles Wipes Canister 2016-01-08 Nestle Toll House Morsels Semi-Sweet Chocolate 2016-01-09 Joy Liquid - Twist of Lime 2016-01-14 Simply Organic Crushed Red Pepper 2016-01-21 Clorox Disinfecting Wipes Lemon Fresh 2016-01-21 Ziploc Freezer Bags 4.29 2.00 3.09 2.69 1.87 2.19 5.99 3.99 2 1 4 10 3 4 1 3 8.58 2.00 12.36 26.90 5.61 8.76 5.99 11.97Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started