At present, the application exchanges and databases have been very common. Therefore, a programming language is the size of the database development capabilities, which determines the extent of the language. Before the JDK version 1.1 version, the ability of the Java language provides a weak database, and the programmer has to add the ODBC (Open Database Connectivity) function of the C language in the Java program, which makes the Java program's cross-platform issuance capabilities Large restrictions. The emergence of JDBC has greatly enhanced Java programs to accesses access to various databases. It defines a "call-level" SQL interface for Java. This means we can perform the original SQL statement and retrieve the result. By using JDBC, developers can easily transmit SQL statements to almost any database. The architecture of JDBC is shown in Figure 13-1.
Figure 13-1 JDBC architecture
As can be seen from the figure, the role of the JDBC API is the difference between the masked different database drivers, so that the program designer has a standard, pure Java database program design interface, providing any type of database in Java. Technical Support. Driver Manager loads a database driver for an application. The database driver is related to the specific database and is used to submit SQL requests to the database.
JDBC has extended Java capabilities, and its combination of JDBC allows developers to really implement "Write Once, Run Everywhere!" When developing database applications. For example, using Java and JDBC APIs can publish a web page, with an applet that can access the remote database. Or enterprises can connect all employees through JDBC (they can use different operating systems, such as Windows, Macintosh, and UNIX) on the Intranet on several global databases, and these global databases can be different.
