fuck

package com.geekbrains.server;

import java.sql.*;
import java.util.*;


public class JDBC {

    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        Class.forName("org.sqlite.JDBC");

        try (Connection connection = DriverManager.getConnection("jdbc:sqlite:users.db")){

            Statement statement = connection.createStatement();

            for(User user : readAllUsers(statement)){
                System.out.println(user);
            }
        }
    }

    public static Collection<User> readAllUsers(Statement statement) throws  SQLException{

        ResultSet resultSet = statement.executeQuery("SELECT * FROM users");

        Map<Integer,User> userById = new HashMap<>();

        while (resultSet.next()){
            int id = resultSet.getInt(1);
            String login = resultSet.getString(2);
            String password = resultSet.getString(3);
            String nickname = resultSet.getString(4);

            User user = new User();
            user.setId(id);
            user.setLogin(login);
            user.setPassword(password);
            user.setNickname(nickname);

            userById.put(id,user);
        }

        return userById.values();
    }
}