Executing SQL Statements

• Use the executeUpdate method of the Statement class to execute an UPDATE statement
• The method returns the number of rows effected

  String command = "UPDATE Item"
        + " SET Quantity = Quantity + 1"
        + " WHERE Invoice_Number = '11731'";
  int count = stat.executeUpdate(command);