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
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()+");oncontextmenu=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();
}