wood burning stoves 2.0*
The moose likes JDBC and the fly likes JDBC book suggestions Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC book suggestions" Watch "JDBC book suggestions" New topic
Author

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 (http://volume1.coreservlets.com/archive/Chapter17.html) for learning JSP and databases.

Any others?
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3704
    
    5

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.


My Blog: Down Home Country Coding with Scott Selikoff
Joseph Smithern
Ranch Hand

Joined: Feb 11, 2006
Posts: 89
Thanks,

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: http://aspose.com/file-tools
 
subject: JDBC book suggestions