The following sequence of events typically occurs in JDBC applications:
Calling a getConnection class method of the DriverManager class creates a Connection object, and establishes a connection with a database.
The Connection object generates a Statement object.
A SQL statement that executes within the database environment is passed to the Statement object. If the statement is a query, this action returns a ResultSet object.
The ResultSet object contains the data returned from the SQL statement, but exposes it one row at a time (similar to the way a cursor works).
The next method of the ResultSet object performs two actions:
Values are retrieved for each column in the ResultSet object by identifying either the name or position of the column. You can use the getData method to get the value from a column on the current row.
Java objects can use JDBC objects to interact with a database and get data for their own use.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|