java xml 树,java制造xml树图

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

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

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

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

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 list =new ArrayList();

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);

}

}

表结构在压缩包里。