Solving enterprise problems with JDBC


Lesson 1 Solving enterprise problems with JDBC
		This module will introduce you to how you can connect a Java program to a database. You are likely aware that a major strength of Java is its system independence. An early slogan for Java was "write once, run anywhere." While that slogan slightly exaggerates the portability of Java applications, that spirit extends to nearly all the services available for those applications. Database services are no exception. The architects for these services attempted to provide a similar level of independence for those database services. This is the JDBC API. Features, benefits, and capabilities An important feature of JDBC is that it provides an application developer with the capability to use the information collected in a database management system (DBMS). In this module, you will learn about the capabilities that JDBC encompasses for a Java programmer who must use that information. You will also learn about database systems--the different types available and why they are important for an organization. We will discuss the relationship between a DBMS and JDBC. After completing this module, you will have the skills and knowledge that will enable you to: Distinguish the role and place of JDBC among the Java technologies Differentiate between DBMS types Explain the relational model Describe design considerations for JDBC and ODBC in a solution Explain what SQL is and its role in database processing Explain JDBC as it functions in two and n-tier systems designs Describe the capabilities of Java and a DBMS used with JDBC In the next lesson, you will learn about the role of JDBC among the Java technologies.