JavaFX program 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. database below --Table structure for table `productCREATE TABLE IF NOT EXISTS `product (vin char(6) NOT NULL,make varchar(16) NOT NULL,model varchar(16) NOT NULL,year int(4) NOT NULL,color varchar(12) NOT NULL,`price` decimal (9,2) NOT NULL,PRIMARY KEY ('vin`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;--Dumping data for table `productINSERT INTO `product` (`vin`, `make`, `model`, `year`, `color`, `price`) VALUES('12345A', 'Chevrolet', 'Volt', 2013, 'silver', 34000.00),('22222V', 'Chevrolet', 'Malibu', 2013, 'red', 24000.00),('35542C', 'Cadillac', 'Escalade', 2012, 'black', 72000.00),('49879X', 'Buick', 'Lacrosse', 2013, 'white', 38000.00),('58932H', 'Chevrolet', 'Camaro SS', 2012, 'yellow', 33000.00),('60842G', 'Buick', 'Enclave', 2013, 'silver', 42000.00),('77776M', 'Cadillac', 'CTS-V Coupe', 2013, 'blue', 40000.00),('88789T', 'GMC', 'Terrain', 2012, 'red', 31000.00),('90201K', 'Bugatti', 'Veyron', 2013, 'red', 1900000.00),('99090P', 'Chevrolet', 'Spark', 2013, 'green', 14000.00);/*140101 SET*/;CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENTCHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;/*140101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;/*140101 SET

Here are a few highlights before you jump to the source code:- The application first connects to the…

Answered: JavaFX program Create a JavaFX GUI…

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 15RQ

See similar textbooks

Similar questions

SQL Use appropriate clauses and filters to run the query with minimum time complexity. 2. Try to avoid running the queries on unnecessary rows and columns. 3. Share the queries along with a brief description of the code in a python file, so that the results are reproducible. Q1: Write a query to find the students working in a company having more ratings than their seniors EMPLOYEES RATING TABLE student id student name rating senior id designation 1 george 9 3 student 2 micheal 8 4 student 3 mary 6 null senior 4 steve 9 null senior For the above table GEORGE has more rating than his sENIOR
Problem 22 Insert the following customer into the CUST_MYSQL table, allowing the AUTO_INCREMENT attribute set up in Problem 20.a and Problem 20.b to generate the customer number automatically: CUST_LNAME CUST_FNAME CUST_BALANCE Powers Ruth 500 This is what problem 20.a said, and got right: Using MySQL, create a table named CUST_MYSQL with the same fields as in Problem 16, except, use the AUTO_INCREMENT feature for the CUST_NUM field. This is what problem 20.b said, and got right: Using MySQL, alter the table to populate the CUST_NUM field, beginning the increment with 2000.
SQL: Start with the Employee table used in Lab 4. CREATE TABLE Employee ( EMPLOYEE_ID INT NOT NULL, FIRST_NAME CHAR(20), LAST_NAME CHAR(20), JOB_LEVEL INT, SALARY BIGINT, COMMISSION_PCT INT, CONSTRAINT PKEmployeeID PRIMARY KEY (EMPLOYEE_ID) ); INSERT INTO Employee VALUES (100,'Steven','King',1,50000,10), (101,'Neena','Kochhar',1,50000,10), (102,'Lex','De Haan',2,60000 ,15), (103,'Alexander','Hunold',2,60000,15), (104,'Bruce','Ernst',3,70000,25), (105,'Johann','Ernst',4,75000,30); Create another table. CREATE TABLE NumEmployeesByLastName ( LastName CHAR(20), NumEmployees INT ); a. Write a query to initialize the NumEmployeesByLastName table by inserting one row for each last name already in the Employee table, and having the accurate count of the number of employees having that last name. Assume that there are no null values in the Employee table. After your query, if you execute the following query, you would…

Recommended textbooks for you

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

SEE MORE TEXTBOOKS