jsoup 解析xml--适用于格式统一的dom解析

import org.jsoup.Jsoup;
import org.jsoup.nodes.Document;
import org.jsoup.select.Elements;
import java.io.File;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;


public class ParseXML {
    public static void main(String[] args) throws Exception {
        //获取document对象
        Document doc = Jsoup.parse(new File("D:\\解析xml\\新建文本文档.xml"), "utf-8");
        Elements newCtrl = doc.getElementsByTag("NewCtrl");
        Elements content_text = doc.getElementsByTag("Content_Text");
        for (int i=0;i<newCtrl.size();i++){
            String K = newCtrl.get(i).attr("HelpTip");
            String V = content_text.get(i).textNodes().get(0).toString();
            //写入数据库
            Class.forName("com.mysql.cj.jdbc.Driver");
            Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test?useSSL=true&serverTimezone=UTC", "root", "123456");
            Statement statement = connection.createStatement();
            String sql1 = "insert into parsexml(K,V) values('"+K+"'";
            String s = ",";
            String sql2 ="'"+V+"'";
            String sql3 = ")";
            String sql = sql1  +s+ sql2+sql3;
            System.out.println(sql);
            statement.execute(sql);
        }
    }
}

 

pom文件如下

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>ParseXML</groupId>
    <artifactId>app.wheeljack.ParseXml</artifactId>
    <version>1.0-SNAPSHOT</version>

    <dependencies>
        <dependency>
            <groupId>org.jsoup</groupId>
            <artifactId>jsoup</artifactId>
            <version>1.10.3</version>
        </dependency>

        <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.13</version>
        </dependency>

    </dependencies>
</project>