How to create dynamic map objects in a loop

Question

//Mysql Query to get project

while(query.next())
{
    Map objname=new Hashmap();
    //Mysql query to get day and hours of respective project
    while(dayandhourquery.next())
    {
        objname.put(day,hour);
    }
}

I've a query to get project name,days and hours.and I want to put day and hours in Hashmap with respective project. While doing this above code,I am getting the details with the last project.

Answer 1

It happen because Map stores only values for unique keys. I assume that for project days could be the same. When you put day value you override old day-hour entry in map. You need to consider changing key value in map or use one collection for each project.