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

    catch (SQLException sqle) {
      // Expected...
    }


    try {
      rs.updateString(1000, "hi");
      fail("Should have thrown an exception on bad column index.");
    }
    catch (SQLException sqle) {
      // Expected...
    }

View Full Code Here

    Statement st = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE, ResultSet.HOLD_CURSORS_OVER_COMMIT);
    ResultSet rs = st.executeQuery("select * from updateable");
    assertNotNull(rs);
    rs.moveToInsertRow();
    rs.updateInt(1, 1);
    rs.updateString(2, "jake");
    rs.updateString(3, "avalue");
    rs.insertRow();
    assertTrue(rs.first());


    rs.updateInt("id", 2);

View Full Code Here

    ResultSet rs = st.executeQuery("select * from updateable");
    assertNotNull(rs);
    rs.moveToInsertRow();
    rs.updateInt(1, 1);
    rs.updateString(2, "jake");
    rs.updateString(3, "avalue");
    rs.insertRow();
    assertTrue(rs.first());


    rs.updateInt("id", 2);
    rs.updateString("name", "dave");

View Full Code Here

    rs.updateString(3, "avalue");
    rs.insertRow();
    assertTrue(rs.first());


    rs.updateInt("id", 2);
    rs.updateString("name", "dave");
    rs.updateRow();


    assertEquals(2, rs.getInt("id"));
    assertEquals("dave", rs.getString("name"));
    assertEquals("avalue", rs.getString("notselected"));

View Full Code Here

    assertEquals("avalue", rs.getString("notselected"));


    rs.deleteRow();
    rs.moveToInsertRow();
    rs.updateInt("id", 3);
    rs.updateString("name", "paul");


    rs.insertRow();


    try {
      rs.refreshRow();

View Full Code Here


    rs = st.executeQuery("select id1, id, name, name1 from updateable, second");
    try {
      while (rs.next()) {
        rs.updateInt("id", 2);
        rs.updateString("name", "dave");
        rs.updateRow();
      }


      fail("should not get here, update should fail");
    }

View Full Code Here

    }


    rs = st.executeQuery("select oid,* from updateable");
    assertTrue(rs.first());
    rs.updateInt("id", 3);
    rs.updateString("name", "dave3");
    rs.updateRow();
    assertEquals(3, rs.getInt("id"));
    assertEquals("dave3", rs.getString("name"));


    rs.moveToInsertRow();

View Full Code Here

    assertEquals(3, rs.getInt("id"));
    assertEquals("dave3", rs.getString("name"));


    rs.moveToInsertRow();
    rs.updateInt("id", 4);
    rs.updateString("name", "dave4");


    rs.insertRow();
    rs.updateInt("id", 5);
    rs.updateString("name", "dave5");
    rs.insertRow();

View Full Code Here

    rs.updateInt("id", 4);
    rs.updateString("name", "dave4");


    rs.insertRow();
    rs.updateInt("id", 5);
    rs.updateString("name", "dave5");
    rs.insertRow();


    rs.moveToCurrentRow();
    assertEquals(3, rs.getInt("id"));
    assertEquals("dave3", rs.getString("name"));

View Full Code Here


  @Override
  protected void doExecuteStatement(Statement statement) throws SQLException {
    ResultSet rs = statement.executeQuery("select apiKey, secret from App");
    while (rs.next()) {
      rs.updateString("apiKey", encrypt(decrypt(rs.getString("apiKey"))));
      rs.updateString("secret", encrypt(decrypt(rs.getString("secret"))));
      rs.updateRow();
    }
    rs = statement.executeQuery("select accessToken, secret from AppConnection");
    while (rs.next()) {

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.