Visual Developer SQL Database Programming with Java: Creating Fast, Efficient Database Applications for the Web [Paperback]

Bill McCarty (Author)

Book Description

Series: Visual Developer | Publication Date: September 3, 1997

Provides practical instruction in creating database applications with Java, SQL, and JDBC. Shows how to design and build Internet-capable client/server systems. Includes thorough coverage of SQL, with key points illustrated by helpful diagrams. Explains how to use Java and SQL with popular database management systems, such as Microsoft Access. Demonstrates how to handle tricky issues such as views, multiuser access, database security, and database integrity. Teaches how to use Java's JDBC classes and the JDBC-ODBC bridge.

Editorial Reviews

About the Author

Bill McCarty teaches Management Information Systems at Azusa Pacific University. He holds a Ph.D. in the Management of Information Systems.

Product Details

• Paperback: 512 pages
• Publisher: Coriolis Group Books (September 3, 1997)
• Language: English
• ISBN-10: 1576101762
• ISBN-13: 978-1576101766
• Product Dimensions: 9.2 x 7.4 x 1.6 inches
• Shipping Weight: 2 pounds
• Average Customer Review: 3.2 out of 5 stars  See all reviews (10 customer reviews)
• Amazon Best Sellers Rank: #2,939,789 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

7 of 7 people found the following review helpful:

5.0 out of 5 stars Excellent introduction to JDBC with Microsoft Access, September 30, 1998

By A Customer

This review is from: Visual Developer SQL Database Programming with Java: Creating Fast, Efficient Database Applications for the Web (Paperback)

I found this book to be extremely useful. It is extremely good at explaining things, and has great code examples. A word of caution: it assumes you'll be using Microsoft Access. It's hard for me to assess how much you would get out of it if you're using a different configuration. It should probably have been called "JDBC programming with Access". But if this is what you'll be using, and/or you're a beginner, this book will be invaluable. I've seen no better book than this for learning the basics of JDBC, and it has helped me immensely. Other books just gloss through the basics and assume you'll figure it out yourself. On the contrary, "SQL Programming with Java" guides you step by step, and tells you every little thing you need to know. You end up with a solid knowledge of both the operation and the concepts behind JDBC. Definitely recommended, "The Book" to start with if you're using Access. It may also be valuable if you're using a similar DBMS.

3 of 3 people found the following review helpful:

4.0 out of 5 stars An excellent resource for writing java database apps, July 13, 1998

By A Customer

This review is from: Visual Developer SQL Database Programming with Java: Creating Fast, Efficient Database Applications for the Web (Paperback)

I found this book to be very useful for creating a database app using JDBC and SQL. It focuses on the SQL side of the equation instead of the JDBC side. While the book does use Microsoft Access as its example, it teaches pure Java. The basic techniques are the same whether using Access or Oracle. If you are looking to write a database front end in Java, this book is an excellent place to start.

5.0 out of 5 stars This is simply a great book on SQL with Java., November 30, 2000

By 

Bill Vannah (Western Mass) - See all my reviews

This review is from: Visual Developer SQL Database Programming with Java: Creating Fast, Efficient Database Applications for the Web (Paperback)

If you need to get into Java/SQL/JDBC, boy are you going to be glad you ran across this review. McCarty's book is probably one of the best tech books I've read. This book is WAY under-rated on Amazon. I first got it a couple of years ago, it helped me a TON, and I was always mystified by the reviews here (at Amazon). Just ran across the JavaWorld review, and thought I'd post it here, to do McCarty justice (thanks for a great helpful book Dr. McCarty), and to pass along the word to anyone else interested in this area. Specific comments

1) It is a bit dated now (Java1.2+), some of the methods are deprecated (will still compile - this is Java, not Micro$oft - but you do get a warning).

2) The main concentration/subject matter is on using Java to send SQL commands to query from and add to a relational database; heavy on the SQL and database design. If that's what you're after, get this book.

3) You need to know Java first.

4) The book does use an Access database. I think that's because most of us some version of Office kicking around. However, you are (contrary to some reviews here) by no means restricted to using Access. Anything JDBC can bridge to is fine. The Access examples in the beginning of the book are simply to show people, who may not know, how to set up an Access database. If you use a different database, you'll have to figure out how to do that yourself - it think it's reasonable to assume most people looking at this book will know how to do that. I am talking about setting up the database, not accessing it - the book covers accessing it, using JDBC, which is what we want to do.

4) For some bizzare reason, my copy's CD came with VisualJ++. I tried it, assuming it must have some kind of valuable feature that Sun Java didn't have. It didn't and I went back to Sun. You certainly don't need to use VJ++ to use the book - in fact, I couldn't get the example code to run in Microsoft's Java. Everything worked fine with Sun's Java, except, as I mentioned, some of the methods are deprecated in Java1.2 (aka Java2).

5) The writing is crystal-clear, to the point, and spare. I suspect McCarty may have taught a class on this for a few semesters before releasing the book. Feedback from students can be great in learning what is unclear about one's explanations, and it can be real hard learn otherwise.