JDBC Pocket Reference : A Quick Guide for Programmers - Donald Bales

Instant online reading.
Don't wait for delivery!
Go digital and save!

JDBC Pocket Reference

A Quick Guide for Programmers

By: Donald Bales

Write A Review

4 February 2003

At a Glance

No. of Pages
152

Dimensions(cm)
17.15 x 10.8 x 1.27

RRP $18.90

$12.75

33%OFF

or 4 interest-free payments of $3.19 with

Ships in 15 to 25 business days

JDBC - the Java Database Connectivity specification - is a complex set of application programming interfaces (APIs) that developers need to understand if they want their Java applications to work with databases. JDBC is so complex that even the most experienced developers need to refresh their memories from time to time on specific methods and details. But, practically speaking, who wants to stop and thumb through a weighty tutorial volume each time a question arises? The answer is the JDBC Pocket Reference, a data-packed quick reference that is both a time-saver and a lifesaver. This reference offers quick look-ups for all methods of the standard JDBC classes. These include concise reviews of the procedures for common JDBC tasks such as connecting to a database, executing stored procedures, executing DDL and the like. You'll find documentation of the connect string formats for the most common databases, including Oracle, SQL-Server, and PostgreSQL. You'll even find information on working with large objects, and on using SQL 99 user defined datatypes to work with object-relational data. Searching for this sort of material through large tutorials is frustrating and a waste of time, but this pocket-sized book is easy to take anywhere and makes finding the information you need a snap.

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $89.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.

Defective items

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

You Can Find This Book In

Non-Fiction Computing & I.T.Computer Programming & Software Development Object-Oriented Programming or OOP Web Programming Databases Database Software Oracle Booktopia Publisher Services John Wiley & Sons Publishers UK

Introduction	p. 1
Import Statements	p. 3
JDBC Drivers	p. 4
Driver Types	p. 4
Database URLs	p. 5
Establishing a Connection	p. 10
Using DriverManager	p. 11
Using JNDI	p. 13
Examining DatabaseMetaData	p. 13
Executing Dynamic SQL	p. 14
Executing DDL	p. 14
Executing INSERT, UPDATE, or DELETE Statements	p. 15
Executing SELECT Statements	p. 16
Executing Precompiled SQL	p. 17
Executing a Stored Procedure	p. 19
Retrieving Query Results	p. 21
Navigating a Result Set	p. 22
Accessing Column Values	p. 23
Inserting, Updating, and Deleting Rows in a ResultSet	p. 24
Dynamically Determining Result Set Characteristics	p. 26
SQL/Java Data Type Mapping	p. 28
Handling NULL Values	p. 29
Detecting NULL Values with wasNull()	p. 29
Detecting NULL Values with BigDecimal	p. 30
Setting a Column to a NULL Value	p. 31
Batching Inserts and Updates	p. 31
Working with Large Objects	p. 33
Inserting a BLOB	p. 33
Retrieving a BLOB	p. 34
User-Defined Data Types	p. 36
Creating a Java Class for a UDT	p. 36
Updating a Type Map	p. 38
Inserting a UDT	p. 38
Selecting a UDT	p. 39
Row Sets	p. 40
Escape Syntax	p. 41
Transaction Management	p. 43
The JDBC API	p. 43
Table of Contents provided by Syndetics. All Rights Reserved.

JDBC Pocket Reference

A Quick Guide for Programmers

At a Glance

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Web Programming

Agentic Mesh

The Genai-Powered Autonomous Agent Ecosystem

Starting Out with Python

5th Global Edition

Beginner's Step-by-Step Coding Course

Learn Computer Programming the Easy Way

Fluent Python

Clear, Concise, and Effective Programming 2nd Edition

Python All-in-One For Dummies

3rd Edition

Web Engineering

Theory and Practice

Building Microservices

Designing Fine-Grained Systems 2nd Edition

Designing Data-Intensive Applications

The Big Ideas Behind Reliable, Scalable, and Maintainable Systems

Coding For Dummies, All New Edition

For Dummies (Computer/Tech)

Head First Design Patterns

Building Extensible and Maintainable Object-Oriented Software 2nd Edition

Flask Web Development, 2nd Edition

Developing Web Applications with Python

PHP, MySQL, & JavaScript All-In-One For Dummies

For Dummies

Cloud Computing

2nd Edition - Concepts, Technology, Security, and Architecture

Coding All-in-One For Dummies

2nd Edition

Java

An Introduction to Problem Solving and Programming, 8th Global Edition

Introduction to Machine Learning with Python

A Guide for Data Scientists

Web Application Security

2nd Eidtion - Exploitation and Countermeasures for Modern Web Applications

Web Scraping with Python

3rd Edition - Data Extraction from the Modern Web

Apache Iceberg: The Definitive Guide

Data Lakehouse Functionality, Performance, and Scalability on the Data Lake

Laravel: Up & Running

3rd Edition - A Framework for Building Modern PHP Apps

Go Cookbook

Expert Solutions for Commonly Needed Go Tasks

Typescript Cookbook

Real World Type-Level Programming

Computer Coding Python Games for Kids

DK Help Your Kids With

Beginner's Step-by-Step Coding Course

Learn Computer Programming the Easy Way

This product is categorised by