要看具体的数据库是否支持createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
比如Oracle 数据库就是这样的:
Oracle中可滚动的结果集有下列限制:
Support Type Concurrency
---------------------------------------------------------------- no TYPE_FORWARD_ONLY CONCUR_READ_ONLY
no TYPE_FORWARD_ONLY CONCUR_UPDATABLE
no TYPE_SCROLL_INSENSITIVE CONCUR_READ_ONLY
yes TYPE_SCROLL_INSENSITIVE CONCUR_UPDATABLE
yes TYPE_SCROLL_SENSITIVE CONCUR_READ_ONLY
yes TYPE_SCROLL_SENSITIVE CONCUR_UPDATABLE
----------------------------------------------------------------
ResultSet.CONCUR_UPDATABLE);
比如Oracle 数据库就是这样的:
Oracle中可滚动的结果集有下列限制:
Support Type Concurrency
---------------------------------------------------------------- no TYPE_FORWARD_ONLY CONCUR_READ_ONLY
no TYPE_FORWARD_ONLY CONCUR_UPDATABLE
no TYPE_SCROLL_INSENSITIVE CONCUR_READ_ONLY
yes TYPE_SCROLL_INSENSITIVE CONCUR_UPDATABLE
yes TYPE_SCROLL_SENSITIVE CONCUR_READ_ONLY
yes TYPE_SCROLL_SENSITIVE CONCUR_UPDATABLE
----------------------------------------------------------------
ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_UPDATABLE