StringBuffer optionStr = new StringBuffer();
public String tree(Connection jdbc,int id,int level){
ResultSet rst = null;
Statement stmt = null;
String preStr = "";
String sql = "select * from cms_channel where parent_id = " + id;
try{
stmt = jdbc.createStatement();
rst = stmt.executeQuery(sql);
while(rst.next()){
for(int i=0; i<level; i++) {
optionStr.append("----");
}
optionStr.append(""+rst.getString("channel_id")+",");
optionStr.append(""+rst.getString("channel_name")+"");
//optionStr.append("d.add("+rst.getString("channel_id").trim()+","+rst.getString("parent_id").trim()+",'"+rst.getString("channel_name").trim()+"','javascript:clickMenu("+rst.getString("channel_id").trim()+","+rst.getString("parent_id").trim()+");οncοntextmenu=showMenu("+rst.getString("channel_id").trim()+","+rst.getString("parent_id").trim()+");','"+rst.getString("channel_name").trim()+"');");
optionStr.append("\n\r");
// if(rst.getInt("has_child") != 1) {
tree(jdbc, rst.getInt("channel_id"), ++level);
--level;
// }
}
} 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();
}
public static void main(String[] args) {
//getDBConnection();
System.out.println(new TestDB().tree(TestDB.getDBConnection(),-1,0));
}
运行结果
1,新闻资讯
----6,国内新闻
----7,国际新闻
4,房产资讯
5,体育世界