Recordset Class

The javaxt.sql.Recordset class is used to query, insert, and update records in a database. It is intended to simplify many of the complexities and nuances associated with the standard Java/JDBC Resultset and is loosely based on the old Microsoft ADODB Resultset class. It is used in conjuction with a live javaxt.sql.Connection.

Simple Query

Here's a simple example of how to execute a query and print the results.

You can retrieve values for specific fields using the getValue() method.

Insert Record

Here's a simple example of how to insert a record into a table. Note how the setValue() method can accept mix object types.

Autogenerated Key

Some tables are designed with an autogenerated key (e.g. identity or sequence). You can retrieve the autogenerated key after inserting a record like this:

Update Record

Here's a simple example of how to update an existing record.