nested JSP

[Marko Debac]

Hi to all,
please somebody help me,

I have class Mom:

  public class Mom {
    private String mom_username;
    private ArrayList childern;
    
    public Mom() {
    }
    public String getMom_username() {
        return mom_username;
    }
    public void setMom_username(String mom_username) {
        this.mom_username = mom_username;
    }
    public ArrayList getChildern() {
        return childern;
    }
    public void setChildern(ArrayList childern) {
        this.childern = childern;
    }    
}  

and I have class Child:

  public class Child {
    private String id_child;
        
    public Child() {
    }
    public String getId_child() {
        return id_child;
    }
    public void setId_child(String id_child) {
        this.id_child = id_child;
    }  
}  

I have similar database where one mom can have multiple child. In JSP, I need to fill up those objects with data from database, and set them in session scope. I can do everything, except to filling up

  ArrayList childern  

with lots of child.
I fill up Mum like this

<sql:query dataSource="${mother}" var="result">
                SELECT * FROM mother where mom_username=? 
                <sql:param value="${requestScope.username}"/>
      </sql:query>
    
<c:choose >
 <c:when test="${result.rowCount > 0}">
  <jsp:useBean  class="org.parents.Mom" id="mom" scope="session"> 
   <c:forEach var="row" items="${result.rows}">
   <c:set target="${mom}" property="mom_username" value="${row.mom_username}" />
   </c:forEach>   
  </jsp:useBean>
 </c:when>
</c:choose>
   <jsp:forward page="welcome.jsp" />    

and thats it, and now similarly for child, but here is a problem, I will have lots of row with child, and I must fill up for every child Arraylist children, so what I must put and where?

Here is the child (witch is not good code):

   
<c:choose >
 <c:when test="${result.rowCount > 0}">
  <jsp:useBean  class="org.parents.Child" id="child" scope="session"> 
   <c:forEach var="row" items="${result.rows}">
   <c:set target="${child}" property="id_child" value="${row.id_child}" />
   </c:forEach>   
  </jsp:useBean>
 </c:when>
</c:choose>
 

I think, that I must put it in here another

  
<jsp:useBean  class="org.parents.Mom" id="mom" scope="session">   

and one more <c:forEach>, to set every child in list children, but I cant figure out.

Please help