Java by API/javax.sql.rowset/CacheRowSet

Материал из Java эксперт
Перейти к: навигация, поиск

CachedRowSet: acceptChanges()

   <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>



CachedRowSet: close()

   <source lang="java">

/* 

* Copyright (c) Ian F. Darwin, http://www.darwinsys.ru/, 1996-2002.
* All rights reserved. Software written by Ian F. Darwin and others.
* $Id: LICENSE,v 1.8 2004/02/09 03:33:38 ian Exp $
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions
* are met:
* 1. Redistributions of source code must retain the above copyright
*    notice, this list of conditions and the following disclaimer.
* 2. Redistributions in binary form must reproduce the above copyright
*    notice, this list of conditions and the following disclaimer in the
*    documentation and/or other materials provided with the distribution.
*
* THIS SOFTWARE IS PROVIDED BY THE AUTHOR AND CONTRIBUTORS ``AS IS""
* AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED
* TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
* PURPOSE ARE DISCLAIMED.  IN NO EVENT SHALL THE AUTHOR OR CONTRIBUTORS
* BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
* CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
* SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
* INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
* CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
* ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
* POSSIBILITY OF SUCH DAMAGE.
* 
* Java, the Duke mascot, and all variants of Sun"s Java "steaming coffee
* cup" logo are trademarks of Sun Microsystems. Sun"s, and James Gosling"s,
* pioneering role in inventing and promulgating (and standardizing) the Java 
* language and environment is gratefully acknowledged.
* 
* The pioneering role of Dennis Ritchie and Bjarne Stroustrup, of AT&T, for
* inventing predecessor languages C and C++ is also gratefully acknowledged.
*/

import javax.sql.rowset.CachedRowSet; /** 

* Demonstrate simple use of the CachedRowSet. The RowSet family of interfaces
* is in JDK1.5, but the Implementation classes are (as of Beta 1) still in the
* unsupported "com.sun" package.
*/

public class Main { 

 public static final String ROWSET_IMPL_CLASS = "com.sun.rowset.CachedRowSetImpl";
 public static void main(String[] args) throws Exception {
   CachedRowSet rs;
   // Create the class with class.forName to avoid importing
   // from the unsupported com.sun packages.
   Class c = Class.forName(ROWSET_IMPL_CLASS);
   rs = (CachedRowSet) c.newInstance();
   rs.setUrl("jdbc:postgresql:tmclub");
   rs.setUsername("ian");
   rs.setPassword("secret");
   rs.setCommand("select * from members where name like ?");
   rs.setString(1, "I%");
   // This will cause the RowSet to connect, fetch its data, and
   // disconnect
   rs.execute();
   // Some time later, the client tries to do something.
   // Suppose we want to update data:
   while (rs.next()) {
     if (rs.getInt("id") == 42) {
       rs.setString(1, "Marvin");
       rs.updateRow(); // Normal JDBC
       // This additional call tells the CachedRowSet to connect
       // to its database and send the updated data back.
       rs.acceptChanges();
     }
   }
   // If we"re all done...
   rs.close();
 }

} 


 </source>



CachedRowSet: execute()

   <source lang="java">

/* 

* Copyright (c) Ian F. Darwin, http://www.darwinsys.ru/, 1996-2002.
* All rights reserved. Software written by Ian F. Darwin and others.
* $Id: LICENSE,v 1.8 2004/02/09 03:33:38 ian Exp $
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions
* are met:
* 1. Redistributions of source code must retain the above copyright
*    notice, this list of conditions and the following disclaimer.
* 2. Redistributions in binary form must reproduce the above copyright
*    notice, this list of conditions and the following disclaimer in the
*    documentation and/or other materials provided with the distribution.
*
* THIS SOFTWARE IS PROVIDED BY THE AUTHOR AND CONTRIBUTORS ``AS IS""
* AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED
* TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
* PURPOSE ARE DISCLAIMED.  IN NO EVENT SHALL THE AUTHOR OR CONTRIBUTORS
* BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
* CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
* SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
* INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
* CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
* ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
* POSSIBILITY OF SUCH DAMAGE.
* 
* Java, the Duke mascot, and all variants of Sun"s Java "steaming coffee
* cup" logo are trademarks of Sun Microsystems. Sun"s, and James Gosling"s,
* pioneering role in inventing and promulgating (and standardizing) the Java 
* language and environment is gratefully acknowledged.
* 
* The pioneering role of Dennis Ritchie and Bjarne Stroustrup, of AT&T, for
* inventing predecessor languages C and C++ is also gratefully acknowledged.
*/

import javax.sql.rowset.CachedRowSet; /** 

* Demonstrate simple use of the CachedRowSet. The RowSet family of interfaces
* is in JDK1.5, but the Implementation classes are (as of Beta 1) still in the
* unsupported "com.sun" package.
*/

public class Main { 

 public static final String ROWSET_IMPL_CLASS = "com.sun.rowset.CachedRowSetImpl";
 public static void main(String[] args) throws Exception {
   CachedRowSet rs;
   // Create the class with class.forName to avoid importing
   // from the unsupported com.sun packages.
   Class c = Class.forName(ROWSET_IMPL_CLASS);
   rs = (CachedRowSet) c.newInstance();
   rs.setUrl("jdbc:postgresql:tmclub");
   rs.setUsername("ian");
   rs.setPassword("secret");
   rs.setCommand("select * from members where name like ?");
   rs.setString(1, "I%");
   // This will cause the RowSet to connect, fetch its data, and
   // disconnect
   rs.execute();
   // Some time later, the client tries to do something.
   // Suppose we want to update data:
   while (rs.next()) {
     if (rs.getInt("id") == 42) {
       rs.setString(1, "Marvin");
       rs.updateRow(); // Normal JDBC
       // This additional call tells the CachedRowSet to connect
       // to its database and send the updated data back.
       rs.acceptChanges();
     }
   }
   // If we"re all done...
   rs.close();
 }

} 


 </source>



CachedRowSet: setCommand(String cmd)

   <source lang="java">

/* 

* Copyright (c) Ian F. Darwin, http://www.darwinsys.ru/, 1996-2002.
* All rights reserved. Software written by Ian F. Darwin and others.
* $Id: LICENSE,v 1.8 2004/02/09 03:33:38 ian Exp $
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions
* are met:
* 1. Redistributions of source code must retain the above copyright
*    notice, this list of conditions and the following disclaimer.
* 2. Redistributions in binary form must reproduce the above copyright
*    notice, this list of conditions and the following disclaimer in the
*    documentation and/or other materials provided with the distribution.
*
* THIS SOFTWARE IS PROVIDED BY THE AUTHOR AND CONTRIBUTORS ``AS IS""
* AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED
* TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
* PURPOSE ARE DISCLAIMED.  IN NO EVENT SHALL THE AUTHOR OR CONTRIBUTORS
* BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
* CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
* SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
* INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
* CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
* ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
* POSSIBILITY OF SUCH DAMAGE.
* 
* Java, the Duke mascot, and all variants of Sun"s Java "steaming coffee
* cup" logo are trademarks of Sun Microsystems. Sun"s, and James Gosling"s,
* pioneering role in inventing and promulgating (and standardizing) the Java 
* language and environment is gratefully acknowledged.
* 
* The pioneering role of Dennis Ritchie and Bjarne Stroustrup, of AT&T, for
* inventing predecessor languages C and C++ is also gratefully acknowledged.
*/

import javax.sql.rowset.CachedRowSet; /** 

* Demonstrate simple use of the CachedRowSet. The RowSet family of interfaces
* is in JDK1.5, but the Implementation classes are (as of Beta 1) still in the
* unsupported "com.sun" package.
*/

public class Main { 

 public static final String ROWSET_IMPL_CLASS = "com.sun.rowset.CachedRowSetImpl";
 public static void main(String[] args) throws Exception {
   CachedRowSet rs;
   // Create the class with class.forName to avoid importing
   // from the unsupported com.sun packages.
   Class c = Class.forName(ROWSET_IMPL_CLASS);
   rs = (CachedRowSet) c.newInstance();
   rs.setUrl("jdbc:postgresql:tmclub");
   rs.setUsername("ian");
   rs.setPassword("secret");
   rs.setCommand("select * from members where name like ?");
   rs.setString(1, "I%");
   // This will cause the RowSet to connect, fetch its data, and
   // disconnect
   rs.execute();
   // Some time later, the client tries to do something.
   // Suppose we want to update data:
   while (rs.next()) {
     if (rs.getInt("id") == 42) {
       rs.setString(1, "Marvin");
       rs.updateRow(); // Normal JDBC
       // This additional call tells the CachedRowSet to connect
       // to its database and send the updated data back.
       rs.acceptChanges();
     }
   }
   // If we"re all done...
   rs.close();
 }

} 


 </source>



CachedRowSet: setMetaData(RowSetMetaData md)

   <source lang="java">

import java.sql.Connection; import java.sql.DriverManager; import java.sql.Statement; import java.sql.Types; import javax.sql.RowSetMetaData; import javax.sql.rowset.CachedRowSet; import javax.sql.rowset.RowSetMetaDataImpl; import com.sun.rowset.CachedRowSetImpl; public class Main { 

 public static void main(String[] args) throws Exception {
   Connection conn = getHSQLConnection();
   System.out.println("Got Connection.");
   Statement st = conn.createStatement();
   st.executeUpdate("create table survey (id int,name varchar);");
   st.executeUpdate("create view surveyView as (select * from survey);");
   st.executeUpdate("insert into survey (id,name ) values (1,"nameValue")");
   st.executeUpdate("insert into survey (id,name ) values (2,"anotherValue")");    
   
   CachedRowSet crs = null;
   RowSetMetaData rsMD = new RowSetMetaDataImpl();
   rsMD.setColumnCount(2);
   rsMD.setColumnName(1, "id");
   rsMD.setColumnType(1, Types.VARCHAR);
   rsMD.setColumnName(2, "name");
   rsMD.setColumnType(2, Types.VARCHAR);
   // sets the designated column"s table name, if any, to the given String.
   rsMD.setTableName(1, "survey");
   rsMD.setTableName(2, "survey");
   // use a custom made RowSetMetaData object for CachedRowSet object
   crs = new CachedRowSetImpl();
   crs.setMetaData(rsMD);
   crs.moveToInsertRow();
   crs.updateString(1, "1111");
   crs.updateString(2, "alex");
   crs.insertRow();
   crs.moveToInsertRow();
   crs.updateString(1, "2222");
   crs.updateString(2, "jane");
   crs.insertRow();
   crs.moveToCurrentRow();
   crs.acceptChanges(conn);
   conn.close();
 }
 private static Connection getHSQLConnection() throws Exception {
   Class.forName("org.hsqldb.jdbcDriver");
   System.out.println("Driver Loaded.");
   String url = "jdbc:hsqldb:data/tutorial";
   return DriverManager.getConnection(url, "sa", "");
 }
 public static Connection getMySqlConnection() throws Exception {
   String driver = "org.gjt.mm.mysql.Driver";
   String url = "jdbc:mysql://localhost/demo2s";
   String username = "oost";
   String password = "oost";
   Class.forName(driver);
   Connection conn = DriverManager.getConnection(url, username, password);
   return conn;
 }
 public static Connection getOracleConnection() throws Exception {
   String driver = "oracle.jdbc.driver.OracleDriver";
   String url = "jdbc:oracle:thin:@localhost:1521:caspian";
   String username = "mp";
   String password = "mp2";
   Class.forName(driver); // load Oracle driver
   Connection conn = DriverManager.getConnection(url, username, password);
   return conn;
 }

} 


 </source>



CachedRowSet: setPassword(String password)

   <source lang="java">

/* 

* Copyright (c) Ian F. Darwin, http://www.darwinsys.ru/, 1996-2002.
* All rights reserved. Software written by Ian F. Darwin and others.
* $Id: LICENSE,v 1.8 2004/02/09 03:33:38 ian Exp $
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions
* are met:
* 1. Redistributions of source code must retain the above copyright
*    notice, this list of conditions and the following disclaimer.
* 2. Redistributions in binary form must reproduce the above copyright
*    notice, this list of conditions and the following disclaimer in the
*    documentation and/or other materials provided with the distribution.
*
* THIS SOFTWARE IS PROVIDED BY THE AUTHOR AND CONTRIBUTORS ``AS IS""
* AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED
* TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
* PURPOSE ARE DISCLAIMED.  IN NO EVENT SHALL THE AUTHOR OR CONTRIBUTORS
* BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
* CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
* SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
* INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
* CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
* ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
* POSSIBILITY OF SUCH DAMAGE.
* 
* Java, the Duke mascot, and all variants of Sun"s Java "steaming coffee
* cup" logo are trademarks of Sun Microsystems. Sun"s, and James Gosling"s,
* pioneering role in inventing and promulgating (and standardizing) the Java 
* language and environment is gratefully acknowledged.
* 
* The pioneering role of Dennis Ritchie and Bjarne Stroustrup, of AT&T, for
* inventing predecessor languages C and C++ is also gratefully acknowledged.
*/

import javax.sql.rowset.CachedRowSet; /** 

* Demonstrate simple use of the CachedRowSet. The RowSet family of interfaces
* is in JDK1.5, but the Implementation classes are (as of Beta 1) still in the
* unsupported "com.sun" package.
*/

public class Main { 

 public static final String ROWSET_IMPL_CLASS = "com.sun.rowset.CachedRowSetImpl";
 public static void main(String[] args) throws Exception {
   CachedRowSet rs;
   // Create the class with class.forName to avoid importing
   // from the unsupported com.sun packages.
   Class c = Class.forName(ROWSET_IMPL_CLASS);
   rs = (CachedRowSet) c.newInstance();
   rs.setUrl("jdbc:postgresql:tmclub");
   rs.setUsername("ian");
   rs.setPassword("secret");
   rs.setCommand("select * from members where name like ?");
   rs.setString(1, "I%");
   // This will cause the RowSet to connect, fetch its data, and
   // disconnect
   rs.execute();
   // Some time later, the client tries to do something.
   // Suppose we want to update data:
   while (rs.next()) {
     if (rs.getInt("id") == 42) {
       rs.setString(1, "Marvin");
       rs.updateRow(); // Normal JDBC
       // This additional call tells the CachedRowSet to connect
       // to its database and send the updated data back.
       rs.acceptChanges();
     }
   }
   // If we"re all done...
   rs.close();
 }

} 


 </source>



CachedRowSet: setString(int parameterIndex, String x)

   <source lang="java">

/* 

* Copyright (c) Ian F. Darwin, http://www.darwinsys.ru/, 1996-2002.
* All rights reserved. Software written by Ian F. Darwin and others.
* $Id: LICENSE,v 1.8 2004/02/09 03:33:38 ian Exp $
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions
* are met:
* 1. Redistributions of source code must retain the above copyright
*    notice, this list of conditions and the following disclaimer.
* 2. Redistributions in binary form must reproduce the above copyright
*    notice, this list of conditions and the following disclaimer in the
*    documentation and/or other materials provided with the distribution.
*
* THIS SOFTWARE IS PROVIDED BY THE AUTHOR AND CONTRIBUTORS ``AS IS""
* AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED
* TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
* PURPOSE ARE DISCLAIMED.  IN NO EVENT SHALL THE AUTHOR OR CONTRIBUTORS
* BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
* CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
* SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
* INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
* CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
* ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
* POSSIBILITY OF SUCH DAMAGE.
* 
* Java, the Duke mascot, and all variants of Sun"s Java "steaming coffee
* cup" logo are trademarks of Sun Microsystems. Sun"s, and James Gosling"s,
* pioneering role in inventing and promulgating (and standardizing) the Java 
* language and environment is gratefully acknowledged.
* 
* The pioneering role of Dennis Ritchie and Bjarne Stroustrup, of AT&T, for
* inventing predecessor languages C and C++ is also gratefully acknowledged.
*/

import javax.sql.rowset.CachedRowSet; /** 

* Demonstrate simple use of the CachedRowSet. The RowSet family of interfaces
* is in JDK1.5, but the Implementation classes are (as of Beta 1) still in the
* unsupported "com.sun" package.
*/

public class Main { 

 public static final String ROWSET_IMPL_CLASS = "com.sun.rowset.CachedRowSetImpl";
 public static void main(String[] args) throws Exception {
   CachedRowSet rs;
   // Create the class with class.forName to avoid importing
   // from the unsupported com.sun packages.
   Class c = Class.forName(ROWSET_IMPL_CLASS);
   rs = (CachedRowSet) c.newInstance();
   rs.setUrl("jdbc:postgresql:tmclub");
   rs.setUsername("ian");
   rs.setPassword("secret");
   rs.setCommand("select * from members where name like ?");
   rs.setString(1, "I%");
   // This will cause the RowSet to connect, fetch its data, and
   // disconnect
   rs.execute();
   // Some time later, the client tries to do something.
   // Suppose we want to update data:
   while (rs.next()) {
     if (rs.getInt("id") == 42) {
       rs.setString(1, "Marvin");
       rs.updateRow(); // Normal JDBC
       // This additional call tells the CachedRowSet to connect
       // to its database and send the updated data back.
       rs.acceptChanges();
     }
   }
   // If we"re all done...
   rs.close();
 }

} 


 </source>



CachedRowSet: setUrl(String url)

   <source lang="java">

/* 

* Copyright (c) Ian F. Darwin, http://www.darwinsys.ru/, 1996-2002.
* All rights reserved. Software written by Ian F. Darwin and others.
* $Id: LICENSE,v 1.8 2004/02/09 03:33:38 ian Exp $
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions
* are met:
* 1. Redistributions of source code must retain the above copyright
*    notice, this list of conditions and the following disclaimer.
* 2. Redistributions in binary form must reproduce the above copyright
*    notice, this list of conditions and the following disclaimer in the
*    documentation and/or other materials provided with the distribution.
*
* THIS SOFTWARE IS PROVIDED BY THE AUTHOR AND CONTRIBUTORS ``AS IS""
* AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED
* TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
* PURPOSE ARE DISCLAIMED.  IN NO EVENT SHALL THE AUTHOR OR CONTRIBUTORS
* BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
* CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
* SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
* INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
* CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
* ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
* POSSIBILITY OF SUCH DAMAGE.
* 
* Java, the Duke mascot, and all variants of Sun"s Java "steaming coffee
* cup" logo are trademarks of Sun Microsystems. Sun"s, and James Gosling"s,
* pioneering role in inventing and promulgating (and standardizing) the Java 
* language and environment is gratefully acknowledged.
* 
* The pioneering role of Dennis Ritchie and Bjarne Stroustrup, of AT&T, for
* inventing predecessor languages C and C++ is also gratefully acknowledged.
*/

import javax.sql.rowset.CachedRowSet; /** 

* Demonstrate simple use of the CachedRowSet. The RowSet family of interfaces
* is in JDK1.5, but the Implementation classes are (as of Beta 1) still in the
* unsupported "com.sun" package.
*/

public class Main { 

 public static final String ROWSET_IMPL_CLASS = "com.sun.rowset.CachedRowSetImpl";
 public static void main(String[] args) throws Exception {
   CachedRowSet rs;
   // Create the class with class.forName to avoid importing
   // from the unsupported com.sun packages.
   Class c = Class.forName(ROWSET_IMPL_CLASS);
   rs = (CachedRowSet) c.newInstance();
   rs.setUrl("jdbc:postgresql:tmclub");
   rs.setUsername("ian");
   rs.setPassword("secret");
   rs.setCommand("select * from members where name like ?");
   rs.setString(1, "I%");
   // This will cause the RowSet to connect, fetch its data, and
   // disconnect
   rs.execute();
   // Some time later, the client tries to do something.
   // Suppose we want to update data:
   while (rs.next()) {
     if (rs.getInt("id") == 42) {
       rs.setString(1, "Marvin");
       rs.updateRow(); // Normal JDBC
       // This additional call tells the CachedRowSet to connect
       // to its database and send the updated data back.
       rs.acceptChanges();
     }
   }
   // If we"re all done...
   rs.close();
 }

} 


 </source>



CachedRowSet: setUsername(String name)

   <source lang="java">

/* 

* Copyright (c) Ian F. Darwin, http://www.darwinsys.ru/, 1996-2002.
* All rights reserved. Software written by Ian F. Darwin and others.
* $Id: LICENSE,v 1.8 2004/02/09 03:33:38 ian Exp $
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions
* are met:
* 1. Redistributions of source code must retain the above copyright
*    notice, this list of conditions and the following disclaimer.
* 2. Redistributions in binary form must reproduce the above copyright
*    notice, this list of conditions and the following disclaimer in the
*    documentation and/or other materials provided with the distribution.
*
* THIS SOFTWARE IS PROVIDED BY THE AUTHOR AND CONTRIBUTORS ``AS IS""
* AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED
* TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
* PURPOSE ARE DISCLAIMED.  IN NO EVENT SHALL THE AUTHOR OR CONTRIBUTORS
* BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
* CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
* SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
* INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
* CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
* ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
* POSSIBILITY OF SUCH DAMAGE.
* 
* Java, the Duke mascot, and all variants of Sun"s Java "steaming coffee
* cup" logo are trademarks of Sun Microsystems. Sun"s, and James Gosling"s,
* pioneering role in inventing and promulgating (and standardizing) the Java 
* language and environment is gratefully acknowledged.
* 
* The pioneering role of Dennis Ritchie and Bjarne Stroustrup, of AT&T, for
* inventing predecessor languages C and C++ is also gratefully acknowledged.
*/

import javax.sql.rowset.CachedRowSet; /** 

* Demonstrate simple use of the CachedRowSet. The RowSet family of interfaces
* is in JDK1.5, but the Implementation classes are (as of Beta 1) still in the
* unsupported "com.sun" package.
*/

public class Main { 

 public static final String ROWSET_IMPL_CLASS = "com.sun.rowset.CachedRowSetImpl";
 public static void main(String[] args) throws Exception {
   CachedRowSet rs;
   // Create the class with class.forName to avoid importing
   // from the unsupported com.sun packages.
   Class c = Class.forName(ROWSET_IMPL_CLASS);
   rs = (CachedRowSet) c.newInstance();
   rs.setUrl("jdbc:postgresql:tmclub");
   rs.setUsername("ian");
   rs.setPassword("secret");
   rs.setCommand("select * from members where name like ?");
   rs.setString(1, "I%");
   // This will cause the RowSet to connect, fetch its data, and
   // disconnect
   rs.execute();
   // Some time later, the client tries to do something.
   // Suppose we want to update data:
   while (rs.next()) {
     if (rs.getInt("id") == 42) {
       rs.setString(1, "Marvin");
       rs.updateRow(); // Normal JDBC
       // This additional call tells the CachedRowSet to connect
       // to its database and send the updated data back.
       rs.acceptChanges();
     }
   }
   // If we"re all done...
   rs.close();
 }

} 


 </source>



CachedRowSet: updateRow()

   <source lang="java">

/* 

* Copyright (c) Ian F. Darwin, http://www.darwinsys.ru/, 1996-2002.
* All rights reserved. Software written by Ian F. Darwin and others.
* $Id: LICENSE,v 1.8 2004/02/09 03:33:38 ian Exp $
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions
* are met:
* 1. Redistributions of source code must retain the above copyright
*    notice, this list of conditions and the following disclaimer.
* 2. Redistributions in binary form must reproduce the above copyright
*    notice, this list of conditions and the following disclaimer in the
*    documentation and/or other materials provided with the distribution.
*
* THIS SOFTWARE IS PROVIDED BY THE AUTHOR AND CONTRIBUTORS ``AS IS""
* AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED
* TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
* PURPOSE ARE DISCLAIMED.  IN NO EVENT SHALL THE AUTHOR OR CONTRIBUTORS
* BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
* CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
* SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
* INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
* CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
* ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
* POSSIBILITY OF SUCH DAMAGE.
* 
* Java, the Duke mascot, and all variants of Sun"s Java "steaming coffee
* cup" logo are trademarks of Sun Microsystems. Sun"s, and James Gosling"s,
* pioneering role in inventing and promulgating (and standardizing) the Java 
* language and environment is gratefully acknowledged.
* 
* The pioneering role of Dennis Ritchie and Bjarne Stroustrup, of AT&T, for
* inventing predecessor languages C and C++ is also gratefully acknowledged.
*/

import javax.sql.rowset.CachedRowSet; /** 

* Demonstrate simple use of the CachedRowSet. The RowSet family of interfaces
* is in JDK1.5, but the Implementation classes are (as of Beta 1) still in the
* unsupported "com.sun" package.
*/

public class Main { 

 public static final String ROWSET_IMPL_CLASS = "com.sun.rowset.CachedRowSetImpl";
 public static void main(String[] args) throws Exception {
   CachedRowSet rs;
   // Create the class with class.forName to avoid importing
   // from the unsupported com.sun packages.
   Class c = Class.forName(ROWSET_IMPL_CLASS);
   rs = (CachedRowSet) c.newInstance();
   rs.setUrl("jdbc:postgresql:tmclub");
   rs.setUsername("ian");
   rs.setPassword("secret");
   rs.setCommand("select * from members where name like ?");
   rs.setString(1, "I%");
   // This will cause the RowSet to connect, fetch its data, and
   // disconnect
   rs.execute();
   // Some time later, the client tries to do something.
   // Suppose we want to update data:
   while (rs.next()) {
     if (rs.getInt("id") == 42) {
       rs.setString(1, "Marvin");
       rs.updateRow(); // Normal JDBC
       // This additional call tells the CachedRowSet to connect
       // to its database and send the updated data back.
       rs.acceptChanges();
     }
   }
   // If we"re all done...
   rs.close();
 }

} 


 </source>



com.sun.rowset.CachedRowSetImpl

   <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>
Источник — «http://jexp.ru/index.php?title=Java_by_API/javax.sql.rowset/CacheRowSet&oldid=1202»