Examples of java.sql.ResultSet.insertRow()

java.sql.ResultSet.insertRow()
Insert the insert row into the ResultSet and into the underlying database. The Cursor must be set to the Insert Row before this method is invoked. @throws SQLException if a database error happens. Particular cases include the Cursor not being on the Insert Row or if any Columns in the Row do not have a value where the column is declared as not-nullable.

      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");
      rs2.next();
      assertEquals("1", rs2.getString("c1"));
      assertEquals("bbb", rs2.getNString("c2"));
      rs2.next();

View Full Code Here

    r.updateString("nationality", nationality);
    r.updateString("maritalstatus", maritalStatus);
    r.updateString("username", username);    
    r.updateBytes("password", Utility.SHA1(password));


    r.insertRow();
    stmt.close();
    connection.closeConnection();


  }

View Full Code Here

    r.updateString("nationality", nationality);
    r.updateString("maritalstatus", maritalStatus);
    r.updateString("username", username);    
    r.updateBytes("password", Utility.SHA1(password));


    r.insertRow();
    stmt.close();
    connection.closeConnection();


  }

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.