Brief Introduction
JDBC has no special features in terms of technology. It is nothing more than an access standard similar to ODBC, which is independent of the database vendor and shared by the world. I even doubt that Sun's design of Java is actually just a language mechanism for database access. I never thought that JDBC would have a huge impact later.
Four JDBC types or layers
- JDBC-ODBC bridge -- Sun's success. It is also something sun can do and can control development. Sun. JDBC. ODBC package
- JDBC + local driver
- JDBC + NETWORK SERVICE
- JDBC pure driver-sun is required and the database vendor is willing to provide
JDBC Structure
- JDBC operation class: result set, statement, etc.
- JDBC driver MANAGER: registers the driver and obtains the connection class.
- Underlying database driver: Provides driver interfaces. The most important thing is the connecton class.
Notes for using JDBC
- JDBC standard version: 4.0 and java6 are currently used together; 3.0 and java5 are used together
- The versions of JDBC drivers vary by vendor: JDBC standard, JDBC level (type), required JRE, and version special ....
- JDBC driver registration method: seven methods are available. The simplest thing is class. forname (jdbc_driver_class_name). The most reasonable reason is that the class of jdbc_driver_class_name is new or in drivermanager. Register (new)
