Introduction to Java Database Connectivity (JDBC) PATH 1
What is JDBC? JDBC is an interface which allows Java code to execute SQL statements inside relational databases - the databases must follow the ANSI SQL-2 standard The JDBC-ODBC Bridge - ODBC (Open Database Connectivity) is a Microsoft standard from the mid 1990’s. - It is an API that allows C/C++ programs to execute SQL inside databases - ODBC is supported by many products. -The JDBC-ODBC bridge allows Java code to use the C/C++ interface of ODBC - it means that JDBC can access many different database products - The layers of translation (Java --> C --> SQL) can slow down execution. - The JDBC-ODBC bridge comes free with the JDK: - called sun.jdbc.odbc.JdbcOdbcDriver - The ODBC driver for Microsoft Access comes with MS Office - so it is easy to connect Java and Access Four Kinds of JDBC Driver 1. JDBC-ODBC Bridge ...