Native UltraLite for Java User's Guide
Understanding UltraLite Development
Accessing and manipulating data with dynamic SQL
To perform SQL Data Manipulation Language operations (INSERT, UPDATE, and DELETE), you carry out the following sequence of operations:
Prepare the statement.
You can indicate parameters in the statement using the ? character.
Assign values for parameters in the statement.
For any INSERT, UPDATE or DELETE, each ? is referred to by its ordinal position in the prepared statement.
Execute the statement.
Repeat steps 2 and 3 as required.
To perform INSERT operations using ExecuteStatement:
Declare a PreparedStatement.
PreparedStatement prepStmt;
Assign a SQL statement to the PreparedStatement object.
prepStmt = conn.prepareStatement( "INSERT INTO MyTable(MyColumn) values (?)");
Assign input parameter values for the statement.
The following code shows a string parameter.
String newValue; // assign value prepStmt.setStringParameter(1, newValue);
Execute the statement.
The return value indicates the number of rows affected by the statement.
long rowsInserted = prepStmt.executeStatement();
If you have set autoCommit to off, commit the change.
conn.commit();
To perform UPDATE operations using ExecuteStatement:
Declare a PreparedStatement.
PreparedStatement prepStmt;
Assign a statement to the PreparedStatement object.
prepStmt = conn.prepareStatement( "UPDATE MyTable SET MyColumn1 = ? WHERE MyColumn2 = ?");
Assign input parameter values for the statement.
String newValue; String oldValue; // assign values prepStmt.setStringParameter( 1, newValue ); prepStmt.setStringParameter( 2, oldValue );
Execute the statement.
long rowsUpdated = prepStmt.executeStatement();
If you have set autoCommit to off, commit the change.
conn.commit();
To perform DELETE operations using ExecuteStatement:
Declare a PreparedStatement.
PreparedStatement prepStmt;
Assign a statement to the PreparedStatement object.
prepStmt = conn.prepareStatement( "DELETE FROM MyTable WHERE MyColumn = ?");
Assign input parameter values for the statement.
String deleteValue; prepStmt.setStringParameter(1, deleteValue);
Execute the statement.
long rowsDeleted = prepStmt.executeStatement();
If you have set autoCommit to off, commit the change.
conn.commit();