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

  @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()) {
      rs.updateString("accessToken", encrypt(decrypt(rs.getString("accessToken"))));

View Full Code Here

      rs.updateString("secret", encrypt(decrypt(rs.getString("secret"))));
      rs.updateRow();
    }
    rs = statement.executeQuery("select accessToken, secret from AppConnection");
    while (rs.next()) {
      rs.updateString("accessToken", encrypt(decrypt(rs.getString("accessToken"))));
      rs.updateString("secret", encrypt(decrypt(rs.getString("secret"))));
      rs.updateRow();
    }
    rs = statement.executeQuery("select member, provider, accessToken, secret from AccountConnection");
    while (rs.next()) {

View Full Code Here

      rs.updateRow();
    }
    rs = statement.executeQuery("select accessToken, secret from AppConnection");
    while (rs.next()) {
      rs.updateString("accessToken", encrypt(decrypt(rs.getString("accessToken"))));
      rs.updateString("secret", encrypt(decrypt(rs.getString("secret"))));
      rs.updateRow();
    }
    rs = statement.executeQuery("select member, provider, accessToken, secret from AccountConnection");
    while (rs.next()) {
      rs.updateString("accessToken", encrypt(decrypt(rs.getString("accessToken"))));

View Full Code Here

      rs.updateString("secret", encrypt(decrypt(rs.getString("secret"))));
      rs.updateRow();
    }
    rs = statement.executeQuery("select member, provider, accessToken, secret from AccountConnection");
    while (rs.next()) {
      rs.updateString("accessToken", encrypt(decrypt(rs.getString("accessToken"))));
      String secret = rs.getString("secret");
      if (secret != null) {
        rs.updateString("secret", encrypt(decrypt(secret)));
      }
      rs.updateRow();

View Full Code Here

    rs = statement.executeQuery("select member, provider, accessToken, secret from AccountConnection");
    while (rs.next()) {
      rs.updateString("accessToken", encrypt(decrypt(rs.getString("accessToken"))));
      String secret = rs.getString("secret");
      if (secret != null) {
        rs.updateString("secret", encrypt(decrypt(secret)));
      }
      rs.updateRow();      
    }    
  }

View Full Code Here

                ResultSet.CONCUR_UPDATABLE);
        ResultSet rs = s.executeQuery(SELECT_STMT);
        rs.next();


        for (int i = 1; i <= COLUMNS; i++) {
            rs.updateString(i, "2");
            assertEquals("Expected rs.getDouble(" + i + 
                         ") to match updated value", 2, (int) rs.getDouble(i));
        }
        rs.updateRow();
        rs.close();

View Full Code Here


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

        assertTrue(rs.isBeforeFirst());
        rs.moveToInsertRow();
        rs.updateInt("EMPLOYEEID", 666);
        rs.updateInt("CATEGORY", 667);
        rs.updateDouble("SALARY", 666.0);
        rs.updateString("NAME", "N.N.");
        rs.insertRow();
        rs.close();


        rs = cStmt.executeQuery(
            "select * from s1.wages where name = 'N.N.'");

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.