JDBC 更新数据结构集操作

查询结果集是否支持更新操作

try {

        DatabaseMetaData dmd = connection.getMetaData();

        if (dmd.supportsResultSetConcurrency(

            ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_UPDATABLE)) {

            // Updatable result sets are supported

        } else {

            // Updatable result sets are not supported

        }

    } catch (SQLException e) {

    }

创建一个可以更新的结果集

try {

        // Create a statement that will return updatable result sets

        Statement stmt = connection.createStatement(

            ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);

        // Primary key col_string must be specified so that the result set is updatable

        ResultSet resultSet = stmt.executeQuery("SELECT col_string FROM my_table");

    } catch (SQLException e) {

    }