Table of Contents
odbc
Wiki Definition
Background
Version History
Home Database Mysql Tutorial Briefly describe the application of ODBC and JDBC in databases

Briefly describe the application of ODBC and JDBC in databases

May 09, 2017 pm 12:00 PM

A few days ago, in order to use PowerDesigner reverse engineering to obtain the ER diagram of the data table, I used ODBC. Let me summarize it here.
Other systems are not clear, window7 There is no built-in mysql implementation to odbc. You need to install a mysql-connector-odbc yourself. The following is how to connect
mysql to configure the ODBC data source

Let’s talk about odbc.

odbc


Wiki Definition

ODBC (Open Database Connectivity, Open Database Connectivity) provides a standard API (Application Programming Interface) method to Access a database management system (DBMS). These APIs utilize SQL to accomplish most of their tasks. ODBC itself also provides support for the SQL language, and users can directly send SQL statements to ODBC. The designers of ODBC strive to make it as independent and open as possible: it has nothing to do with specific programming languages, has nothing to do with specific database systems, and has nothing to do with specific operating systems.

Background

Before the birth of ODBC, if you want to develop a database application, you must use some tool sets released by the database manufacturer along with the database product to access the database, or use embedding in the program SQL to access the database. At that time, there was a lack of a unified programming interface based on C language for how to access the database. Against this background, Microsoft released ODBC in 1992. After that, the X/Open organization and the ISO standardization organization further standardized based on the ODBC 3.0 specification and published the SQL/CLI standard in 1995. This standard has become part of the SQL standard.
It shows that the emergence of ODBC has unified the database access interface, which is a benefit to developers. They no longer need to provide an access method for Oracle and another access method for MS.

Version History

  • ODBC 1.0: Published in September 1992

  • ##ODBC 2.0: Published in 1994 Year

  • ODBC 3.0: Published in 1995

  • ODBC 3.5: Published in 1997

  • ODBC 3.8: Published in 2009, released together with Windows 7[1]

ODBC is just an application programming interface, it is a specification, specifically ODBC DriverThe program is implemented by various database manufacturers. From Oracle, DB2, SQL Server to Microsoft's Access database, they have all implemented data drivers for their respective database products.

The ODBC driver adapts the manufacturer interface to the ODBC interface, which is an application in adaptation mode.

JDBC


The functions of jdbc and odbc are very similar, except that the driver is implemented in java, compiled once and run everywhere.

Since the Java language was officially announced in May 1995, Java has become popular all over the world. There are a large number of programs written in Java language, including database applications. Since there is no Java language API, programmers have to add C language ODBC

function calls in Java programs. This prevents many of Java's excellent features from being fully utilized, such as platform independence, object-oriented features, etc. As more and more programmers become more and more fond of the Java language, more and more companies are investing more and more energy in Java program development, and the requirements for the API of the Java language interface to access the database are getting stronger and stronger. Also because ODBC has its shortcomings, such as it is not easy to use, has no object-oriented features, etc., SUN decided to develop a database application development interface with Java language as the interface. In JDK1. In version

jdbc-odbc bridge


Since ODBC is widely used, in order to allow JDBC to access almost all databases, the JDBC-ODBC bridge was created. The JDBC-ODBC bridge is a JDBC driver that implements JDBC operations by converting JDBC operations into ODBC operations. It is still an adaptation mode.

At present, most manufacturers have implemented the jdbc interface, and the jdbc-odbc bridge
has withdrawn from the stage of history.

【Related recommendations】

1.

Free mysql online video tutorial

2.

MySQL latest manual tutorial

3.

Boolean Education Yan Shiba mysql introductory video tutorial

The above is the detailed content of Briefly describe the application of ODBC and JDBC in databases. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

How does Go language implement the addition, deletion, modification and query operations of the database? How does Go language implement the addition, deletion, modification and query operations of the database? Mar 27, 2024 pm 09:39 PM

Go language is an efficient, concise and easy-to-learn programming language. It is favored by developers because of its advantages in concurrent programming and network programming. In actual development, database operations are an indispensable part. This article will introduce how to use Go language to implement database addition, deletion, modification and query operations. In Go language, we usually use third-party libraries to operate databases, such as commonly used sql packages, gorm, etc. Here we take the sql package as an example to introduce how to implement the addition, deletion, modification and query operations of the database. Assume we are using a MySQL database.

iOS 18 adds a new 'Recovered' album function to retrieve lost or damaged photos iOS 18 adds a new 'Recovered' album function to retrieve lost or damaged photos Jul 18, 2024 am 05:48 AM

Apple's latest releases of iOS18, iPadOS18 and macOS Sequoia systems have added an important feature to the Photos application, designed to help users easily recover photos and videos lost or damaged due to various reasons. The new feature introduces an album called "Recovered" in the Tools section of the Photos app that will automatically appear when a user has pictures or videos on their device that are not part of their photo library. The emergence of the "Recovered" album provides a solution for photos and videos lost due to database corruption, the camera application not saving to the photo library correctly, or a third-party application managing the photo library. Users only need a few simple steps

How does Hibernate implement polymorphic mapping? How does Hibernate implement polymorphic mapping? Apr 17, 2024 pm 12:09 PM

Hibernate polymorphic mapping can map inherited classes to the database and provides the following mapping types: joined-subclass: Create a separate table for the subclass, including all columns of the parent class. table-per-class: Create a separate table for subclasses, containing only subclass-specific columns. union-subclass: similar to joined-subclass, but the parent class table unions all subclass columns.

Detailed tutorial on establishing a database connection using MySQLi in PHP Detailed tutorial on establishing a database connection using MySQLi in PHP Jun 04, 2024 pm 01:42 PM

How to use MySQLi to establish a database connection in PHP: Include MySQLi extension (require_once) Create connection function (functionconnect_to_db) Call connection function ($conn=connect_to_db()) Execute query ($result=$conn->query()) Close connection ( $conn->close())

An in-depth analysis of how HTML reads the database An in-depth analysis of how HTML reads the database Apr 09, 2024 pm 12:36 PM

HTML cannot read the database directly, but it can be achieved through JavaScript and AJAX. The steps include establishing a database connection, sending a query, processing the response, and updating the page. This article provides a practical example of using JavaScript, AJAX and PHP to read data from a MySQL database, showing how to dynamically display query results in an HTML page. This example uses XMLHttpRequest to establish a database connection, send a query and process the response, thereby filling data into page elements and realizing the function of HTML reading the database.

How to handle database connection errors in PHP How to handle database connection errors in PHP Jun 05, 2024 pm 02:16 PM

To handle database connection errors in PHP, you can use the following steps: Use mysqli_connect_errno() to obtain the error code. Use mysqli_connect_error() to get the error message. By capturing and logging these error messages, database connection issues can be easily identified and resolved, ensuring the smooth running of your application.

How to connect to remote database using Golang? How to connect to remote database using Golang? Jun 01, 2024 pm 08:31 PM

Through the Go standard library database/sql package, you can connect to remote databases such as MySQL, PostgreSQL or SQLite: create a connection string containing database connection information. Use the sql.Open() function to open a database connection. Perform database operations such as SQL queries and insert operations. Use defer to close the database connection to release resources.

How to use database callback functions in Golang? How to use database callback functions in Golang? Jun 03, 2024 pm 02:20 PM

Using the database callback function in Golang can achieve: executing custom code after the specified database operation is completed. Add custom behavior through separate functions without writing additional code. Callback functions are available for insert, update, delete, and query operations. You must use the sql.Exec, sql.QueryRow, or sql.Query function to use the callback function.

See all articles