What you'll learn
in this project, you'll use JDBC to build the persistence layer of a command-line application for managing the orders of an e-commerce store.
Table of contents
Setup
1h
- Set up your local environment for this project. We'll walk you through everything you need to know, including how to install and configure your environment to be able to complete all of the tasks.
Connect to the database
5m
- In this module, you'll add the code to connect to the database using the DriverManager class.
Get information about an order
5m
- In this module, you will add code to get information from an order by its identifier.
Update the status of an order
5m
- In this module, you will add code to update the status of orders and return the number of rows affected.
Delete orders
5m
- In this module, you will add code to delete one or more orders from the database and return the number of rows affected.
Insert an Order
15m
- In this module, you will add code to insert an order in the database. Inserting an order involves inserting a record in the `orders` table and one record for every product contained in the order in the `order_details` table. These operations will have to be executed in the same transaction.
Get the total amount of all paid orders of a customer
5m
- In this module, you will call a stored procedure to get the total amount of all paid orders of a particular customer.
About the author
Esteban Herrera has more than twelve years of experience in the software development industry. He has worked in many roles and projects, but mostly architecting and developing enterprise systems with Java and Javascript. Among others, Esteban holds the PMI's Project Manager certification and the Oracle Java EE 6 Enterprise Architect Master Certification. Nowadays, he spends all of his time learning new things, writing articles, teaching programming, and enjoying his kids.
