如何使用JAVA从Dynamo DB获取列的总和

import software.amazon.awssdk.services.dynamodb.DynamoDbClient;
import software.amazon.awssdk.services.dynamodb.model.*;
import software.amazon.awssdk.regions.Region;

DynamoDbClient client = DynamoDbClient.builder()
    .region(Region.US_EAST_1) // 设置所需的区域
    .build();

ScanRequest scanRequest = ScanRequest.builder()
    .tableName("your_table_name") // 替换为实际的表名
    .projectionExpression("column_name") // 替换为实际的列名
    .build();

ScanResponse scanResponse = client.scan(scanRequest);
List<Map<String, AttributeValue>> items = scanResponse.items();

int sum = 0;
for (Map<String, AttributeValue> item : items) {
    AttributeValue value = item.get("column_name"); // 替换为实际的列名
    int columnValue = Integer.parseInt(value.n()); // 假设列的值为数字类型
    sum += columnValue;
}

System.out.println("列的总和为：" + sum);