package com.javaorigin.jdbc.sample.cachedrowset;

import javax.sql.rowset.CachedRowSet;

import com.sun.rowset.CachedRowSetImpl;

public class UpdateCachedRowSet {	

	  public static void main(String[] args) throws Exception {
	    CachedRowSet rs=new CachedRowSetImpl();
	    Class.forName("oracle.jdbc.driver.OracleDriver");
	    rs.setUrl("jdbc:oracle:thin:@javaorigin.com:1521:orcl");
	    rs.setUsername("mydb");
	    rs.setPassword("password123");
	    rs.setCommand("select * from users where userid=?");
	    rs.setString(1, "%");
	    rs.execute();
	 
	    while (rs.next()) {
	      if (rs.getString("usrid").equals("Arun")) {
	          rs.setString("usrid", "Arunkumar");
	          rs.updateRow(); 	       
	          rs.acceptChanges();
	      }
	    }	   
	    rs.close();
	  }
	
}