JDBC connection objects

When you connect to a data source by either connection method, you create a Connection object, which represents the connection to the data source.

You use this Connection object to do the following things:
  • Create Statement, PreparedStatement, and CallableStatement objects for executing SQL statements. These are discussed in "Executing SQL statements in JDBC applications".
  • Gather information about the data source to which you are connected. This process is discussed in "Learning about a data source using DatabaseMetaData methods".
  • Commit or roll back transactions. You can commit transactions manually or automatically. These operations are discussed in "Commit or roll back a JDBC transaction".
  • Close the connection to the data source. This operation is discussed in "Disconnecting from data sources in JDBC applications".