oracle.ifs.core.util

Class SelectUtilities

java.lang.Object

oracle.ifs.core.util.SelectUtilities

public class SelectUtilities
extends Object

A set of utility methods to aid bean-side select operations.

Author:

Dave Long

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	SelectUtilities.BatchedStatement Represents selected IDs.

Method Summary

Modifier and Type	Method and Description
static AttributeValue	getValueFromResultSet(ResultSet rset, int position, int dataType) Gets the value from a ResultSet.
static AttributeValue	getValueFromResultSet(ResultSet rset, int position, int dataType, Long attrId, long objectId, Long priClassId) Gets the value from a ResultSet - for complex data types.
static void	setValueInStatement(LibrarySessionInterface session, IfsPreparedStatement stmt, AttributeValue av, int position) Set bind values in the specified statement.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

setValueInStatement

public static void setValueInStatement(LibrarySessionInterface session,
                                       IfsPreparedStatement stmt,
                                       AttributeValue av,
                                       int position)
                                throws IfsException,
                                       SQLException

Set bind values in the specified statement.

Parameters:

session - the session context

stmt - the statement

av - the value

position - the position in the statement

Throws:

IfsException - if operation fails

SQLException - if operation fails

(Published)

getValueFromResultSet

public static AttributeValue getValueFromResultSet(ResultSet rset,
                                                   int position,
                                                   int dataType)
                                            throws IfsException,
                                                   SQLException

Gets the value from a ResultSet.

This variant can be used for all scalar types except for SimpleObject. For non-scalar types and for SimpleObject types, use the full variant.

Parameters:

rset - the result set

position - the position in the resultSet

dataType - the column's data type

Returns:

the value at the specified position

Throws:

IfsException - if operation fails

SQLException - if operation fails

(Published)

getValueFromResultSet

public static AttributeValue getValueFromResultSet(ResultSet rset,
                                                   int position,
                                                   int dataType,
                                                   Long attrId,
                                                   long objectId,
                                                   Long priClassId)
                                            throws IfsException,
                                                   SQLException

Gets the value from a ResultSet - for complex data types.

This variant must be used for array types and for SimpleObject types.

Parameters:

rset - the result set

position - the position in the resultSet

dataType - the column's data type

attrId - if this AttributeValue represents the value of a LibraryObject's Attribute, this is the id of that Attribute

objectId - the objectId associated with this resultSet

priClassId - the class ID reflecting a ClassDomain setting

Returns:

the value at the specified position

Throws:

IfsException - if operation fails

SQLException - if operation fails

(Published)