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

                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

      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

        for (int i = 1; i <= colCount; i++) {
          System.out.printf("%s=%s: ", rsMetaData.getColumnName(i), rs.getObject(i));
          String resp = is.readLine();
          if (resp == null || "".equals(resp))
            continue;
          rs.updateString(i, resp);
          changed = true;
        }
        if (changed) {
          rs.updateRow();
        }

View Full Code Here

    Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
        ResultSet.CONCUR_UPDATABLE);
    ResultSet resultSet = stmt
        .executeQuery("SELECT * FROM note where note_id=" + note_id);
    resultSet.first(); // Move cursor to the row to update
    resultSet.updateString("titre", note.getTitre());
    resultSet.updateString("texte", note.getTexte());
    Date date = new Date();
    Timestamp time = new Timestamp(date.getTime());
    resultSet.updateTimestamp("datemodif", time);
    resultSet.updateRow(); // Update the row;

View Full Code Here

        ResultSet.CONCUR_UPDATABLE);
    ResultSet resultSet = stmt
        .executeQuery("SELECT * FROM note where note_id=" + note_id);
    resultSet.first(); // Move cursor to the row to update
    resultSet.updateString("titre", note.getTitre());
    resultSet.updateString("texte", note.getTexte());
    Date date = new Date();
    Timestamp time = new Timestamp(date.getTime());
    resultSet.updateTimestamp("datemodif", time);
    resultSet.updateRow(); // Update the row;
    return;

View Full Code Here

          if (rs.next()) {
            // This connector property exists, update the property value.
            if (fieldValue == null) {
              rs.updateNull(propertyValueColumn);
            } else {
              rs.updateString(propertyValueColumn, fieldValue);
            }
            // Bump the ModifyStamp, so others may know the value has changed.
            rs.updateInt(modifyStampColumn, rs.getInt(modifyStampColumn) + 1);
            rs.updateRow();
          } else {

View Full Code Here

            rs.updateRow();
          } else {
            // This connector property does not exist, insert it with new value.
            rs.moveToInsertRow();
            rs.updateInt(modifyStampColumn, 1); // Bootstrap the ModifyStamp
            rs.updateString(connectorNameColumn, context.getConnectorName());
            rs.updateString(propertyNameColumn, fieldName);
            if (fieldValue == null) {
              rs.updateNull(propertyValueColumn);
            } else {
              rs.updateString(propertyValueColumn, fieldValue);

View Full Code Here

          } else {
            // This connector property does not exist, insert it with new value.
            rs.moveToInsertRow();
            rs.updateInt(modifyStampColumn, 1); // Bootstrap the ModifyStamp
            rs.updateString(connectorNameColumn, context.getConnectorName());
            rs.updateString(propertyNameColumn, fieldName);
            if (fieldValue == null) {
              rs.updateNull(propertyValueColumn);
            } else {
              rs.updateString(propertyValueColumn, fieldValue);
            }

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.