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