movieDBDevelop a JDBC program called MovieDB that finds and displays movie records in a database

table in different order. The table, called movie, has three columns: name VARCHAR$(255),$

yr INTEGER, and score INTEGER. The following SQL file creates and populates the table.

$--$ Create the 'movie' table

CREATE TABLE movie $($

name VARCHAR$(255),$

yr INTEGER,

score INTEGER

;

Insert data into the 'movie' table

INSERT INTO movie $($name$,$ yr$,$ score$)$ VALUES

$(\text{'}$Oppenheimer$\text{'},2023,86),$

$(\text{'}$Barbie$\text{'},2023,72),$

$(\text{'}$The Whale', $2022,77),$

$(\text{'}$Everything Everywhere All At Once', $2022,78),$

$(\text{'}$Drive My Car', $2021,76),$

$(\text{'}$No Time to Die', $2021,73)$;

The program accepts "name" or "score" as input parameters. After that, it prompts the user

for a year. If the input parameter is "name", it should display the details of the matched

records which are sorted by name in ascending order. If the input parameter is "score", it

should display the details of the matched records which are sorted by score in descending

order. If no record matched, the message "Record not found." is displayed. The program

should check the correctness of the input parameter, if the input is incorrect, the usage of this

program is printed.

The program should load the following database. properties file, which stores the driver

name and connection string.

The program should load the following database.properties file, which stores the driver

name and connection string.

jdbc$.$drivers$=$org.apache.derby.jdbc$.$ClientDriver

jdbc$.$url$=$jdbc:derby:$//$localhost:$1527/$MyDB;create$=$true

Use JDBC to connect to the database. These are sample outputs of running the program

$($assuming the above data in the table$).$

$>$ set CLASSPATH$=.$;C:$\backslash$Apache$\backslash$db$-$derby$-10\mathrm{.}16\mathrm{.}1\mathrm{.}1-$bin$\backslash$lib$\backslash$derbyclient$.$jar;$\%$CLASSPATH$\%$

$>$ java a$2.$MovieDB

Usage: java a$2.$MovieDB $[$name$|$score$]$

$>$ java a$2.$MovieDB x

Usage: java a$2.$MovieDB $[$name$|$score$]$