下划线转驼峰

    /*** 下划线转驼峰* 字符串 "USER_NAME" 会被转换为 "userName"* 字符串 "user_name" 会被转换为 "userName"* @param underscoreStr* @return*/public static String underlineToCamelCase(String underscoreStr) {if (underscoreStr == null) {return null;}// 先全部转小写underscoreStr = underscoreStr.toLowerCase();// 首字母小写StringBuilder camelCaseStr = new StringBuilder();boolean nextIsUpperCase = false;for (char underscoreChar : underscoreStr.toCharArray()) {if ('_' == underscoreChar) {nextIsUpperCase = true;} else if (nextIsUpperCase) {camelCaseStr.append(Character.toUpperCase(underscoreChar));nextIsUpperCase = false;} else {camelCaseStr.append(underscoreChar);}}return camelCaseStr.toString();}

POI 导出Excel工具类

package com.bairong.micro.modules.util;import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFCellStyle;
import org.apache.poi.xssf.usermodel.XSSFFont;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;import java.io.IOException;
import java.io.OutputStream;
import java.lang.reflect.Field;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.LinkedHashMap;
import java.util.List;/*** Excel导出工具类** @Author:Y.P* @CreateDate:2024/9/19 15:47* @Version:v1.0*/
public class ExcelExportUtil {private static Logger log = LoggerFactory.getLogger(ExcelExportUtil.class);public static void downLoadFile(List contextlist, List<String> titleNameList,OutputStream outputStream) throws Exception {// 创建excel文件SXSSFWorkbook wb = new SXSSFWorkbook();// 将数据写入Excel中buildSheet(wb, contextlist, titleNameList);// 将数据写出去try {wb.write(outp