Java by API/javax.sql/RowSet

RowSet: setCommand(String cmd)

   <source lang="java">

import javax.sql.rowset.CachedRowSet; public class Main {

 public static void main(String[] args) throws Exception {
   CachedRowSet rs;
   String ROWSET_IMPL_CLASS = "com.sun.rowset.CachedRowSetImpl";
   
   
   Class c = Class.forName(ROWSET_IMPL_CLASS);
   rs = (CachedRowSet) c.newInstance();
   rs.setUrl("jdbc:postgresql:dbname");
   rs.setUsername("username");
   rs.setPassword("password");
   rs.setCommand("select * from members where name like ?");
   rs.setString(1, "I%");
   rs.execute();
   while (rs.next()) {
     if (rs.getInt("id") == 42) {
       rs.setString(1, "newString");
       rs.updateRow(); // Normal JDBC
       rs.acceptChanges();
     }
   }
   rs.close();
 }

}

      </source>
   
  
 
  

RowSet: setPassword(String password)

   <source lang="java">

import javax.sql.rowset.CachedRowSet; public class Main {

 public static void main(String[] args) throws Exception {
   CachedRowSet rs;
   String ROWSET_IMPL_CLASS = "com.sun.rowset.CachedRowSetImpl";
   
   
   Class c = Class.forName(ROWSET_IMPL_CLASS);
   rs = (CachedRowSet) c.newInstance();
   rs.setUrl("jdbc:postgresql:dbname");
   rs.setUsername("username");
   rs.setPassword("password");
   rs.setCommand("select * from members where name like ?");
   rs.setString(1, "I%");
   rs.execute();
   while (rs.next()) {
     if (rs.getInt("id") == 42) {
       rs.setString(1, "newString");
       rs.updateRow(); // Normal JDBC
       rs.acceptChanges();
     }
   }
   rs.close();
 }

}

      </source>
   
  
 
  

RowSet: setString(int parameterIndex, String x)

   <source lang="java">

import javax.sql.rowset.CachedRowSet; public class Main {

 public static void main(String[] args) throws Exception {
   CachedRowSet rs;
   String ROWSET_IMPL_CLASS = "com.sun.rowset.CachedRowSetImpl";
   
   
   Class c = Class.forName(ROWSET_IMPL_CLASS);
   rs = (CachedRowSet) c.newInstance();
   rs.setUrl("jdbc:postgresql:dbname");
   rs.setUsername("username");
   rs.setPassword("password");
   rs.setCommand("select * from members where name like ?");
   rs.setString(1, "I%");
   rs.execute();
   while (rs.next()) {
     if (rs.getInt("id") == 42) {
       rs.setString(1, "newString");
       rs.updateRow(); // Normal JDBC
       rs.acceptChanges();
     }
   }
   rs.close();
 }

}

      </source>
   
  
 
  

RowSet: setUrl(String url)

   <source lang="java">

import javax.sql.rowset.CachedRowSet; public class Main {

 public static void main(String[] args) throws Exception {
   CachedRowSet rs;
   String ROWSET_IMPL_CLASS = "com.sun.rowset.CachedRowSetImpl";
   
   
   Class c = Class.forName(ROWSET_IMPL_CLASS);
   rs = (CachedRowSet) c.newInstance();
   rs.setUrl("jdbc:postgresql:dbname");
   rs.setUsername("username");
   rs.setPassword("password");
   rs.setCommand("select * from members where name like ?");
   rs.setString(1, "I%");
   rs.execute();
   while (rs.next()) {
     if (rs.getInt("id") == 42) {
       rs.setString(1, "newString");
       rs.updateRow(); // Normal JDBC
       rs.acceptChanges();
     }
   }
   rs.close();
 }

}

      </source>
   
  
 
  

RowSet: setUsername(String name)

   <source lang="java">

import javax.sql.rowset.CachedRowSet; public class Main {

 public static void main(String[] args) throws Exception {
   CachedRowSet rs;
   String ROWSET_IMPL_CLASS = "com.sun.rowset.CachedRowSetImpl";
   
   
   Class c = Class.forName(ROWSET_IMPL_CLASS);
   rs = (CachedRowSet) c.newInstance();
   rs.setUrl("jdbc:postgresql:dbname");
   rs.setUsername("username");
   rs.setPassword("password");
   rs.setCommand("select * from members where name like ?");
   rs.setString(1, "I%");
   rs.execute();
   while (rs.next()) {
     if (rs.getInt("id") == 42) {
       rs.setString(1, "newString");
       rs.updateRow(); // Normal JDBC
       rs.acceptChanges();
     }
   }
   rs.close();
 }

}

      </source>