java制作xml树图

1.IndustryBean.java

package com.javaXMLTree;

public class IndustryBean {
 private String indusid;
 
 private String indusname;
 
 private String parentid;

 public String getIndusid() {
  return indusid;
 }

 public void setIndusid(String indusid) {
  this.indusid = indusid;
 }

 public String getIndusname() {
  return indusname;
 }

 public void setIndusname(String indusname) {
  this.indusname = indusname;
 }

 public String getParentid() {
  return parentid;
 }

 public void setParentid(String parentid) {
  this.parentid = parentid;
 }

}

2.XmlTree.java

package com.javaXMLTree;

import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStreamWriter;
import java.util.Properties;

import org.apache.crimson.tree.XmlDocument;
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;

import org.w3c.dom.Document;
import org.w3c.dom.Element;
import com.javaXMLTree.IndustryBean;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.DriverManager;
import java.util.ArrayList;
public class XmlTree {

 private static Connection conn;
 private static Statement stat;
 private static ResultSet rs;

 
 //写入XML
 public void WriteXML(String fileName,ArrayList list) throws Exception{
   DocumentBuilderFactory dbf=DocumentBuilderFactory.newInstance();
    DocumentBuilder db=null;
    try{
     db=dbf.newDocumentBuilder();
    }
    catch(Exception e){
     e.printStackTrace();
    }
    Document doc=db.newDocument();
   
    Element root=doc.createElement("tree");
    root.setAttribute("id", "0");
    doc.appendChild(root);
   
    Element item =doc.createElement("item");
    item.setAttribute("text","行业选择");
    item.setAttribute("open","0");
   
    String Indusid = "";
    String Indusname = "";
    String Parentid = "";
    Element item1 = null;
    Element item2 = null;
    Element item3 = null;
    Element item4 = null;
    for(int i=0;i<list.size();i++){
    
     IndustryBean bean = (IndustryBean)list.get(i);
     if(bean.getParentid().equals("0")){
      item1=doc.createElement("item");
      Indusid =  bean.getIndusid();
      Indusname =bean.getIndusname();
      Parentid = bean.getParentid();
      item1.setAttribute("text", Indusname);
      item1.setAttribute("id", Indusid);
     
     
      for(int j=i+1;j<list.size();j++){
       IndustryBean bean2 = (IndustryBean)list.get(j);
       if(j!=i+1&&bean2.getParentid().indexOf(Parentid.substring(0,1))<0){
        j=list.size();
       }else{
        if(!bean2.getParentid().equals("0")&&bean2.getParentid().length()==1){
         item2 = doc.createElement("item");
         Indusid =  bean2.getIndusid();
         Indusname =bean2.getIndusname();
         Parentid = bean2.getParentid();
         item2.setAttribute("text", Indusname);
         item2.setAttribute("id", Indusid);
        
        
         for(int z=j+1;z<list.size();z++){
          IndustryBean bean3 = (IndustryBean)list.get(z);
          if(bean3.getParentid().length()==3&&bean3.getParentid().indexOf(Parentid)>=0){
           item3 = doc.createElement("item");
           Indusid =  bean3.getIndusid();
           Indusname =bean3.getIndusname();
           Parentid = bean3.getParentid();
           item3.setAttribute("text", Indusname);
           item3.setAttribute("id", Indusid);
          
           for(int s=z+1;s<list.size();s++){
           
            IndustryBean bean4 = (IndustryBean)list.get(s);
            if(s!=z+1&&bean4.getParentid().length()==3){
             s=list.size();
            }else{
             if(bean4.getParentid().length()==4&&bean4.getParentid().indexOf(Parentid)>=0){
              item4 = doc.createElement("item");
              Indusid =  bean4.getIndusid();
              Indusname =bean4.getIndusname();
              item4.setAttribute("text", Indusname);
              item4.setAttribute("id", Indusid);
              item3.appendChild(item4);
             }
            }   
           }
           item2.appendChild(item3);
          }
         }
         item1.appendChild(item2);
        } 
       }
      }
      item.appendChild(item1);
     }
    }
   
   
    /*
   
    Element age=doc.createElement("item");
    age.setAttribute("text", "飞机");
    age.setAttribute("id", "fj");
   
    Element age1=doc.createElement("item");
    age1.setAttribute("text", "飞机制造");
    age1.setAttribute("id", "fj1");
    Element age12=doc.createElement("item");
    age12.setAttribute("text", "零件制造");
    age12.setAttribute("id", "fj12");
    age1.appendChild(age12);
    age.appendChild(age1);
   
    Element age2=doc.createElement("item");
    age2.setAttribute("text", "飞机销售");
    age2.setAttribute("id", "fj2");
    age.appendChild(age2);
   
    Element age3=doc.createElement("item");
    age3.setAttribute("text", "飞机维修");
    age3.setAttribute("id", "fj3");
    age.appendChild(age3);
   
   
    item.appendChild(age);
   
    Element tel=doc.createElement("item");
    tel.setAttribute("text", "汽车");
    tel.setAttribute("id", "qc");
   
    Element tel1=doc.createElement("item");
    tel1.setAttribute("text", "汽车制造");
    tel1.setAttribute("id", "qc1");
    Element tel12=doc.createElement("item");
    tel12.setAttribute("text", "零件制造");
    tel12.setAttribute("id", "qc12");
    tel1.appendChild(tel12);
    tel.appendChild(tel1);
   
    Element tel2=doc.createElement("item");
    tel2.setAttribute("text", "汽车销售");
    tel2.setAttribute("id", "qc2");
    tel.appendChild(tel2);
   
    Element tel3=doc.createElement("item");
    tel3.setAttribute("text", "汽车维修");
    tel3.setAttribute("id", "qc3");
    tel.appendChild(tel3);

   
    item.appendChild(tel);
   
   
   
   
    age=doc.createElement("item");
    age.setAttribute("text", "飞机1");
    age.setAttribute("id", "1fj");
   
     age1=doc.createElement("item");
    age1.setAttribute("text", "飞机制造1");
    age1.setAttribute("id", "1fj1");
     age12=doc.createElement("item");
    age12.setAttribute("text", "零件制造1");
    age12.setAttribute("id", "1fj12");
    age1.appendChild(age12);
    age.appendChild(age1);
   
     age2=doc.createElement("item");
    age2.setAttribute("text", "飞机销售1");
    age2.setAttribute("id", "1fj2");
    age.appendChild(age2);
   
     age3=doc.createElement("item");
    age3.setAttribute("text", "飞机维修1");
    age3.setAttribute("id", "1fj3");
    age.appendChild(age3);
   
   
    item.appendChild(age);
   
    */
   
    root.appendChild(item);
    try{
     FileOutputStream fos=new FileOutputStream(fileName);
     OutputStreamWriter osw=new OutputStreamWriter(fos,"UTF-8");
     ((XmlDocument)doc).write(osw,"utf-8");
     osw.close();
     fos.close();
    }
    catch(Exception e){
     e.printStackTrace();
    }
  
 }
 
 public ArrayList GetCollocate() throws IOException{
  Properties initProps = new Properties();
  InputStream in =  null;
  int count = 0;
     try {
       in =getClass().getResourceAsStream("config.properties");
       initProps.load(in);
       Class.forName(initProps.getProperty("DBDriver"));
    conn = DriverManager.getConnection(initProps.getProperty("DBUrl"), initProps.getProperty("DBUser"), initProps.getProperty("DBPassword"));
    stat = conn.createStatement();
    rs = stat.executeQuery("select * from Industry where Parentid in (select distinct Parentid from Industry   order by Parentid) order by Indusid ");
       ArrayList<IndustryBean> list =new ArrayList<IndustryBean>();
    while(rs.next()){
     IndustryBean bean = new IndustryBean();
     bean.setIndusid(rs.getString("indusid"));
     bean.setIndusname(rs.getString("indusname"));
     bean.setParentid(rs.getString("parentid"));
     list.add(bean);
        count++;
    }close(rs);
    return list;
     } catch (Exception e) {
       System.out.println("读系统属性\"config.properties\"失败");
       e.printStackTrace();
     }
     return null;
   
 }
 public static void ConnectDataBase(){
  try {
   
  } catch (Exception e) {
   e.printStackTrace();
  }finally{
   
  }
  
 }
 public static void close(Connection conn) {
     try {
       if (conn != null) {
         conn.close();
         conn = null;
       }
     } catch (SQLException e) {
       e.printStackTrace();
     }
   }
 
   public static void close(PreparedStatement pstmt) {
     try {
       if (pstmt != null) {
         pstmt.close();
         pstmt = null;
       }
     } catch (SQLException e) {
       e.printStackTrace();
     }
   }
 
   public static void close(Statement stmt) {
     try {
       if (stmt != null) {
         stmt.close();
         stmt = null;
       }
     } catch (SQLException e) {
       e.printStackTrace();
     }
   }
 
   public static void close(ResultSet rs) {
     try {
       if (rs != null) {
         rs.close();
         rs = null;
       }
     } catch (SQLException e) {
       e.printStackTrace();
     }
   }
 
 public static void main(String[] args) throws Exception {
  XmlTree xml = new XmlTree();
  ArrayList list = xml.GetCollocate();
  xml.WriteXML("WebRoot/jsp/xmlTest.xml",list);
    }
}

表结构在压缩包里。