public class Mysql {
 
 
 public static HashMap<String,ArrayList<String>> getDrinks(String input) {
   
        final HashMap<String, ArrayList<String>> drinkar = new HashMap<String, ArrayList<String>>();
 
        Connection con = null;
        String url = "jdbc:mysql://localhost:3306/";
        String db = "drycker";
        String driver = "com.mysql.jdbc.Driver";
        String user = "root";
        String pass = "";
 
 
        try {
            Class.forName(driver).newInstance();
            con = DriverManager.getConnection(url + db, user, pass);
            try {
                Statement st = (Statement) con.createStatement();
                String SQLDrink = "SELECT drink FROM drinkar WHERE drink LIKE '" + input + "%'";
 
                ResultSet res = st.executeQuery(SQLDrink);
                while (res.next()) {
                    String s = res.getString("drink");
                    Statement st2 = (Statement) con.createStatement();
                    String SQLIngrediens = "SELECT Ingrediens FROM drinkar INNER JOIN ingrediens ON drinkar.drink_ID = ingrediens.drink_ID WHERE drinkar.drink = '" + s + "'";
                    ResultSet res2 = st2.executeQuery(SQLIngrediens);
                    ArrayList<String> ingredienser = new ArrayList<String>();
                    while (res2.next()) {
                        ingredienser.add(res2.getString("Ingrediens"));
                    }
                    drinkar.put(s, ingredienser);
                }
                con.close();
            } catch (SQLException s) {
                System.out.println(s);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return drinkar;
    }


 public static void main(String[] args) {
  Mysql ms = new Mysql();
 }

}