A Practical Guide To Database Programming With Java Gui And Postgresql

Author : Vivian Siahaan
Publisher : SPARTA PUBLISHING
ISBN 13 :
Total Pages : 550 pages
Book Rating : 4./5 ( download)

DOWNLOAD NOW!

Download or read book A Practical Guide to Database Programming with Java GUI and PostgreSQL written by Vivian Siahaan and published by SPARTA PUBLISHING. This book was released on 2020-01-12 with total page 550 pages. Available in PDF, EPUB and Kindle. Book excerpt: In this book, you will create three desktop applications using Java GUI and PostgreSQL. In this book, you will learn how to build from scratch a PostgreSQL database management system using Java. In designing a GUI and as an IDE, you will make use of the NetBeans tool. Gradually and step by step, you will be taught how to utilize PostgreSQL in Java. In chapter one, you will create School database and its six tables. In chapter two, you will study: Creating the initial three table projects in the school database: Teacher table, TClass table, and Subject table; Creating database configuration files; Creating a Java GUI for viewing and navigating the contents of each table; Creating a Java GUI for inserting and editing tables; and Creating a Java GUI to join and query the three tables. In chapter three, you will learn: Creating the main form to connect all forms; Creating a project will add three more tables to the school database: the Student table, the Parent table, and Tuition table; Creating a Java GUI to view and navigate the contents of each table; Creating a Java GUI for editing, inserting, and deleting records in each table; Creating a Java GUI to join and query the three tables and all six. In chapter four, you will study how to query the six tables. In chapter five, you will learn the basics of cryptography using Java. Here, you will learn how to write a Java program to count Hash, MAC (Message Authentication Code), store keys in a KeyStore, generate PrivateKey and PublicKey, encrypt / decrypt data, and generate and verify digital prints. In chapter six, you will create Bank database and its tables. In chapter seven, you will learn how to create and store salt passwords and verify them. You will create a Login table. In this case, you will see how to create a Java GUI using NetBeans to implement it. In addition to the Login table, in this chapter you will also create a Client table. In the case of the Client table, you will learn how to generate and save public and private keys into a database. You will also learn how to encrypt / decrypt data and save the results into a database. In chapter eight, you will create an Account table. This account table has the following ten fields: account_id (primary key), client_id (primarykey), account_number, account_date, account_type, plain_balance, cipher_balance, decipher_balance, digital_signature, and signature_verification. In this case, you will learn how to implement generating and verifying digital prints and storing the results into a database. In chapter nine, you will create a Client_Data table, which has the following seven fields: client_data_id (primary key), account_id (primary_key), birth_date, address, mother_name, telephone, and photo_path. In chapter ten, you will be taught how to create Crime database and its tables. In chapter eleven, you will be taught how to extract image features, utilizing BufferedImage class, in Java GUI. In chapter twelve, 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 chapter thirteen, 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 chapter fourteen, you will add two tables: Police_Station and Investigator. These two tables will later be joined to Suspect table through another table, File_Case. 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 chapter fifteen, 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.

Author : Vivian Siahaan
Publisher : SPARTA PUBLISHING
ISBN 13 :
Total Pages : 450 pages
Book Rating : 4./5 ( download)

DOWNLOAD NOW!

Download or read book The Best Guide to Database Programming with Java GUI, PostgreSQL, and SQL Server written by Vivian Siahaan and published by SPARTA PUBLISHING. This book was released on 2020-01-13 with total page 450 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book offers the straightforward, practical answers you need to help you do your job. This hands-on tutorial/reference/guide to PostgreSQL and SQL Server is not only perfect for students and beginners, but it also works for experienced developers who aren't getting the most from PostgreSQL and SQL Server. As you would expect, this book shows how to build from scratch two different databases: PostgreSQL and SQL Server using Java. In designing a GUI and as an IDE, you will make use of the NetBeans tool. In chapter one, 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 chapter two, 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 chapter three, you will learn the basics of cryptography using Java. Here, you will learn how to write a Java program to count Hash, MAC (Message Authentication Code), store keys in a KeyStore, generate PrivateKey and PublicKey, encrypt / decrypt data, and generate and verify digital prints. You will also learn how to create and store salt passwords and verify them. In chapter four, you will create a PostgreSQL database, named Bank, and its tables. In chapter five, you will create a Login table. In this case, you will see how to create a Java GUI using NetBeans to implement it. In addition to the Login table, in this chapter you will also create a Client table. In the case of the Client table, you will learn how to generate and save public and private keys into a database. You will also learn how to encrypt / decrypt data and save the results into a database. In chapter six, you will create an Account table. This account table has the following ten fields: account_id (primary key), client_id (primarykey), account_number, account_date, account_type, plain_balance, cipher_balance, decipher_balance, digital_signature, and signature_verification. In this case, you will learn how to implement generating and verifying digital prints and storing the results into a database. In chapter seven, you create a table named Client_Data, which has seven columns: client_data_id (primary key), account_id (primary_key), birth_date, address, mother_name, telephone, and photo_path. In chapter eight, you will be taught how to create a SQL Server database, named Crime, and its tables. In chapter nine, you will be taught how to extract image features, utilizing BufferedImage class, in Java GUI. In chapter ten, 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 chapter eleven, 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 chapter twelve, 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 chapter thirteen, 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 and can improve database programming skills for every Java/PostgreSQL/SQL Server programmer.

Author : Vivian Siahaan
Publisher : SPARTA PUBLISHING
ISBN 13 :
Total Pages : pages
Book Rating : 4./5 ( download)

DOWNLOAD NOW!

Download or read book JAVA GUI WITH POSTGRESQL: A Practical Approach to Build Database Project for Students and Programmers written by Vivian Siahaan and published by SPARTA PUBLISHING. This book was released on 2019-08-21 with total page pages. Available in PDF, EPUB and Kindle. Book excerpt: In this book, you will learn how to build from scratch a PostgreSQL database management system using Java. In designing a GUI and as an IDE, you will make use of the NetBeans tool. Gradually and step by step, you will be taught how to utilize PostgreSQL in Java. 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 the third chapter, you will study: Creating the initial three table projects in the school database: Teacher table, TClass table, and Subject table; Creating database configuration files; Creating a Java GUI for viewing and navigating the contents of each table; Creating a Java GUI for inserting and editing tables; and Creating a Java GUI to join and query the three tables. In the fourth chapter, you will learn: Creating the main form to connect all forms; Creating a project will add three more tables to the school database: the Student table, the Parent table, and Tuition table; Creating a Java GUI to view and navigate the contents of each table; Creating a Java GUI for editing, inserting, and deleting records in each table; Creating a Java GUI to join and query the three tables and all six. In the last chapter, you will study how to query the six tables. Finally, this book is hopefully useful and can improve database programming skills for every Java/PostgreSQL programmer.

Author : Gregory D. Speegle
Publisher : Morgan Kaufmann
ISBN 13 : 1558607366
Total Pages : 130 pages
Book Rating : 4.61/5 ( download)

DOWNLOAD NOW!

Download or read book JDBC written by Gregory D. Speegle and published by Morgan Kaufmann. This book was released on 2002 with total page 130 pages. Available in PDF, EPUB and Kindle. Book excerpt: 1 -- Introduction to JDBC -- 2 -- Presenting Information to Users -- 3 -- Querying the Database -- 4 -- Updating the Database -- 5 -- Advanced JDBC Topics -- 6 -- An eCommerce Example -- 7 -- How to Stay Current with JDBC -- 8 -- Appendix.

Author : Hamzan Wadi
Publisher : TR Publisher
ISBN 13 :
Total Pages : 330 pages
Book Rating : 4./5 ( download)

DOWNLOAD NOW!

Download or read book Step By Step Java GUI With JDBC & MySQL : Practical approach to build database desktop application with project based examples written by Hamzan Wadi and published by TR Publisher. This book was released on with total page 330 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book comes as an answer for students, lecturers, or the general public who want to learn Java GUI programming starting from scratch. This book is suitable for beginner learners who want to learn Java GUI programming from the basic to the database level. This book is also present for JAVA learners who want to increase their level of making GUI-based database applications for small, medium, or corporate businesses level. The discussion in this book is not wordy and not theoretical. Each discussion in this book is presented in a concise and clear brief, and directly to the example that implements the discussion. Beginner learners who want to learn through this book should not be afraid of losing understanding of the programming concepts, because this book in detail discusses the concepts of Java programming from the basic to the advanced level. By applying the concept of learning by doing, this book will guide you step by step to start Java GUI programming from the basics until you are able to create database applications using JDBC and MySQL. Here are the material that you will learn in this book. CHAPTER 1 : This chapter will give you brief and clear introduction about how to create desktop application using Java GUI starting from how to setup your environments, create your first project, understand various control for your form, and understand how to interact with your form using event handling. CHAPTER 2 : This chapter will discuss clearly about the concept and the implementatiton of data types and variables in Java GUI. CHAPTER 3 : This chapter will discuss in detail about how to make decisions or deal with a condition in the program. This chapter is the first step to deeper understanding of logics in programming. This chapter specifically discusses relational operators and logical operators, if statements, if-else statements, and switch-case statements, and how to implement all of these conditional statements using Java GUI. CHAPTER 4 : This chapter will discuss in detail the looping statements in Java including for statement, while statement, do-while statement, break statement, and continue statement. All of these looping statements will be implemented using Java GUI. CHAPTER 5 : This chapter will discuss how to use methods to group codes based on their funcitonality. This discussion will also be the first step for programmers to learn how to create efficient program code. This chapter will discuss in detail the basics of methods, methods with return values, how to pass parameters to methods, how to overload your methods, and how to make recursive methods. CHAPTER 6 : This chapter will discuss in detail how to create and use arrays, read and write file operations, and how to display data stored in arrays or files in graphical form. CHAPTER 7 : This chapter will discuss in detail the basics of MySQL, how to access databases using JDBC and MySQL, and how to perform CRUD operations using JDBC and MySQL. CHAPTER 8 : In this chapter we will discuss more about Java GUI programming. This chapter will discuss in detail about how to make a program that consists of multi forms, how to create MDI application, and how to create report using iReport with data stored in a database.

Author : Vivian Siahaan
Publisher : SPARTA PUBLISHING
ISBN 13 :
Total Pages : 450 pages
Book Rating : 4./5 ( download)

DOWNLOAD NOW!

Download or read book Learn JDBC The Hard Way: A Hands-On Guide to PostgreSQL and SQL Server Driven Programming written by Vivian Siahaan and published by SPARTA PUBLISHING. This book was released on 2019-11-23 with total page 450 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book offers the straightforward, practical answers you need to help you do your job. This hands-on tutorial/reference/guide to PostgreSQL and SQL Server is not only perfect for students and beginners, but it also works for experienced developers who aren't getting the most from PostgreSQL and SQL Server. As you would expect, this book shows how to build from scratch two different databases: PostgreSQL and SQL Server using Java. In designing a GUI and as an IDE, you will make use of the NetBeans tool. In chapter one, 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 chapter two, 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 chapter three, you will learn the basics of cryptography using Java. Here, you will learn how to write a Java program to count Hash, MAC (Message Authentication Code), store keys in a KeyStore, generate PrivateKey and PublicKey, encrypt / decrypt data, and generate and verify digital prints. You will also learn how to create and store salt passwords and verify them. In chapter four, you will create a PostgreSQL database, named Bank, and its tables. In chapter five, you will create a Login table. In this case, you will see how to create a Java GUI using NetBeans to implement it. In addition to the Login table, in this chapter you will also create a Client table. In the case of the Client table, you will learn how to generate and save public and private keys into a database. You will also learn how to encrypt / decrypt data and save the results into a database. In chapter six, you will create an Account table. This account table has the following ten fields: account_id (primary key), client_id (primarykey), account_number, account_date, account_type, plain_balance, cipher_balance, decipher_balance, digital_signature, and signature_verification. In this case, you will learn how to implement generating and verifying digital prints and storing the results into a database. In chapter seven, you create a table named Client_Data, which has seven columns: client_data_id (primary key), account_id (primary_key), birth_date, address, mother_name, telephone, and photo_path. In chapter eight, you will be taught how to create a SQL Server database, named Crime, and its tables. In chapter nine, you will be taught how to extract image features, utilizing BufferedImage class, in Java GUI. In chapter ten, 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 chapter eleven, 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 chapter twelve, 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 chapter thirteen, 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 and can improve database programming skills for every Java/PostgreSQL/SQL Server programmer.

Author : Hamzan Wadi
Publisher : TURIDA Publisher
ISBN 13 :
Total Pages : 384 pages
Book Rating : 4./5 ( download)

DOWNLOAD NOW!

Download or read book Step By Step Database Programming using Python GUI & MySQL written by Hamzan Wadi and published by TURIDA Publisher. This book was released on with total page 384 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book provides a practical explanation of database programming using Python GUI & MySQL. The discussion in this book is presented in step by step so that it will help readers understand each material and also will make it easier for the readers to follow all of the instructions. This book is very suitable for students, programmers, and anyone who want to learn database programming using Python GUI & MySQL from scratch. This book is divided into two parts: The first part of this book will discuss about the fundamentals of database programming using Python GUI & MySQL. This part will discuss in detail about how to setup your working environment and how to understand GUI programming using Python. This part will also discuss in detail about how to start your database programming using Python GUI & MySQL. This part will discuss in detail about the basic of database programming using Python GUI & MySQL. The second part of this book will discuss about how to build database application using Python GUI & MySQL. This part will discuss in detail about how to build Multiple Document Interface (MDI) database application through real project-based example. This part will discuss in detail about how to design and create database for Library Management System application, and how to create all forms for the application. The final objective of this book is that the readers are able to create real database application using Python GUI & MySQL. Here are the materials that you will learn in this book. PART I: THE FUNDAMENTAL OF DATABASE PROGRAMMING USING PYTHON GUI & MySQL CHAPTER 1: The discussion in this chapter will guide you in preparing what software are needed to start your database programming using Python GUI. This chapter will guide you to install all software including Python, MySQL, and Qt Designer. In addition, this chapter also will discuss about how to understand and use Qt Designer for user interface design, and how to create a GUI application using Python and Qt Designer. CHAPTER 2: The discussion in this chapter will guide you to start your database programming using Python GUI & MySQL. This chapter will discuss in detail about the basic of database programming using Python GUI & MySQL. The discussion in this chapter will talk about how to create and drop database, how to create and drop table, how to insert data into table, how to display data from table, how to update data in table, and how to delete data in table. All discussions in this chapter will give you deep understanding of database programming using Python GUI & MySQL. PART II: BUILDING DATABASE APPLICATION USING PYTHON GUI & MySQL, CASE STUDY: LIBRARY MANAGEMENT SYSTEM APPLICATION CHAPTER 3: The discussion in this chapter will guide you to design and create database for library management system application. This is the first step that must be taken to create database application using Python GUI & MySQL. This chapter will discuss in detail about how to design the Entity Relationship Diagram (ERD) for library management system application. The discussion in this chapter will also talk about how to create database and its tables based on the ERD design using MySQL server. CHAPTER 4: The discussion in this chapter will guide you to create main form and login form for the application. This chapter will discuss in detail about how to create these two forms. These forms are the first two forms that we will create in building library management system application. This chapter will also discuss about how to run the application. CHAPTER 5: The discussion in this chapter will guide you to create user accounts form and members form for Library Management System application. This chapter will discuss in detail about how to create these two forms. This chapter will also discuss about how to add these two forms as MDI sub windows of the main form. And the final discussion of this chapter will guide you to use the forms to manage user accounts and members data of Library Management System application. CHAPTER 6: The discussion in this chapter will guide you to create authors form, genres form, and books form for Library Management System application. This chapter will discuss in detail about how to create these three forms. This chapter will also discuss about how to add books form as MDI sub window of the main form. And the final discussion of this chapter will guide you to use the forms to manage authors, genres, and books data in Library Management System application. CHAPTER 7: The discussion in this chapter will guide you to create member search form, book search form, and loan transaction form for Library Management System application. This chapter will discuss in detail about how to create these three forms. This chapter will also discuss about how to add loan transaction form as MDI sub window of the main form. And the final discussion of this chapter will guide you to use the forms to manage loan transactions in Library Management System application. CHAPTER 8: The discussion in this chapter will guide you to create members statistic form, books statistic form, and loan statistic form for Library Management System application. This chapter will discuss in detail about how to create these three forms. This chapter will also discuss about how to add all of the forms as MDI sub windows of the main form. And the final discussion of this chapter will guide you to use all of the forms to display the statistics in the library.

Author : Vivian Siahaan
Publisher : SPARTA PUBLISHING
ISBN 13 :
Total Pages : 404 pages
Book Rating : 4./5 ( download)

DOWNLOAD NOW!

Download or read book Learn JDBC By Example: A Quick Start Guide to MariaDB and SQL Server Driven Programming written by Vivian Siahaan and published by SPARTA PUBLISHING. This book was released on 2019-11-24 with total page 404 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book explains relational theory in practice, and demonstrates through two projects how you can apply it to your use of MariaDB and SQL Server databases. This book covers the important requirements of teaching databases with a practical and progressive perspective. This book offers the straightforward, practical answers you need to help you do your job. This hands-on tutorial/reference/guide to MariaDB and SQL Server is not only perfect for students and beginners, but it also works for experienced developers who aren't getting the most from MariaDB and SQL Server. As you would expect, this book shows how to build from scratch two different databases: MariaDB and SQL Server using Java. In designing a GUI and as an IDE, you will make use of the NetBeans tool. In chapter one, you will learn the basics of cryptography using Java. Here, you will learn how to write a Java program to count Hash, MAC (Message Authentication Code), store keys in a KeyStore, generate PrivateKey and PublicKey, encrypt / decrypt data, and generate and verify digital prints. You will also learn how to create and store salt passwords and verify them. In chapter two, you will create a PostgreSQL database, named Bank, and its tables. In chapter three, you will create a Login table. In this case, you will see how to create a Java GUI using NetBeans to implement it. In addition to the Login table, in this chapter you will also create a Client table. In the case of the Client table, you will learn how to generate and save public and private keys into a database. You will also learn how to encrypt / decrypt data and save the results into a database. In chapter four, you will create an Account table. This account table has the following ten fields: account_id (primary key), client_id (primarykey), account_number, account_date, account_type, plain_balance, cipher_balance, decipher_balance, digital_signature, and signature_verification. In this case, you will learn how to implement generating and verifying digital prints and storing the results into a database. In chapter five, you create a table named Client_Data, which has seven columns: client_data_id (primary key), account_id (primary_key), birth_date, address, mother_name, telephone, and photo_path. In chapter six, you will be taught how to create a SQL Server database, named Crime, and its tables. In chapter seven, you will be taught how to extract image features, utilizing BufferedImage class, in Java GUI. In chapter eight, 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 chapter nine, 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 chapter ten, 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 chapter eleven, 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 and can improve database programming skills for every Java/MariaDB/SQL Server programmer.

Author : Hamzan Wadi
Publisher :
ISBN 13 :
Total Pages : 338 pages
Book Rating : 4.15/5 ( download)

DOWNLOAD NOW!

Download or read book Step by Step Java GUI with JDBC and MySQL : Practical Approach to Build Database Desktop Application with Project Based Examples written by Hamzan Wadi and published by . This book was released on 2020-02-10 with total page 338 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book comes as an answer for students, lecturers, or the general public who want to learn Java GUI programming starting from scratch. This book is suitable for beginner learners who want to learn Java GUI programming from the basic to the database level. This book is also present for JAVA learners who want to increase their level of making GUI-based database applications for small, medium, or corporate businesses level. The discussion in this book is not wordy and not theoretical. Each discussion in this book is presented in a concise and clear brief, and directly to the example that implements the discussion. Beginner learners who want to learn through this book should not be afraid of losing understanding of the programming concepts, because this book in detail discusses the concepts of Java programming from the basic to the advanced level. By applying the concept of learning by doing, this book will guide you step by step to start Java GUI programming from the basics until you are able to create database applications using JDBC and MySQL. Here are the material that you will learn in this book.CHAPTER 1 : This chapter will give you brief and clear introduction about how to create desktop application using Java GUI starting from how to setup your environments, create your first project, understand various control for your form, and understand how to interact with your form using event handling.CHAPTER 2 : This chapter will discuss clearly about the concept and the implementatiton of data types and variables in Java GUI.CHAPTER 3 : This chapter will discuss in detail about how to make decisions or deal with a condition in the program. This chapter is the first step to deeper understanding of logics in programming. This chapter specifically discusses relational operators and logical operators, if statements, if-else statements, and switch-case statements, and how to implement all of these conditional statements using Java GUI.CHAPTER 4 : This chapter will discuss in detail the looping statements in Java including for statement, while statement, do-while statement, break statement, and continue statement. All of these looping statements will be implemented using Java GUI.CHAPTER 5 : This chapter will discuss how to use methods to group codes based on their funcitonality. This discussion will also be the first step for programmers to learn how to create efficient program code. This chapter will discuss in detail the basics of methods, methods with return values, how to pass parameters to methods, how to overload your methods, and how to make recursive methods.CHAPTER 6 : This chapter will discuss in detail how to create and use arrays, read and write file operations, and how to display data stored in arrays or files in graphical form.CHAPTER 7 : This chapter will discuss in detail the basics of MySQL, how to access databases using JDBC and MySQL, and how to perform CRUD operations using JDBC and MySQL. CHAPTER 8 : In this chapter we will discuss more about Java GUI programming. This chapter will discuss in detail about how to make a program that consists of multi forms, how to create MDI application, and how to create report using iReport with data stored in a database.

Author : Vivian Siahaan
Publisher : SPARTA PUBLISHING
ISBN 13 :
Total Pages : 490 pages
Book Rating : 4./5 ( download)

DOWNLOAD NOW!

Download or read book POSTGRESQL FOR JAVA GUI: Database, Cryptography, and Image Processing written by Vivian Siahaan and published by SPARTA PUBLISHING. This book was released on 2019-09-01 with total page 490 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 cryptography and 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 PostgreSQL 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 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 the second chapter, you will learn the basics of cryptography using Java. Here, you will learn how to write a Java program to count Hash, MAC (Message Authentication Code), store keys in a KeyStore, generate PrivateKey and PublicKey, encrypt / decrypt data, and generate and verify digital prints. In the third chapter, you will learn how to create and store salt passwords and verify them. You will create a Login table. In this case, you will see how to create a Java GUI using NetBeans to implement it. In addition to the Login table, in this chapter you will also create a Client table. In the case of the Client table, you will learn how to generate and save public and private keys into a database. You will also learn how to encrypt / decrypt data and save the results into a database. In the fourth chapter, you will create an Account table. This account table has the following ten fields: account_id (primary key), client_id (primarykey), account_number, account_date, account_type, plain_balance, cipher_balance, decipher_balance, digital_signature, and signature_verification. In this case, you will learn how to implement generating and verifying digital prints and storing the results into a database. In the fifth chapter, you create a table with the name of the Account, which has ten columns: account_id (primary key), client_id (primarykey), account_number, account_date, account_type, plain_balance, cipher_balance, decipher_balance, digital_signature, and signature_verification. In the sixth chapter, you will create a Client_Data table, which has the following seven fields: client_data_id (primary key), account_id (primary_key), birth_date, address, mother_name, telephone, and photo_path. In the seventh chapter, you will be taught how to create Crime database and its tables. In eighth chapter, you will be taught how to extract image features, utilizing BufferedImage class, in Java GUI. In the nineth 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 tenth 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 eleventh 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 twelfth 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.