5.1

Method Returns Description
getConnection(string,string,str
ing):Connection
Connection
The three strings represent URL, user
name, and password.
PreparedStatement Class
The PreparedStatement class represents a precompiled SQL statement.
The PreparedStatement class defines the following methods.
Method Returns Description
execute():boolean Boolean
Runs an SQL statement in the
PreparedStatement object.
executeQuery():ResultSet ResultSet
Runs an SQL query in the
PreparedStatement object and returns
the ResultSet object generated by the
query.
executeUpdate():number Number
Runs an SQL INSERT, UPDATE, or
DELETE statement, or an SQL
statement that returns nothing, in the
PreparedStatement object.
setDate(number,object):Object Object
Sets a designated parameter to the given
Date value.
setString(number,object):Object Object
Sets a designated parameter to the given
String value.
setTimestamp(number,object):Obj
ect
Object
Sets a designated parameter to the given
Timestamp value.
ResultSet Class
The ResultSet class is the result of a run of an executeQuery method.
The ResultSet class defines the following methods.
Method Returns Description
afterLast():Object Object
Moves the cursor to the end of the
ResultSet object, after the last row.
This method has no effect if the result
set contains no rows.
beforeFirst():Object Object
Moves the cursor to the front of the
ResultSet object, before the first row.
This method has no effect if the result
set contains no rows.
first():boolean Boolean
Moves the cursor to the first row in the
ResultSet object. Returns true if the
cursor is on a valid row, and false if
there are no rows in the result set.
getDate(string):Object Object
Returns the Date value of a given
column name.
getDateAt(number):Object Object
Returns the Date value of a given
column index.
getNumber(string):number Number
Returns the Number value of a given
column name.
Using VMware vCenter Orchestrator Plug-Ins
36 VMware, Inc.