欢迎来新博客地址参观~ https://www.simonjia.top/
在网上搜了一下关于博客园搬家到wordpress的，很多帖子说到《cnblogs2wp》这个插件，但是不知道因为版本更新的原因还是我的环境问题，一直导入失败。看了下博客园的备份文件（每天晚上18点以后才能备份，周末24小时）就是xml格式，于是打算用java进行dom4j解析，转存sql文件，导入到wp_posts表即可。
这里主要用到dom4j进行xml解析，拼接sql然后以io流的格式存到sql文件中。
主要注意，文章内容要先进行json格式化之后再存入sql文件，不然显示会出现代码行错乱。
以前的文章样式基本没变化！奥利给~
下面贴上代码：
pom文件
<dependency>
<groupId>dom4j</groupId>
<artifactId>dom4j</artifactId>
<version>1.6.1</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>1.2.58</version>
</dependency>
import com.fasterxml.jackson.annotation.JsonInclude;
import com.fasterxml.jackson.core.JsonProcessingException;
import com.fasterxml.jackson.databind.DeserializationFeature;
import com.fasterxml.jackson.databind.ObjectMapper;
import com.fasterxml.jackson.databind.SerializationFeature;
import java.io.IOException;
import java.util.HashMap;
import java.util.Map;
/**
*json工具类
*/
public class JsonUtils {
private static final ObjectMapper JSON = new ObjectMapper();
private static final ObjectMapper JSON_NOFORMAT = new ObjectMapper();
static {
//Include.NON_NULL 属性为NULL 不序列化
JSON.setSerializationInclusion(JsonInclude.Include.NON_NULL);
//是否缩放排列输出
JSON.configure(SerializationFeature.INDENT_OUTPUT, Boolean.TRUE);
//不解析未知的字符串
JSON.configure(DeserializationFeature.FAIL_ON_UNKNOWN_PROPERTIES, false);
//Include.NON_NULL 属性为NULL 不序列化
JSON_NOFORMAT.setSerializationInclusion(JsonInclude.Include.NON_NULL);
//是否缩放排列输出
JSON_NOFORMAT.configure(SerializationFeature.INDENT_OUTPUT, Boolean.FALSE);
JSON_NOFORMAT.configure(DeserializationFeature.FAIL_ON_UNKNOWN_PROPERTIES, false);
}
public static <T> String toJsonNf(T t) {
try {
return JSON_NOFORMAT.writeValueAsString(t);
} catch (JsonProcessingException e) {
e.printStackTrace();
}
return null;
}
public static <T> String toJson(T t) {
try {
return JSON.writeValueAsString(t);
} catch (JsonProcessingException e) {
e.printStackTrace();
}
return null;
}
public static <T> T toObject(String str, Class<T> clazz) {
try {
return (T) JSON.readValue(str, clazz);
} catch (IOException e) {
e.printStackTrace();
}
return null;
}
public static <T> T cast2(Class<T> clazz, Map map) {
return (T) map;
}
public static void main(String args[]) {
}
}
xml文件解析和创建sql文件
import org.dom4j.Document;
import org.dom4j.DocumentException;
import org.dom4j.Element;
import org.dom4j.io.SAXReader;
import java.io.*;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.*;
public class ReadXml {
public static void main(String[] args) throws ParseException {
//创建DOM4J解析器对象
SAXReader saxReader = new SAXReader();
int i = 0;
List<Map> list = new ArrayList<>();
try {
//读取xml文件，并生成document对象 现可通过document来操作文档
Document document = saxReader.read("C:\Users\Administrator\Desktop\CNBlogs_BlogBackup_1_201706_202007.xml");
//获取到文档的根节点
Element rootElement = document.getRootElement();
System.out.println("根节点的名字是:" + rootElement.getName());
//获取子节点列表
Iterator it = rootElement.elementIterator();
while (it.hasNext()) {
Element fistChild = (Element) it.next();
//获取节点的属性值
System.out.println("第1个子节点--" + fistChild.getName());
//获取子节点的下一级节点
Iterator iterator = fistChild.elementIterator();
while (iterator.hasNext()) {
Element element = (Element) iterator.next();
System.out.println("第2个子节点--" + element.getName());
if (element.getName().equalsIgnoreCase("item")) {
Map map = new HashMap();
i++;
Iterator itemElements = element.elementIterator();
while (itemElements.hasNext()) {
Element ielement = (Element) itemElements.next();
String elemetName = ielement.getName();
String elemetValue = ielement.getStringValue();
if ("pubDate".equals(elemetName)) {
elemetValue = getTimestampTimeV17(elemetValue);
}
System.out.println("-------item----name---" + elemetName);
// System.out.println("-------item-----value--" + elemetValue);
map.put(elemetName, elemetValue);
}
list.add(map);
}
}
}
System.out.println("-----总共有多少文章---------" + i);
System.out.println("-----总共有多少文章---------" + list.size());
writeFile(list);
} catch (DocumentException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
/**
* 格式化GMT时间到北京时间
*
* @param str
* @return
* @throws ParseException
*/
public static String getTimestampTimeV17(String str) throws ParseException {
SimpleDateFormat dateFormat = new SimpleDateFormat("EEE, d MMM yyyy HH:mm:ss 'GMT'", Locale.US);
Date date = dateFormat.parse(str);
//加8个时区
Calendar calendar = Calendar.getInstance();
calendar.setTime(date);
calendar.set(Calendar.HOUR, calendar.get(Calendar.HOUR) + 8);
date = calendar.getTime();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String formatTime = sdf.format(date);
System.out.println(formatTime);
return formatTime;
}
/**
* 写入sql文件
*
* @param mapList
* @throws IOException
*/
public static void writeFile(List<Map> mapList) throws IOException {
//写入中文字符时解决中文乱码问题
FileOutputStream fos = new FileOutputStream(new File("C:\Users\Administrator\Desktop\wp.sql"));
OutputStreamWriter osw = new OutputStreamWriter(fos, "UTF-8");
BufferedWriter bw = new BufferedWriter(osw);
int y = 180;
for (int i = 0; i < mapList.size(); i++) {
//所有内容进行json格式化，防止"
"在sql文件中格式化
//获取标题
String post_title = JsonUtils.toJson(String.valueOf(mapList.get(i).get("title")));
//获取发布时间
String post_modified = JsonUtils.toJson(String.valueOf(mapList.get(i).get("pubDate")));
//获取发布内容
String post_content = JsonUtils.toJson(String.valueOf(mapList.get(i).get("description")));
//获取文章路径 y根据文章的id来定义
String guid = JsonUtils.toJson("https://www.simonjia.top/?p=" + y);
y++;
String sql = "INSERT INTO `word_press`.`wp_posts`(id,guid,post_author,post_date,post_date_gmt,post_content,post_title,`post_excerpt`," +
"`post_status`, `comment_status`, `ping_status`, `post_name`,`to_ping`, `pinged`, `post_modified`, `post_modified_gmt`, `post_content_filtered`,`post_parent`,`menu_order`, `post_type`, `post_mime_type`, `comment_count` )VALUES(" +
+y + "," + guid + ",1," + post_modified + "," + post_modified + "," + post_content + "," + post_title + ",'','publish','open', 'open'," + post_title + ",'', '', " + post_modified + "," + post_modified + "," + post_content + ",0," +
"0, 'post', '', 0);";
//默认给文章分到新目录
// String sql = "insert into wp_term_relationships values("+y+",1,0);";
sql = sql.replaceAll(" ", "");
System.out.println("--------sq;------" + sql);
bw.write(sql + "
");
}
//注意关闭的先后顺序，先打开的后关闭，后打开的先关闭
bw.close();
osw.close();
fos.close();
}
}