Jdbc Developer's Resource: Database Programming on the Internet (Prentice Hall Ptr Developer's Resource Series) [Paperback]

Art Taylor (Author)

Book Description

Publication Date: April 1997 | Series: Prentice Hall Ptr Developer's Resource Series

84235-1 Write JavaaA A code that leverages all your corporate data resources-with JDBC and The JDBC Developer's Resource. If you need to build Java applications that use existing corporate data, you deserve the best JDBC tutorial and reference available: The JDBC Developer's Resource. For programmers familiar with Java, this book/CD-ROM package offers comprehensive coverage of Sun's Java Database Connectivity (JDBC) API-and provides complete tools for making the most of JDBC. Learn all the fundamentals you need to know, including JDBC's interface, methods, and relationship to ODBC. Then, using extensive code examples, discover how to use JDBC in a wide range of applications, in both two-tiered and three-tiered environments. An extensive tutorial walks you through every step of developing numerous sample applications, demonstrating virtually all the techniques you need to know to program JDBC applications. Examples range from the development of simple JDBC applications to connect to a database and retrieve data, to the creation of a three-tiered RMI program with an applet that makes remote calls to object methods on a server using Java's RMI interface.As you become familiar with JDBC, you'll depend on The JDBC Developer's Resource even more. Its exclusive "Quick Reference" describes all JDBC methods, the classes they belong to, and the parameters passed to them. A more detailed reference presents every class, its methods and variables, with code samples. The accompanying CD-ROM contains indispensable tools for JDBC and Java software development, including: *A trial version of the exciting new Mojo Java applet development environment. *The complete Java RMI and JDBC API. *Intersolv's DataDirect ODBC Pack for Microsoft WindowsA (R) 95. *Sun's complete Java Developer's Kit 1.02. *Complete source code for all the books applets and applications. With The JDBC Developer's Resource, you've got everything you need to combine Java's unprecedented capabilities with your organization's massive data resources. Now that's power.

Editorial Reviews

Amazon.com Review

For every computer subject, there must be a large, shelf-straining tome that attempts to cover everything about the subject and more. JDBC Developer's Resource fills that niche for JDBC. Taylor's book opens with information about the Java language, including the now-hackneyed story of the language's development and a comparison to C and C++. Then, there's a valuable chapter for programmers who haven't done database work before that explains in clear terms how relational databases work. After a glancing introduction to the JDBC application programming interface (API), the author walks the reader through the creation of all the critical elements of a JDBC application, including inserts, deletes, and updates. He covers the applet-specific implications of JDBC and explores three-tiered databases. The entire second half of JDBC Developer's Resource is given over to a full JDBC API reference.

All the sample applications appear on the companion CD-ROM, along with some driver software. One drawback is that code listings and some sidebars appear on gray fields and are somewhat hard to read. The author also consistently refers to the "Java SDK," rather than the proper "JDK."

From the Inside Flap

Introduction The Java Language and JDBC Since its inception in 1995, the Java language has generated intense interest in the computer industry. The Java Database Connectivity (JDBC) standard adds a whole new dimension to this capable and multi-faceted language. Rather than simply being used to “bring life to Web pages,” Java with JDBC can now fill the role of database-aware applications for a variety of application needs. Where currently common gateway interface (CGI) applications are required to access databases from within Web browsers, Java applets with JDBC now have the potential to provide this functionality with more direct programming and the potential for improved performance. Using this API, you can now use Java applications for standard database programming tasks such as reports or updates. With JAVA's flexible network API, you can use Java/JDBC applications for filter programs, to read data from a data stream, and to provide conversion facilities before updating a database. Java applications written using JDBC are portable both for the hardware platform and the database. You can run a correctly written Java/JDBC program on a variety of platforms against a variety of databases without any code changes. This is possible because JDBC is based on ODBC, which is in turn based on the X/Open CLI specification. The goals of the X/Open group have been met to the extent that database access standards have been accepted by the industry. Access to all major databases is available through ODBC. And JDBC-ODBC bridges are available to provide database access by mapping JDBC calls to their corresponding ODBC calls. Thus, any database that is accessible with an ODBC driver is also accessible with a Java/JDBC driver using the JDBC-ODBC bridge. JDBC uses the industry standard Structured Query Language (SQL) to communicate with the database. Writing a JDBC application, therefore, requires knowledge of both the Java language and SQL. To provide a refresher, this book includes sections on both of these languages. These chapters are intended to help those who have had moderate exposure to these languages. For those with no experience in SQL, additional training is recommended. About This Book This book is designed to provide you with a thorough grounding in the JDBC API. It is divided into two parts: a tutorial and a reference. The tutorial part provides a primer on the Java language and relational databases. This is followed by a set of examples that demonstrate the process of programming database applications using JDBC. This part begins with simple examples and then progresses into more complex applications. The reference part provides several listings of the methods available in JDBC. A brief, quick reference of the methods is provided, followed by a more detailed description of the methods arranged by JDBC interfaces. Target Audience If you use Java and have a need to perform database access, then this book is for you. This book presumes the reader is an experienced programmer, but not necessarily a Java programmer. This book is designed to be a useful resource for both the experienced and inexperienced Java programmer. A programmer just learning the Java language will find the JDBC library is similar in design to the other Java libraries and just as easy to use. This book will provide the guidance and the code samples to easily complete a JDBC application. Java has intentionally been designed with a syntax similar to C/C++, so a programmer familiar with either of these languages will be able to use Java. And a programmer familiar with object-oriented concepts will be comfortable with JDBC and it's object-oriented design. If you are one of those individuals very familiar with C but with moderate exposure to C++ or Java, then this book provides a Java overview to present some of the more important Java concepts. Having read these sections, an experienced programmer will have no problem understanding the numerous code samples presented in this book. Resource This book is designed to be both a tutorial and a reference combined into a single book: a complete “developer's resource.” As a reference book, a quick reference section contains all methods in the class library and a short description of the method. A second reference section lists all JDBC interface descriptions and provides a code sample for virtually all JDBC methods. This book is designed to be a complete JDBC resource. A tutorial section is provided to demonstrate how to use JDBC with Java. With the belief that a good code sample is worth a 1000 words, numerous code samples provide a “picture” of how to access data using JDBC. A complete reference section is also included. The entire JDBC class library is covered with code samples provided for most of the methods. An experienced programmer with solid Java experience could read the sections of the tutorial that cover basic JDBC programming, use the reference section as needed, and quickly develop a working JDBC application. A less-experienced Java programmer could read the Java primer section and the tutorial section, and then use the reference section as a reference to develop a JDBC application. Conventions Used in This Book You'll notice as you read this book that there are several conventions used to help make especially useful material easier to read and to locate when you're using this book as a reference during your programming sessions. Source Code All code fragments and listings that have been set off from the main text of this book have been formatted in the following way: ... StringBuffer DTString = “The answer is ”; int num = 42; DTString = DTString + num; System.out.println( DTString ); ... As well, coding terms that appear within the main text have been set in a special font for easier reference, like so: “The Java language eliminates this difficulty by extending the capabilities of the continue and break statements.” Icons Oftentimes, there is information that deserves special attention because it highlights a particularly useful or important point that might otherwise get lost among all of the other important information in the main text. For this reason, a number of special icons have been created to help this information stand out. About the CD Several useful tools and programming examples are provided on the CD-ROM enclosed with the book. The tools are as follows:

The Java JDK, an essential part of any JDBC development effort, is provided.

The JDBC-ODBC bridge from SunSoft.

INTERSOLV DataDirect ODBC Pack for Windows 95/Windows NT.

The Mojo Visual Java Development Environment for Windows 95. Also provided are the majority of the programming examples used in this book. Wherever a program is referenced with a program name, that program is available on the CD-ROM. A special Web page has been created as a front-end to navigating the CD-ROM included with this book. To access that Web page, please load the file named index.html, found in the root directory of the CD-ROM, into your browser. The directory locations of the programs and instructions on running the various applications are accessible from this Web page. Also included on this Web page are links to various JDBC-related sites, as well as the online supplement to this book, explained in the following section. The combination of the JDBC-ODBC bridge and the Intersolv DataDirect ODBC drivers allow JDBC applications to be developed under the Windows 95 environment. ODBC drivers are provided for a number of databases, including MicroSoft Access. The Mojo Visual Java Development Environment is a robust development environment that provides a window painter and class browser with the ability to drop pre-developed modules directly into the applet being developed. Directions and online help are provided on the CD-ROM. About the Web Site Finally, this and every book in the Developer's Resource Series is accompanied by a special online Web supplement created especially for each book. Changes to JDBC for JDK 1.1 With the release of version 1.1 of the JDK, JDBC will be part of the core Java API. As part of this merge effort, several minor changes have been made to JDBC. These changes are not, unfortunately, backward compatible. They are as follows: The java.sql.Numeric class has been renamed java.lang.Bignum. The Connection class auto close mode has been removed from JDBC. This has the impact of removing the setAutoClose and getAutoClose methods from the Connection class. The code samples that appear in this book have been developed with JDK version 1.02. The Numeric class and the setAutoClose method of the Connection class have not been used in any of the examples so it is reasonable to expect that this code could be recompiled and run under JDK version 1.1 with little or no modification. But this would require the use of a different version of the JDBC-ODBC bridge and ODBC driver than is included on the CD-ROM. The reference section of this book does not contain a reference for the setAutoClose and getAutoClose methods of the Connection class. The reference section for the Numeric class, however, has not been renamed to BigDecimal. As this book goes to press, the JDK version 1.1 has not yet been released and it is possible that this class may be given another name. The reader should be aware that the Numeric class referenced in this text will carry another name in the final release of the Java 1.1 JDK. Note that the methods for the Numeric class will remain the same, having the same name and signature, only the class name will change. Acknowledgments I would like to acknowledge the contributions of the following individual: Zia Kahn at XenoSys, a true Java evangelist, for the excellent three-tier RMI application demo; Shekhar Kirani, for a perceptive technical review; and Mark Hapner at SunSoft, for consistently speedy responses to my technical queries.

See all Editorial Reviews

Product Details

• Paperback: 730 pages
• Publisher: Prentice Hall Ptr; Bk&CD-Rom edition (April 1997)
• Language: English
• ISBN-10: 0138423520
• ISBN-13: 978-0138423520
• Product Dimensions: 9.2 x 7 x 1.2 inches
• Shipping Weight: 2.5 pounds
• Average Customer Review: 3.0 out of 5 stars  See all reviews (8 customer reviews)
• Amazon Best Sellers Rank: #5,531,655 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:

4.0 out of 5 stars Good for starting JDBC, December 4, 1997

By 

[e-mail] (Colorado Springs, Colorado) - See all my reviews

This review is from: Jdbc Developer's Resource: Database Programming on the Internet (Prentice Hall Ptr Developer's Resource Series) (Paperback)

This book steps you through the JDBC API. This is not a book for an expert, but gives you a stepping stone into the relm of java database programming. This book also touches on points to watch out for and sometimes offers workarounds. The book also offers an explanation section and then a seperate reference section which allows you to get to the meat.

2 of 3 people found the following review helpful:

2.0 out of 5 stars Sloppy, very SLoppy...., June 14, 2001

By 

Keith Kwiatek (Washington DC) - See all my reviews

This review is from: JDBC Developer's Resource (2nd Edition) (Paperback)

Tons of garbarge examples that don't even make sense....I will let the horse speak:

int getColumnType(int column)

String colTypeName = rsmd.getColumTypeName(1);

4.0 out of 5 stars For a beginner, July 20, 2001

By 

Michael Pucciarelli (Rockville, MD United States) - See all my reviews

This review is from: JDBC Developer's Resource (2nd Edition) (Paperback)

This book is good for a beginner. I read this book and it helped me tremondously. This book would not be good for the experienced beginner. The code is easy to follow; although some could have been written better. It is a good reference. -- Not the best I have read.