ProResultSet interface extensions to java.sql.ResultSet
ProResultSet adds the following methods not found in java.sql.ResultSet, where DataType is the name of the data type. These extensions allow your application to access the data in a ResultSet based on the ABL array model (see Accessing temp-table array fields).
The following method returns the value of the arrayIndex element of the array field identified by fieldNum:
Syntax
Object getObject(int fieldNum, int arrayIndex)
The data type of the object is the default data type of the arrayIndex. The arrayIndex and fieldNum are 1-based.
The following method returns the value of the arrayIndex element of the array field identified by fieldName:
Syntax
Object getObject(String fieldName, int arrayIndex)
The data type of the object is the default data type of the array field. The arrayIndex and fieldName are 1-based.
The following method returns the array field identified by fieldNum:
Syntax
DataTypegetDataType(int fieldNum, int arrayIndex)
DataType is the name of the data type; for example, String getString(), Integer getInteger(), and so on. The arrayIndex and fieldNum are 1-based.
The following method returns the array field:
Syntax
DataTypegetDataType(String fieldName, int arrayIndex)
DataType is the name of the data type; for example, String getString(), Integer getInteger(), and so on. The arrayIndex and fieldName are 1-based.
For example, the following is the syntax for methods that return a value for a String and an Integer array element of a temp-table field:
String getString(int fieldNum, int arrayIndex)
String getString(String fieldName, int arrayIndex)
Integer getInteger(int fieldNum, int arrayIndex)
Integer getInteger(String fieldName, int arrayIndex)
For a complete listing of the methods implemented by the ProResultSet interface, see the documentation in OpenEdge-install-directory/java/doc/.
