Talking about Database interface technology

Source: Internet
Author: User
Tags odbc most popular database
Data | Database from www.yesky.com

In the previous topics, we introduced database knowledge, but when we wanted to really do something through the database, or when designing a database application
How to access the database inevitably? How to manipulate the data in the library and so on? So in this topic to introduce the database interface technology.

The two most popular database interfaces currently in the market are ODBC and JDBC. Microsoft's ODBC is the first database interface to consolidate heterogeneous databases,
A great deal of success has now become a de facto standard. The most common way to access a database is through ODBC. Now we're going to talk about what is
Odbc.

What is ODBC
ODBC is based on SQL (structured Query Language) and is used as a standard for accessing databases. This interface provides the maximum of mutual operability
Sex: An application can access a different database management system through a set of common code.

Configuring an ODBC data source
The ODBC Administrator (Administrator) is responsible for installing drivers, managing data sources, and helping programmers track function calls for ODBC. In ODBC, the application
The program cannot access the database directly, it must exchange information through the manager and the database.

Dynamically configuring an ODBC data source
Can not through the configuration of ODBC data source, but in the program, according to the installation of the environment, automatic configuration database connection. The answer is yes, the next
We introduce a way to dynamically configure an ODBC data source in a program by modifying the window registry.

Database access Technology
With ODBC, it is easy to write the database application under the Client/server two-tier architecture, which can meet many realistic needs. Other party
Face, with the development of computer technology, three-layer, or four-tier architecture is also beginning to be put forward and applied in the concrete reality ...


JDBC Article
With the extensive use of Java, Java developers also find it necessary to find a way to make Java apps talk to a variety of different databases, and JDBC is the real
One of the mechanisms of this conversation is to use JDBC to easily transfer SQL statements to any relational database. In other words, the user does not need to count each relationship
According to the library to write a separate program. JDBC allows developers to take advantage of the "Write Once,run Anywhere" feature of the Java platform, and developers can even
Access to a variety of different databases.

Overview
JDBC is the Java API that executes SQL statements. In fact, JDBC itself is a product's trademark name. Relative to ODBC (open Database connectivity Open
Database connection), you can also consider JDBC as "Java Database Connectivity (Java DB connection)." It consists of a set of classes written in the Java language
and interfaces.

Several important classes in the JDBC1.2
Let's first introduce some of the important classes in JDBC1.2.

JDBC2.0 Extension API
The latest version of the JDBC 2.0 API is divided into two parts: the JDBC 2.0 core API and the JDBC 2.0 standard extension API. Core API in Java.sql

JDBC-driven types
The JDBC drivers we currently know can be categorized into the following four categories

A few simple examples
Here are a few simple examples to deepen your understanding of the JDBC API.



Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.