hi! all, in one of my program i've certain data in parent child relationship. like parent A has child B and B has children C1, C2, and C3. And in my
java program i'm retrieving this data using recursion.
public void child(
String str ) throws Exception
{
ResultSet rs=s.executeQuery("select uid from tree where parent='"+str+"' ");
while(rs.next())
{
String abc= rs.getString(1);
System.out.println(abc);
child(abc);
}
}
while calling child("A") for the first time inside main i got the output like...
A
B
C1
Resultset is closed.
I want to print all the C1, C2, and C3 child nodes.
I've MSAccess at backend.
regards
--prateek