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

            rs.updateString(connectorNameColumn, context.getConnectorName());
            rs.updateString(propertyNameColumn, fieldName);
            if (fieldValue == null) {
              rs.updateNull(propertyValueColumn);
            } else {
              rs.updateString(propertyValueColumn, fieldValue);
            }
            rs.insertRow();
          }
          connection.commit();
          rs.close();

View Full Code Here

            rs.updateTimestamp("F11", new java.sql.Timestamp(System.currentTimeMillis()));
            rs.updateBytes("F12", new byte[300]);
            rs.updateBinaryStream("F12", null);
            rs.updateBinaryStream("F12", null, 0);
            rs.updateBinaryStream("F12", null, 0L);
            rs.updateString("F13", "13x");
            rs.updateAsciiStream("F13", null);
            rs.updateAsciiStream("F13", null, 0);
            rs.updateAsciiStream("F13", null, 0L);
            rs.updateCharacterStream("F14", null);
            rs.updateCharacterStream("F14", null, 0);

View Full Code Here

            rs.updateTimestamp(11, new java.sql.Timestamp(System.currentTimeMillis()));
            rs.updateBytes(12, new byte[300]);
            rs.updateBinaryStream(12, null);
            rs.updateBinaryStream(12, null, 0);
            rs.updateBinaryStream(12, null, 0L);
            rs.updateString(13, "13x");
            rs.updateAsciiStream(13, null);
            rs.updateAsciiStream(13, null, 0);
            rs.updateAsciiStream(13, null, 0L);
            rs.updateCharacterStream(14, null);
            rs.updateCharacterStream(14, null, 0);

View Full Code Here

                        new PasswordHash().generateSaltedHash("", username,
                                PasswordHash.ALGORITHM_MD5);


                if (emptyPasswordHash.equals(passwordHash)) {
                    emptyPasswordsFound++;
                    rset.updateString("passwordHash", null);
                    rset.updateRow();
                }
            }
        } catch (DatabaseException e) {
            throw new CustomChangeException(e);

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 r = stmt.executeQuery("select * from usertable"); 


    r.moveToInsertRow();


    r.updateString("name", name);
    r.updateString("surname", surname);
    r.updateDate("birthdate", birthDate);
    r.updateString("birthplace", birthPlace);
    r.updateString("nationality", nationality);
    r.updateString("maritalstatus", maritalStatus);

View Full Code Here

    ResultSet r = stmt.executeQuery("select * from usertable"); 


    r.moveToInsertRow();


    r.updateString("name", name);
    r.updateString("surname", surname);
    r.updateDate("birthdate", birthDate);
    r.updateString("birthplace", birthPlace);
    r.updateString("nationality", nationality);
    r.updateString("maritalstatus", maritalStatus);
    r.updateString("username", username);

View Full Code Here

    r.moveToInsertRow();


    r.updateString("name", name);
    r.updateString("surname", surname);
    r.updateDate("birthdate", birthDate);
    r.updateString("birthplace", birthPlace);
    r.updateString("nationality", nationality);
    r.updateString("maritalstatus", maritalStatus);
    r.updateString("username", username);    
    r.updateBytes("password", Utility.SHA1(password));

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.