JDBC stands for Java Database Connectivity. JDBC is a Java API to connect and execute the query with the database. It is a part of JavaSE (Java Standard Edition). JDBC API uses JDBC drivers to connect with the database.
This book uses the Sakila sample database which is a fictitious database designed to represent a DVD rental store. The 15 tables of the database include film, film_category, actor, customer, rental, payment and inventory among others. The Sakila sample database is intended to provide a standard schema that can be used for examples in books, tutorials, articles, samples, and so forth. You can download the sample database from site.
In this project, you will design the form for every table and you will plot: top 10 film distribution by release year; top 10 film distribution by rating; top 10 film distribution by rental duration; top 10 film distribution by language; film distribution by categorized rental rate; film distribution by categorized length; film distribution by categorized replacement cost; top 10 film distribution by actor name; top 10 actor name distribution by average rental rate; top 10 actor name distribution by average replacement cost; film distribution by rating; rating distribution by average rental rate; rating distribution by average replacement cost; top 10 film distribution by category name, category distribution by average replacement cost; category distribution by average rental rate; category distribution by length; top 10 city distribution by by country; top 10 address distribution by district, top 10 address distribution by country; top 10 address distribution by city; top 10 address distribution by district; top 10 address distribution by country; top 10 address distribution by city; top 10 inventory distribution by release year; top 10 inventory distribution by film rating; top 10 inventory distribution by film language; top 10 inventory distribution by film rental duration; top 10 inventory distribution by city; top 10 inventory distribution by country; top 10 customer distribution by country; top 10 customer distribution by city; top 10 customer distribution by district; top 10 customer distribution by store country; top 10 customer distribution by store city; top 10 customer distribution by store district; top 10 staff distribution by country; top 10 staff distribution by city; rental distribution by year of rental date; rental distribution by month of rental date; 10 rental distribution by week of rental date; rental distribution by day of rental date; rental distribution by quarter of rental date; rental distribution by film release year; rental distribution by film duration; rental distribution by film rating; top 10 rental distribution by staff name; rental distribution by film language; top 10 rental distribution by film title; rental distribution by customer active; top 10 rental distribution by film category; top 10 rental distribution by actor name; top 10 rental distribution by customer name; top 10 rental distribution by customer city; top 10 rental distribution by customer country, top 10 rental distribution by customer district; payment distribution by year of payment date; payment distribution by month of payment date; top 10 payment distribution by week of payment date; payment distribution by day of payment date; payment distribution by quarter of payment date; payment distribution by film release year; payment distribution by film duration; payment distribution by film rating; top 10 payment distribution by staff name; payment distribution by film language; top 10 payment distribution by film title; payment distribution by customer active; top 10 payment distribution by film category; top 10 payment distribution by actor name; top 10 payment distribution by customer name; top 10 payment distribution by customer city; top 10 payment distribution by customer country; and top 10 payment distribution by customer district.
Author(s): Vivian Siahaan, Rismon Hasiholan Sianipar
Publisher: BALIGE PUBLISHING
Year: 2023
Language: English
Pages: 734
PROJECT AND UTILITY CLASS
DESCRIPTION
CREATING PROJECT AND UTILITY CLASS
SOURCE CODE
ACTOR FORM
CREATING AND POPULATING ACTOR TABLE
DESIGNING GUI
POPULATING TABLE AND COMBOBOXES
DISPLAYING AND NAVIGATING DATA ROW BY ROW
UPDATING RECORD
UPDATING RECORD DIRECTLY ON JTABLE
INSERTING NEW RECORD
DELETING RECORD
SOURCE CODE
LANGUAGE FORM
CREATING AND POPULATING LANGUAGE TABLE
DESIGNING GUI
POPULATING TABLE AND COMBOBOXES
DISPLAYING AND NAVIGATING DATA ROW BY ROW
UPDATING RECORD
UPDATING RECORD DIRECTLY ON JTABLE
INSERTING NEW RECORD
DELETING RECORD
SOURCE CODE
CATEGORY FORM
CREATING AND POPULATING CATEGORY TABLE
DESIGNING GUI
POPULATING TABLE AND COMBOBOXES
DISPLAYING AND NAVIGATING DATA ROW BY ROW
UPDATING RECORD
UPDATING RECORD DIRECTLY ON JTABLE
INSERTING NEW RECORD
DELETING RECORD
SOURCE CODE
FILM FORM
CREATING AND POPULATING FILM TABLE
DESIGNING GUI
POPULATING TABLE AND COMBOBOXES
DISPLAYING AND NAVIGATING DATA ROW BY ROW
UPDATING RECORD
UPDATING RECORD DIRECTLY ON JTABLE
INSERTING NEW RECORD
DELETING RECORD
PLOTTING CHART
SOURCE CODE
FILM ACTOR FORM
CREATING AND POPULATING FILM ACTOR TABLE
DESIGNING GUI
POPULATING TABLE AND COMBOBOXES
DISPLAYING AND NAVIGATING DATA ROW BY ROW
UPDATING RECORD
INSERTING NEW RECORD
DELETING RECORD
PLOTTING CHART
SOURCE CODE
FILM CATEGORY FORM
CREATING AND POPULATING FILM CATEGORY TABLE
DESIGNING GUI
POPULATING TABLE AND COMBOBOXES
DISPLAYING AND NAVIGATING DATA ROW BY ROW
UPDATING RECORD
INSERTING NEW RECORD
DELETING RECORD
PLOTTING CHART
SOURCE CODE
COUNTRY FORM
CREATING AND POPULATING COUNTRY TABLE
DESIGNING GUI
POPULATING TABLE AND COMBOBOXES
DISPLAYING AND NAVIGATING DATA ROW BY ROW
UPDATING RECORD
UPDATING RECORD DIRECTLY ON JTABLE
INSERTING NEW RECORD
DELETING RECORD
SOURCE CODE
CITY FORM
CREATING AND POPULATING CITY TABLE
DESIGNING GUI
POPULATING TABLE AND COMBOBOXES
DISPLAYING AND NAVIGATING DATA ROW BY ROW
UPDATING RECORD
UPDATING RECORD DIRECTLY ON JTABLE
INSERTING NEW RECORD
DELETING RECORD
PLOTTING CHART
SOURCE CODE
ADDRESS FORM
CREATING AND POPULATING ADDRESS TABLE
DESIGNING GUI
POPULATING TABLE AND COMBOBOXES
DISPLAYING AND NAVIGATING DATA ROW BY ROW
UPDATING RECORD
UPDATING RECORD DIRECTLY ON JTABLE
INSERTING NEW RECORD
DELETING RECORD
PLOTTING CHART
SOURCE CODE
STORE FORM
CREATING AND POPULATING STORE TABLE
DESIGNING GUI
POPULATING TABLE AND COMBOBOXES
DISPLAYING AND NAVIGATING DATA ROW BY ROW
UPDATING RECORD
UPDATING RECORD DIRECTLY ON JTABLE
INSERTING NEW RECORD
DELETING RECORD
PLOTTING CHART
SOURCE CODE
INVENTORY FORM
CREATING AND POPULATING INVENTORY TABLE
DESIGNING GUI
POPULATING TABLE AND COMBOBOXES
DISPLAYING AND NAVIGATING DATA ROW BY ROW
UPDATING RECORD
INSERTING NEW RECORD
DELETING RECORD
PLOTTING CHART
SOURCE CODE
CUSTOMER FORM
CREATING AND POPULATING CUSTOMER TABLE
DESIGNING GUI
POPULATING TABLE AND COMBOBOXES
DISPLAYING AND NAVIGATING DATA ROW BY ROW
UPDATING RECORD
UPDATING RECORD DIRECTLY ON JTABLE
INSERTING NEW RECORD
DELETING RECORD
PLOTTING CHART
SOURCE CODE
STAFF FORM
CREATING AND POPULATING STAFF TABLE
DESIGNING GUI
POPULATING TABLE AND COMBOBOXES
DISPLAYING AND NAVIGATING DATA ROW BY ROW
UPDATING RECORD
INSERTING NEW RECORD
DELETING RECORD
PLOTTING CHART
SOURCE CODE
RENTAL FORM
CREATING AND POPULATING RENTAL TABLE
DESIGNING GUI
POPULATING TABLE AND COMBOBOXES
DISPLAYING AND NAVIGATING DATA ROW BY ROW
UPDATING RECORD
INSERTING NEW RECORD
DELETING RECORD
PLOTTING CHART
SOURCE CODE
PAYMENT FORM
CREATING AND POPULATING PAYMENT TABLE
DESIGNING GUI
POPULATING TABLE AND COMBOBOXES
DISPLAYING AND NAVIGATING DATA ROW BY ROW
UPDATING RECORD
INSERTING NEW RECORD
DELETING RECORD
PLOTTING CHART
SOURCE CODE