e261. updating a row in a database table.txt

来自「这里面包含了一百多个JAVA源文件」· 文本 代码 · 共 14 行

This 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) {
    }