Chapter 16, Problem 13AW

Explanation of Solution

Static JDBC method to get connection to a database:

• The method to create connection to a database is “DriverManager.getConnection()”.
• It creates a connection object that is used for creating SQL statements, and sends them to database as well as process results.
• The “DriverManager” class would track available drivers and would handle connection requests among appropriate drivers as well as database.
• The three types of methods includes:
  • DriverManager.getConnection(String url):
    • The “url” denotes database URL that would specify sub protocol, database server identifier as well as list of properties.
  • DriverManager.getConnection(String url, Properties prop):
    • The “url” denotes database URL that would specify sub protocol, database server identifier as well as list of properties...