Statement – the statement is sent to the database server each and every time.

JDBC represents statements using one of the following classes: Additionally, stored procedures may be invoked through a JDBC connection. These may be update statements such as SQL's CREATE, INSERT, UPDATE and DELETE, or they may be query statements such as SELECT. JDBC connections support creating and executing statements.

The Driver Manager is used as a connection factory for creating JDBC connections. The API provides a mechanism for dynamically loading the correct Java packages and registering them with the JDBC Driver Manager. JDBC ('Java Database Connectivity') allows multiple implementations to exist and be used by the same application. The latest version, JDBC 4.3, is specified by a maintenance release 3 of JSR 221 and is included in Java SE 9. JDBC 4.2, is specified by a maintenance release 2 of JSR 221 and is included in Java SE 8. JDBC 4.1, is specified by a maintenance release 1 of JSR 221 and is included in Java SE 7. JSR 54 specifies JDBC 3.0 (included in J2SE 1.4), JSR 114 specifies the JDBC Rowset additions, and JSR 221 is the specification of JDBC 4.0 (included in Java SE 6). Starting with version 3.1, JDBC has been developed under the Java Community Process.

The JDBC classes are contained in the Java package java.sql and javax.sql. Since then it has been part of the Java Platform, Standard Edition (Java SE). Sun Microsystems released JDBC as part of Java Development Kit (JDK) 1.1 on February 19, 1997.

How to use jdbc odbc driver in netbeans