Chapter 16.3, Problem 16.17CP

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.
    • The “prop” denotes a property object that holds a set of keyword value pairs.
  • DriverManager.getConnection(String url, String user, String password):
    • The “url” denotes database URL that would specify sub protocol, database server identifier as well as list of properties.
    • The “user” and “password” denotes username as well as password to get a connection object.
• Hence, the method to create connection to a database is “DriverManager.getConnection()”.

executeQuery:

• The “executeQuery” method returns one ResultSet object...