while (rs.next()) {
    name=rs.getString(1);
    id=rs.getString(2);


//  session.setAttribute("name1", obj); 

    session.setAttribute("id",id);
session.setAttribute("name",name);

i didn't get this properly,i could get the last results only from resultset,please correct this

how to set a group of resultset values to session