Exercises Java with Examples-
Practice Exercises Java 4,5 5 302940

Database creation - Practice Exercises Java


Lesson 10:

Access to relational databases


Exercise 10.1:

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.


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

Share Now:


Google Ads





Privacy Policy:



Google uses associated advertising companies to serve ads when it visits our website. These companies may use the information they obtain from your visits to this and other websites (not including your name, address, email address, or phone number) to provide you with announcements about products and services that interest you. If you would like to learn more about this practice and know your options to prevent these companies from using this information. Click in... Privacy and Terms of Google.

Cookies

This site uses Google cookies to provide its services, to personalize advertisements and to analyze traffic. Google receives information about your use of this website. More information in... Privacy and Terms of Google.