Java Database Programming with JDBC: Discover the Essentials for Developing Databases for Internet and Intranet Applications
Description:Java Database Programming with JDBC by Pratik Patel and Karl Moss is an updated edition of the authors' guide to the Java Database Connectivity (JDBC) standard for database programming under Java. While the original edition was perhaps geared more to those developers who needed to write their own JDBC database drivers, a fairly arduous task, this new edition provides more background information on database connectivity issues in Java and so will be even more useful to the casual or intermediate programmer. After a general introduction to JDBC and Structured Query Language (SQL), useful even to beginning programmers, the authors start by building a simple database-aware applet. New chapters on `servlets,` Java components that run on the server-side and manage database operations, as well as a general discussion of middleware technologies are particularly good. Database access for JavaBean components (from Sun Microsystems JDK 1.1) is also discussed, including working code for two database-aware beans. This book also includes a quick introduction to the Java language (which will only be helpful if you already know C/C++), a detailed reference for the JDBC API, and a working example of a text-based JDBC driver. Though this book is still oriented toward the JDBC driver developer, the authors now provide enough general discussion of JDBC architectural issues to make it worthwhile to any programmer who needs to ramp up on what JDBC is and what capabilities it offers.
I found this book to be really good and it gives a great overview of Java programming with JDBC. This book really has a lot of condensed material, and quickly covers a lot of areas. I was able to use the first application right off the bat to connect to a PostgreSQL database and do some simple queries. There is a lot to RDBMS accessed through JDBC, so I would suggest that readers prepare to review web servers, TCP/IP ports and client web browser java security problems. Make sure to get a good reference book for SQL, it will be a good investment for the future. The reader should also have a good grasp of programming with java and be ready to sit in the driver's seat. This book gets my thumb of approval.
2ND Edition repeats mistakes of the first
I got the 2nd edition after using the middleware chapter of the 1st edition. They repeat the mistakes of the first! On page 13, it states that a combination of ROWS can be used to compose a primary key. It should read a combination of COLUMNS! Half of the book is just a repeat of the 1st edition, word for word! Very little proofreading went into this book. Commented out debugging aids are left in the code.
Please don't buy this book
You would think that a book about JDBC programming would show you how to program using JDBC. Well, in this case, you would be absolutely wrong. It (very poorly) talks about what JDBC is, what SQL is, what a JDBC driver is, but IT NEVER TALKS ABOUT JDBC PROGRAMMING!!!! IT NEVER TELLS YOU HOW TO USE ANY OF THE JDBC CLASSES TO ACTUALLY PROGRAM SOMETHING THAT USES JDBC. It's like driving your wife to the hospital to give birth, but forgetting your wife. And remember, everything it talks about is poorly written.
Good at JDBC driver developing only
I just finish studying this book,,. and want to throw this book out of my window,,. I own `Inside ODBC` (MS Press). If it is 10, this book is 2,,
I suggest author combine part 1, 2, and 5 into one part and condense the content,, Part 3 teach you how to write a JDBC driver, must be useful to driver developer, Part 4 walks through some samples, for general reader, this part is most helpful,,
My conclusion is if you are a JDBC driver developer and want to know some about SQL and database programming. Buy this book. Otherwise, buy O'Relly's JDBC book. It is much better than this book!!
This book is so poor that I have never got any useful information about JDBC from it. We can not hope one book can cover everything, but at least one thing. This author hopes he can tell the readers more about SQL, JDBC driver, Java. In fact, almost all us do not want to get these from a JDBC book. Just give us some interesting examples and tell us how to us JDBC. If you just want to start to use JDBC, the JDBC tutorial is much more useful than this book.