word 文档 可自由复制编辑
simple applications. For example, applications can provide a choice of According to the
mandate of the menu. Task was chosen, the application will be given tips and blank selected
for the task of completing the implementation of the necessary information. Application
procedures for the importation of the required information will automatically call for SQL
Order. In such a process with the assistance, even if they do not understand the fundamental
SQL syntax, but also can perform database tasks.
Third, JDBC and ODBC compared with other API
Currently, Microsoft's ODBC API is the most widely used for the visit of the relational
database programming interface. It can connect almost all platforms almost all databases. For
What Java does not use ODBC? The answer to this question is: Java can use ODBC, but
preferably with the help of the JDBC to JDBC-ODBC Bridge in the form of use of this point, preferably with the help of the JDBC to JDBC-ODBC Bridge in the form of use of this point,
ODBC not suitable for direct use in Java, because it uses C language interface. Transferred
from Java C code in the local security, achieved solid and procedural aspects of the automatic
transplantation has many shortcomings. From ODBC C API Java API to the literal translation
is not advisable. For example, Java does not guide, and it has ODBC indicators used very
widely (including very error-prone Guidelines Guidelines Guidelines You can imagine JDBC will be
converted into the object-oriented interface to the ODBC, and the object-oriented interface to
make it easier for Java programmers to receive. ODBC is difficult to learn. It simple and
advanced features of the mix, and even the simple query, the options are extremely complex.
On the contrary, JDBC to guarantee simple function of simplicity, At the same time, if
necessary, to allow the use of advanced features. The opening of of of mechanism
needs such as JDBC Java API. If you use ODBC, it is necessary to manually will be ODBC
driver management and driver installation in each client machines. If completely written in
Java JDBC Driver in all the JDBC code on the Java platform (from the computer network to
the mainframe) can be Automatic installation, and guarantee the safety of transplantation.
In short, JDBC API for SQL abstract and basic concepts of Java is a natural interface. It
is built on ODBC rather than starting from scratch. Therefore, programmers will be familiar
with ODBC JDBC found very easy to use. ODBC JDBC retains the basic design features; In
fact, the two interfaces are based on the X / Open SQL CLI (call-level interface). Among
them the largest district, another is: Java JDBC to style and based on the merits and
optimization, more easy to use.
At present, Microsoft has introduced a new addition to ODBC API: RDO, ADO and
OLE DB. These design in many ways and JDBC is the same, that is, they are the
object-oriented Based on the database interface and can be achieved on ODBC in the category.