Summary

Today we covered JDBC as a standard and unified API to access many data sources in tabular forms, such as relational tables, flat files, and spreadsheets. J2EE applications and components use JDBC across all tiers. We examined the methods of connecting to a data source, and showed how to construct and implement SQL statements, and the optimized ways of handling them. We looked briefly at local transactions and stored procedures. Metadata of both the DBMS and the ResultSet was discussed, and we ended by giving a brief account of the best practices in dealing with database objects and queries using JDBC.

Tomorrow, you will learn how to develop a stateless session bean. You will see a full life cycle example by writing, compiling, deploying, and running the bean.