2.2   JdbcRowSet

o       The following line of code creates an empty JdbcRowSet object.

    JdbcRowSet jrs = new JdbcRowSetImpl();

    jrs.setCommand("SELECT * FROM TITLES);

    jrs.setURL("jdbc:myDriver:myAttribute");

    jrs.setUsername("cervantes");

    jrs.setPassword("sancho");

    jrs.execute();

o       Using a JdbcRowSet Object

      jdbcRs.setCommand("select * from COFFEES");

      jdbcRs.execute();

      jdbcRs.beforeFirst();

      while (jdbcRs.next()) {

String name = jdbcRs.getString("COF_NAME");

BigDecimal price = jdbcRs.getBigDecimal("PRICE");

System.out.println(name + " " + price);

}

o       Updating  a JdbcRowSet Object

         jdbcRs.absolute(3);

 jdbcRs.updateBigDecimal("PRICE", new BigDecimal("10.99"));

 jdbcRs.updateRow();

                                         or with Sql

                                                jdbcRs.setCommand ("UPDATE  .... SET....

                                                jdbcRs.execute();

o       Inserting a Row

jdbcRs.moveToInsertRow();

jdbcRs.updateString("COF_NAME", "House_Blend");

jdbcRs.updateInt("SUP_ID", 49);

jdbcRs.updateBigDecimal("PRICE", new BigDecimal("7.99"));

jdbcRs.updateInt("SALES", 0);

jdbcRs.updateInt("TOTAL", 0);

jdbcRs.insertRow();

jdbcRs.moveToCurrentRow();

or with Sql

                                                jdbcRs.setCommand ("INSERT INTO....

                                                jdbcRs.execute();

o       Deleting a Row

jdbcRs.last();

jdbcRs.deleteRow();

or with Sql

                                                jdbcRs.setCommand ("DELETE FROM....

                                                jdbcRs.execute();