package com.yeshi.buwan.util;
|
|
import org.jsoup.Jsoup;
|
import org.jsoup.nodes.Document;
|
import org.jsoup.select.Elements;
|
|
import java.io.File;
|
import java.io.IOException;
|
import java.util.ArrayList;
|
import java.util.List;
|
|
public class HtmlToolUtil {
|
|
//解析SQLYog工具导出的html内容
|
public static List<String[]> parseSQLYogExportHtmData(String path, int columns) {
|
List<String[]> contentList = new ArrayList<>();
|
try {
|
Document doc = Jsoup.parse(new File(path), "UTF-8");
|
Elements els = doc.getElementsByTag("tr");
|
for (int i = 1; i < els.size(); i++) {
|
Elements tds = els.get(i).getElementsByTag("td");
|
String[] contents = new String[columns];
|
for (int j = 0; j < columns; j++) {
|
String content = tds.get(j).html().trim();
|
contents[j] = content;
|
}
|
contentList.add(contents);
|
}
|
} catch (IOException e) {
|
e.printStackTrace();
|
}
|
return contentList;
|
}
|
|
}
|
