How the connection example works

The external connection example is a Java command line program.

Importing packages

The application requires a couple of packages, which are imported in the first lines of JDBCConnect.java:

The java.io package contains the Java input/output classes, which are required for printing to the command prompt window.
The java.sql package contains the JDBC classes, which are required for all JDBC applications.

Each Java application requires a class with a method named main, which is the method invoked when the program starts. In this simple example, JDBCConnect.main is the only public method in the application.

The JDBCConnect.main method carries out the following tasks:

Determines which driver to load based on the command line argument. For the SQL Anywhere JDBC 3.0 driver, it loads the requested driver (using the Class.forName method). The jConnect 7.0 and the SQL Anywhere JDBC 4.0 driver are automatically loaded at startup if it is in the class file path.
Connects to the default running database using the selected JDBC driver URL. The getConnection method establishes a connection using the specified URL.
Creates a statement object, which is the container for the SQL statement.
Creates a result set object by executing a SQL query.
Iterates through the result set, printing the column information.
Closes each of the result set, statement, and connection objects.

Discuss this page in DocCommentXchange.

How the connection example works

Importing packages

The main method