An Introduction to Embedded Database Programming & JDBC

11/1/2002


Click here to start


Table of Contents

An Introduction to Embedded Database Programming & JDBC

PPT Slide

What is a Database?

Database

What is RDBMS?

DBMS & Oracle

PPT Slide

How to get and put data to a DBMS?

SQL

SQL Commands

Example

Embedded SQL

Why Embedded SQL?

Embedded Languages

An Introduction to JDBC

What does JDBC?

Prerequisites

Installing a Java Platform Which includes JDBC API

Drivers

Getting Started

Import JDBC classes

Loading a Driver

Making a Connection

Making a Connection

Creating JDBC Statement

executeUpdate() Statement

executeQuery() Statement

Example of executeQuery()

Transactions Ý

Errors and Warnings

Example for Error statement

Now, Letís see a small JDBC program.

Example JDBC programming

String member = "create table member(" +

Statement stmt = conn.createStatement();

stmt.executeUpdate("insert into Member values

Author: Instructional Software

Download presentation source