Read Anywhere and on Any Device!

Subscribe to Read | $0.00

Join today and start reading your favorite books for Free!

Create Free Account

Quick and Easy Sign Up!

It takes less then 1 minute to sign up, then you can enjoy Unlimited eBooks.

Sign Up Browse

Popular Genres

Read Anywhere and on Any Device!

  • Download on iOS
  • Download on Android
  • Download on iOS

Learn JDBC the Hard Way: A Hands-On Reference to MySQL and SQL Server Driven Programming

Learn JDBC the Hard Way: A Hands-On Reference to MySQL and SQL Server Driven Programming

Vivian Siahaan
0/5 ( ratings)
Read Download
This hands-on tutorial/reference/guide to MySQL 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 MySQL and SQL Server. As you would expect, this book shows how to build from scratch two different MySQL and SQL Server using Java. In designing a GUI and as an IDE, you will make use of the NetBeans tool. In the first chapter, you will How to install NetBeans, JDK 11, and MySQL Connector/J; How to integrate external libraries into projects; How the basic MySQL 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 Creating the initial three table projects in the school 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 third chapter, you will Creating the main form to connect all forms; Creating a project will add three more tables to the school 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 be taught how to create Crime database and its tables. In chapter six, you will be taught how to extract image features, utilizing BufferedImage class, in Java GUI. In chapter seven, you will be taught to create Java GUI to view, edit, insert, and delete Suspect table data. This table has eleven suspect_id , suspect_name, birth_date, case_date, report_date, suspect_ status, arrest_date, mother_name, address, telephone, and photo. In chapter eight, you will be taught to create Java GUI to view, edit, insert, and delete Feature_Extraction table data. This table has eight feature_id , suspect_id , feature1, feature2, feature3, feature4, feature5, and feature6. In chapter nine, you will add two 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 police_station_id , location, city, province, telephone, and photo. The Investigator has eight investigator_id , 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 ten, you will add two Victim and File_Case. The File_Case table will connect four other Suspect, Police_Station, Investigator and Victim. The Victim table has nine victim_id , victim_name, crime_type, birth_date, crime_date, gender, address, telephone, and photo. The File_Case has seven file_case_id , suspect_id , police_station_id , investigator_id , victim_id , 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/MySQL/SQL SERVER programmer.
Language
English
Pages
910
Format
Kindle Edition
Release
November 22, 2019

Learn JDBC the Hard Way: A Hands-On Reference to MySQL and SQL Server Driven Programming

Vivian Siahaan
0/5 ( ratings)
Read Download
This hands-on tutorial/reference/guide to MySQL 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 MySQL and SQL Server. As you would expect, this book shows how to build from scratch two different MySQL and SQL Server using Java. In designing a GUI and as an IDE, you will make use of the NetBeans tool. In the first chapter, you will How to install NetBeans, JDK 11, and MySQL Connector/J; How to integrate external libraries into projects; How the basic MySQL 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 Creating the initial three table projects in the school 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 third chapter, you will Creating the main form to connect all forms; Creating a project will add three more tables to the school 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 be taught how to create Crime database and its tables. In chapter six, you will be taught how to extract image features, utilizing BufferedImage class, in Java GUI. In chapter seven, you will be taught to create Java GUI to view, edit, insert, and delete Suspect table data. This table has eleven suspect_id , suspect_name, birth_date, case_date, report_date, suspect_ status, arrest_date, mother_name, address, telephone, and photo. In chapter eight, you will be taught to create Java GUI to view, edit, insert, and delete Feature_Extraction table data. This table has eight feature_id , suspect_id , feature1, feature2, feature3, feature4, feature5, and feature6. In chapter nine, you will add two 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 police_station_id , location, city, province, telephone, and photo. The Investigator has eight investigator_id , 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 ten, you will add two Victim and File_Case. The File_Case table will connect four other Suspect, Police_Station, Investigator and Victim. The Victim table has nine victim_id , victim_name, crime_type, birth_date, crime_date, gender, address, telephone, and photo. The File_Case has seven file_case_id , suspect_id , police_station_id , investigator_id , victim_id , 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/MySQL/SQL SERVER programmer.
Language
English
Pages
910
Format
Kindle Edition
Release
November 22, 2019

More books from Vivian Siahaan

Rate this book!

Write a review?

loader