LAB

ACTIVITY

$10\mathrm{.}1\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:HINT: Use import java.sq$1.*$ 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.