ResultSet rs = stmt.executeQuery( "SELECT * FROM COMPANY;" ); while ( rs.next() ) { int id = rs.getInt("id"); String name = rs.getString("name"); int age = rs.getInt("age"); getInt("age"); String address = rs.getString("address"); float salary = rs.getFloat("salary"); System.out.println( "ID = " + id ); System.out.println( "NAME = " + name System.out.println( "SALARY = " + salary ); System.out.println(); } rs.close(); stmt.close(); c.close(); } catch ( Exception e ) { System.err.println(

from arrests") dbBegin(con) rs <- dbSendStatement(con, "DELETE from arrests WHERE Murder > 1") dbGetRowsAffected(rs) dbReadTable_SQLiteConnection_character 5 dbClearResult(rs) dbGetQuery(con, "select dbGetQuery(con, "select count(*) from arrests")[1, ] dbBegin(con) rs <- dbSendStatement(con, "DELETE FROM arrests WHERE Murder > 5") dbClearResult(rs) dbCommit(con) dbGetQuery(con, "SELECT count(*) FROM arrests")[1 13 # Or do it in batches rs <- dbSendQuery(con, "SELECT * FROM USArrests") d1 <- dbFetch(rs, n = 10) # extract data in chunks of 10 rows dbHasCompleted(rs) d2 <- dbFetch(rs, n = -1) # extract all remaining

within a try/with block so that they are automatically closed. Line 24 This while loop uses the rs.next() method to iterate through each row. As long as there is another row in the result set, the try/with block so that they are automatically closed. Page 40 of 43 Line 24 This while loop uses the rs.next() method to iterate through each row. As long as there is another row in the result set, the ResultSet rs = stmt.executeQuery(sql)) { while (rs.next()) { System.out.printf("%d\t%‐10s\t%‐10s\t%tD%n", rs.getInt(1), rs.getString(2), rs.getString(3), rs.getDate(4));