e277. inserting a row into a database table using an updatable result set.txt

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

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