assertThat(rs.getTimestamp(6)).isEqualTo(Timestamp.ofTimeMicroseconds(usecs)); assertThat(rs.getTimestamp("timestamp")).isEqualTo(Timestamp.ofTimeMicroseconds(usecs)); assertThat(rs.getDate(7)).isEqualTo(Date.fromYearMonthDay(year, month, day)); assertThat(rs.getDate("date")).isEqualTo(Date.fromYearMonthDay(year, month, day)); assertThat(rs.getBooleanArray(8)).isEqualTo(boolArray); assertThat(rs.getBooleanArray("boolArray")).isEqualTo(boolArray);
static void queryPerformancesTable(DatabaseClient dbClient) { // Rows without an explicit value for Revenue will have a Revenue equal to // null. ResultSet resultSet = dbClient .singleUse() .executeQuery( Statement.of( "SELECT SingerId, VenueId, EventDate, Revenue, LastUpdateTime " + "FROM Performances ORDER BY LastUpdateTime DESC")); while (resultSet.next()) { System.out.printf( "%d %d %s %s %s\n", resultSet.getLong("SingerId"), resultSet.getLong("VenueId"), resultSet.getDate("EventDate"), // We check that the value is non null. ResultSet getters can only be used to retrieve // non null values. resultSet.isNull("Revenue") ? "NULL" : resultSet.getLong("Revenue"), resultSet.getTimestamp("LastUpdateTime")); } }