public static void main(String[] args) {
// TODO Auto-generated method stub
SimpleTreeNode rootSTN = new SimpleTreeNode();
rootSTN.setNodeKey("0");
rootSTN.setNodeName("name");
setTree(rootSTN,"0");
}
public static void setTree(SimpleTreeNode rootStn,String id)
{
String str_a = null;
String strsql= "select * from testtree where parentid ="+id;
ArrayList al = (ArrayList) DBControl.getInstance().executeQuery(strsql);
Iterator it = al.iterator();
while(it.hasNext()){
SimpleTreeNode subTreeNode = new SimpleTreeNode();
HashMap hm = (HashMap) it.next();
str_a = (String) hm.get("test");
String str_id = (String) hm.get("id");
subTreeNode.setNodeKey(str_id);
subTreeNode.setNodeName(str_a);
subTreeNode.setParentKey(id);
rootStn.addChild(subTreeNode);
setTree(subTreeNode,str_id);
}
}
// TODO Auto-generated method stub
SimpleTreeNode rootSTN = new SimpleTreeNode();
rootSTN.setNodeKey("0");
rootSTN.setNodeName("name");
setTree(rootSTN,"0");
}
public static void setTree(SimpleTreeNode rootStn,String id)
{
String str_a = null;
String strsql= "select * from testtree where parentid ="+id;
ArrayList al = (ArrayList) DBControl.getInstance().executeQuery(strsql);
Iterator it = al.iterator();
while(it.hasNext()){
SimpleTreeNode subTreeNode = new SimpleTreeNode();
HashMap hm = (HashMap) it.next();
str_a = (String) hm.get("test");
String str_id = (String) hm.get("id");
subTreeNode.setNodeKey(str_id);
subTreeNode.setNodeName(str_a);
subTreeNode.setParentKey(id);
rootStn.addChild(subTreeNode);
setTree(subTreeNode,str_id);
}
}
字符串是不是应该加上引号呢。