Inserting a Row into a Database Table Using an Updatable Result Set
An updatable result supports a row called the insert row. It is a
buffer for holding the values of a new row. After the fields in the
insert row are filled, the new row can be inserted into the
database using Result.insertRow().
try {
// Create an updatable result set
Statement stmt = connection.createStatement(
ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
ResultSet resultSet = stmt.executeQuery("SELECT * FROM my_table");
// Move cursor to the "insert row"
resultSet.moveToInsertRow();
// Set values for the new row.
resultSet.updateString("col_string", "new data");
// Insert the row
resultSet.insertRow();
} catch (SQLException e) {
}
Post a comment