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') LabProgram.java public class LabProgram { public static void main(String[] args) { /* Type your code here */ // FIXME 1: Call the connect() method to connect to the database // FIXME 2: Create the sql statement string to create a table and pass it to creatTable() method // FIXME 3: Create the sql statement to Insert the horse data into the databasem // and pass it to the insertRow() method // FIXME 4: Print out all horses by calling the selectAllHorses() method; } }
Write a Java program that connects to a SQLite
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')
LabProgram.java
public class LabProgram {
public static void main(String[] args) {
/* Type your code here */
// FIXME 1: Call the connect() method to connect to the database
// FIXME 2: Create the sql statement string to create a table and pass it to creatTable() method
// FIXME 3: Create the sql statement to Insert the horse data into the databasem
// and pass it to the insertRow() method
// FIXME 4: Print out all horses by calling the selectAllHorses() method;
}
}
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
