Java - JDBC

Details

Services

• Lunch / Catering
• Assistance for hotel / travel bookings
• Comelio certificate
• Flexible: Free cancellation up until one day before the training

Summary

JDBC is a Java-based data access technology which consists of an API that defines how a client may access a relational database. It provides methods for querying and updating data in a database. JDBC allows multiple implementations to exist and be used by the same application. The API provides a mechanism for dynamically loading the correct Java packages and registering them with the JDBC Driver Manager. The Driver Manager is used as a connection factory for creating JDBC connections. JDBC connections support creating and executing statements. These may be update statements such as SQL's CREATE, INSERT, UPDATE and DELETE, or they may be query statements such as SELECT. Additionally, stored procedures may be invoked through a JDBC connection. This training shows you how to execute various DB-related operations from your Java application.

Agenda

JDBC Introduction

JDBC Architecture - Establishing a Connection - Connecting with DataSource Objects - Handling SQLExceptions

Performing SQL Operations

Retrieving and Modifying Values from Result Sets: ResultSet Interface, Retrieving Column Values from Rows, Cursors, Updating Rows in ResultSet Objects, Using Statement Objects for Batch Updates, Inserting Rows in ResultSet Objects - Using Prepared Statements: Overview of Prepared Statements, Creating a PreparedStatement Object, Supplying Values for PreparedStatement Parameters - Using Transactions: Auto-Commit Mode, Committing Transactions, Preserving Data Integrity, Setting and Rolling Back to Savepoints, Releasing Savepoints - Using Stored Procedures

RowSet Objects

Using JdbcRowSet Objects - Using CachedRowSetObjets - Using JoinRowSet Objects - Using FilteredRowSet Objects - Using WebRowSet Objects

Using SQLXML Objects

Creating SQLXML Objects - Retrieving SQLXML Values in ResultSet - Accessing SQLXML Object Data - Storing SQLXML Objects - Initializing SQLXML Objects - Releasing SQLXML Resources

JDBC and Object-Relational Extensions in Oracle

Using Array Objects: Creating Array Objects, Retrieving and Accessing Array Values in ResultSet, Storing and Updating Array Objects, Releasing Array Resources - - Using Customized Type Mappings - Using Structured Objects: Overview of Structured Types, Using DISTINCT Type in Structured Types, Using References to Structured Types, Using User-Defined Types as Column Values, Inserting User-Defined Types into Tables