There are some definite improvements with the JDBC 2.0 API. Some
of those are summarized in the following list.
Batch fetch: JDBC 2.0 allows retrieving a batch of records from
the Database.
Scrollable Resultset: One can go back and forth in the resultset.
Easy update Methods like updateRow() make updating the current
row easy w/o writing a SQL update statement.
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.
