Exercise
Database creation
Objetive
Create a program to ask the user for data about books (title, author, genre, and summary) and store them in a SQLite database.
Example Code
import java.util.*;
public class Main
{
static void main(String[] args)
{
SQLiteConnection conexion;
SQLiteCommand cmd;
try
{
conexion = new SQLiteConnection("Data Source=ejemplo01.sqlite;Version=3;" + " New=True; Compress=True;");
conexion.Open();
if (!(new java.io.File("ejemplo01.sqlite")).isFile())
{
String creacion = "create table books ("
+ " title varchar(50), autor varchar(50)," +
" genre varchar(50), summary varchar(50))";
cmd = new SQLiteCommand(creacion, conexion);
cmd.ExecuteNonQuery();
}
String line;
String title = "", autor = "", genre = "", summary = "";
do
{
System.out.print("Title: ");
line = new Scanner(System.in).nextLine();
if (line != null)
{
title = line;
}
System.out.print("Autor: ");
line = new Scanner(System.in).nextLine();
if (line != null)
{
autor = line;
}
System.out.print("Genre: ");
line = new Scanner(System.in).nextLine();
if (line != null)
{
genre = line;
}
System.out.print("Summary: ");
line = new Scanner(System.in).nextLine();
if (line != null)
{
summary = line;
}
String insercion = "insert into books values ('" + title +
"', '" + autor + "','" + genre + "', '" + summary + "')";
cmd = new SQLiteCommand(insercion, conexion);
cmd.ExecuteNonQuery();
System.out.println("Insert OK!");
} while (line != null);
conexion.Close();
}
catch (RuntimeException e)
{
System.out.println("Error" + e.getMessage());
}
}
}