动态菜单的问题，急！

String sqlStr1="select second_column_code,second_column_name from code_second_column order by second_column_code";
int rowCount=DBQuery.getCountRow(sqlStr1);
DBQuery.release();
DBQuery=new DatabaseQuery();
JspWriter out=pageContext.getOut();
rs=getSecondColumn();

DBQuery_Second.release();

try{
   //建立数据库连接
  
        // DBConnectionProvider myConn=new DBConnectionProvider();
        // String sqlStr="select third_column_name,maintenance_url,third_column_code from code_third_column where second_column_code=? and can_be_maintenance='1'";
        // PreparedStatement ps=myConn.prepareStatement(sqlStr);         
   
   // try{
   //关闭连接
// ps.close();
// myConn.release();
//   }catch(Exception e){
    // System.out.println("关闭DBConnectionProvider时错误："+e);
//    }
     try{
     String idSign="KB";
     String parentIdName="Parent";
     String childIdName="Child";
     int i=1;
while(rs.next()){
   sndColumnCode=rs.getString("second_column_code");
   sndColumnName=rs.getString("second_column_name");
   
   idSign=idSign+idSign.valueOf(i);
   parentIdName=idSign+parentIdName;
   
   out.println("<DIV class=parent id="+parentIdName+">");
   out.println("<table border=0 cellspacing=0 cellpadding=0><tr>");
   if(i==rowCount){
   out.println("<td><a href=\"#\" style=\"cursor:hand\" onmouseover=\"setstatus('"+sndColumnName+"')\" onclick=\"expandIt('"+idSign+"');swapImage(document.img"+parentIdName+",'images/addb.gif','images/addb2.gif');return false;\" onmouseout=\"setstatus('')\"><IMG src='images/addb.gif' border=0 name=img"+parentIdName+"></a></td>");
   out.println("<td><a href=\"#\" style=\"cursor:hand\" onmouseover=\"setstatus('"+sndColumnName+"')\" onclick=\"expandIt('"+idSign+"');swapImage(document.img"+parentIdName+",'images/addb.gif','images/addb2.gif');return false;\" onmouseout=\"setstatus('')\">"+sndColumnName+"</td></tr></table>");
   }
   else{
   out.println("<td><a href=\"#\" style=\"cursor:hand\" onmouseover=\"setstatus('"+sndColumnName+"')\" onclick=\"expandIt('"+idSign+"');swapImage(document.img"+parentIdName+",'images/add.gif','images/add2.gif');return false;\" onmouseout=\"setstatus('')\"><IMG src='images/add.gif' border=0 name=img"+parentIdName+"></a></td>");
   out.println("<td><a href=\"#\" style=\"cursor:hand\" onmouseover=\"setstatus('"+sndColumnName+"')\" onclick=\"expandIt('"+idSign+"');swapImage(document.img"+parentIdName+",'images/add.gif','images/add2.gif');return false;\" onmouseout=\"setstatus('')\">"+sndColumnName+"</td></tr></table>");
   }
   out.println("</u></DIV>");
   
   sqlSecond="select third_column_name,maintenance_url,third_column_code from code_third_column where second_column_code='"+sndColumnCode+"' and can_be_maintenance='1'";
   DBQuery_Second=new DatabaseQuery();
rs_1=DBQuery_Second.getRS(sqlSecond);

//     ps.setString(1,sndColumnCode);
// rs_1=ps.executeQuery();




sqlStr1="select * from code_third_column where second_column_code="+sndColumnCode+" and can_be_maintenance='1'";
DatabaseQuery DBQuery_1=new DatabaseQuery();
int rowCount_1=DBQuery_1.getCountRow(sqlStr1);
childIdName=idSign+childIdName;


out.print("<DIV class=child id="+childIdName+"><table border=0 cellspacing=0 cellpadding=0>");
                             int j=1;
while(rs_1.next()){


trdColumnName=rs_1.getString("third_column_name");
url=rs_1.getString("maintenance_url");
trdColumnCode=rs_1.getString("third_column_code");
sign=permission.lastIndexOf(trdColumnCode);
      out.println("<tr>");
      if(i==rowCount)
out.println("<td><IMG src='images/left1.gif' border=0></td>");
else
out.println("<td><IMG src='images/left.gif' border=0></td>");
if(sign==(-1)){
   if(j==rowCount_1){
    out.println("<td><IMG src='images/jianb.gif' border=0 name=img"+trdColumnName+"></td>");
    out.println("<td><font color="+disableFontColor+">"+trdColumnName+"</font></td>");
   }
   else{
    out.println("<td><IMG src='images/jian.gif' border=0 name=img"+trdColumnName+"></td>");
    out.println("<td><font color="+disableFontColor+">"+trdColumnName+"</font></td>");
   }

}else{
   if(j==rowCount_1){
    out.println("<td><a href=\""+url+"\" target=main onmouseover=\"setstatus('"+trdColumnName+"')\") onmouseout=\"setstatus('')\"><IMG src='images/jianb.gif' border=0 name=img"+trdColumnName+"></a></td>");
    out.println("<td><a href=\""+url+"\" target=main onmouseover=\"setstatus('"+trdColumnName+"')\") onmouseout=\"setstatus('')\">"+trdColumnName+"</a></td>");
   }
   else{
    out.println("<td><a href=\""+url+"\" target=main onmouseover=\"setstatus('"+trdColumnName+"')\" onmouseout=\"setstatus('')\"><IMG src='images/jian.gif' border=0 name=img"+trdColumnName+"></a></td>");
    out.println("<td><a href=\""+url+"\" target=main onmouseover=\"setstatus('"+trdColumnName+"')\") onmouseout=\"setstatus('')\">"+trdColumnName+"</a></td>");
   }
                                  
}
      out.println("</tr>");
j++;
}

out.println("</table></DIV>");
idSign="KB";
     parentIdName="Parent";
    childIdName="Child";
    i++;
DBQuery_Second.release();     
    
}
}catch(SQLException e){
     out.println("出现SQL异常"+e.toString());
    }     
    
//释放连接
    //ps=null;
DBQuery.release();    }catch(Exception e){
     System.out.println("出现SQL异常"+e.toString());
    }