try{
            // Step 1: create connection
            Connection connection =
                    DriverManager.getConnection("jdbc:sqlite:identifier.sqlite");

            // Step 2: Create SQL query
            String addToList = "SELECT DISTINCT name FROM FOODS";

            Statement statement = connection.createStatement();
            statement.execute(addToList);

            ResultSet resultSet =
                    statement.executeQuery(addToList);


            // Step 6: Only for select, read your results;
            while(resultSet.next()){
                System.out.println(resultSet.getString(1)); // select what column from the select statement
            }

            // Final step, close the connection
            connection.close();
        }
        catch(SQLException throwables){
            throwables.printStackTrace();
        }