JDBC(TM) API Tutorial and Reference (3rd Edition) (The Java Series)

JDBC(TM) API Tutorial and Reference (3rd Edition) (The Java Series)
by Maydene Fisher, Jon Ellis, Jonathan Bruce

JDBC(TM) API Tutorial and Reference (3rd Edition) (The Java Series)
List Price: $64.99
Our Price: $44.52
You Save: $20.47 (31%)
Availability: Usually ships in 1-2 business days
Category: Book
See more book details and other editions


(Click here)
Buy this book at online book store in your country
Canada | UK | Germany | France

Book Summary Information

Author: Jon Ellis, Jonathan Bruce, Maydene Fisher
Edition: Paperback
Published: 2003-06-21
ISBN: 0321173848
Number of pages: 1280
Publisher: Prentice Hall PTR

Book Reviews of JDBC(TM) API Tutorial and Reference (3rd Edition) (The Java Series)

Book Review: A Must For Your Bookshelf!
Summary: 5 Stars

What can I say... if you do JDBC programming, you must have this book in your bookshelf. Great examples and super coverage of a very wide topic. You'll read it and continue to look back at it. Well worth the money!

Summary of JDBC(TM) API Tutorial and Reference (3rd Edition) (The Java Series)

This book provides the definitive description of the JDBC(tm) API, the technology that enables universal data access for the Java(tm) programming language. This new edition has been updated and expanded to cover all of the JDBC 2.0 API, including the JDBC 2.0 core API and the JDBC Standard Extension API, the package that facilitates building server-side applications.

Containing in-depth explanations that go beyond the specification, this complete resource pairs a step-by-step tutorial with a comprehensive reference to all of the classes and interfaces.

For those new to Java technology, the book includes an introduction to the Java programming language and to SQL. It builds on this basic knowledge to walk you through creating a JDBC application-from setting up a database and establishing a connection to retrieving values from result sets and using prepared statements. In addition, the authors provide many examples along the way that demonstrate how to execute common tasks. The book proceeds to more advanced topics, focusing on the new features of the JDBC 2.0 API, including scrollable and updatable result sets, batch updates, SQL3 data types, custom mapping, and more.

You will also find an introduction to working with the JDBC metadata API as well as information on rowsets, the technology that makes it possible to handle data sets from virtually any data source as JavaBeans(tm) components.

From array to XADataSource, a useful alphabetical reference provides concise but complete information on each class and interface in the JDBC API. Each entry includes an overview as well as a list and explanation of the methods and fields.

A chapter on mapping SQL types and types in the Java programming language, a summary of the new JDBC 2.0 features, and a glossary complete this indispensable resource for all database programmers.


The second edition of the JDBC API Tutorial and Reference provides a worthwhile tour of the new features in Java Database Connectivity (JDBC) 2.0 and serves well as a reference to Sun's new standard for Java database programming.

Once you open this book, it becomes quickly obvious that it is more comprehensive than the first edition. The new edition begins with an overview of the JDBC API, including its architecture and overall design. Beginners will also be pleased with a short breakdown of the Java programming language and SQL basics.

Early sections of the book walk through an approachable tutorial of JDBC, concentrating on topics such as connecting to databases, retrieving result sets, manipulating records, and handling database transactions. There's also coverage of using stored procedures, including embedded SQL with SQLJ.

The book then turns to new JDBC 2.0 API features, like scrollable cursors, updateable record sets, and batch updates. Experienced readers will appreciate how the authors show off JDBC 1.0 code before presenting these new features. An explanation of SQL3 data types supported in JDBC 2.0 follow the discussion of the API features.

The book provides extensive support for finding and understanding recordsets and databases, including the use of the oddly named ResultSetMetaData and DatabaseMetaData classes, which have been greatly enhanced in JDBC 2.0. (You can now write Java code that customizes itself at runtime for almost any SQL platform.) Similar in spirit to the Microsoft OLE DB, the new JDBC 2.0 now supports rowsets, which let programmers work with any tabular data store from within their applications.

Most of the book (over 600 pages) functions as a reference containing every JDBC 2.0 class. Presented alphabetically, each class comes with an introductory definition and a complete listing of its constituent members and methods (including deprecated APIs). Final sections include a guide to "SQL to Java" mappings and tips for writing JDBC drivers.

Whether you are approaching JDBC for the very first time or are ramping up from JDBC 1.0, there is perhaps no better source for learning about the enhanced powers of the new JDBC than this "official" guide from Sun. --Richard Dragan

General Books

Book Subjects
Most talked about in Java J2SE classics
Design Patterns Explained: A New Perspective on Object-Oriented Design (2nd Edition) (Software Patterns Series) ImageDesign Patterns Explained: A New Perspective on Object-Oriented Design (2nd Edition) (Software Patterns Series)
by Alan Shalloway, James Trott
Addison-Wesley Professional; Published: 2004-10-22; Paperback; Book
Best price: $30.65
Price in other shops: $49.99
SCJP Sun Certified Programmer for Java 5 Practice Exams (Exam 310-055) (Certification Press) ImageSCJP Sun Certified Programmer for Java 5 Practice Exams (Exam 310-055) (Certification Press)
by Katherine Sierra, Bert Bates
McGraw-Hill Osborne Media; Published: 2008-01-29; Paperback; Book
Price in other shops: $39.99
SCJP Sun Certified Programmer for Java 5 Study Guide (Exam 310-055) (Certification Press Study Guides) ImageSCJP Sun Certified Programmer for Java 5 Study Guide (Exam 310-055) (Certification Press Study Guides)
by Katherine Sierra, Bert Bates
McGraw-Hill Osborne Media; Published: 2005-12-21; Paperback; Book
Best price: $22.50
Price in other shops: $49.99
Java(TM) Puzzlers: Traps, Pitfalls, and Corner Cases ImageJava(TM) Puzzlers: Traps, Pitfalls, and Corner Cases
by Joshua Bloch, Neal Gafter
Addison-Wesley Professional; Published: 2005-07-04; Paperback; Book
Best price: $27.71
Price in other shops: $39.99
Java Swing, Second Edition ImageJava Swing, Second Edition
by James Elliott, Marc Loy, David Wood, Brian Cole
O'Reilly Media, Inc.; Published: 2002-11-01; Paperback; Book
Best price: $21.63
Price in other shops: $59.99
JDBC(TM) API Tutorial and Reference (3rd Edition) (The Java Series) ImageJDBC(TM) API Tutorial and Reference (3rd Edition) (The Java Series)
by Maydene Fisher, Jon Ellis, Jonathan Bruce
Prentice Hall PTR; Published: 2003-06-21; Paperback; Book
Best price: $39.99
Price in other shops: $64.99
Concurrent Programming in Java(TM): Design Principles and Pattern (2nd Edition) (The Java Series) ImageConcurrent Programming in Java(TM): Design Principles and Pattern (2nd Edition) (The Java Series)
by Doug Lea
Prentice Hall PTR; Published: 1999-11-04; Paperback; Book
Best price: $38.99
Price in other shops: $64.99
Java Concurrency in Practice ImageJava Concurrency in Practice
by Brian Goetz, Tim Peierls, Joshua Bloch, Joseph Bowbeer, David Holmes, Doug Lea
Addison-Wesley Professional; Published: 2006-05-19; Paperback; Book
Best price: $32.81
Price in other shops: $54.99
Effective Java (2nd Edition) (The Java Series) ImageEffective Java (2nd Edition) (The Java Series)
by Joshua Bloch
Prentice Hall PTR; Published: 2008-05-28; Paperback; Book
Best price: $34.81
Price in other shops: $49.99
Java(TM) Programming Language, The (4th Edition) (The Java Series) ImageJava(TM) Programming Language, The (4th Edition) (The Java Series)
by Ken Arnold, James Gosling, David Holmes
Prentice Hall PTR; Published: 2005-08-27; Paperback; Book
Best price: $39.98
Price in other shops: $54.99
Similar Books and other products
Head First Java, 2nd Edition ImageHead First Java, 2nd Edition
by Kathy Sierra, Bert Bates
O'Reilly Media, Inc.; Published: 2005-02-09; Paperback; Book
Best price: $24.65
Price in other shops: $44.95
Filthy Rich Clients: Developing Animated and Graphical Effects for Desktop Java Applications (The Java Series) ImageFilthy Rich Clients: Developing Animated and Graphical Effects for Desktop Java Applications (The Java Series)
by Chet Haase, Romain Guy
Prentice Hall PTR; Published: 2007-08-19; Paperback; Book
Best price: $29.91
Price in other shops: $49.99
Core JavaServer(TM) Faces (2nd Edition) (Sun Core Series) ImageCore JavaServer(TM) Faces (2nd Edition) (Sun Core Series)
by David Geary, Cay S. Horstmann
Prentice Hall PTR; Published: 2007-05-19; Paperback; Book
Best price: $32.12
Price in other shops: $54.99
JavaScript Definitive Guide ImageJavaScript Definitive Guide
by David Flanagan
O'Reilly; Published: 1998-07-15; Paperback; Book
Best price: $9.38
Price in other shops: $39.95
Java Persistence with Hibernate ImageJava Persistence with Hibernate
by Christian Bauer, Gavin King
Manning Publications; Published: 2006-11-24; Paperback; Book
Best price: $32.04
Price in other shops: $59.99
Enterprise JavaBeans ImageEnterprise JavaBeans
by Richard Monson-Haefel
Published: 1999-05-31; Paperback; Book
Best price: $13.36
Price in other shops: $34.95
Java(TM) EE 5 Tutorial, The (3rd Edition) (The Java Series) ImageJava(TM) EE 5 Tutorial, The (3rd Edition) (The Java Series)
by Eric Jendrock, Jennifer Ball, Debbie Carson, Ian Evans, Scott Fordin, Kim Haase
Prentice Hall PTR; Published: 2006-11-13; Paperback; Book
Best price: $31.99
Price in other shops: $59.99
The Java Tutorial: A Short Course on the Basics, 4th Edition (The Java Series) ImageThe Java Tutorial: A Short Course on the Basics, 4th Edition (The Java Series)
by Sharon Zakhour, Scott Hommel, Jacob Royal, Isaac Rabinovitch, Tom Risser, Mark Hoeber
Prentice Hall PTR; Published: 2006-10-09; Paperback; Book
Best price: $25.99
Price in other shops: $49.99
The JFC Swing Tutorial: A Guide to Constructing GUIs (2nd Edition) (The Java Series) ImageThe JFC Swing Tutorial: A Guide to Constructing GUIs (2nd Edition) (The Java Series)
by Kathy Walrath, Mary Campione, Alison Huml, Sharon Zakhour
Prentice Hall PTR; Published: 2004-03-05; Paperback; Book
Best price: $32.94
Price in other shops: $54.99
Java Concurrency in Practice ImageJava Concurrency in Practice
by Brian Goetz, Tim Peierls, Joshua Bloch, Joseph Bowbeer, David Holmes, Doug Lea
Addison-Wesley Professional; Published: 2006-05-19; Paperback; Book
Best price: $32.81
Price in other shops: $54.99
Book store. Illustrated catalog of books on different categories