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
- 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.
- In this module, you'll add the code to connect to the database using the DriverManager class.
- In this module, you will add code to get information from an order by its identifier.
- In this module, you will add code to update the status of orders and return the number of rows affected.
- In this module, you will add code to delete one or more orders from the database and return the number of rows affected.
- 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.
- In this module, you will call a stored procedure to get the total amount of all paid orders of a particular customer.