Examples of java.sql.ResultSet.updateString()

java.sql.ResultSet.updateString()
Updates a column specified by a column index with a String value. @param columnIndex the index of the column to update @param x the new value for the specified column @throws SQLException if a database error happens


        // case a)
        ResultSet rs = s.executeQuery("select c from t1 for update of c");


        rs.next();
        rs.updateString(1,"foobar");
        rs.updateRow();
        rs.next();
        rs.previous();
        assertEquals("foobar", rs.getString(1));
        rs.close();

View Full Code Here

        rs = s.executeQuery("SELECT * from t1 for update of c");
        rs.next();
        int id = rs.getInt(1);
        int a =  rs.getInt(2);
        int b =  rs.getInt(3);
        rs.updateString(4,"foobar");
        rs.updateRow();
        rs.next();
        rs.previous();
        assertEquals(id, rs.getInt(1));
        assertEquals(a, rs.getInt(2));

View Full Code Here

        rs = s.executeQuery("SELECT * from t1 for update of id,a,b,c");
        rs.next();
        rs.updateInt(1, -20);
        rs.updateInt(2, 20);
        rs.updateInt(3, 21);
        rs.updateString(4,"foobar");
        rs.updateRow();
        rs.next();
        rs.previous();
        assertEquals(-20, rs.getInt(1));
        assertEquals(20, rs.getInt(2));

View Full Code Here

      ResultSet rs1 = stmt1.executeQuery("SELECT c1, c2 FROM testUpdateNCharacterStream");
      rs1.next();
      rs1.updateNCharacterStream("c2", new StringReader("bbb"), 3);
      rs1.updateRow();
      rs1.moveToInsertRow();
      rs1.updateString("c1", "2");
      rs1.updateNCharacterStream("c2", new StringReader("ccc"), 3);
      rs1.insertRow();
      ResultSet rs2 = stmt1.executeQuery("SELECT c1, c2 FROM testUpdateNCharacterStream");
      rs2.next();
      assertEquals("1", rs2.getString("c1"));

View Full Code Here

      NClob nClob2 = conn1.createNClob();
      nClob2.setString(1, "bbb");
      rs1.updateNClob("c2", nClob2);
      rs1.updateRow();
      rs1.moveToInsertRow();
      rs1.updateString("c1", "2");
      NClob nClob3 = conn1.createNClob();
      nClob3.setString(1, "ccc");
      rs1.updateNClob("c2", nClob3);
      rs1.insertRow();
      ResultSet rs2 = stmt1.executeQuery("SELECT c1, c2 FROM testUpdateNChlob");

View Full Code Here

      ResultSet rs1 = stmt1.executeQuery("SELECT c1, c2 FROM testUpdateNString");
      rs1.next();
      rs1.updateNString("c2", "bbb");
      rs1.updateRow();
      rs1.moveToInsertRow();
      rs1.updateString("c1", "2");
      rs1.updateNString("c2", "ccc");
      rs1.insertRow();
      ResultSet rs2 = stmt1.executeQuery("SELECT c1, c2 FROM testUpdateNString");
      rs2.next();
      assertEquals("1", rs2.getString("c1"));

View Full Code Here


            ResultSet rs = st.executeQuery(s);




            rs.absolute(10);
            rs.updateString(2, "UPDATE10");
            rs.updateRow();


            rs.absolute(11);
            rs.deleteRow();

View Full Code Here

            rs.deleteRow();


            rs.moveToInsertRow();


            rs.updateInt(1, 1011);
            rs.updateString(2, "INSERT1011");
            rs.updateString(3, "0101");


            rs.insertRow();


            rs.close();

View Full Code Here


            rs.moveToInsertRow();


            rs.updateInt(1, 1011);
            rs.updateString(2, "INSERT1011");
            rs.updateString(3, "0101");


            rs.insertRow();


            rs.close();

View Full Code Here

            ResultSet rs = statement.executeQuery(select);


            while (rs.next()) {
                String s = rs.getString(2);


                rs.updateString(2, s + s);
                rs.updateRow();
            }


            rs.close();

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.