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.