获取数据库中的数据并放入集合

 源码送上：

public class Account {
    private String id;
    private String name;
    private String money;

    public Account(String id, String name, String money) {
        this.id = id;
        this.name = name;
        this.money = money;
    }

    public String getId() {
        return id;
    }

    public void setId(String id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getMoney() {
        return money;
    }

    public void setMoney(String money) {
        this.money = money;
    }
}

import java.sql.*;
import java.util.ArrayList;
import java.util.stream.Stream;

public class Data {
    public static void main(String[] args) throws SQLException {
        String url = "jdbc:mysql://127.0.0.1:3306/test?serverTimezone=UTC";
        String username = "root";
        String password = "你的数据库密码";
        String sql = "select * from account";
        ArrayList<Account> list = new ArrayList<>();
        try (Connection connection = DriverManager.getConnection(url, username, password);
             PreparedStatement prepare = connection.prepareStatement(sql);
             ResultSet resultSet = prepare.executeQuery()
        ) {
            while (resultSet.next()) {
                String id = resultSet.getString("id");
                String name = resultSet.getString("name");
                String money = resultSet.getString("money");
                list.add(new Account(id, name, money));
            }

        } catch (SQLException e) {
            e.printStackTrace();

        }
        Stream<Account> stream = list.stream();
        stream.forEach((Account account) -> {
                    System.out.println(account.getId());
                    System.out.println(account.getName());
                    System.out.println(account.getMoney());
                }
        );
        System.out.println("学习java，来源码时代");
    }
}