import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;

public class ConnectionBD {
    public static void main(String[] args) throws SQLException {
        Connection connectBD = null;
        try{
            Class.forName("com.mysql.jdbc.Driver");
            String username = "root";
            String password = "";
            connectBD = DriverManager.getConnection("jdbc:mysql://localhost:3306/java_connection_bd", username, password);
            ResultSet rsClient = connectBD.createStatement().executeQuery("SELECT * FROM persons; ");

            while (rsClient.next()){
                // Columns database:
                String personId = rsClient.getString("PersonId");
                String lastName = rsClient.getString("LastName");
                String firstName = rsClient.getString("FirstName");
                String adrdess = rsClient.getString("Address");
                String city = rsClient.getString("City");

                //Data BD:
                System.out.println("The person id is: " + personId + ",\n lastname: " + lastName + ",\n firstname: " + firstName + ",\n address: " + adrdess);

                            }
        }catch (ClassNotFoundException ex){
            System.out.println("DB driver not found");
        } catch (SQLException e) {
            System.out.println("Was an error accessing the database " + e.getMessage());
        }finally {

            // Close connection:
            if(connectBD != null) {
                connectBD.close();
            }

        }
    }
}