DateTimeUtilTest.java 1.53 KB
package com.canrd.webmagic.utils;

import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.canrd.webmagic.BaseTest;
import com.canrd.webmagic.common.utils.StringUtils;
import com.canrd.webmagic.domain.dto.ArticleDO;
import com.canrd.webmagic.service.ArticleService;
import org.junit.Test;

import javax.annotation.Resource;
import java.util.List;

/**
 * @author: xms
 * @description: TODO
 * @date: 2023/2/10 14:09
 * @version: 1.0
 */
public class DateTimeUtilTest extends BaseTest {

    @Resource
    private ArticleService articleService;

    @Test
    public void export() {
        List<ArticleDO> articleDOList = articleService.list(new LambdaQueryWrapper<ArticleDO>().select(ArticleDO::getEmailInfo));
        JSONArray array = new JSONArray();
        for (ArticleDO articleDO : articleDOList) {
            if (StringUtils.isBlank(articleDO.getEmailInfo())) {
                continue;
            }
            JSONArray jsonArray = JSONArray.parseArray(articleDO.getEmailInfo());
            array.addAll(jsonArray);
        }
        System.out.println("联系作者,邮箱");
        for (Object o : array) {
            JSONObject jsonObject = JSONObject.parseObject(JSON.toJSONString(o));
            String authorEmailName = jsonObject.getString("authorEmailName");
            String email = jsonObject.getString("email");
            System.out.println(authorEmailName + "," + email);
        }
    }
}