javaÉú³Éxml¸ñʽÊý¾Ý

//»ñÈ¡Êý¾Ý¿âÊý¾Ý·µ»Ølist
public List queryAll(int fcateId) {
List list = new ArrayList();
String sql = "select * from g_Account where fCateID=? order by fCode";
Connection con = SqlHelp.getConn();//»ñµÃÁ¬½Ó£¬sqlhelp×Ô¼ºÐ´µÄ¹¤¾ßÀà
PreparedStatement pst = null;
ResultSet rs = null;
try {
pst = con.prepareStatement(sql);
pst.setInt(1, fcateId);
rs = pst.executeQuery();
while (rs.next()) {
GAccount ga=new GAccount();
ga.setFCode(rs.getString("fCode"));
ga.setFName(rs.getString("fName"));
ga.setFCateID(rs.getInt("fCateID"));
ga.setFLevel(rs.getInt("fLevel"));
ga.setFParent(rs.getString("fParent"));
ga.setFIsDetail(rs.getInt("fIsDetail"));
list.add(ga);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
SqlHelp.colseConn(con, pst, rs);
}
return list;
}
//´Ë·½·¨Êǹؼü£¨»ñÈ¡tree½á¹¹£©
public String getTree(int fcateId){
StringBuffer sb=new StringBuffer();
List gas=this.queryAll(fcateId);
String fparent="";
String fcode="";
int flevel=0;

//sb.append("<node>\r");
for (Iterator iterator = gas.iterator(); iterator.hasNext();) {
GAccount ga = (GAccount) iterator.next();

if (!ga.getFParent().equals(fparent)) {

if (!ga.getFParent().equals(fcode)) {
sb.append("\r"+getT("\t",ga.getFLevel())+"</node>\r");
for (int i = 1; i < flevel - ga.getFLevel(); i++) {
sb.append("\r\t</node>\r");
}
}
}

if(ga.getFLevel()==1){
sb.append("<node label=\"");
sb.append(ga.getFCode()+"-"+ga.getFName());
sb.append("\" id=\""+ga.getFCode()+"\">\r");

if(ga.getFIsDetail()==1){
sb.append("</node>\r");
}
}else{
if(ga.getFIsDetail()==1){
sb.append(""+getT("\t", ga.getFLevel())+"<node label=\"");
sb.append(ga.getFCode()+"-"+ga.getFName());
sb.append("\" id=\""+ga.getFCod