Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I am having major issues creating this table, I wanna take it slow. I am trying to just create the table in java code without
I am having major issues creating this table, I wanna take it slow. I am trying to just create the table in java code without the sql and once I finish the table then add in the sql requirments. 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
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.Select fields of Products Table to Display
Vin
where
Step 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