JDBC Technology Introduction < EXT >

1. Introduce
Many developers and users are looking for a convenient way to access a database in a Java program. Because Java is a robust, secure, easy to use, easy to understand and can automatically download from the network, it becomes a good language base for developing database applications. It provides many of the advantages of C,c++,smalltalk, BASIC, COBOL, and 4GLs. Many companies have begun to work on the Java-DBMS connection.
Many Java application developers want to be able to write programs that are independent of specific DBMS, and we also believe that a DBMS-independent interface will make connectivity with a wide variety of DBMS the most convenient and faster to develop. So we think it is very meaningful to define a universal SQL database access framework to provide a unified interface in a variety of database connectivity modules. This allows programmers to face a single database interface, making it possible for database-independent Java tools and products, so that database-connected developers can provide a wide range of connectivity scenarios. We see the urgent task of defining a generic low-level, javadatabase connectivity (JDBC) API that supports basic SQL functionality.
Luckily, we don't have to design a SQL API from scratch. We can build our work on the X/open SQL CLI (call-layer interface) (which is also the basis of Microsoft's ODBC).
Our main task is to define a natural Java interface to connect with the basic abstraction layers and concepts defined in the X/open CLI.
The JDBC API is important for database developers, connectivity developers, ISVs, and application developers. We believe that by building our work on the basis of the ODBC abstraction layer, JDBC will be more easily accepted. and technically, ODBC is a good foundation for our design work.
Because ODBC is a C language interface, ODBC is not used properly in Java. Calling C code from Java has many inconveniences in terms of security, robustness, ease of implementation, portability, and so on. It makes Java's many advantages in these areas not to be played.
We have implemented an API built on ODBC in the short term. In the long run, we can provide implementation in other ways.
1.1. Attention
We are very grateful to many early workers in the field of database, database connection and database Tools. They provided good advice and advice for the early drafts of JDBC. Their work has played an inestimable role in this norm.
　
2. Goals and Philosophy
This section describes the goals and philosophies that guide the development of this API.
2.1. SQL level API
Our primary goal is to define a "call-level" (call-level) SQL interface for Java. means that our primary focus is on executing the literal SQL statements and retrieving the results. We expect high-level APIs to be defined, which may be built on the base-level interface.
These high-level interfaces include the direct and transparent mapping of data in a table to Java classes, the use of syntax trees to represent more general queries, and the SQL syntax embedded in Java.