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 (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.
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.
ODBC 1.0: Published in September 1992
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. JDBCfunction 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 At present, most manufacturers have implemented the jdbc interface, and the jdbc-odbc bridge
has withdrawn from the stage of history.
Free mysql online video tutorial
2. 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!