Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC book suggestions

 
Joseph Smithern
Ranch Hand
Posts: 89
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
author
Saloon Keeper
Posts: 4015
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Joseph Smithern
Ranch Hand
Posts: 89
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic