java - Difference between CONCUR_UPDATABLE and RowSet -
are there difference(advantages or disadvatages) between using concure_updatable , jdbcrowset make changes database?
1.
statement stmt = conn.createstatement(resultset.type_scroll_insensitive, resultset.concur_updatable); resultset set = stmt.executequery("select * book"); set.absolute(2); set.deleterow(); 2.
rowsetfactory factory = rowsetprovider.newfactory(); jdbcrowset rowset = factory.createjdbcrowset(); ..... rowset.setcommand("select * book"); rowset.execute(); rowset.absolute(2); rowset.deleterow();
all rowset objects default scrollable , updatable. if driver , database being used not support scrolling and/or updating of result sets, application can populate jdbcrowset object data of resultset object , operate on jdbcrowset object if resultset object. - enthuware
Comments
Post a Comment