Tutorials : Building Web Applications Using Servlets and JSP :

There are some definite improvements with the JDBC 2.0 API. Some of those are summarized in the following list.

  1. Batch fetch: JDBC 2.0 allows retrieving a batch of records from the Database.
  2. Scrollable Resultset: One can go back and forth in the resultset.
  3. Easy update Methods like updateRow() make updating the current row easy w/o writing a SQL update statement.
  4. Batch updates: Updates and inserts can be sent to the underlying RDBMS in Batches.

To learn more about how to use these features check out the JDBC 2.0 tutorial.

NOTE: Which of these features are supported and to what level is also dependent on your JDBC driver.

Finally the latest development on making database access (from a java application such as JSP) simpler is JDO. Check out this FAQ for more details.

Now let's move on to our next topic, Connection Pooling, which is more relevant with our primary goal: building web applications with Servlets and JSP.

How to Add Java Applets to Your Site

New on the Java Boutique:

New Review:

Time Management Made Easy with the Quartz Enterprise Job Scheduler
Why not just use the Java timer API? This open source scheduling API boasts simplicity, ease-of-integration, a well-rounded feature set, and it's free!

New Applet:

Reverse Complement
Reverse Complement is a simple applet that converts DNA or RNA sequences into three useful formats.

Elsewhere on internet.com:

WebDeveloper Java
Lots of Java information on webdeveloper.com

WDVL Java
Thorough Java resource at the Web Developer's Virtual Library.

ScriptSearch Java
Hundreds of free Java code files to download.

jGuru: Your View of the Java Universe
Customizable portal with online training, FAQs, regular news updates, and tutorials.