Create a JavaFX program to allow a user to query the Northwind database. You should be able to perform the following functionality using the program:

1. Print order total (not including the freight cost) for a given order number

The program will ask the user for an order number, and then print out the total for all products in the order, taking into account quantities and discounts. (All computations should be done within the SQL query).

2. Print all order details for a given order number

The program will ask the user for an order number, and then print the order date, freight charge, and all products and their quantity, unit price, and discount for the order.

3. Print the names and cities of all customers in a given state

The program will ask the user for a state, and then print out the names and cities of all customers in this state in order by city.

4. Print the names of all employees who have a birthday in a given year

The program will ask the user for a year, and then print out the first and last names (in alphabetical order by last name) of all employees who were born during that year.

I asked this question before and the response was to add info about the database. I have the actual database file, but I don't know how to upload a file to this format. I only need the code thats necessary to execute the queries. Here is some of the info from the database. I hope these screenshots help. I also have the finished visual of how the database should look. Let me know if this helps and if you need the visual. 

  
 
 
 
 
 

Transcribed Image Text:

AutoSave Off H File Paste X 10 Clipboard Home Page 1 of 4 A Insert 12 words Draw Design Calibri (Body) 11 Y Font Type here to search NorthWind Database Tables - Saved to this PC Uab x, x² AA. Layout A A A A A Aa A E-¹-¹2- Aa # * NorthWind Database Tables Category: Category 1 Category Nam. & Seafood 3 + References Mailings Review E E AL T + • * A C Product ANTON AROUT BERGS BLAUS BLONP BOLID BONAP 4 BOTTM + BSBEV CACTU CENTC CHOPS Paragraph Customer: - 73 Röd Kaviar (New) Customer 1- ALFKI ANATR 10 kura 13 Konbu 18 Carnarvon Tigers 30 Nord-Ost Matjeshering 36 Inlagd Sill 37 Gravad lax Product Name 45 Røgede sild 46 Spegesild 58 Escargots de Bourgogne O Seaweed and fish Tokyo Traders Mayumi's Pavlova, Ltd. Nord-Ost-Fisch Svensk Sjöföda AB Svensk Sjöföda AB 40 Boston Crab Meat New England Seafood Cannery 41 Jack's New England Clam Chowder New England Seafood Cannery Company Name V j . Description 5 Blauer See Delikatessen Blondel père et fils Bólido Comidas preparadas Bon app Bottom-Dollar Markets B's Beverages Cactus Comidas para llevar Centro comercial Moctezuma Chop-suey Chinese Supplier Lyngbysild Lyngbysild Escargots Nouveaux Svensk Sjöföda AB AaBbCcDc AaBbCcDc AaBbC AaBbCct AaB 1 Normal 1 No Spac... Heading 1 Heading 2 Title 1 0 Search. View Help Alfreds Futterkiste Maria Anders Ana Trujillo Emparedados y helados Ana Trujillo Antonio Moreno Taqueria Around the Horn Berglunds snabbkop Handelsgesellschaft Contact Name Antonio Moreno Thomas Hardy Christina Berglund Hanna Moos Frédérique Citeaux Martin Sommer Laurence Lebihan. Elizabeth Lincoln Victoria Ashworth Patricio Simpson Francisco Chang Yang Wang S 3 T Picture Bitmap Image - Quantity Per Unit 12-200 ml jars 2 kg box • Click to Add 16 kg pkg. mbH 10-200 g glasses 24-250g jars 12-500 g pkgs. 24-40ztins 12-12 oz cans 1k pkg. 4-450 g glasses 24 pieces 24-150 g jars Contact Title Sales Representative Owner Owner Sales Representative Order Administrator Sales Representative Marketing Manager Owner Owner Accounting Manager Sales Representative Sales Agent Marketing Manager Owner Styles $19.00 $26.00 $18.40 $9.65 $9.50 $12.00 $13.25 $15.00 $0.00 Unit Pric Units In Stoc Units On Orde Reorder Leve Discontinue. Click to Add $31.00 0 $6.00 0 $62.50 0 $25.89 31 24 42 10 112 Ⓒ 11 123 85 S 95 62 101 0 Address Obere Str. 57 Avda. de la Constitución 2222 Mataderos 2312 120 Hanover Sq. Berguvsvägen 8 Forsterstr. 57 24, place Kléber C/ Araquil, 67 12, rue des Bouchers 23 Tsawassen Blvd. Fauntleroy Circus Cerrito 333 Sierras de Granada 9993 Hauptstr. 29 W 0 0 0 0 0 50 0 0 70 0 0 0 0 0 5 0 15 20 25 30 10 15 0 20 5 0 0 0 10 П 7 0 0 0 F Editing 0 0 City Faheem Abdur-Rasheed FA O Find Berlin México D.F México D.F. London Luleå Mannheim Strasbourg Madrid Marseille Tsawassen London Buenos Aires México D.F. Bern Replace Select Region BC Focus 09 Dictate F Share Sensitivity Voice Sensitivity Editor Editor 4») 0 X Comments 12:24 PM 3/12/2021 < + 100% AutoSave Off H File Paste X 10 Clipboard Home Page 1 of 4 A Insert 12 words Draw Design Calibri (Body) 11 Y Font Type here to search NorthWind Database Tables - Saved to this PC Uab x, x² AA. Layout A A A A A Aa A E-¹-¹2- Aa # * NorthWind Database Tables Category: Category 1 Category Nam. & Seafood 3 + References Mailings Review E E AL T + • * A C Product ANTON AROUT BERGS BLAUS BLONP BOLID BONAP 4 BOTTM + BSBEV CACTU CENTC CHOPS Paragraph Customer: - 73 Röd Kaviar (New) Customer 1- ALFKI ANATR 10 kura 13 Konbu 18 Carnarvon Tigers 30 Nord-Ost Matjeshering 36 Inlagd Sill 37 Gravad lax Product Name 45 Røgede sild 46 Spegesild 58 Escargots de Bourgogne O Seaweed and fish Tokyo Traders Mayumi's Pavlova, Ltd. Nord-Ost-Fisch Svensk Sjöföda AB Svensk Sjöföda AB 40 Boston Crab Meat New England Seafood Cannery 41 Jack's New England Clam Chowder New England Seafood Cannery Company Name V j . Description 5 Blauer See Delikatessen Blondel père et fils Bólido Comidas preparadas Bon app Bottom-Dollar Markets B's Beverages Cactus Comidas para llevar Centro comercial Moctezuma Chop-suey Chinese Supplier Lyngbysild Lyngbysild Escargots Nouveaux Svensk Sjöföda AB AaBbCcDc AaBbCcDc AaBbC AaBbCct AaB 1 Normal 1 No Spac... Heading 1 Heading 2 Title 1 0 Search. View Help Alfreds Futterkiste Maria Anders Ana Trujillo Emparedados y helados Ana Trujillo Antonio Moreno Taqueria Around the Horn Berglunds snabbkop Handelsgesellschaft Contact Name Antonio Moreno Thomas Hardy Christina Berglund Hanna Moos Frédérique Citeaux Martin Sommer Laurence Lebihan. Elizabeth Lincoln Victoria Ashworth Patricio Simpson Francisco Chang Yang Wang S 3 T Picture Bitmap Image - Quantity Per Unit 12-200 ml jars 2 kg box • Click to Add 16 kg pkg. mbH 10-200 g glasses 24-250g jars 12-500 g pkgs. 24-40ztins 12-12 oz cans 1k pkg. 4-450 g glasses 24 pieces 24-150 g jars Contact Title Sales Representative Owner Owner Sales Representative Order Administrator Sales Representative Marketing Manager Owner Owner Accounting Manager Sales Representative Sales Agent Marketing Manager Owner Styles $19.00 $26.00 $18.40 $9.65 $9.50 $12.00 $13.25 $15.00 $0.00 Unit Pric Units In Stoc Units On Orde Reorder Leve Discontinue. Click to Add $31.00 0 $6.00 0 $62.50 0 $25.89 31 24 42 10 112 Ⓒ 11 123 85 S 95 62 101 0 Address Obere Str. 57 Avda. de la Constitución 2222 Mataderos 2312 120 Hanover Sq. Berguvsvägen 8 Forsterstr. 57 24, place Kléber C/ Araquil, 67 12, rue des Bouchers 23 Tsawassen Blvd. Fauntleroy Circus Cerrito 333 Sierras de Granada 9993 Hauptstr. 29 W 0 0 0 0 0 50 0 0 70 0 0 0 0 0 5 0 15 20 25 30 10 15 0 20 5 0 0 0 10 П 7 0 0 0 F Editing 0 0 City Faheem Abdur-Rasheed FA O Find Berlin México D.F México D.F. London Luleå Mannheim Strasbourg Madrid Marseille Tsawassen London Buenos Aires México D.F. Bern Replace Select Region BC Focus 09 Dictate F Share Sensitivity Voice Sensitivity Editor Editor 4») 0 X Comments 12:24 PM 3/12/2021 < + 100%

Answer rating: 100% (QA)

Answer Code import javasqlConnection import javasqlDriverManager import javasqlResultSet import java... View the full answer