Industrial-Sized Deals TextBTS15 Shop Women's Handbags Learn more nav_sap_plcc_6M_fly_beacon $5 Albums Fire TV Stick Shop Popular Services tmnt tmnt tmnt  Amazon Echo Starting at $99 Kindle Voyage Disney Infinity 3.0 Shop Back to School with Amazon Back to School with Amazon Outdoor Recreation Deal of the Day

JDBC¿ API Tutorial and Reference (3rd Edition) 3rd Edition

23 customer reviews
ISBN-13: 978-0321173843
ISBN-10: 0321173848
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Sell yours for a Gift Card
We'll buy it for $4.37
Learn More
Trade in now
Have one to sell? Sell on Amazon
Buy used
$24.99
Buy new
$46.90
More Buying Choices
17 New from $29.47 19 Used from $18.56
Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


InterDesign Brand Store Awareness Textbooks
$46.90 FREE Shipping. Only 3 left in stock (more on the way). Ships from and sold by Amazon.com. Gift-wrap available.

Frequently Bought Together

JDBC¿ API Tutorial and Reference (3rd Edition) + Database Programming with JDBC & Java (Java (O'Reilly)) + Java Database Best Practices
Price for all three: $119.73

Buy the selected items together

Special Offers and Product Promotions

Editorial Reviews

Amazon.com Review

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 --This text refers to an out of print or unavailable edition of this title.

From the Back Cover

This book provides the definitive tutorial and reference to the JDBC™ API, the technology that enables universal data access for the Java™ programming language. This new edition has been updated and expanded to cover the entire JDBC 3.0 API, including the java.sql package and the javax.sql package, 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 every class and interface.

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 the creation of 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 then turns to more advanced topics, focusing on features such as scrollable and updatable result sets, batch updates, SQL99 data types, custom mapping, savepoints, statement pooling, automatically generated keys, and more.

In addition to in-depth coverage of the JDBC metadata API, the book gives you the latest information on rowsets, the technology that makes it possible to handle data sets as JavaBeans™ components. As an added bonus, you get a preview of the standard implementations for JdbcRowSet, CachedRowSet, WebRowSet, JoinRowSet, and FilteredRowSet objects.

From Array to XADataSource, an easy-to-use alphabetical reference provides concise but complete information on each class and interface in the JDBC API. Each entry includes an overview with usage examples as well as a comprehensive explanation of the methods and fields.

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

The Java™ Series is supported, endorsed, and authored by the creators of the Java technology at Sun Microsystems, Inc. It is the official place to go for complete, expert, and definitive information on Java technology. The books in this Series provide the inside information you need to build effective, robust, and portable applications and applets. The Series is an indispensable resource for anyone targeting the Java™ 2 platform.



0321173848B05222003

See all Editorial Reviews
NO_CONTENT_IN_FEATURE


Best Books of the Month
Best Books of the Month
Want to know our Editors' picks for the best books of the month? Browse Best Books of the Month, featuring our favorite new books in more than a dozen categories.

Product Details

  • Paperback: 1280 pages
  • Publisher: Addison-Wesley Professional; 3 edition (June 21, 2003)
  • Language: English
  • ISBN-10: 0321173848
  • ISBN-13: 978-0321173843
  • Product Dimensions: 7.3 x 2.5 x 9 inches
  • Shipping Weight: 4.2 pounds (View shipping rates and policies)
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (23 customer reviews)
  • Amazon Best Sellers Rank: #1,355,600 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

26 of 26 people found the following review helpful By A Customer on September 28, 1999
Format: Paperback
The full database connectivity and usage of the Java language is covered. With excellent code samples that appeal to all levels of programmers. I have used it to develope an inhouse delivery system and I am not a professional programmer. Very up to date with coverage of all the latest features of the API and what is due soon. EXCELLENT.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
21 of 22 people found the following review helpful By A Customer on September 14, 1999
Format: Paperback
Despite the complexity of JDBC in general, this book gives it to you in a clear, concise format that even a first time programmer would understand.
Although this book provides coverage of SQL and Java, it wouldn't hurt to familiarize yourself with them before picking this book up.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
24 of 28 people found the following review helpful By A Customer on September 28, 1999
Format: Paperback
This book provides a lot of valuable background information and is complementary to the JDBC specification. This is a "must have" if you want to know more about the more complex topics of JDBC like scrollable result sets, datasources, connection pooling, etc.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
12 of 13 people found the following review helpful By A Customer on September 6, 2000
Format: Paperback
If you look for a good book on JDBC 2.0, this is "the" book. The book is complete, in fact, it covers both jdbc1.0 and 2.0. All topics are explained expertly with style and depth, and in a very accesible way so that beginners can understand. All the codes are clearly written to prove all the main points discussed in the book. This book is the best both for learning jdbc and a reference.
Since not all the features in JDBC2.0 have been adopted by vendors, this book will remain as "the" reference for many years to come.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
9 of 11 people found the following review helpful By A Customer on September 27, 1999
Format: Paperback
This book provides an excellent tutorial on JDBC 2.0 core features and standard extensions. In particular, the chapters on standard extensions (XA, connection pooling,...) provide unique step-by-step descriptions/examples that offer a top-down view of these features.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
7 of 9 people found the following review helpful By uniq on November 10, 2003
Format: Paperback
JDBC is one of the most mature and widely used Java APIs. Even after the arrival of more recent tools and technologies like EJB's CMP and JDO, JDBC still remains a simple, fast, and reliable way of storing objects' state in an RDBMS. While conceptually this technology is quite straightforward, its evolution has made it more complex and voluminous. Many books have been trying to explain the main aspects of it over and over again, but the 3rd edition of "JDBC API Tutorial and Reference" goes far beyond that.

The book is divided into two major sections: the Tutorial and the Reference. Actually, there are four tutorials in the Part One: Basic, Advanced, MetaData, and Rowset. Here well-written explanations are followed by clear and detailed examples.

It is remarkable that Part Two, The Reference, is not your typical API reference with simply method signatures or redundant explanations of their arguments. This is an extremely well thought through description of how to use JDBC 3.0 API to achieve a particular goal. Every class has a solid overview, examples, schemas -- everything one needs to get the job done. The book also contains an Appendix for JDBC driver developers and another Appendix covering JDBC 3.0 API changes.

This book provides the most clear and comprehensive JDBC coverage that I have ever seen. It is not just a matter of its size of over 1200 pages, but although the result of a well designed book structure and clear delivery.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 3 people found the following review helpful By Shahram Khorsand on June 25, 2003
Format: Paperback Verified Purchase
If you are an experienced or intermediate programmer this is the only book you will need. Almost every bit of the JDBC is explaind. The API in the second part of the book is also very good, it is filled with explanations that the javadoc lacks.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 2 people found the following review helpful By Rosalba Scott on December 4, 2004
Format: Paperback
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!
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Recent Customer Reviews

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
JDBC¿ API Tutorial and Reference (3rd Edition)
This item: JDBC¿ API Tutorial and Reference (3rd Edition)
Price: $46.90
Ships from and sold by Amazon.com

Want to discover more products? Check out this page to see more: fashion design software