不用递归实现论坛树型结构的算法

jsp:useBean id="mybbs" scope="session" class="netzero.mydb" />



int intRowCount;
out.print("显示论坛树形结构");
out.print("

");
try {
String sql="select * from mybbslist order by rootid desc,depth,fid,bbsid";
ResultSet rs = mybbs.executeQuery(sql);
if (rs.next())
{
rs.last();
intRowCount=rs.getRow();
out.print("论坛树中有");
out.print(intRowCount);
out.print("个叶子节点");
rs.first();
int j=0;
int Depth = 0;
out.print("

");
while(j{
int rsDepth=rs.getInt("Depth");
if (rsDepth{
for(int i=1;i{
out.print("

");
}
}
rsDepth=rs.getInt("Depth");
if (rsDepth>Depth)
{
out.print("

");
}
out.print("
• ");
  String bbssubject=rs.getString("bbssubject");
  out.print(bbssubject);
  out.print("
");
Depth = rs.getInt("Depth");
j=j+1;
rs.next();
}
out.print("

");
}
else
{
out.print("数据库中无记录");
}
}catch (SQLException E) {
out.println("SQLException: " + E.getMessage());
out.println("SQLState: " + E.getSQLState());
out.println("VendorError: " + E.getErrorCode());
}
%>
try {
if(!mybbs.closeConn());
} catch (Exception ex) {
System.err.println("closeConn: " + ex.getMessage());
}
%>