如何从多行PostgreSQL ResultSet中获取一行并将其存储在Java中？

<dependency>
    <groupId>org.postgresql</groupId>
    <artifactId>postgresql</artifactId>
    <version>版本号</version>
</dependency>

import java.sql.*;

public class Main {
    public static void main(String[] args) {
        String url = "jdbc:postgresql://localhost:5432/数据库名";
        String username = "用户名";
        String password = "密码";

        try {
            Class.forName("org.postgresql.Driver");
            Connection connection = DriverManager.getConnection(url, username, password);
            // 连接成功后进行后续操作
        } catch (ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        }
    }
}

Statement statement = connection.createStatement();
String sql = "SELECT * FROM 表名";
ResultSet resultSet = statement.executeQuery(sql);

while (resultSet.next()) {
    int id = resultSet.getInt("id");
    String name = resultSet.getString("name");
    // 将获取到的数据存储在Java对象中或进行其他操作
}

resultSet.close();
statement.close();
connection.close();