数据分类分级 数据识别-识别日期类型数据

package test.dateUtil;

import com.alibaba.excel.util.StringUtils;

import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.Locale;
import java.util.regex.Pattern;

/**
 * @author kunZhi
 * @date 2023/4/22 19:40
 */
public class DateTest {
    public static void main(String[] args) {
        regex1("2001年02月10日");
        regex1("二〇一一年三月七日");
        regex1("2001/2/20");
        regex1("2001-2-20");
        regex1("20010220");
        regex1("20010220000000");
        regex1("2001/02/07 00:00:00");
        regex1("2001-03-07 14:00:00");
        regex1("2001/2/20 10:00 PM");
    }
    
    public static String convertChineseNumToArabicNum(String str) {
        String[] chineseNums = {"十月", "二十日", "三十日", "月十日", "二十", "三十", "一", "二", "三", "四", "五", "六", "七", "八", "九", "十", "〇"};
        String[] arabicNums = {"10月", "20日", "30日", "月10日", "2", "3", "1", "2", "3", "4", "5", "6", "7", "8", "9", "1", "0"};

        for (int i = 0; i < chineseNums.length; i++) {
            str = str.replace(chineseNums[i], arabicNums[i]);
        }
        return str;
    }

    public static void regex1(String inputDateStr) {

        String patternDate = null;
        //2001年3月7日
        if (Pattern.compile("^\\d{4}年\\d{1,2}月\\d{1,2}日$").matcher(inputDateStr).matches()) {
            patternDate = "yyyy年M月d日";
        } else if (Pattern.compile("^二[零〇一二三四五六七八九]{1,3}年(十[一二]|[一-九])月(三十|三十一|十[一-九]|二十[一-九]|[一-九])日$").matcher(inputDateStr).matches()) {
            //二〇〇一年三月七日
            inputDateStr = convertChineseNumToArabicNum(inputDateStr);
            patternDate = "yyyy年M月d日";
        } else if (Pattern.compile("^\\d{4}/\\d{1,2}/\\d{1,2}$").matcher(inputDateStr).matches()) {
            //2001/3/7
            patternDate = "yyyy/M/d";
        } else if (Pattern.compile("^\\d{4}-\\d{1,2}-\\d{1,2}$").matcher(inputDateStr).matches()) {
            //2001-3-7
            patternDate = "yyyy-MM-dd";
        } else if (Pattern.compile("^\\d{8}$").matcher(inputDateStr).matches()) {
            //20010307
            patternDate = "yyyyMMdd";
        } else if (Pattern.compile("^\\d{14}$").matcher(inputDateStr).matches()) {
            //20010307121212
            patternDate = "yyyyMMddHHmmss";
        } else if (Pattern.compile("^\\d{4}/\\d{1,2}/\\d{1,2}\\s\\d{1,2}:([0-5]\\d):([0-5]\\d)$").matcher(inputDateStr).matches()) {
            //2001/3/7 0:00
            patternDate = "yyyy/MM/dd HH:mm:ss";
        } else if (Pattern.compile("^\\d{4}-\\d{1,2}-\\d{1,2}\\s\\d{1,2}:([0-5]\\d):([0-5]\\d)$").matcher(inputDateStr).matches()) {
            //2001-3-7 0:00
            patternDate = "yyyy-MM-dd HH:mm:ss";
        }  else if (Pattern.compile("^\\d{4}/\\d{1,2}/\\d{1,2}\\s(0?\\d|1[0-2]):([0-5]\\d) (AM|PM)$").matcher(inputDateStr).matches()) {
            //2001/3/7 12:00 AM
            patternDate = "yyyy/MM/dd hh:mm a";
        } else {
            System.out.println("无法匹配的字符串 ：" + inputDateStr);
        }

        if (!StringUtils.isEmpty(patternDate)) {
            Date inputDate = new Date();
            if (patternDate.equals("yyyy/MM/dd hh:mm a")) {
                DateFormat format = new SimpleDateFormat("yyyy/MM/dd hh:mm a", Locale.ENGLISH);
                format.setLenient(false); // 设置为严格解析日期
                try {
                    inputDate = format.parse(inputDateStr);
                } catch (Exception e) {
                    System.out.println("解析日期字符串出错：" + e.getMessage());
                }
            } else {
                SimpleDateFormat inputDateFormat = new SimpleDateFormat(patternDate);
                inputDateFormat.setLenient(false); // 设置为严格解析日期
                // 解析输入字符串为Date对象
                try {
                    inputDate = inputDateFormat.parse(inputDateStr);
                } catch (Exception e) {
                    System.out.println("解析日期字符串出错：" + e.getMessage());
                }
            }

            // 将Date对象格式化为目标格式的字符串
            SimpleDateFormat outputDateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
            String outputDateStr = outputDateFormat.format(inputDate);
            System.out.println("输入字符串：" + inputDateStr + "目标格式的字符串：" + outputDateStr + "\n");
        }
    }
}