Java SE example: Reading a table

In this example, a PreparedStatement object is obtained from a connection, and a ResultSet object is obtained from the PreparedStatement object. The next method on the ResultSet returns true each time a subsequent row can be obtained. Values for the columns in the current row can then be obtained from the ResultSet object.

Run the ReadSeq.java example

Change to the following directory: %SQLANYSAMP12%\UltraLiteJ\J2SE.
Run the CreateDb example:
rundemo CreateDb
Run the LoadDb example:
rundemo LoadDb
Run the following command (the command is case sensitive):
rundemo ReadSeq

Notes

When a ResultSet is created, it is positioned before the first row of the result set. The code must invoke the next method to move to the first row in the table.
Table and column names in UltraLiteJ are case insensitive. Columns can be referenced either by the column name alone ("age") or by qualifying the column name with the table name ("Employee.age").

Java SE example: Reading a table

Run the ReadSeq.java example

Notes

See also