![]() |
The Java Developers Almanac 1.4Order this book from Amazon. |
e261. Updating a Row in a Database TableThis example updates a row in a table.try { Statement stmt = connection.createStatement(); // Prepare a statement to update a record String sql = "UPDATE my_table SET col_string='a new string' WHERE col_string = 'a string'"; // Execute the insert statement int updateCount = stmt.executeUpdate(sql); // updateCount contains the number of updated rows } catch (SQLException e) { }
e259. Inserting a Row into a Database Table Using a Prepared Statement e260. Getting and Inserting Binary Data into an Database Table © 2002 Addison-Wesley. |