beautypg.com

Description, Query (with preparedstatement), Synopsis – Sun Microsystems Sun StorageTek 5800 User Manual

Page 35: Query (with preparedstatement and selectkeys), Query (with preparedstatement ), Query (with preparedstatement and selectkeys )

background image

Description

Takes a where clause and a select clause and returns a QueryResultSet of NameValueRecord
instances containing the selected values.

selectKeys

identifies the values to be returned, functioning as an SQL select clause.

The query parameter is a where clause in the 5800 system query syntax, which is a subset of SQL.

Returns a QueryResultSet. The results are stepped through by calling the next method and
using the getObjectIdentifier accessor.

Note –

For more information on the 5800 system query language, refer to

Chapter 4, “Sun

StorageTek 5800 System Query Language.”

query

(with PreparedStatement)

Returns the OIDs of metadata records matching the query as a QueryResultSet instance.

Synopsis

public QueryResultSet query(PreparedStatement query,

int resultsPerFetch)

Description

Takes a PreparedStatement and returns a QueryResultSet of SystemRecord instances
containing MetadataRecord OIDs.

The PreparedStatement parameter enables queries with dynamic parameters to pass typed
data items to the query.

Returns a QueryResultSet. The results are stepped through by calling the next method and
using the typed getXXX accessor methods.

Note –

For more information on the 5800 system query language, refer to

Chapter 4, “Sun

StorageTek 5800 System Query Language.”

query

(with PreparedStatement and selectKeys)

Returns specified fields from metadata records matching the query as a QueryResultSet
instance.

Java API

Chapter 2 • Sun StorageTek 5800 System Java Client API

35