import java.sql.*;

public class test {
    public static void main(String[] args) {
        String dbUser = "root";
        String dbPass = "12345678";
        String url = "jdbc:mysql://localhost/YodaFitness?useSSL=false";

        Connection connection = null;
        try
        {
            Class.forName("com.mysql.jdbc.Driver");
            connection = DriverManager.getConnection(url,dbUser, dbPass);
            String query = "SELECT * FROM MEDLEM";

            Statement statement = connection.createStatement();
            ResultSet resultSet = statement.executeQuery(query);

            while (resultSet.next()) {
                String name = resultSet.getString("navn");

                System.out.println(name);
            }
            statement.close();

        }
        catch (ClassNotFoundException e)
        {
            e.printStackTrace();
            System.exit(1);
        }
        catch (SQLException e)
        {
            e.printStackTrace();
            System.exit(2);
        }
    }
}