Advertisement
Published in:
2020 | OriginalPaper | Chapter
15. Java and the Database (JDBC)
Activate our intelligent search to find suitable subject content or patents.
Select sections of text to find matching patents with Artificial Intelligence. powered by
Select sections of text to find additional relevant content using AI-assisted search. powered by
Abstract
This chapter explains how to create and populate a database using the MySQL relational database management system (RDBMS). It also demonstrates how a JDBC driver enables Java code to connect to and interact with a relational database using a standard API. Code examples cover the execution of queries to create a ResultSet, and the execution of updates. They also demonstrate how PreparedStatements can be set up that can be efficiently reused for common types of interaction with the database. The level of interaction between Java and the database described in this chapter is at the very simple level of moving data in and out of the database and does not address in detail the much broader issue of object relational mapping. It therefore directs readers interested in further detail of how objects can be made persistent in a relational database to explore the Java Persistence API, which can be used with both SQL and NoSQL databases.