Briefly describe the application of ODBC and JDBC in databases

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!