Connecting Java Application using 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 of database systems that are available and why they are important for an organization.
We will discuss the relationship between a DBMS and JDBC.
JDBC Case Study
Like all organizations, the Brazilian Hospital Project wants to get its work completed in the most efficient manner possible.
They want to focus their resources on analyzing the data they will collect. A computer system is a tool to accomplish that objective.
Because of that, they want their computer system to help them reach that goal with a minimum of trouble and expense. In addition, they want a system that can easily change or grow as circumstances require.
Because of those requirements, they chose to use Java and JDBC for the development of their computer system.
Java and JDBC can provide the efficiency and flexibility they require. The system could be written to run on a wide range of systems, from inexpensive Linux machines to
clustered mainframes, with a minimum of changes. Now, you must learn how to use the tools provided by JDBC to utilize those features of Java for your client.
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.