Adding Rows To a Table by Using the SQL INSERT Statement

Procedure

  1. Formulate a SQL INSERT string for adding rows of data to a table.
  2. Call the createStatement() method of the Session object. Pass the SQL INSERT string as an argument.
  3. If the SQL INSERT string contains parameter markers, call the Statement methods to set the parameter values.
  4. Run the INSERT statement by calling the executeUpdate() method of the Statement object.
  5. Check the result of the executeUpdate() method to verify that the correct number of rows have been inserted into the table.
  6. Optional: Set different parameter values and rerun the INSERT statement by repeating steps Step 3 to Step 5.
  7. Close the Statement object.
Related concepts