Connection Object : Connection « Database « Java Tutorial

The Connection object has the following capabilities:

  1. Creates SQL statements
  2. Executes SQL queries, inserts, updates, and deletes
  3. Handles commits and rollbacks
  4. Provides metadata regarding the database connection

By default, a Connection object is in autocommit mode, which means it automatically commits changes after executing each statement.

20.3.1.Connection Object
20.3.2.Connection Object Requirements
20.3.3.Connection Properties: Pass additional properties using java.util.Properties:
20.3.4.Passing 'user' and 'password' Parameters as a java.util.Properties Object to Connection object
20.3.5.Test to See if Your Connection is Alive
20.3.6.Vendor URL Formats
20.3.7.Connection's Method to Print Native SQL