Pushing contents of HashMap to Database :)

Ok, so I would like to push the contents of my hashmap..

Code:java

public static HashMap<Player, String> toPush = new HashMap<Player, String>();

to my database, using this query.

Code:java

    public static void push(Player p, String a) {
        String query = "INSERT into ATTRIB_PLAYERS (player, attribute) values = '"+p.getName()+"', '"+a+"';";
        try {
            Attributes.manageMySQL.insertQuery(query);
        } catch (MalformedURLException e) {
            e.printStackTrace();
        } catch (InstantiationException e) {
            e.printStackTrace();
        } catch (IllegalAccessException e) {
            e.printStackTrace();
        }
    }

All i need to know really, is how to extract the key and value from the hashmap to use in this method, i'm no used to using hashmaps

Thanks!

 

So, I don't know mysql, but i'm guessing the table will look like this:
--------------------------
Tips48|ValueHere
OtherName|ValueHere

So would you just go through each player and get the value?

 

Yeah, i just need to get the player and value from the hashmap. That is what i am unsure about.

 

Go through each (row) and the first value is the key and the second is the value, yes?

 

Erm, yes

Code:java

    public static void push(Player p, String a) {
        for (int i = 0; i < attributes.size(); i++) {
        String query = "INSERT into ATTRIB_PLAYERS (player, attribute) values = ('"+attributes.get(i)+"', '"+???????+"');";
        try {
            Attributes.manageMySQL.insertQuery(query);
        } catch (MalformedURLException e) {
            e.printStackTrace();
        } catch (InstantiationException e) {
            e.printStackTrace();
        } catch (IllegalAccessException e) {
            e.printStackTrace();
        }
        }
    }

I'm just confused as how to get the value of the key?

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

@cheese5505 , your needed

 

Ok

Code:java

 
for(Map.Entry<Player, String> entry : toPush.entrySet()){
    Player p = entry.getKey();
    String s = entry.getValue();
    //Your query etc
}