JDBC Tutorial

About This Book

JDBC (Java Database Connectivity) Introduction

What Is JDBC?

JDBC Version and History

JDBC Driver Types

Establishing Connections from JDBC to Databases

DriverManager - Loading JDBC Driver

DriverManager - Connection URL

Downloading and Installing JDK - Java SE

Java SE 1.6 Update 2 Installation

Compile and Run Java Programs

JDK Documentation Installation

Microsoft SQL Server 2005 Express Edition

Downloading Microsoft SQL Server 2005 Express Edition

Installing Microsoft SQL Server 2005 Express Edition

SQLCMD SQL Server Command Line Tool

Installing AdventureWorksLT Sample Database

Microsoft JDBC Driver for SQL Server - sqljdbc.jar

Installing Microsoft JDBC Driver for SQL Server

Loading Driver Class with Class.forName()

DriverManager.getConnection() and Connection URL

Specifying Port Number in Connection URL

Closing the Database Connection - con.close()

Specifying Database Name in Connection URL

Incorrect Database Name in Connection URL

Microsoft JDBC Driver - Query Statements and Result Sets

Commonly Used JDBC Class Methods

Calling createStatement() and executeQuery

Receiving ResultSet Objects from executeQuery

Closing ResultSet Objects - res.close()

Looping through ResultSet with res.next()

Retrieving Field Values using res.get*() Methods

Using ResultSetMetaData Objects to List All Fields

Microsoft JDBC Driver - DatabaseMetaData Object

Commonly Used DatabaseMetaData Methods

Getting Database Server and Driver Info

Listing All Databases - getCatalogs()

Listing All Schemas - getSchemas()

Listing All Tables - getTables()

Listing All Culumns - getColumns()

Listing All Stored Procedures - getProcedures()

Microsoft JDBC Driver - DDL Statements

Executing "Update" Statements - executeUpdate()

"CREATE SCHEMA" Statements

"CREATE TABLE" Statements

"ALTER TABLE" Statements

"DROP TABLE" Statements

Microsoft JDBC Driver - DML Statements

"SELECT ... INTO" Statements

"INSERT INTO" Statements

"INSERT INTO" Statements with INDENTITY Columns

"UPDATE" Statements

"DELETE FROM" Statements

JDBC-OBDC Bridge Driver - sun.jdbc.odbc.JdbcOdbcDriver

JDBC-ODBC Bridge Driver Features

JDBC-ODBC - Loading sun.jdbc.odbc.JdbcOdbcDriver

JDBC-ODBC - Creating DNS

JDBC-ODBC - Connecting to a DSN

JDBC-ODBC - Problem with Incorrect DSN

JDBC-OBDC Bridge Driver - Flat Text Files

JDBC-ODBC - Creating DNS for Flat Test File

JDBC-ODBC - Connecting to Flat Text Files

JDBC-ODBC - Getting Flat File Driver Info

JDBC-ODBC - CREATE TABLE in Flat Text Files

JDBC-ODBC - Listing Tables with meta.GetTables()

JDBC-ODBC - Tab Delimited Flat File Data

JDBC-ODBC - ODBC Configuration for Flat Files

JDBC-ODBC - Executing Queries on Flat Files

JDBC-ODBC - Missing Flat Data Files

JDBC-OBDC Bridge Driver - MS Access

JDBC-ODBC - Creating a MS Access Database File

JDBC-ODBC - Creating DNS for MS Access

JDBC-ODBC - Connecting to MS Access Database Files

JDBC-ODBC - MS Access Database and Driver Info

JDBC-ODBC - Creating New Tables in MS Access Database

JDBC-ODBC - Inserting Data Rows to MS Access Database

JDBC-ODBC - Running Queries on MS Access Database

JDBC-OBDC Bridge Driver - MS SQL Server

JDBC-ODBC-SQL-Server-TCP/IP

JDBC-ODBC - Creating DNS for SQL Server 2005

JDBC-ODBC - Connecting to SQL Server 2005

JDBC-ODBC - SQL Server and Driver Info

JDBC-ODBC - Setting Current Database

JDBC-ODBC - Looping through ResultSet

Additional Tutorial Notes to Be Added

References

PDF Printing Version