The difference between JDBC and ODBC, perception, learning ...

What is JDBC? JDBC, called Java Database Connectivity Standard, is an object-oriented application interface (API) that allows access to a variety of relational databases.    JDBC is also part of the Java Core Class library. The most important feature of JDBC is that it is independent of the specific relational database. Similar to ODBC (Open Database Connectivity), some Java classes are defined in the JDBC API to represent a connection to a database (connections), an SQL statement (SQL statements), a result set (results Sets) and other database objects make it easy for Java programs to interact with the database and process the resulting results.    With JDBC, all Java programs (including Java applications, applets, and Servlets) can access the database through SQL statements or procedures stored in the database (stored procedures).    To access a particular database through JDBC, you must have the appropriate JDBC driver, which is often provided by the manufacturer of the production database and is the bridge between the JDBC API and the specific database. Typically, the Java program first uses the JDBC API to interact with the JDBC Driver Manager, which is loaded by the JDBC Driver manager into the specified JDBC drivers, which can then be accessed through the JDBC API. ODBC, open Database Connectivity, is an integral part of the database in the Microsoft Open Service Architecture (Wosa,windows Open Services Architecture), which establishes a set of specifications and provides a set of standard APIs (application programming interfaces) for database access. These APIs use SQL to accomplish most of their tasks. ODBC itself also provides support for the SQL language, which allows users to send SQL statements directly to ODBC. An ODBC-based application operates on a database that does not rely on any DBMS, does not interact directly with the DBMS, and that all database operations are done by the corresponding DBMS's ODBC driver. That is, either FoxPro, Access, or an Oracle database can be accessed using the ODBC API. Thus, the greatest advantage of ODBC is the ability to handle all databases in a unified manner. A complete ODBC consists of the following parts: Application (Application). ODBC Administrator (AdMinistrator). The program is within 32-bit ODBC of the Windows 95 Control Panel, and its primary task is to manage installed ODBC drivers and manage data sources. Driver Manager (Driver Manager). The driver manager is included in the ODBC32.DLL and is transparent to the user. Its task is to manage the ODBC driver, which is the most important part of ODBC. ODBC API. ODBC driver. is a number of DLLs that provide an interface between ODBC and the database. The data source. A data source contains information such as database location and database type, and is actually an abstraction of a data connection. The relationship between the components is as follows: To access a database, the application must first register a data source with the ODBC Administrator, which establishes the connection between ODBC and a specific database based on information such as the database location, database type, and ODBC driver provided by the data source. This allows the application to establish a connection to the corresponding database as long as the data source name is supplied to the ODBC,ODBC. In ODBC, the ODBC API does not have direct access to the database and must exchange information with the database through the driver manager. The driver manager is responsible for passing the application's call to the ODBC API to the correct driver, and the driver returns the results to the application through the driver manager after performing the appropriate operation. ODBC driver support is required when accessing an ODBC data source. With Visual C + + 5.0 Setup, you can install drivers such as SQL Server, Access, Paradox, DBase, FoxPro, Excel, Oracle, and Microsoft text. By default, VC5.0 only installs drivers for SQL Server, Access, FoxPro, and dBASE. If the user needs to install a different driver, you will need to rerun the Setup program for VC 5.0 and select the desired driver.

JDBC and ODBC differences, sentiment, learning ...