Learn SQLite with JDBC

Learn SQLite with JDBC
Author :
Publisher : SPARTA PUBLISHING
Total Pages : 333
Release :
ISBN-10 :
ISBN-13 :
Rating : 4/5 ( Downloads)

Book Synopsis Learn SQLite with JDBC by : Vivian Siahaan

Download or read book Learn SQLite with JDBC written by Vivian Siahaan and published by SPARTA PUBLISHING. This book was released on 2019-09-30 with total page 333 pages. Available in PDF, EPUB and Kindle. Book excerpt: In this book, you will learn how to build from scratch a criminal records management database system using Java / SQLite. All Java code for digital image processing in this book is Native Java. Intentionally not to rely on external libraries, so that readers know in detail the process of extracting digital images from scratch in Java. In the first chapter, you will be shown how to create SQLite database and tables with Java. In second chapter, you will be taught how to extract image features, utilizing BufferedImage class, in Java GUI. Digital image techniques to extract image features used in this chapted are grascaling, sharpening, invertering, blurring, dilation, erosion, closing, opening, vertical prewitt, horizontal prewitt, Laplacian, horizontal sobel, and vertical sobel. For readers, you can develop it to store other advanced image features based on descriptors such as SIFT and others for developing descriptor based matching. In the third chapter, you will be taught to create Java GUI to view, edit, insert, and delete Suspect table data. This table has eleven columns: suspect_id (primary key), suspect_name, birth_date, case_date, report_date, suspect_ status, arrest_date, mother_name, address, telephone, and photo. In the fourth chapter, you will be taught to create Java GUI to view, edit, insert, and delete Feature_Extraction table data. This table has eight columns: feature_id (primary key), suspect_id (foreign key), feature1, feature2, feature3, feature4, feature5, and feature6. All six fields (except keys) will have a BLOB data type, so that the image of the feature will be directly saved into this table. In the fifth chapter, you will add two tables: Police_Station and Investigator. These two tables will later be joined to Suspect table through another table, File_Case, which will be built in the seventh chapter. The Police_Station has six columns: police_station_id (primary key), location, city, province, telephone, and photo. The Investigator has eight columns: investigator_id (primary key), investigator_name, rank, birth_date, gender, address, telephone, and photo. Here, you will design a Java GUI to display, edit, fill, and delete data in both tables. In the sixth chapter, you will add two tables: Victim and Case_File. The File_Case table will connect four other tables: Suspect, Police_Station, Investigator and Victim. The Victim table has nine columns: victim_id (primary key), victim_name, crime_type, birth_date, crime_date, gender, address, telephone, and photo. The Case_File has seven columns: case_file_id (primary key), suspect_id (foreign key), police_station_id (foreign key), investigator_id (foreign key), victim_id (foreign key), status, and description. Here, you will also design a Java GUI to display, edit, fill, and delete data in both tables. Finally, this book is hopefully useful for you.


Learn SQLite with JDBC Related Books

Learn SQLite with JDBC
Language: en
Pages: 333
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2019-09-30 - Publisher: SPARTA PUBLISHING

DOWNLOAD EBOOK

In this book, you will learn how to build from scratch a criminal records management database system using Java / SQLite. All Java code for digital image proces
SQLite with JDBC for Beginners
Language: en
Pages: 308
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2019-09-29 - Publisher: SPARTA PUBLISHING

DOWNLOAD EBOOK

In this book, you will learn how to build from scratch a SQLite database management system using Java. In designing a GUI and as an IDE, you will make use of th
Java Programming For Developers: The Definitive Guide to Learn JDBC And Database Applications
Language: en
Pages: 441
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2019-11-28 - Publisher: SPARTA PUBLISHING

DOWNLOAD EBOOK

This step-by-step guide to explore database programming using Java is ideal for people with little or no programming experience. The goal of this concise book i
The Definitive Guide to SQLite
Language: en
Pages: 363
Authors: Grant Allen
Categories: Computers
Type: BOOK - Published: 2011-01-28 - Publisher: Apress

DOWNLOAD EBOOK

Outside of the world of enterprise computing, there is one database that enables a huge range of software and hardware to flex relational database capabilities,
Using SQLite
Language: en
Pages: 526
Authors: Jay Kreibich
Categories: Computers
Type: BOOK - Published: 2010-08-17 - Publisher: "O'Reilly Media, Inc."

DOWNLOAD EBOOK

Explains how to build database-backed applications for the Web, desktop, embedded systems, and operating systems using SQLite.