Database Interface Technology

From
In the previous topics, we introduced database knowledge, but when we want to do something through the database, or when designing database applications
And how to access the database? How to manipulate the data in the database? Therefore, we will introduce the database interface technology in this topic.
Currently, the two most popular database interfaces on the market are ODBC and JDBC. ODBC launched by Microsoft is the first database interface to integrate heterogeneous databases,
The success has become a de facto standard. The most common way to access a database is through ODBC. Now let's talk about what is
ODBC.
What is ODBC
ODBC is based on SQL (Structured Query Language) and uses it as the standard for database access. This interface provides maximum mutual operation
Nature: An application can access different database management systems through a set of common code.
Configure ODBC data sources
ODBC manager (Administrator) is responsible for installing drivers, managing data sources, and helping programmers track ODBC function calls. In ODBC, the application
The program cannot directly access the database. It must exchange information with the database through the manager.
Dynamic Configuration of ODBC data sources
You can automatically configure the database connection according to the environment where the program is installed. The answer is yes.
This section describes how to dynamically configure the ODBC data source by modifying the Window registry in a program.
Database Access Technology
Through ODBC, you can easily write database applications under the Client/Server two-tier architecture, which can meet many practical needs. Other party
With the development of computer technology, the layer-3 or layer-4 architecture has also been proposed and applied in specific reality ......
JDBC
As Java is widely used, Java developers also find a way to enable Java applications to communicate with different databases.
Now, a mechanism for this type of dialog can easily transmit SQL statements to any relational database using JDBC. In other words, you do not need to specify the number of links.
A separate program is written into the database. JDBC allows developers to use the "Write once, run anywhere" feature of the Java platform. Developers can even
Connect different databases in different environments.
Overview
JDBC is a Java API for executing SQL statements. In fact, JDBC itself is the trademark name of a product. Open Database Connectivity
Database Connection), you can also regard JDBC as "Java Database Connectivity (Java Database connection )". It is composed of a group of classes written in Java.
And interfaces.
Several important classes in JDBC1.2
Let's first introduce several important classes in JDBC1.2.
JDBC2.0 extended API
The latest JDBC 2.0 API is divided into two parts: JDBC 2.0 core API and JDBC 2.0 standard extended API. The core API is in java. SQL.
JDBC driver type
The JDBC driver we currently know can be divided into the following four types:
A few simple examples
This is a few simple examples to deepen your understanding of the JDBC api.