This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Java Interview Guide and have Anthony DePalma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes JDBC book suggestions Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC book suggestions" Watch "JDBC book suggestions" New topic

JDBC book suggestions

Joseph Smithern
Ranch Hand

Joined: Feb 11, 2006
Posts: 89
I want to buy books that can teach me JSP and databases using JDBC.

I found one called JDBC(TM) API Tutorial and Reference: Universal Data Access for the Java(TM) 2 Platform (2nd Edition) but it is dated 1999 from what I can see on Amazon. Is that too old or outdated book?

Please advise some good learning books on JDBC/JSP Database.
Also I was told of this site ( for learning JSP and databases.

Any others?
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3753

I'd recommend you study them separately (since they dont really overlap). Also, putting JDBC code directly in a JSP is considered a bad practice. The better solution is to create a utility class (just a regular java class) that controls all your JDBC interactions and reference it in the JSP.

The more advanced solution (for J2EE) is to have a service oriented architecture. In this model, JSPs have no database access but access to open servers (EJB or Web Services) that run independently of the JSP and make their own database connections.

J2EE is probably more heavy weight than you require so I'd recommend writing good utility classes.

[OCA 8 Book] [Blog]
Joseph Smithern
Ranch Hand

Joined: Feb 11, 2006
Posts: 89

I meant to say learn how to efficiently develop with Java Beans and databases working with JSP.

I have created a utility class (java class file with database connection and query) and it works with my Bean in JSP.

I need a good book to guide me on Java Beans and databases working with JSP.
I agree. Here's the link:
subject: JDBC book suggestions
It's not a secret anymore!