Chapter 10: Managing Data in a Database
This chapter explains and demonstrates how to manage – that is, insert, read, update, and delete – data in a database using a Java application. It also provides a short introduction to Structured Query Language (SQL) and basic database operations, including how to connect to a database, how to create a database structure, how to write a database expression using SQL, and how to execute these expressions.
The following topics will be covered in this chapter:
- Creating a database
- Creating a database structure
- Connecting to a database
- Releasing the connection
- Create, read, update, and delete (CRUD) operations on data
- Using a shared library JAR file to access a database
By the end of the chapter, you will be able to create and use a database for storing, updating, and retrieving data as well as create and use a shared library.