源码地址:链接:http://pan.baidu.com/s/1o76Okrw 密码:ehda
Demo和本人解析xml成sql的实例
Javatest类
package com.huayu.parseXml;
import java.io.IOException;
import java.io.InputStream;
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import javax.xml.parsers.ParserConfigurationException;
import org.w3c.dom.Document;
import org.w3c.dom.Node;
import org.w3c.dom.NodeList;
import org.xml.sax.SAXException;
public class DomDemo {
public static void main(String[] args) {
// 创建解析器工厂
DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();
// 由工厂创建一个DocumentBuilder解析器
try {
DocumentBuilder db = factory.newDocumentBuilder();
// 创建一个Document对象
InputStream xml = testxml.class.getResourceAsStream("/student.xml");
Document doc = db.parse(xml);
// 获取所有节点
NodeList nodes = doc.getChildNodes();
// 获取根节点
Node root = nodes.item(0);
System.out.println(root.getNodeName());
// 获取根节点的所有子节点
NodeList students = root.getChildNodes();
for (int i = 0; i < students.getLength(); i++) {
// 遍历获得根节点的子节点
Node student = students.item(i);
// 获得根节点下子节点的所有子节点
NodeList texts = student.getChildNodes();
for (int j = 0; j <texts.getLength(); j++) {
// 遍历根节点下子节点的子节点,并输出其文本内容
Node text = texts.item(j);
//System.out.println(texts.item(j) instanceof org.w3c.dom.Element);
if (text.getNodeName().equals("stuno")) {
System.out.println("学号:" + text.getTextContent());
} else if (text.getNodeName().equals("name")) {
System.out.println("姓名:" + text.getTextContent());
} else if (text.getNodeName().equals("sex")) {
System.out.println("性别:" + text.getTextContent());
} else if (text.getNodeName().equals("grade")) {
System.out.println("班级:" + text.getTextContent());
}
}
}
} catch (ParserConfigurationException | SAXException | IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
Src下的xml测试文件
<?xml version="1.0" encoding="UTF-8"?>
<students>
<student id="1001">
<stuno>1001</stuno>
<name>张三</name>
<sex>男</sex>
<grade>Java一班</grade>
</student>
<student id="1002">
<stuno>1002</stuno>
<name>李四</name>
<sex>女</sex>
<grade>Java二班</grade>
</student>
<student id="1003">
<stuno>1003</stuno>
<name>小二</name>
<sex>男</sex>
<grade>Java三班</grade>
</student>
<student id="1004">
<stuno>1004</stuno>
<name>小蜡</name>
<sex>女</sex>
<grade>Java四班</grade>
</student>
<student id="1005">
<stuno>1005</stuno>
<name>小蜡</name>
<sex>女</sex>
<grade>Java四班</grade>
</student>
</students>