Database creation Learn programming Java

Lesson:

Access To Relational Databases


Exercise:

Database creation 16


Objetive:

Create a program to ask the user for data about books (title, author, genre and summary) and store them in a SQLite database.


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());
		}
	}
}