parserxml.java~19~

一个解析xml到数据表的程序

package xmltotable;

import java.io.File;
import javax.xml.parsers.DocumentBuilderFactory;
//import org.w3c.dom.Document;
import java.io.IOException;
import java.util.LinkedList;
import java.util.List;
//import org.w3c.dom.Element;
import org.jdom.input.SAXBuilder;
import org.jdom.Document;
import org.jdom.JDOMException;
import org.jdom.Element;
import org.jdom.Attribute;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */
//jdom在jbulider里自带类库里有。点开Required Libraris，点击add，找到JDOM加入就可以了

public class ParserXml {

  public ParserXml() {
  }
//解析XML文件

  public Document parserFile(File file) {
    SAXBuilder builder = new SAXBuilder();
    try {
      Document doc = builder.build(file);
      return doc;
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
    return null;
  }
//得到文件中数据，通过一个链表装入，链表节点是数据库链表
//链表第一层是database，第二层是table，第三层是table得各个属性
  public List getDbFrDoc(Document doc) {
    LinkedList rBeacon = new LinkedList();

    Element root = doc.getRootElement();
    List nl = root.getChildren();
    for (int i = 0; i < nl.size(); i++) {
      Element databaseEle = (Element) nl.get(i);
      if (databaseEle.getName().equals("database")) {
        LinkedList llist = getTablesList(databaseEle);
        rBeacon.add(llist);
      }
    }
    return rBeacon;
  }
//将各个table作为链表装入数据库链表节点中
  public LinkedList getTablesList(Element dbEle) {
    LinkedList tablesList = new LinkedList();
    List nl = dbEle.getChildren();
    for (int i = 0; i < nl.size(); i++) {
      Element tableEle = (Element) nl.get(i);
      LinkedList tableProList = getTableProList(tableEle);
      tablesList.add(tableProList);
    }
    return tablesList;
  }
//将table的各个属性作为一个链表装入数据库表得链表中
  public LinkedList getTableProList(Element tableEle) {
    LinkedList tableProList = new LinkedList();
    List nl = tableEle.getAttributes();
    for (int i = 0; i < nl.size(); i++) {
      Attribute attrNode = (Attribute) nl.get(i);
      String colName = attrNode.getValue();
      System.out.println("nodeValue:" + colName);
      tableProList.add(colName);
    }
    return tableProList;
  }
}