This chapter explains how to write Java code that can manipulate—insert, read, update, delete—data in a database. It also provides a short introduction to the SQL language and basic database operations.
In this chapter, we will cover the following topics:
- What is Java Database Connectivity (JDBC)?
- How to create/delete a database
- Short overview of Structured Query Language (SQL)
- How to create/delete/modify a database table
- Create, read, update, and delete (CRUD) database data
- Exercise – Selecting unique first names