POSTGRESQL FOR JAVA GUI: Database and Image Processing

POSTGRESQL FOR JAVA GUI: Database and Image Processing
Author :
Publisher : SPARTA PUBLISHING
Total Pages : 340
Release :
ISBN-10 :
ISBN-13 :
Rating : 4/5 ( Downloads)

Book Synopsis POSTGRESQL FOR JAVA GUI: Database and Image Processing by : Vivian Siahaan

Download or read book POSTGRESQL FOR JAVA GUI: Database and Image Processing written by Vivian Siahaan and published by SPARTA PUBLISHING. This book was released on 2019-08-27 with total page 340 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/PostgreSQL. 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. There are only three external libraries used in this book: Connector / J to facilitate Java to MySQL connections, JCalendar to display calendar controls, and JFreeChart to display graphics. Digital image techniques to extract image features used in this book 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 first chapter, you will learn: How to install NetBeans, JDK 11, and the PostgreSQL connector; How to integrate external libraries into projects; How the basic PostgreSQL commands are used; How to query statements to create databases, create tables, fill tables, and manipulate table contents is done.In the first chapter, you will learn: How to install NetBeans, JDK 11, and the PostgreSQL connector; How to integrate external libraries into projects; How the basic PostgreSQL commands are used; How to query statements to create databases, create tables, fill tables, and manipulate table contents is done. In the second chapter, you will learn querying data from the postgresql using jdbc including establishing a database connection, creating a statement object, executing the query, processing the resultset object, querying data using a statement that returns multiple rows, querying data using a statement that has parameters, inserting data into a table using jdbc, updating data in postgresql database using jdbc, calling postgresql stored function using jdbc, deleting data from a postgresql table using jdbc, and postgresql jdbc transaction. In third chapter, you will be taught how to extract image features, utilizing BufferedImage class, in Java GUI. In the fourth chapter, you will be taught how to create Crime database and its tables. In the fifth 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 sixth 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 seventh 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 eigthth chapter, you will add two tables: Victim and File_Case. 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 File_Case has seven columns: file_case_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.


POSTGRESQL FOR JAVA GUI: Database and Image Processing Related Books

POSTGRESQL FOR JAVA GUI: Database and Image Processing
Language: en
Pages: 340
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2019-08-27 - Publisher: SPARTA PUBLISHING

DOWNLOAD EBOOK

In this book, you will learn how to build from scratch a criminal records management database system using Java/PostgreSQL. All Java code for digital image proc
LEARN FROM SCRATCH SIGNAL AND IMAGE PROCESSING WITH PYTHON GUI
Language: en
Pages: 372
Authors: Vivian Siahaan
Categories: Technology & Engineering
Type: BOOK - Published: 2023-06-14 - Publisher: BALIGE PUBLISHING

DOWNLOAD EBOOK

In this book, you will learn how to use OpenCV, NumPy library and other libraries to perform signal processing, image processing, object detection, and feature
SIX BOOKS IN ONE: Classification, Prediction, and Sentiment Analysis Using Machine Learning and Deep Learning with Python GUI
Language: en
Pages: 1165
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2022-04-11 - Publisher: BALIGE PUBLISHING

DOWNLOAD EBOOK

Book 1: BANK LOAN STATUS CLASSIFICATION AND PREDICTION USING MACHINE LEARNING WITH PYTHON GUI The dataset used in this project consists of more than 100,000 cus
Step by Step Tutorial IMAGE CLASSIFICATION Using Scikit-Learn, Keras, And TensorFlow with PYTHON GUI
Language: en
Pages: 211
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2023-06-21 - Publisher: BALIGE PUBLISHING

DOWNLOAD EBOOK

In this book, implement deep learning-based image classification on classifying monkey species, recognizing rock, paper, and scissor, and classify airplane, car
Hands-On Guide To IMAGE CLASSIFICATION Using Scikit-Learn, Keras, And TensorFlow with PYTHON GUI
Language: en
Pages: 210
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2023-06-20 - Publisher: BALIGE PUBLISHING

DOWNLOAD EBOOK

In this book, implement deep learning on detecting face mask, classifying weather, and recognizing flower using TensorFlow, Keras, Scikit-Learn, OpenCV, Pandas,