POSTGRESQL FOR JAVA GUI: Database and Image Processing

POSTGRESQL FOR JAVA GUI: Database and Image Processing

In this book, you will learn how to build from scratch a criminal records management database system using Java/PostgreSQL.

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, and so on.

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

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.

Finally, this book is hopefully useful for you.

Download Now Read Online

Similar Free eBook

Mysql For Java Gui Database Cryptography And Image Processing


Mysql For Java Gui Database Cryptography And Image Processing Download Now Read Online

Author by : Vivian Siahaan
Languange Used : id
Release Date : 2019-08-01
Publisher by : SPARTA PUBLISHING






Postgresql For Java Gui Database And Image Processing


Postgresql For Java Gui Database And Image Processing Download Now Read Online

Author by : Vivian Siahaan
Languange Used : id
Release Date : 2019-08-27
Publisher by : SPARTA PUBLISHING






Cryptography And Image Processing With Java Gui And Sqlite


Cryptography And Image Processing With Java Gui And Sqlite Download Now Read Online

Author by : Vivian Siahaan
Languange Used : id
Release Date : 2019-10-31
Publisher by : SPARTA PUBLISHING






Java Gui With Mysql Database And Image Processing


Java Gui With Mysql Database And Image Processing Download Now Read Online

Author by : Vivian Siahaan
Languange Used : id
Release Date : 2019-08-26
Publisher by : SPARTA PUBLISHING






Database And Image Processing Using Java Gui And Microsoft Access


Database And Image Processing Using Java Gui And Microsoft Access Download Now Read Online

Author by : Vivian Siahaan
Languange Used : id
Release Date : 2019-11-01
Publisher by : SPARTA PUBLISHING






Database And Image Processing Using Sql Server And Python


Database And Image Processing Using Sql Server And Python Download Now Read Online

Author by : Vivian Siahaan
Languange Used : id
Release Date : 2019-10-31
Publisher by : SPARTA PUBLISHING






Java Gui With Postgresql A Practical Approach To Build Database Project For Students And Programmers


Java Gui With Postgresql A Practical Approach To Build Database Project For Students And Programmers Download Now Read Online

Author by : Vivian Siahaan
Languange Used : id
Release Date : 2019-08-21
Publisher by : SPARTA PUBLISHING






Leave a Reply

Your email address will not be published. Required fields are marked *