WDD_lec_14 - Design & Development Web Lec - 14 1 Design &...

Info iconThis preview shows pages 1–12. Sign up to view the full content.

View Full Document Right Arrow Icon
1 Web Lec - 14
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2 Web Java Database Connectivity (JDBC)
Background image of page 2
JDBC 3 Umair Javed©2005 Agenda Overview of JDBC technology JDBC drivers Seven basic steps in using JDBC Example of Retrieving data from ResultSet Example of Executing DML statements Using prepared Statement
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
JDBC 4 Umair Javed©2005 JDBC Introduction JDBC provides a standard library for accessing relational databases API standardizes Way to establish connection to database Approach to initiate queries Method to create stored (parameterized) queries The data structure of query result (table) Determining the number of columns Looking up metadata, etc.
Background image of page 4
JDBC 5 Umair Javed©2005 JDBC Introduction API does not standardize SQL syntax JDBC is not embedded SQL JDBC classes located in java.sql package
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
JDBC 6 Umair Javed©2005 Connecting Microsoft Access Example Create PersonInfo database Create Person table
Background image of page 6
JDBC 7 Umair Javed©2005 Connecting MS Access Example: Setup System DSN settings ControlPanel AdministrativeTools data sources(ODBC)
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
8 Web Basic Steps in Using JDBC
Background image of page 8
JDBC 9 Umair Javed©2005 Basic Steps in Using JDBC 1. Import required packages 1. Load driver 1. Define Connection URL 1. Establish Connection 1. Create a Statement object
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
JDBC 10 Umair Javed©2005 Basic Steps in Using JDBC (cont.) 1. Execute query / DML 1. Process results 1. Close connection
Background image of page 10
11 Web JDBC Details of Process
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 12
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 07/01/2010 for the course CS CS506 taught by Professor mr. umair javed during the Spring '10 term at Virtual University of Pakistan.

Page1 / 27

WDD_lec_14 - Design & Development Web Lec - 14 1 Design &...

This preview shows document pages 1 - 12. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online