COURSE SEARCH

HOME > COURSES > JAVA DATABASE CONNECTIVITY (JDBC) AND RMI

MEMBERS LOGIN

UNLIMITED ACCESS TO OVER 575 ONLINE TRAINING COURSES FOR ONE ANNUAL PAYMENT OF ONLY $149 USD
BUY NOW

HOME

COURSE LIBRARY

QUESTIONS & ANSWERS

There are many excellent online courses. This has been hugely beneficial in my day to day work.

- Louise Nolan

MORE INFO

Java Database Connectivity (JDBC) and RMI

Course Aims
This course explores Java's database connectivity package, JDBC 2.0. Topics include JDBC elements, the steps used to access a database with JDBC, data retrieval issues, and some of the advanced features that will gain more support with future releases of the JDBC API. Participants will use the JDBC interface to provide a call-level API for SQL-based database applications.

Assumed Knowledge
This course is developed for people involved with Web publishing and Web technology based GUI development, or people writing multi-tiered networking applications.

Course Audience
Although there is no specific prerequisite for this course student should however have a good level of Java programming.

This course can be found in the following categories:

Courses > Programming
Courses > Programming > Java

Table of Contents

Databases and Java

Introduction

Database overview

Database Terminology

Database Access Methods

Database Client/Server Methodology

Single-tier Database Design

Two-tier Database Design

Three-tier Database Design

Databases and Java

Role of JDBC

JDBC Goals

Structured Query Language SQL

Overview

Select Statements

Where Clause

Joins

Common SQL Commands

ResultSet and Cursors

Transaction

Stored Procedures

Example to create a Stored Procedure

Metadata

JDBC Overview

What is JDBC?

Example to establish, send and process the database statement

What Does JDBC do?

The JDBC API

JDBC Vs ODBC

The API Components

JDBC Drivers

JDBC Products

The java.sql Package

Interfaces in java.sql

Classes in java.sql

Exceptions in java.sql

Steps to access a database using JDBC

Step 1 Import java.sql. Package

Step 2 Registering the Drivers

Step 3 Connecting to the Database

Step 4 Create a Statement

Step 5 Execute the Statement

Step 6 Retrieving the results

Step 7 Close the Statement and Connection

Exercise for connecting to the oracle database

Exercise for connecting to the MS-Access database

Executing DDL Commands

Creating the Tables

Exercise for creating the tables

Altering a Table

Exercise for Altering a Table

Dropping a Column

Exercise for Dropping a Column

Executing DML Commands

Inserting values into Tables

Exercise to insert a row into the table.

Retrieving values from Database

Exercise to retrieve values using select statement

Updating a table

Exercise to update the records

Deleting a row from the table

Exercise to delete a row from the table

Joins and Transaction

Joins Overview

Example showing Equi-join

Exercise to show Equi-Join

Exercise to show Outer-Join

Transaction

Exercise for Transaction

PreparedStatement

Overview

The PreparedStatement Class

Creating a PreparedStatement

Supplying values to PreparedStatement

Exercise for Prepared Statement

CallableStatement

Stored Procedures

Creating Stored Procedures

Creating and Executing CallableStatement

Exercise for creating Stored Procedure

Exercise of CallableStatement

Cursors and Batch Updates

Overview

Cursors

ResultSet Parameters

Creating a Scrollable ResultSet

Exercise for Scrollable ResultSet

Exercise to Retrive: 1

Exercise to Retrive: 2

Updatable ResultSets

Batch Updates

PART TWO: Remote Method Invocation (RMI)

PART TWO: Remote Method Invocation (RMI)

Distributed Applications

Overview

Distributed Object Computing

Need for Distributed Application

Distribution Vs Non-Distribution Models

Advantages of Distributed Application

Introduction to Java RMI

Overview

Alternatives to RMI

Remote Procedure Call (RPC)

DCOM

CORBA

RMI Architecture

RMI Layers

RMI Registry

RMI URLs

Looking up a Remote Object

The RMI Compiler

Object Serialization

How Objects are Serialized

Pass by Value

Passing by Reference

Defining Interface

How RMI works?

Garbage Collection in RMI

Building a Client/Server Application

Create a Remote Interface

Example for Remote interface

Exercise for creating a Remote Interface

Create a class that implements the Remote Interface

Exercise for Class that implements a remote interface

Create the main server program

Exercise for Server program

Create Stub and Skeleton Classes

Create a client class that uses remote services

Exercise for Client programple

Startup the Remote object Registry, Server and Client

Dynamic Class Loading

Introduction

Looking back, codebase in Applets

Codebase in RMI

Command line examples

Exercise on Dynamic Class Loading

Advanced Concepts in RMI

Introduction

Security

Serialization

Object Streams

Externalized Objects

Protocols

Java Object Serialization Protocol

HTTP Protocol

Multiplexing Protocol

Object Activation

Making an object activable

Sample Source Code

Creating the 'setup' class

Sample Source Code

Compile and run the code

Exercise

Questions

Solutions

Example to Update

Exercise to Update

Exercise to Insert

Standard Extension Features

Exercise

Questions

Solutions

TRY BEFORE YOU BUY

BECOME A RESELLER

TERMS & PRIVACY

Thursday 17th May 2012