Take the supplied cars_db.sql and create your Cars database (you will have to create the Cars database first, then execute the .sql file from within Netbeans). 2) Implement a program that has the same general user interface as the SimpleSchoolData presented in class. 3) Implement two classes, CarsDisplay which displays the above application, and implement a class named CarQueries that contains the prepared statements to execute the queries. (Java) This is the cars_db.sql DROP TABLE Cars; CREATE TABLE Cars ( CarID INT NOT NULL GENERATED ALWAYS AS IDENTITY, CarMake VARCHAR (10) NOT NULL, CarModel VARCHAR (15) NOT NULL, CarYear VARCHAR (4) NOT NULL, CarMileage DECIMAL (6) NOT NULL ); INSERT INTO Cars (CarMake,CarModel,CarYear,CarMileage) VALUES ('Honda','Civic','1998',135647), ('Honda','Accord','2009',46877), ('Nissan','Pickup','1997',235444);
1) Take the supplied cars_db.sql and create your Cars
2) Implement a program that has the same general user interface as the SimpleSchoolData presented in class.
3) Implement two classes, CarsDisplay which displays the above application, and implement a class named CarQueries that contains the prepared statements to execute the queries.
(Java)
This is the cars_db.sql
DROP TABLE Cars;
CREATE TABLE Cars
(
CarID INT NOT NULL GENERATED ALWAYS AS IDENTITY,
CarMake VARCHAR (10) NOT NULL,
CarModel VARCHAR (15) NOT NULL,
CarYear VARCHAR (4) NOT NULL,
CarMileage DECIMAL (6) NOT NULL
);
INSERT INTO Cars (CarMake,CarModel,CarYear,CarMileage)
VALUES ('Honda','Civic','1998',135647),
('Honda','Accord','2009',46877),
('Nissan','Pickup','1997',235444);
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
