@Override public Long run(TransactionContext transaction) { long rowCount = 0; for (final String stmt : stmts) { ResultSet resultSet = transaction.executeQuery(Statement.of(stmt)); assertThat(resultSet.next()).isFalse(); assertThat(resultSet.getStats()).isNotNull(); rowCount += resultSet.getStats().getRowCountExact(); } return rowCount; } };
@Override public Void run(TransactionContext transaction) throws Exception { // Insert record. String sql = "INSERT INTO Singers (SingerId, FirstName, LastName) " + " VALUES (11, 'Timothy', 'Campbell')"; long rowCount = transaction.executeUpdate(Statement.of(sql)); System.out.printf("%d record inserted.\n", rowCount); // Read newly inserted record. sql = "SELECT FirstName, LastName FROM Singers WHERE SingerId = 11"; ResultSet resultSet = transaction.executeQuery(Statement.of(sql)); while (resultSet.next()) { System.out.printf( "%s %s\n", resultSet.getString("FirstName"), resultSet.getString("LastName")); } return null; } });
ResultSet resultSet = transaction.executeQuery(Statement.of(sql1)); long album1Budget = 0; while (resultSet.next()) { String sql2 = "SELECT MarketingBudget from Albums WHERE SingerId = 2 and AlbumId = 2"; ResultSet resultSet2 = transaction.executeQuery(Statement.of(sql2)); long album2Budget = 0; while (resultSet.next()) {