Java Database Programming with JDBC

Java Database Programming with JDBC
by George Reese

Download Book

If you are the author or the publisher, and would like to link to your site here, please contact us.

About Book

Amazon.com
The Java Database Connectivity classes (JDBC) sensibly provide an interface between a platform-independent programming language (Java) and a standardized database language (Structured Query Language, or SQL). Pretty much every Java program that's involved in transactions or other business operations connects to a database through JDBC; so, familiarity with the JDBC classes can magnify your other Java skills. Database Programming with JDBC and Java explains how JDBC fits into unitized software applications in which various functional parts communicate over a network. Author George Reese also shows how to write programs that take advantage of the JDBC classes, emphasizing the most commonly used ones (such as those that perform INSERT and SELECT operations), but giving also the more obscure classes their due.

This book is essentially an ongoing lecture of increasing complexity. To cite one thread, it begins with clear but academic examples that involve discrete transactions (opening a connection, performing a query, and closing the connection). It then moves on to connection pooling and other JDBC-supported optimizations for the real world. A menagerie of specialized sections on such topics as security and persistence rely heavily on long code examples. A section on Swing programming seems kind of out of place, but it's short. In sum, this slim volume is a great introduction to JDBC for those who are looking to approach Java distributed applications by way of database work.

Punk music fans, however, will object to the misidentification of the Sex Pistols' classic album Never Mind the Bollocks, Here's the Sex Pistols. It's actually Never Mind the Bullocks, Here Come the Sex Pistols. Rotten fact-checking, obviously. --David Wall

Topics covered: The Java Database Connectivity (JDBC) classes, with emphasis on how JDBC code fits into distributed applications (so-called enterprise applications) that use Enterprise JavaBeans (EJBs) and Remote Method Invocation (RMI). Java Naming and Directory Interface (JNDI), serialization, persistence, security, and (especially) application design receive plenty of attention. Fully a quarter of this book is a reference (including statements of syntax and brief descriptions) to the JDBC Core API and the JDBC Optional Package classes.

From Library Journal
O'Reilly books are rarely for neophytes, but advanced users swear by them, and these will be no exception. Englander covers a hot Java subtopic for students, programmers, and professionals already familar with Java and object-oriented programming. He discusses events, event adapters, properties, persistence, java archive files, the BeanBox tool, property editors, ActiveX, and the java.beans Package. Flanagan's work is the book Java programmers want nearby when they are at the keyboard. A complete ready-reference work, this belongs in all collections supporting programmers. Java is a constantly changing language so Nutshell will be coming out often with new editions; always have the newest one on hand. Reese goes beyond simple applet design to relational databases, SQL, object-oriented database applications, application servers, and remote object manipulation. The examples used throughout the book are based on a banking application designed in Java.
Copyright 1997 Reed Business Information, Inc.

Book Description
Java and databases make a powerful combination. Getting the two sides to work together, however, takes some effort--largely because Java deals in objects while most databases do not.

This book describes the standard Java interfaces that make portable object-oriented access to relational databases possible and offers a robust model for writing applications that are easy to maintain. It introduces the JDBC and RMI packages and uses them to develop three-tier applications (applications divided into a user interface, an object-oriented logic component, and an information store).

The book begins with a quick overview of SQL for developers who may be asked to handle a database for the first time. It then explains how to issue database queries and updates through SQL and JDBC. It also covers the use of stored procedures and other measures to improve efficiency, where these are available.

But the book's key contribution is a set of patterns that let developers isolate critical tasks like object creation, information storage and retrieval, and the committing or aborting of transactions.

The second edition includes more basics of JDBC and SQL, with more examples, and a deeper discussion about the architecture of a robust, maintainable database application. The second edition also explains the relationship between JDBC and Enterprise JavaBeans.

Book Info
Describes the standard Java interfaces that make portable object-oriented access to relational databases possible and offers a robust model for writing applications that are easy to maintain. Introduces the JDBC packages and uses them to develop three-tier applications. Previous edition: c1997. Softcover. DLC: Database design.

Card catalog description
Java and databases make a powerful combination. Getting the two sides to work together, however, takes some effort - largely because Java deals in objects, while most databases do not. This book describes the standard Java interfaces that make portable, object-oriented access to relational databases possible, and offers a robust model for writing applications that are easy to maintain. It introduces the JDBC and RMI packages and uses them to develop three-tier applications (applications divided into a user interface, an object-oriented logic component, and an information store). If you have a database at your site and have studied Java, this book will help you become a more effective application developer for Java database programs. The book includes reference listings for JDBC and the most important RMI classes, and covers Java 1.1.

The publisher, O'Reilly and Associates
Java and databases make a powerful combination. Java lends itself to portable interfaces and reuse, while databases serve up the riches stored by a corporation or other organization. Getting the two sides to work together, however, takes some fiddling -- largely because Java deals in objects while most databases are not object oriented. This book describes the standard Java interfaces that make portable, object-oriented access to relational databases possible, and offers a robust model for writing applications that are easy to maintain. It covers the JDBC and RMI packages and uses them to develop three-tier applications (applications divided into a user interface, an object-oriented logic component, and an information store). Virtually all the important database providers have drivers to support JDBC. If you have a database at your site and know some Java, this book will help you become a more effective application developer for Java database programs. It shows you how to embed SQL commands into a Java program using the JDBC APIs, and how to break your application into interfaces and classes that maximize the opportunities for reuse and easy maintenance. You also learn how to find servers through the RMI (Remote Method Invocation) interface and to use an object broker. This is a book that can truly pull your computing site together. It includes a comprehensive three-tier database example and reference listings for JDBC and the most important RMI classes. Covers Java 1.1.

Comments

SEND A COMMENT

PLEASE READ: All comments must be approved before appearing in the thread; time and space constraints prevent all comments from appearing. We will only approve comments that are directly related to the article, use appropriate language and are not attacking the comments of others.