This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
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?
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.