我对 Java 和 Xml 解析还很陌生。我的要求是获取一个 xml 文件，并使用 java.lang 将 XML 文件的数据以表和列格式存储在数据库中。我尝试在谷歌中找到正确的解决方案。但我很无奈。到目前为止，我所做的是，我可以动态获取 xml 数据并存储标签名称或值。但我的要求是只将标签名称作为列名称和与行格式中特定列相关的数据一次，任何人都可以请更正我的代码。

<?xml version="1.0"?>
<company>
    <staff>
        <firstname>yong</firstname>
        <lastname>mook kim</lastname>
        <nickname>mkyong</nickname>
        <salary>100000</salary>
    </staff>
    <staff>
        <firstname>low</firstname>
        <lastname>yin fong</lastname>
        <nickname>fong fong</nickname>
        <salary>200000</salary>
    </staff>
</company>

Java代码

 import java.io.*;
    import javax.xml.parsers.*;
    import org.w3c.dom.*;
    import org.xml.sax.*;

    public class XmlData{
     static public void main(String[] arg){
     try {
     BufferedReader bf = new BufferedReader(new InputStreamReader(System.in));
     System.out.print("Enter XML File Path: ");
     String xmlFile = bf.readLine();
     //Store the String into the File
     File file = new File(xmlFile);
     if(file.exists()){
     // Create a factory
     DocumentBuilderFactory factory =DocumentBuilderFactory.newInstance();
     // Use the factory to create a builder
     DocumentBuilder builder = factory.newDocumentBuilder();
     Document doc = builder.parse(xmlFile);
     Element docEle = doc.getDocumentElement();
     System.out.println("Root element of the document: "+ docEle.getNodeName());
     // Get a list of all elements in the document
     NodeList list = doc.getElementsByTagName("*");

     int totalElements = list.getLength();

     System.out.println("XML Elements: " + totalElements);
     for (int i=0; i<list.getLength(); i++) 
     {
     // Get element
     Element element = (Element)list.item(i);
     String tag=element.getTagName();
     String name=list.item(0).getChildNodes().item(0).getNodeValue();
     System.out.println(name);
     System.out.print(tag);
     System.out.print(" ");
     //System.out.println(element.getNodeName());


     }
     }
     else{
     System.out.print("File not found!");
     }
     }
     catch (Exception e) {
     System.exit(1);
     }
     }
    }

此代码的输出:

company 
staff 
firstname 
lastname 
nickname 
salary 
staff 
firstname 
lastname 
nickname 
salary 

预期输出:

FirstName, Lastname, nickname  , salary  //column

yong     ,mook kim, mkyong     , 100000   // rows
low      ,yin fong, fong fong   ,200000

最佳答案

我假设您已经创建了一个包含四列的数据库表 - FirstNAme、LastName、NickName、Salary。

读取数据并存储在数据库中非常简单。

import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import org.w3c.dom.Document;
import org.w3c.dom.Element;
import org.w3c.dom.NodeList;

public class ParseStaff {
    public static void main(String [] args){
        parseFile();
    }
    public static void parseFile() {
        //get the factory
        DocumentBuilderFactory dbf = DocumentBuilderFactory.newInstance();
        try {
            //Using factory get an instance of document builder
            DocumentBuilder db = dbf.newDocumentBuilder();
            //parse using builder to get DOM representation of the XML file
            //Document dom = db.parse("employees.xml");
            Document dom = db.parse("C:\\GAE\\NetBeansProjects\\Test\\src\\statff.xml");
            //get the root element
            Element docEle = dom.getDocumentElement();
            //get a nodelist of elements
            NodeList nl = docEle.getElementsByTagName("staff");

            if (nl != null && nl.getLength() > 0) {
                for (int i = 0; i < nl.getLength(); i++) {
                    //get the employee element
                    Element el = (Element) nl.item(i);
                    String firstname = getTextValue(el, "firstname");
                    String lastname = getTextValue(el, "lastname");
                    String nickname = getTextValue(el, "nickname");
                    int salary = getIntValue(el, "salary");

                    System.out.println(firstname);
                    System.out.println(lastname);
                    System.out.println(nickname);
                    System.out.println(salary);
                }
            }

        } catch (Exception e) {
            e.printStackTrace();
        }

    }
    private static String getTextValue(Element ele, String tagName) {
        String textVal = null;
        NodeList nl = ele.getElementsByTagName(tagName);
        if (nl != null && nl.getLength() > 0) {
            Element el = (Element) nl.item(0);
            textVal = el.getFirstChild().getNodeValue();
        }

        return textVal;
    }
    private static int getIntValue(Element ele, String tagName) {
        return Integer.parseInt(getTextValue(ele, tagName));
    }
}

将打印:

yong
mook kim
mkyong
100000
low
yin fong
fong fong
200000

关于java - 使用 Java 检索 XMl 数据，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/11329812/