Portal de Periódicos da CAPES

Java and the Database (JDBC)

2020; Springer International Publishing; Linguagem: Inglês

10.1007/978-3-030-54518-5_15

1868-095X

David Parsons,

Cloud Computing and Resource Management

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.