setAttribute to a query result

[RicardoPereira]

Hi,

After login i want to set some attributes in my index.jsp.
The attributes must be the result of a query to my database.
I think i cant put in an attribute the result of an arrayList, even if result only one record.
How do i do that?

Thanks
Ricardo Pereira

 

[sedj]

ArrayList arr = new ArrayList();

// JDBC stuff
// Loop the ResultSet, building up the line you want to add
// to the ArrayList, then add it as so :
arr.add(myLineToAdd);

// Then outside of the loop
session.setAttribute("myLineToAdd", myLineToAdd);

 

[RicardoPereira]

Thanks sedj