provide an overview of the function of JDBC. describe the java.sql package, incl
ID: 3877508 • Letter: P
Question
provide an overview of the function of JDBC.
describe the java.sql package, including interfaces for DriverManager, Connection, Statement, and ResultSet.
discuss the basic issues that arise in developing networked database applications.
describe the three tiers into which a typical application can be broken down.
analyze the data access tier of a multi-tiered distributed application.
show the various ways that a JDBC driver can be configured to interact with an RDBMS.
outline the options for implementing data objects in a multi-tiered, distributed application.
outline the data caching issues in distributed applications
Explanation / Answer
Overview of function of JDBS:
JDBC, Java DataBase Connectivity is an API, which provides an interface to interact with RDBMS. It helps to connect java program with different databases like access, MYSQL, ORACLE, e.tc., based on requirement.
JDBC Components:
Java.sql package:
Java.sql package contains the entire JDBC API that sends SQL to relational databases and retrieves the results of executing those SQL statements.
Above questions explains some interfaces used in this package.
Issues arise in Network based application:
Three Tires to which a typical application can break down:
Three tire architecture contains the data storage in one tier, the business logic in a second tier, and the user interface in third.
The main advantage of this architecture is it becomes simpler to modify the user interface, business logic, or data storage components without affecting the other components.
Data storage tier:
Database request and all query processing are takes place in this tier. Without effecting application server. Data storage server maintained separately.
Application tier:
Business logic is contained in application sever. Server request and response will be take take care by this server only.
Client tier:
User interacts with application in this tier. Using an interface.
Data access tier of multi tiered distributed application:
The mechanism used to access data and process the data.
It also holds and manages data that is at rest.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.