import java.sql.Date;

class Customer {
    private String first_name;
    private String last_name;
    private String gedner;
    private Date age;
    private String address;


    Customer(String first_name, String last_name, String gedner, Date age, String address) {
        this.first_name = first_name;
        this.last_name = last_name;
        this.gedner = gedner;
        this.age = age;
        this.address = address;
    }

    public String getLast_name() {
        return last_name;
    }

    public String getFirst_name() {
        return first_name;
    }

    public String getGedner() {
        return gedner;
    }

    public Date getAge() {
        return age;
    }

    public String getAddress() {
        return address;
    }
}

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


public class Bank {
    private static final String URL = "jdbc:mysql://localhost/bank?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC";
    private static final String USER = "root";
    private static final String PASSWORD = "root";

    Connection connection = null;
    PreparedStatement preparedStatement = null;
    Scanner in = new Scanner(System.in);

    public void connect() {
        try {
            connection = DriverManager.getConnection(URL, USER, PASSWORD);
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    Customer readCustomer() {
        Customer customer = null;
        try {
            preparedStatement = connection.prepareStatement("SELECT * FROM customers WHERE id_customer = ?");
            System.out.print("Введите id пользователя: ");
            preparedStatement.setInt(1, Integer.parseInt(in.next()));
            preparedStatement.execute();
            ResultSet rs = preparedStatement.executeQuery();
            String first_name = rs.getString("first_name");
            String last_name = rs.getString("last_name");
            String gender = rs.getString("gender");
            Date age = rs.getDate("age");
            String address = rs.getString("address");
            customer = new Customer(first_name, last_name, gender, age, address);
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                preparedStatement.close();
                connection.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        return customer;
    }
}