HomeDigital EditionSys-Con RadioSearch Java Cd
Advanced Java AWT Book Reviews/Excerpts Client Server Corba Editorials Embedded Java Enterprise Java IDE's Industry Watch Integration Interviews Java Applet Java & Databases Java & Web Services Java Fundamentals Java Native Interface Java Servlets Java Beans J2ME Libraries .NET Object Orientation Observations/IMHO Product Reviews Scalability & Performance Security Server Side Source Code Straight Talking Swing Threads Using Java with others Wireless XML
 

"Cross-Database Portability with JDBC"
Volume: 5 Issue: 1, p.62

	

Listing 1: Pure JDBC Template for Positioned Update

ResultSet rset =  stmt.executeQuery("select ename from emp for update");
   String cursor = rset.getCursorName();
   PreparedStatement ps = conn.prepareStatement("update emp set ename = ? "
+
                                                    "where current of ?");
   while (rset.next()) {
        String ename = rset.getString(1);
        ps.getString(1, ename.toLowerCase());
        ps.setString(2, cursor);
        ps.executeUpdate();
	}


 

All Rights Reserved
Copyright ©  2004 SYS-CON Media, Inc.
  E-mail: [email protected]

Java and Java-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. in the United States and other countries. SYS-CON Publications, Inc. is independent of Sun Microsystems, Inc.