assertThat(rs.getBytes(5)).isEqualTo(ByteArray.copyFrom(byteVal)); assertThat(rs.getBytes("byteVal")).isEqualTo(ByteArray.copyFrom(byteVal)); 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));
static void queryMarketingBudgetWithTimestamp(DatabaseClient dbClient) { // Rows without an explicit value for MarketingBudget will have a MarketingBudget equal to // null. ResultSet resultSet = dbClient .singleUse() .executeQuery( Statement.of( "SELECT SingerId, AlbumId, MarketingBudget, LastUpdateTime FROM Albums" + " ORDER BY LastUpdateTime DESC")); while (resultSet.next()) { System.out.printf( "%d %d %s %s\n", resultSet.getLong("SingerId"), resultSet.getLong("AlbumId"), // We check that the value is non null. ResultSet getters can only be used to retrieve // non null values. resultSet.isNull("MarketingBudget") ? "NULL" : resultSet.getLong("MarketingBudget"), resultSet.isNull("LastUpdateTime") ? "NULL" : resultSet.getTimestamp("LastUpdateTime")); } } // [END spanner_query_data_with_timestamp_column]
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")); } }