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.