The PreparedStatement class represents a precompiled SQL statement.
The PreparedStatement class defines the following methods.
|
|
|
|
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):Object
|
Object
|
Sets a designated parameter to the given Timestamp value.
|