iAnywhere.com - PreparedStatement class

PreparedStatement class

Represents a pre-compiled SQL statement with or without IN parameters.

Prototypes

' Visual Basic
Public Class PreparedStatement

// C#
public class PreparedStatement

Remarks

This class cannot be directly instantiated. Prepared statements are created using the PrepareStatement method method of the Connection class class. This object can then be used to efficiently execute this statement multiple times.

When a prepared statement is closed, all ResultSet and ResultSetSchema objects associated with it are also closed. PreparedStatement objects are closed when they are garbage collected. However, since all ResultSet and ResultSetSchema objects reference their prepared statement, the prepared statement will not be garbage collected until all its open ResultSet and ResultSetSchema objects are ready for garbage collection.

For resource management reasons, it is recommended that you explicitly close prepared statements when you are done with them.