J2EEOnline J2EEOnline

JDBC   «Prev  Next»
Lesson 9

JDBC Connectivity Conclusion

This module explored the role of JDBC in providing solution developers with enterprise-wide database connectivity capabilities and the JDBC architecture.
You studied the relationship between JDBC and Java. You learned about various database systems and how JDBC was designed to work with relational DBMSs and the relational command language, SQL. You learned about two and n-tier application models. Finally, you learned about how JBDC was designed to leverage the power of Java.
Specifically, you learned to:
  1. Distinguish the role and place of JDBC among the Java technologies
  2. Differentiate between DBMS types
  3. Explain the relational model
  4. Describe design considerations for JDBC and ODBC in a solution
  5. Explain what SQL is and its role in database processing
  6. Explain JDBC as it functions in two and n-tier system designs
  7. Describe the capabilities of Java and a DBMS used with JDBC

Importing Packages

Regardless of which Oracle JDBC driver you use, include the import statements shown in Table 3- 9 at the beginning of your program.
Table 3-9 Import Statements for JDBC Driver

The Oracle packages listed as optional provide access to the extended functionality provided by the Oracle JDBC drivers, but are not required for the example presented in this section.

JDBC Concepts

This module discussed how the following terms related to JDBC:
  1. JDBC: Java API for querying a relational database. It provides methods for querying and updating data in a database. JDBC is oriented towards relational databases.
In the next module, making a JDBC connection will be discussed.