$9\mathrm{.}9$ LAB $-$ Database programming with Java

$9\mathrm{.}9\mathrm{.}1$: LAB $-$ Database programming with Java

Complete the Java program to create a Horse table, insert one row, and print the row.

Implement the following methods. Method parameters are described in the template. Do not modify the main program.

createConnection$()$ creates a connection to the database. This method calls DriverManager.getConnection$()$ with the following connection information:

$-$ User: root

$-$ Server address: $127\mathrm{.}0\mathrm{.}0\mathrm{.}1$

$-$ Database: zybooksdb

Password is not necessary and can be omitted.

createTable $()$ creates Horse, with five columns:

$-$ ID $-$ integer, primary key, not null

$-$ Name $-$ varchar$(30)$

$-$ Breed $-$ varchar$(30)$

$-$ Height$-$double

$-$ Birthdate $-$ varchar$(10)$

Before creating Horse, drop the table if the table exists $($from a prior run$).$

insertHorse $()$ inserts one row into Horse:

$(1,$ 'Babe', 'Quarter horse', $15\mathrm{.}3,\text{'}2015-02-10\text{'})$

selectAllHorses $()$ selects and prints all Horse rows, as follows:

All horses:

$(1,$ 'Babe', 'Quarter Horse', $15\mathrm{.}3,\text{'}2015-02-10\text{'})$

HINT: Use import java.sql$.*$ to access all classes and methods of the Java$-$SQL API. Calls to these methods may throw exceptions and must be enclosed in the try block of a try$-$catch statement.