Summary

Today you covered the main areas of the JDBC API, which are Statement, PreparedStatement, and CallableStatement. You studied the methods in each interface and the different scenarios in which you might use the Statement, PreparedStatement, and CallableStatement interfaces.

The next topic that you explored was using the ResultSet and ResultSetMetaData interfaces for retrieving data. You also learned about the new enhancements provided by the JDBC 2.0 API, namely, scrollable and updatable result sets. Another new enhancement in the JDBC 2.0 API is the batch update concept that allowed you to group SQL statements and execute them all at once.

RowSet and RowSetMetaData, which are two entirely new extensions to the JDBC 2.0 API, were also covered. You became aware of the differences between a ResultSet and a RowSet object as well as where to use a ResultSet and where to use a RowSet. There were three types of RowSet objects, covered in the section on RowSets. They were CachedRowSet, JDBCRowSet, and WebRowSets.

Finally, you wrote a sample application using the JDBC APIs that you studied today by extending the shopping cart application that you have been building over the past few days.