StringBuffer optionStr = new StringBuffer(); public String tree(Connection jdbc,int id,int level){ ResultSet rst = null; Statement stmt = null; String preStr = ""; for(int i=0; i<level; i++) { preStr += "----"; } String sql = "select * from tree where pid = " + id; try{ stmt = jdbc.createStatement(); rst = stmt.executeQuery(sql); while(rst.next()){ optionStr.append("d.add("+rst.getString("id").trim()+","+rst.getString("pid").trim()+",'"+rst.getString("name").trim()+"','javascript:clickMenu("+rst.getString("id").trim()+","+rst.getString("pid").trim()+");οncοntextmenu=showMenu("+rst.getString("id").trim()+","+rst.getString("pid").trim()+");','"+rst.getString("name").trim()+"','"+rst.getString("target").trim()+"','"+rst.getString("icon").trim()+"','"+rst.getString("icon").trim()+"');"); optionStr.append("/r/n"); if(rst.getInt("is_leaf") != 1) { tree(jdbc, rst.getInt("id"), level+1); } } } catch(SQLException e){ e.printStackTrace(); } finally { try { if(rst != null) { rst.close(); rst = null; } if(stmt != null){ stmt.close(); stmt = null; } } catch (SQLException e) { e.printStackTrace(); } } return optionStr.toString(); }