JDBC: Practical Guide for Java Programmers (The Practical Guides) [Paperback]

Gregory D. Speegle (Author)

Book Description

ISBN-10: 1558607366 | ISBN-13: 978-1558607361 | Publication Date: September 14, 2001 | Edition: 1

JDBC: Practical Guide for Java Programmers is the quickest way to gain the skills required for connecting your Java application to a SQL database. Practical, tutorial-based coverage keeps you focused on the essential tasks and techniques, and incisive explanations cement your understanding of the API features you'll use again and again. No other resource presents so concisely or so effectively the exact material you need to get up and running with JDBC right away.

* Provides tutorial-based instruction in key JDBC techniques, complemented by example code.
* Centered around an incrementally developed example of a three-tiered application for a video rental e-commerce site.
* Designed to help you tackle standard JDBC tasks: connecting your database to the Internet, displaying query results, using stored procedures, updating the database, storing metadata, carrying out transactions, working with binary large objects, implementing security, and more.
* Via the companion Web site, provides code for the examples, tools for loading the example database, links to useful JDBC sites, and a forum in which to interact with other readers.

Editorial Reviews

Amazon.com Review

Ideal for any Java programmer trying to master JDBC database programming in a hurry, the remarkably concise and useful JDBC: Practical Guide for Java Programmers offers an example-based quick tour of essential APIs and techniques that you can use every day at your desk.

Weighing in at just over 100 pages, this text bucks the trend in today's computing titles in terms of size and focus. Instead of trying to cover everything about Java, this text zeros in on essential JDBC concepts and APIs. An experienced teacher, the author presents his own "framework" for connecting to databases in Java. Short, essential examples and compact explanation are the rule here.

From the basics of querying and updating databases to more advanced techniques like using prepared statements, updated result sets, and batch updates, the author's choice of examples is dead-on. Even experienced Java programmers can use this text as a reference to crucial advanced techniques. Standout material here includes using the Swing JTable table control to present multiple records, and a quick tour of servlet APIs. The book closes with a "case study" for an online video store combining the techniques presented early on.

With an extremely compact format and a no-frills approach to essential JDBC APIs and techniques, this text will serve as a reference and tutorial that can get you started with JDBC perhaps more quickly than any other available title. It's particularly well suited to those programmers who want to learn by example. Though small in size, it manages to cover several advanced features of JDBC that would require a lot of digging in a traditional Java tutorial. --Richard Dragan

Topics covered: Introduction and overview of JDBC; review of CGI and Java alternatives; basic database tables; JDBC connections and statements; using Swing JTables to present information; JDBC ResultSets; database queries (including prepared and callable statements); action queries and updates; batch updates and writeable ResultSets; types of JDBC drivers; metadata; programming BLOB fields; case study for a database using servlets for an online video store; sample code; essential JDBC APIs; and introduction of the JDBC 3.0 standard.

Review

"A highly useful reference for students, educators, and professionals alike, who are learning to use JAVA and JDBC for interconnecting and using databases. The real world analogies and JDBC examples presented throughout the text direct the reader to the essential elements required to make the Java database connection function seamlessly within a user's application. I found the book easy to read, informative, and a great addition to standard course texts."
—Dr. Paul J. Fortier, University of Massachusetts--Dartmouth

See all Editorial Reviews

Product Details

• Paperback: 120 pages
• Publisher: Morgan Kaufmann; 1 edition (September 14, 2001)
• Language: English
• ISBN-10: 1558607366
• ISBN-13: 978-1558607361
• Product Dimensions: 9.1 x 7.5 x 0.2 inches
• Shipping Weight: 8.8 ounces (View shipping rates and policies)
• Average Customer Review: 3.3 out of 5 stars  See all reviews (3 customer reviews)
• Amazon Best Sellers Rank: #408,386 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

2 of 2 people found the following review helpful:

2.0 out of 5 stars Practical Guide but NOT for Java Programmers, January 19, 2005

By 

J. Smith "Java Smith" (Grand Rapids, MI) - See all my reviews
(REAL NAME)   

This review is from: JDBC: Practical Guide for Java Programmers (The Practical Guides) (Paperback)

I have to disagree with the title. As an experienced programmer I found the book to be nearly useless. It's well written and gives a quick overview of JDBC, but if you plan to actually develop using JDBC, you're going to need much more. I might recommend this for students or managers needing to know what JDBC is or when to use it, but not for learning how to use it.

1 of 1 people found the following review helpful:

3.0 out of 5 stars Good intro to Java API with examples, January 29, 2005

By 

Mark Geek Twain (Minnesota) - See all my reviews

Amazon Verified Purchase

This review is from: JDBC: Practical Guide for Java Programmers (The Practical Guides) (Paperback)

This is a good intro to selecting one or several records or updating one or several records using the JDBC api, with examples in Java. He also provides actual java classes based on the java api, but I didn't find his classes very reusable - I don't think it was very good OO design, just good JDBC examples. I bought the book to get some source code that I could re-use, but it was just too terse. Now that I am learning Design Patterns, I might look at his code again, with the idea of rewriting it. Most people are better of learning Hibernate.

5.0 out of 5 stars Great little book on JDBC, December 31, 2001

By A Customer

This review is from: JDBC: Practical Guide for Java Programmers (The Practical Guides) (Paperback)

I found this book to be an excellent book on JDBC. It is packed with very practical code for accessing databases. The examples "build" upon themselves using classes which inherit from previously created classes. This was extremely insightful in building code which uses a true object oriented approach ( with the added benefit of making the entire book fit together in a logical manner.) I recommend it highly. Well done Greg.