In my java code I need to: Create a JavaFX GUI that allows the user to retrieve records from the product table in the example database. The GUI should allow the user to specify desired fields, desired order, and a where condition. Display only the desired fields in the desired order for the desired where condition.

You may display the records in the GUI in any way you wish.

Sample output $-$ the output fields do not line up but that is not required.

Added hints on $2/24/2024-$

Make sure the MySQL server is running in the background. The instructions are a bit ambiguous hinting that you should stop it$.$ It must be operational to make this program work.

Start with the simplest SQL statement, such as "Select $*$ FROM Products", once that is working then start adding in the option buttons to build the SQL statement.

To test you will have to type the where cause as shown in the example below, not sure I would count on users to be able to do this.

If you are having trouble with mySQL connect me immediately.

I would not recommend using JavaFX tableview. It is complex, your output works just as well with a textarea.