4.10 LAB: Java and SQLite basics
Write a Java program that connects to a SQLite database.
Create a table called Horses with the following fields:
id (integer): a primary key and not null
name (text)
breed (text)
height (real)
birthday (text)
Next, insert the following data row into the Horses table:
id: 1
name: 'Babe'
breed: 'Quarter Horse'
height: 15.3
birthday: '2015-02-10'
Output all records from the Horses table.
Ex: With the above row inserted, the output should be:
All horses:
(1, 'Babe', 'Quarter Horse', 15.3, '2015-02-10')