The JDBC of the 13 specifications of the Java EE

Let's say you touch something new. You may feel at a loss, but assuming it's the old thing, is it hard for you to learn?

First,ODBC, our old friend.

the ODBC (Open database Connectivity) is the interface specification for Microsoft Corporation and the database.

Essence Point:

1.ODBC , set up a set of specifications and provide a set of standards for access to the database API , standard application Data interface.

2.ODBC is to use C language Implementation, the use of a large number of pointers.

3.The use of ODBC drivers isolates the application from detailed database calls, and the driver manager centrally manages individual drivers for a particular database and provides the application with a unified standard interface .

4. structure model: divided into four parts, application interface, drive Manager, database drive and data source. Detailed View:

watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqvy2fvemhhbmd5aw5nzmvpmdewoq==/font/5a6l5l2t/fontsize/400/fill/ I0jbqkfcma==/dissolve/70/gravity/southeast ">

Second,JDBC. Should be the voice of the

          java The emergence of language. Swept the world. At that time java Personnel with odbc To manipulate the database application. Encountered a lot of trouble, for example odbc is using c The language is implemented and includes a large number of pointers. This pair of java Completely object-oriented thinking is a very large conflict, resulting in the java Very many excellent features can not be used, for example, platform-independent. Object-oriented features, etc.

so. In response,SUN developed a database application development interface dedicated to the Java language interface.

JDBC (Java database Connectivity) is the interface specification for Java and database .

Essence Point:

1.JDBC defines a generic low-level application programming Interface (API) that supports standard SQL functionality.

2.JDBC is to use Java The language realizes, the completely object-oriented thought, has the platform independence, the consistency is strong. Safe and stable. Distributed. Ease of use and other strengths, but also extend the capabilities of Java.

3.JDBC is Java that communicates with the database through a database drive. With the platform-agnostic nature of Java, JDBC applications can naturally implement cross-platform features, making them more suitable for database applications in heterogeneous environments on the Internet. (As with ODBC )

4. Structural model: divided into four parts. The application interface. Drive Manager, database drives, and data sources.

(Same as ODBC ) Look at the graph in detail:

three, control to learn

Same point:

1.JDBC with the ODBC are based on X/open of the SQL The call-level interface.

2.JDBC a lot of design ideas follow ODBC that contains many abstractions and SQL CLI implementation. . Both ODBC and JDBC provide support for the SQL language;

3.JDBC is similar to the overall structure of ODBC ,

watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqvy2fvemhhbmd5aw5nzmvpmdewoq==/font/5a6l5l2t/fontsize/400/fill/ I0jbqkfcma==/dissolve/70/gravity/southeast ">

different points:

1.ODBC is by Microsoft Corporation. written in C, a large number of pointers are used;JDBC is by SUN , with JAVA Written in the language. Completely object-oriented thinking.

2.ODBC difficult to learn, ODBC by mixing simple functions with complex functions, even simple things can lead to complex operations. JDBC easy to learn, design ideas are simple things to do simply. If necessary, users will be allowed to use advanced features.

3.ODBC the drive management programs and drives must be manually installed on each client computer. JDBC drives are all written in Java , so jdbc can be used in all java Platform on its own initiative to install.

Iv. Expansion and summary

Extensions:

jdbc-odbc , The reason it appears is very easy: we sometimes need to use the JAVA language to connect Microsoft's database, But because Microsoft's database is not written by JAVA , we need a bridge connection.

The detailed implementation is not mentioned here. One thing to note, however, is thatJDBC is connected directly to the database using JAVA's database drive, and jdbc-odbc is connected ODBC Data source, the actual connection to the database is ODBC.

Summary

the Technical summary is summed up in the comparison, here just to illustrate, I myself from the beginning to understand JDBC, and then think of ODBC, but for ODBC is limited to use, so feel very messy, finishing a few days later, found that the most can make their own understanding of the relationship is "traced back", from the "root" on the search , this is a kind of knowledge of the network to grow. Outward expansion or a more dense feeling. Instead of appearing abruptly a point. Let your brains out. Mechanically the relationship, but the natural. It is better to learn than to grow, and to be efficient. Recommend to everyone!

The JDBC of the 13 specifications of the Java EE