Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » UltraLiteJ » UltraLiteJ Reference » UltraLiteJ API reference

 

CollectionOfValueWriters interface

Provides methods to set the column value of a given row.

Syntax
public CollectionOfValueWriters
Derived classes
Remarks

All methods are prepared based on a SQL statement, which is defined in the initial declaration of a PreparedStatement, and are applied to the database with the execute method.

When updating a column value, you must reference the column by the order number as it appears in the prepared SQL statement. This number is passed as an integer parameter, ordinal, which has a base index of one.

The following example demonstrates how to declare a new PreparedStatement with a SQL UPDATE statement, prepare your change using the set method, and apply those changes to the UltraLite database.

// Define a new prepared SQL statement.
String sql_string = "UPDATE SampleTable SET column1 = ? WHERE pkey = 1";

// Create a new PreparedStatement from an existing connection.
PreparedStatement ps = conn.prepareStatement(sql_string);

// Set a String value to the first column in the SQL statement (column1).
ps.set(1, "New Value");

// Commit the changes to the database.
conn.commit();
Members

All members of CollectionOfValueWriters, including all inherited members.


getBlobOutputStream method
getClobWriter method
getOrdinal method
set method
set method
set method
set method
set method
set method
set method
set method
set method
set method
setNull method