JDBC book suggestions

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?

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.

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.