Script started on Sat 30 Jul 2016 11:52:26 PM EDT [?1034hbash-4.1$ javac Program.java bash-4.1$ java Program Connecting to Oracle... Connected! *************************************************************************************************** First report: Customer Activity for the Quarter April 1 - June 30, 2016 ----------------------------------------------------------- Customer Number: C09, Name: Arron Aderholt, Address: 7282 Littleton Drive _Wyoming MI 49509 Date | ITEM | Desc | Price | Ship | Qty | T_Price |T_Ship | Total | Credit | --------------------------------------------------------------------------------------------------- 160407 | I17 | office | 75 | 5 | 3 | 225 | 15 | 240 |4485381866541770 | --------------------------------------------------------------------------------------------------- 160504 | I16 | kitchen | 10 | 2.5 | 2 | 20 | 5 | 25 |4485381866541770 | --------------------------------------------------------------------------------------------------- 160602 | I01 | Printing | 21.99 | 2 | 20 | 439.8 | 40 | 479.8 |4485381866541770 | Customer Purchases:3, Overall Charge: 744.80, Average Charge: 248.27 Customer Number: C16, Name: Andrea Barzagli, Address: 32 West Silver Spear Ave. _Cranford NJ 07016 Date | ITEM | Desc | Price | Ship | Qty | T_Price |T_Ship | Total | Credit | --------------------------------------------------------------------------------------------------- 160402 | I10 | food | 150 | 1.5 | 32 | 4800 | 48 | 4848 |4929297006298500 | Customer Purchases:1, Overall Charge: 4848.00, Average Charge: 4848.00 Customer Number: C02, Name: Joann Janas, Address: 198 Cactus St. _Norcross GA 30092 Date | ITEM | Desc | Price | Ship | Qty | T_Price |T_Ship | Total | Credit | --------------------------------------------------------------------------------------------------- 160417 | I07 | Office | 20 | 2.2 | 5 | 100 | 11 | 111 |4532353085581030 | Customer Purchases:1, Overall Charge: 111.00, Average Charge: 111.00 Customer Number: C08, Name: Magdalene Miles, Address: 862 Shore St. _Springboro OH 45066 Date | ITEM | Desc | Price | Ship | Qty | T_Price |T_Ship | Total | Credit | --------------------------------------------------------------------------------------------------- 160403 | I17 | office | 75 | 5 | 1 | 75 | 5 | 80 |6011813257712410 | --------------------------------------------------------------------------------------------------- 160526 | I02 | Printing | 60 | 4.5 | 2 | 120 | 9 | 129 |6011813257712410 | Customer Purchases:2, Overall Charge: 209.00, Average Charge: 104.50 Customer Number: C14, Name: Gianluigi Buffon, Address: 81 E. Victoria St. _Whitestone NY 11357 Date | ITEM | Desc | Price | Ship | Qty | T_Price |T_Ship | Total | Credit | --------------------------------------------------------------------------------------------------- 160602 | I03 | Printing | 30.99 | 2 | 6 | 185.94 | 12 | 197.94 |4532889418233230 | --------------------------------------------------------------------------------------------------- 160602 | I01 | Printing | 21.99 | 2 | 6 | 131.94 | 12 | 143.94 |4532889418233230 | --------------------------------------------------------------------------------------------------- 160602 | I05 | Office | 70 | 2.2 | 6 | 420 | 13.2 | 433.2 |4532889418233230 | --------------------------------------------------------------------------------------------------- 160602 | I06 | Office | 40 | 1.2 | 6 | 240 | 7.2 | 247.2 |4532889418233230 | --------------------------------------------------------------------------------------------------- 160602 | I07 | Office | 20 | 2.2 | 6 | 120 | 13.2 | 133.2 |4532889418233230 | Customer Purchases:5, Overall Charge: 1155.48, Average Charge: 231.10 Customer Number: C07, Name: Kiana Kilgore, Address: 8434 Redwood St. _Olive Branch MS 38654 Date | ITEM | Desc | Price | Ship | Qty | T_Price |T_Ship | Total | Credit | --------------------------------------------------------------------------------------------------- 160512 | I19 | kitchen | 100 | 5 | 1 | 100 | 5 | 105 |5462305935179450 | --------------------------------------------------------------------------------------------------- 160402 | I18 | office | 150 | 10 | 5 | 750 | 50 | 800 |5462305935179450 | --------------------------------------------------------------------------------------------------- 160520 | I02 | Printing | 60 | 4.5 | 3 | 180 | 13.5 | 193.5 |5462305935179450 | Customer Purchases:3, Overall Charge: 1098.50, Average Charge: 366.17 Customer Number: C17, Name: Angelo Ogbonna, Address: 628 Creekside Rd. _Dubuque IA 52001 Date | ITEM | Desc | Price | Ship | Qty | T_Price |T_Ship | Total | Credit | --------------------------------------------------------------------------------------------------- 160407 | I09 | food | 30 | 1.5 | 15 | 450 | 22.5 | 472.5 |4024007125114710 | Customer Purchases:1, Overall Charge: 472.50, Average Charge: 472.50 Customer Number: C11, Name: Lesley Legleiter, Address: 48 Euclid Dr. _Riverdale GA 30274 Date | ITEM | Desc | Price | Ship | Qty | T_Price |T_Ship | Total | Credit | --------------------------------------------------------------------------------------------------- 160616 | I06 | Office | 40 | 1.2 | 11 | 440 | 13.2 | 453.2 |4330916251069420 | Customer Purchases:1, Overall Charge: 453.20, Average Charge: 453.20 Customer Number: C03, Name: Rosanne Roman, Address: 456 Gonzales Street _Lapeer MI 48446 Date | ITEM | Desc | Price | Ship | Qty | T_Price |T_Ship | Total | Credit | --------------------------------------------------------------------------------------------------- 160512 | I23 | Books | 40 | 10 | 4 | 160 | 40 | 200 |5338165439842310 | --------------------------------------------------------------------------------------------------- 160422 | I06 | Office | 40 | 1.2 | 11 | 440 | 13.2 | 453.2 |5338165439842310 | Customer Purchases:2, Overall Charge: 653.20, Average Charge: 326.60 Customer Number: C04, Name: Staci Scannell, Address: 59 Lincoln St. _Milwaukee WI 53204 Date | ITEM | Desc | Price | Ship | Qty | T_Price |T_Ship | Total | Credit | --------------------------------------------------------------------------------------------------- 160502 | I05 | Office | 70 | 2.2 | 34 | 2380 | 74.8 | 2454.8 |4929296680988780 | Customer Purchases:1, Overall Charge: 2454.80, Average Charge: 2454.80 Customer Number: C05, Name: Melonie Mcfarlin, Address: 9 Oak Ave. _Munster IN 46321 Date | ITEM | Desc | Price | Ship | Qty | T_Price |T_Ship | Total | Credit | --------------------------------------------------------------------------------------------------- 160508 | I04 | Office | 50 | 2.2 | 23 | 1150 | 50.6 | 1200.6 |5419336904773810 | Customer Purchases:1, Overall Charge: 1200.60, Average Charge: 1200.60 Customer Number: C12, Name: Maura Myles, Address: 907 Charles Street _Xenia OH 45385 Date | ITEM | Desc | Price | Ship | Qty | T_Price |T_Ship | Total | Credit | --------------------------------------------------------------------------------------------------- 160623 | I05 | Office | 70 | 2.2 | 19 | 1330 | 41.8 | 1371.8 |5415683840128390 | Customer Purchases:1, Overall Charge: 1371.80, Average Charge: 1371.80 Quarter Purchases:22, Overall Charges: 14772.88, Average Charge: 671.49 The following customers were not active in this period Customer Number: C01, Name: Jackie Jolly Customer Number: C06, Name: Arturo Arndt Customer Number: C10, Name: Loren Luckie Customer Number: C13, Name: Piedad Pagani Customer Number: C15, Name: Giorgio Chiellini Customer Number: C18, Name: Antonio Candreva *************************************************************************************************** Second report: Supplier Activity for the Quarter April 1 - June 30, 2016 ----------------------------------------------------------- Supplier Number: S05, Name: Dell, Location: 7741 Proctor Ave. _Boca Raton FL 33428 Transaction Number | Date |Item Number |Description |Quantity |Total Cost | ------------------------------------------------------------------------------ 1234567909 | 160520 | I20 | Office | 5 | 150 | ------------------------------------------------------------------------------ 1234567911 | 160530 | I22 | Office | 10 | 6500 | Supplier procurements: 2, Overall Charge: 6650.00, Average Charge: 3325.00 Supplier Number: S02, Name: W.B. Mason ProCard, Location: 7700 Manhattan Ave. _Greensburg PA 15601 Transaction Number | Date |Item Number |Description |Quantity |Total Cost | ------------------------------------------------------------------------------ 1234567900 | 160401 | I11 | food | 30 | 1140 | ------------------------------------------------------------------------------ 1234567902 | 160409 | I13 | kitchen | 140 | 2100 | ------------------------------------------------------------------------------ 1234567901 | 160405 | I12 | kitchen | 50 | 300 | Supplier procurements: 3, Overall Charge: 3540.00, Average Charge: 1180.00 Supplier Number: S04, Name: FedEx, Location: 7672 Philmont St. _West Warwick RI 02893 Transaction Number | Date |Item Number |Description |Quantity |Total Cost | ------------------------------------------------------------------------------ 1234567917 | 160510 | I02 | Printing | 10 | 495 | ------------------------------------------------------------------------------ 1234567907 | 160429 | I18 | office | 50 | 6000 | Supplier procurements: 2, Overall Charge: 6495.00, Average Charge: 3247.50 Supplier Number: S07, Name: Dick's Sporting Goods, Location: 5716 Columbia Pike Bailey's Crossroads VA 22041 Transaction Number | Date |Item Number |Description |Quantity |Total Cost | ------------------------------------------------------------------------------ 1234567913 | 160604 | I24 |sports good | 50 | 1275 | Supplier procurements: 1, Overall Charge: 1275.00, Average Charge: 1275.00 Supplier Number: S06, Name: Amazon, Location: 12900 Worldgate Dr Herndon VA 20170 Transaction Number | Date |Item Number |Description |Quantity |Total Cost | ------------------------------------------------------------------------------ 1234567910 | 160525 | I21 | office | 5 | 390 | ------------------------------------------------------------------------------ 1234567908 | 160515 | I19 | kitchen | 10 | 800 | ------------------------------------------------------------------------------ 1234567912 | 160602 | I23 | Books | 50 | 1797.5 | Supplier procurements: 3, Overall Charge: 2987.50, Average Charge: 995.83 Quarter Procurements: 11, Overall Charges: 20947.50, Average Charge: 1904.32 The following suppliers were not active in this period Supplier Number: S01, Name: Office Max GMS Supplier Number: S03, Name: Xerox *************************************************************************************************** bash-4.1$ exit exit Script done on Sat 30 Jul 2016 11:52:48 PM EDT