public interface MyBaseMapper<T> extends BaseMapper<T> {
   

    int batchInsert(@Param("list") List<T> entityList);
}

@Component
public class MySqlInjector extends DefaultSqlInjector {
   
	@Override
	public List<AbstractMethod> getMethodList(Class<?> mapperClass, TableInfo tableInfo) {
   
		List<AbstractMethod> defaultMethodList = super.getMethodList(mapperClass, tableInfo);
		defaultMethodList.add(new BatchInsert("batchInsert"));
		return defaultMethodList;
	}
}

public class BatchInsert extends AbstractMethod {
   
	public BatchInsert(String name) {
   
		super(name);
	}

	@Override
	public MappedStatement injectMappedStatement(Class<?> mapperClass, Class<?> modelClass, TableInfo tableInfo) {
   
		KeyGenerator keyGenerator = NoKeyGenerator.INSTANCE;
		SqlMethod sqlMethod = SqlMethod.INSERT_ONE;
		String columnScript = getAllInsertSqlColumn(tableInfo.getFieldList());
		String valuesScript = SqlScriptUtils.convertForeach(LEFT_BRACKET + getAllInsertSqlProperty("item.", tableInfo.getFieldList()) + RIGHT_BRACKET,
				LIST, null, "item", COMMA);
		String keyProperty = null;
		String keyColumn = null;
		// 表包含主键处理逻辑,如果不包含主键当普通字段处理
		if (StringUtils.isNotBlank(tableInfo.getKeyProperty())) {
   
			if (tableInfo.getIdType() == IdType.AUTO) {
   
				/* 自增主键 */
				keyGenerator = Jdbc3KeyGenerator.INSTANCE;
				keyProperty = tableInfo.getKeyProperty();
				// 去除转义符
				keyColumn = SqlInjectionUtils.removeEscapeCharacter(tableInfo.getKeyColumn());
			} else if (null != tableInfo.getKeySequence()) {
   
				keyGenerator = TableInfoHelper.genKeyGenerator(methodName, tableInfo, builderAssistant);
				keyProperty = tableInfo.getKeyProperty();
				keyColumn = tableInfo.getKeyColumn();
			}
		}
		String sql = String.format(sqlMethod.getSql(), tableInfo.getTableName(), columnScript, valuesScript);
		SqlSource sqlSource = super.createSqlSource(configuration, sql, modelClass);
		return this.addInsertMappedStatement(mapperClass, modelClass, methodName, sqlSource, keyGenerator, keyProperty, keyColumn);
	}

	/**
	 * 获取 insert 时所有列名组成的sql片段
	 * @param fieldList 表字段信息列表
	 * @return sql 脚本片段
	 */
	private String getAllInsertSqlColumn(List<TableFieldInfo> fieldList) {
   
		return LEFT_BRACKET + fieldList.stream()
				.map(TableFieldInfo::getColumn).filter(Objects::nonNull).collect(joining(COMMA + NEWLINE)) + RIGHT_BRACKET;
	}

	/**
	 * 获取 insert 时所有属性值组成的sql片段
	 * @param prefix 前缀
	 * @param fieldList 表字段信息列表
	 * @return sql 脚本片段
	 */
	private String getAllInsertSqlProperty(final String prefix, List<TableFieldInfo> fieldList) {
   
		final String newPrefix = prefix == null ? EMPTY : prefix;
		return fieldList.stream()
				.map(i -> i.getInsertSqlProperty(newPrefix).replace(",", ""))
				.filter(Objects::nonNull)
				.collect(joining(COMMA + NEWLINE));
	}
}

@Data
@EqualsAndHashCode(callSuper = true)
@Accessors(chain = true)
@TableName("user")
public class User{
   
	@TableId(value = "id", type = IdType.AUTO)
    private Long id;
    private String userName;
    private int userAge;
}

<insert id="batchInsert" parameterType="java.util.List">
    insert into user(
        id,
        user_name,
        user_age
    )values
    <foreach collection="list" item="item" separator=",">
    (   
    	#{item.id},
        #{item.userName},
        #{item.userAge}
    )
    </foreach>
</insert>

@Override
public MappedStatement injectMappedStatement(Class<?> mapperClass, Class<?> modelClass, TableInfo tableInfo)

//如果你的表名没有主键，那么你需要指定keyGenerator 为NoKeyGenerator，
//因为重写injectMappedStatement最后需要返回return this.addInsertMappedStatement
//其中就需要KeyGenerator 
KeyGenerator keyGenerator = NoKeyGenerator.INSTANCE;
//SqlMethod.INSERT_ONE就是"INSERT INTO %s %s VALUES %s"
//我们依据表的信息生成列名sql片段和属性名sql片段后填入%s就可以得到近似最后的xml sql
SqlMethod sqlMethod = SqlMethod.INSERT_ONE;

//tableInfo.getFieldList()会得到一个包含数据表列信息(不包含主键)的TableFieldInfo类组成的List
String columnScript = getAllInsertSqlColumn(tableInfo.getFieldList());
//这行代码就是在调用这个函数
private String getAllInsertSqlColumn(List<TableFieldInfo> fieldList) {
   
	return LEFT_BRACKET + fieldList.stream()
			//从TableFieldInfo中只拿取列名
			.map(TableFieldInfo::getColumn)
			//过滤null
			.filter(Objects::nonNull)
			//在元素间以逗号和分行分割
			.collect(joining(COMMA + NEWLINE)) + RIGHT_BRACKET;
}
//对于User表，这个函数返回以下String
/*
(user_name,
user_age)
*/

//首先调用了getAllInsertSqlProperty
String valuesScript = SqlScriptUtils.convertForeach(
	// 这也是个内置函数，可以直接去看看
	LEFT_BRACKET + getAllInsertSqlProperty("item.", tableInfo.getFieldList()) + RIGHT_BRACKET,
	LIST, 
	null, 
	"item", 
	COMMA
);
//LEFT_BRACKET + getAllInsertSqlProperty("item.", tableInfo.getFieldList()) + RIGHT_BRACKET
//得到
/*
(#{userName},
#{userAge})
*/
//经过convertForeach函数后，得到如下字符串
/*
<foreach collection="list" item="item" separator=",">
(#{userName},
#{userAge})
 </foreach>
*/

//getAllInsertSqlProperty函数如下
private String getAllInsertSqlProperty(final String prefix, List<TableFieldInfo> fieldList) {
   
	//这里newPrefix 就是"item."
	final String newPrefix = prefix == null ? EMPTY : prefix;
	return fieldList.stream()
			//i.getInsertSqlProperty("item.")是内置函数，假设i现在遍历到了user_name列
			//那么得到的就是"#{userName},"
			//然后,被删了
			//所以本来每个元素从TableFieldInfo变成了形如"#{userName}"的字符串
			.map(i -> i.getInsertSqlProperty(newPrefix).replace(",", ""))
			.filter(Objects::nonNull)
			//在元素间插入逗号和分行
			.collect(joining(COMMA + NEWLINE));
}
//对于User表，这个函数返回以下String
/*
#{userName},
#{userAge}
*/

		//定义主键属性名
		String keyProperty = null;
		//定义主键列名
		String keyColumn = null;
		// 表包含主键处理逻辑,如果不包含主键当普通字段处理
		if (StringUtils.isNotBlank(tableInfo.getKeyProperty())) {
   
			if (tableInfo.getIdType() == IdType.AUTO) {
   
				/* 自增主键 */
				keyGenerator = Jdbc3KeyGenerator.INSTANCE;
				keyProperty = tableInfo.getKeyProperty();
				// 去除转义符
				keyColumn = SqlInjectionUtils.removeEscapeCharacter(tableInfo.getKeyColumn());
			} else if (null != tableInfo.getKeySequence()) {
   
				keyGenerator = TableInfoHelper.genKeyGenerator(methodName, tableInfo, builderAssistant);
				keyProperty = tableInfo.getKeyProperty();
				keyColumn = tableInfo.getKeyColumn();
			}
		}
//这段代码没什么好说的，就是根据不同情况，得到三个变量
//keyGenerator keyProperty keyColumn 

String sql = String.format(sqlMethod.getSql(), tableInfo.getTableName(), columnScript, valuesScript);
//就是把表名user，列名片段，属性名片段，填入%s中，得到如下
/*
INSERT INTO user (user_name,
user_age) VALUES <foreach collection="list" item="item" separator=",">
(#{userName},
#{userAge})
 </foreach>
*/

//这两句没有什么可说的，是重写injectMappedStatement函数的必要的操作
//自定义的内容就在于sql和主键
SqlSource sqlSource = super.createSqlSource(configuration, sql, modelClass);
return this.addInsertMappedStatement(mapperClass, modelClass, methodName, sqlSource, keyGenerator, keyProperty, keyColumn);

/pattern/flags

@GetMapping("move/search")
public AjaxResult moveSearch(StockMoveSearchDTO dto){
   
    startPage();//第一句
    List<BztStockMoveHeadExp> list = stockMgntService.moveSearch(dto);//这是自己本身的逻辑代码
    TableDataInfo dataTable = getDataTable(list);//第二句
    return success(dataTable);
}

public static void startPage()
{
   
    PageDomain pageDomain = TableSupport.buildPageRequest();
    Integer pageNum = pageDomain.getPageNum();
    Integer pageSize = pageDomain.getPageSize();
    String orderBy = SqlUtil.escapeOrderBySql(pageDomain.getOrderBy());
    Boolean reasonable = pageDomain.getReasonable();
    PageHelper.startPage(pageNum, pageSize, orderBy).setReasonable(reasonable);
}

public static PageDomain getPageDomain()
{
   
    PageDomain pageDomain = new PageDomain();
    pageDomain.setPageNum(Convert.toInt(ServletUtils.getParameter(PAGE_NUM), 1));
    pageDomain.setPageSize(Convert.toInt(ServletUtils.getParameter(PAGE_SIZE), 10));
    pageDomain.setOrderByColumn(ServletUtils.getParameter(ORDER_BY_COLUMN));
    pageDomain.setIsAsc(ServletUtils.getParameter(IS_ASC));
    pageDomain.setReasonable(ServletUtils.getParameterToBool(REASONABLE));
    return pageDomain;
}

public static PageDomain buildPageRequest()
{
   
    return getPageDomain();
}

<template>
<el-table :data="tableList" @sort-change="handleSortChange">
	<el-table-column prop="formCreateTime"
						 label="录入日期"
						 sortable="custom"
						 :sort-orders="['ascending', 'descending']"
		>
			<template #default="scope">
				{
  { new Date(scope.row.formCreateTime).toLocaleDateString() }}
			</template>
		</el-table-column>
</template>

<script setup>
const queryParams = reactive({
     
	pageNum: undefined,
	pageSize: undefined,
	orderByColumn: 'formCreateTime',
	isAsc: 'descending',
})
const tableList = ref([])

const handleSortChange=(column)=>{
     
	queryParams.orderByColumn = column.prop;
	queryParams.isAsc = column.order;
	onSubmitQuiet();
}
const onSubmitQuiet = () => {
     
	queryParams.pageNum = 1;
	queryParams.pageSize = 10;
	moveSearch(queryParams).then(rp => {
     
		// console.log(rp)
		tableList.value = rp.data.rows;
		pageTotal.value = rp.data.total;
	})
}
</script>

@GetMapping("move/search")
public AjaxResult moveSearch(StockMoveSearchDTO dto){
   
    startPage();
    List<BztStockMoveHeadExp> list = stockMgntService.moveSearch(dto);
    TableDataInfo dataTable = getDataTable(list);
    return success(dataTable);
}

import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;

@Data
@EqualsAndHashCode(callSuper = true)
@Accessors(chain = true)
@TableName("auto_numbering")
public class AutoNumbering{
   

    private static final long serialVersionUID = 1L;

    /**
     * 主键
     */
    @TableId(value = "id", type = IdType.AUTO)
    private Long id;

    /**
     * 编号名称
     */
    private String name;

    /**
     * 前缀
     */
    private String prefix;

    /**
     * 初始值
     */
    private Long intiValue;

    /**
     * 当前值
     */
    private Long currentValue;

    /**
     * 编号长度（不包含前缀）
     */
    private Integer length;

}

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface AutoNumberingMapper extends BaseMapper<AutoNumbering> {
   

}

public enum AutoNumberingEnum {
   

    STOCK_INPUT("stock_input", "入库编号"),
    PRODUCT_CODE("product_code", "产品编号");
    
    private final String name;
    private final String remark;

    AutoNumberingEnum(String name, String remark) {
   
        this.name = name;
        this.remark = remark;
    }
    
    /**
     * 获取枚举名称
     *
     * @return name
     */
    public String getName() {
   
        return this.name;
    }

    /**
     * 获取枚举描述
     *
     * @return remark
     */
    public String getRemark() {
   
        return this.remark;
    }
}

public interface AutoNumberingService {
   

	/**
	 * 获取下一个编号
	 * @param  param 自动编号枚举值
	 * @return 自动编号字符串
	 */
	String getNextNo(AutoNumberingEnum param);
}

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.io.IOUtils;
import org.springframework.beans.factory.annotation.Autowired;
import java.io.*;
import java.util.ArrayList;
import java.util.List;

@Slf4j
@Service
public class AutoNumberingServiceImpl  implements AutoNumberingService {
   

	@Autowired
	private AutoNumberingMapper autoNumberingMapper ;

	/**
	 * 自动编号方法
	 *
	 * @param  param 自动编号枚举值
	 * @return 编号
	 */
	@Transactional
	public String getNextNo(AutoNumberingEnum param) {
   

		// 查找当前的采番配置信息
		LambdaQueryWrapper<AutoNumbering> wrapper = new LambdaQueryWrapper<>();
		wrapper.eq(AutoNumbering::getName, param.getName());
		List<AutoNumbering> AutoNumberings = AutoNumberingMapper.selectList(wrapper);
		// 未获取到配置信息
		if (AutoNumberings.isEmpty()) {
   
			return null;
		} else {
   
			// 规则获取
			AutoNumbering autoNumbering = AutoNumberings.get(0);
			// 前缀
			String prefix = autoNumbering.getPrefix();
			// 长度
			Integer length = autoNumbering.getLength();
			// 顺番
			Long currentNo = autoNumbering.getCurrentValue();
			// 更新原数据
			currentNo++;
		}
			autoNumbering.setCurrentValue(currentNo);
			AutoNumberingMapper.updateById(autoNumbering);

			// 生成编号
			String formatNo = StringUtils.leftPad(String.valueOf(currentNo), length, "0");
			return String.format("%s%s", prefix, formatNo);
		}
	}

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;

@Component
public class NoGeneratorUtil {
   

    private static AutoNumberingService autoNumberingService;

    @Autowired
    public void setAutoNumberingService(AutoNumberingService autoNumberingService) {
   
        NoGeneratorUtil.autoNumberingService = autoNumberingService;
    }

    /**
     * 获取最新的入库单编号
     * @return 最新的入库单编号
     */
    public static String getNextStockInputNo() {
   
        return autoNumberingService.getNextNo(AutoNumberingEnum.STOCK_INPUT);
    }

    /**
     * 获取最新的产品编号
     * @return 最新的c'p 编号
     */
    public static String getNextProductNo() {
   
        return autoNumberingService.getNextNo(AutoNumberingEnum.PRODUCT_CODE);
    }

String string1 = NoGeneratorUtil.getNextStockInputNo();
String string2 = NoGeneratorUtil.getNextProductNo();

## MyBatis配置
#mybatis:
#  # 搜索指定包别名
#  typeAliasesPackage: com.ruoyi.**.domain
#  # 配置mapper的扫描，找到所有的mapper.xml映射文件
#  mapperLocations: classpath*:mapper/**/*Mapper.xml
#  # 加载全局的配置文件
#  configLocation: classpath:mybatis/mybatis-config.xml
mybatis-plus:
  # 配置要扫描的xml文件目录，classpath* 代表所有模块的resources目录 classpath 不加星号代表当前模块下的resources目录
  mapper-locations: classpath*:mapper/**/*Mapper.xml
  # 实体扫描，*通配符
  typeAliasesPackage: com.ruoyi.**.domain

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>最新版本</version>
</dependency>

//    @Bean
//    public SqlSessionFactory sqlSessionFactory(DataSource dataSource) throws Exception
//    {
   
//        String typeAliasesPackage = env.getProperty("mybatis.typeAliasesPackage");
//        String mapperLocations = env.getProperty("mybatis.mapperLocations");
//        String configLocation = env.getProperty("mybatis.configLocation");
//        typeAliasesPackage = setTypeAliasesPackage(typeAliasesPackage);
//        VFS.addImplClass(SpringBootVFS.class);
//
//        final SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
//        sessionFactory.setDataSource(dataSource);
//        sessionFactory.setTypeAliasesPackage(typeAliasesPackage);
//        sessionFactory.setMapperLocations(resolveMapperLocations(StringUtils.split(mapperLocations, ",")));
//        sessionFactory.setConfigLocation(new DefaultResourceLoader().getResource(configLocation));
//        return sessionFactory.getObject();
//    }

<el-upload
    v-model:file-list="createParams.fileList"
    action="http://localhost:8080/DataMgt/uploadPic"
    :headers="{ Authorization: 'Bearer ' + getToken() }"
    list-type="picture-card"
    :on-success="handleSuccess"
    :before-upload="handlePicBeforeUpload"
    :on-preview="handlePictureCardPreview"
    :on-remove="handleRemove"
>
  <el-icon><Plus /></el-icon>
</el-upload>

@RestController
@RequestMapping("/DataMgt")
public class Home extends BaseController {
   
    private static String picDir = "C:\\Users\\mumu\\Desktop\\images\\";

    @RequestMapping("/uploadPic")
    public AjaxResult uploadPic(MultipartFile file) throws IOException {
   
        String filePath = picDir+ UUID.randomUUID().toString() + file.getOriginalFilename().substring(file.getOriginalFilename().lastIndexOf('.'));
        File saveF = new File(filePath);
        logger.info("save pic:"+filePath);
        file.transferTo(saveF);
        return success(filePath);
    }
}

@Configuration
public class StaticConfig implements WebMvcConfigurer {
   
    @Override
    public void addResourceHandlers(ResourceHandlerRegistry registry) {
   
        registry.addResourceHandler("/images/**")
                .addResourceLocations("file:C:\\Users\\mumu\\Desktop\\images\\");
    }
}

.antMatchers(HttpMethod.GET, "/", "/*.html", "/**/*.html", "/**/*.css", "/**/*.js", "/profile/**", "/images/**").permitAll()

<el-image src="http://localhost:8080/images/1.png" style="width: 200px;height: 200px"></el-image>

<script setup>
	import {
    onBeforeRouteLeave, onBeforeRouteUpdate } from "vue-router";
	
	onBeforeRouteUpdate((to, from, next) => {
   
		console.log("onBeforeRouteUpdate",to,from, typeof next)
		next();
	})
	onBeforeRouteLeave((to, from, next)=>{
   
		console.log("beforeRouteLeave",to,from, typeof next)
		next()
	})
</script>

<script setup>
	import {
   watch} from "vue";
	import {
   useRouter} from "vue-router";
	let router = useRouter()
	// 监听当前路由变化
	watch(() => router.currentRoute.value,(newPath, oldPath) => {
   
		if (newPath != null && oldPath != null && "fullPath" in newPath && "fullPath" in oldPath && newPath["fullPath"] === "/stock/move/moveSearch" && oldPath["fullPath"] === "/stock/move/moveDetail"){
   
			onSubmitQuiet()
		}
	}, {
    immediate: true});
</script>

ISO 8601是一种国际标准的日期和时间表示方式。这种格式的主要特点包括：

- 时间日期按照年月日时分秒的顺序排列，大时间单位在小时间单位之前。
- 每个时间单位的位数固定，不足时于左补0。
- 提供两种方法来表示时间：其一为只有数字的基础格式；其二为添加分隔符的扩展格式，让人能更容易阅读。

具体来说，ISO 8601的日期和时间表示方式的格式为`YYYY-MM-DDTHH:mm:ss.sssZ`，其中：

- `YYYY`代表四位数年份。
- `MM`代表月份。
- `DD`代表天数。
- `T`作为日期和时间的分隔符。
- `HH`代表小时。
- `mm`代表分钟。
- `ss.sss`代表秒和毫秒。
- `Z`代表的是时区。

例如，

"2023年11月15日06时16分50秒"可以表示为"2023-11-15T06:16:50"。
"2023-11-15"是ISO 8601日期格式的一个子集。在ISO 8601中，日期可以表示为"YYYY-MM-DD"的格式。因此，"2023-11-15"是符合ISO 8601日期格式的。

<template>
	<el-button type="primary" @click="updateData" size="small" plain>数据上传</el-button>
	<el-dialog :title="upload.title" v-model="upload.open" width="400px" align-center append-to-body>
		<el-upload
			ref="uploadRef"
			:limit="1"
			accept=".xlsx, .xls"
			:headers="upload.headers"
			:action="upload.url"
			:disabled="upload.isUploading"
			:on-progress="handleFileUploadProgress"
			:on-success="handleFileSuccess"
			:auto-upload="false"
			drag
		>
			<el-icon class="el-icon--upload">
				<upload-filled/>
			</el-icon>
			<div class="el-upload__text">将文件拖到此处，或<em>点击上传</em></div>
			<template #tip>
				<div class="el-upload__tip text-center">
					<span>仅允许导入xls、xlsx格式文件。</span>
				</div>
			</template>
		</el-upload>
		<template #footer>
			<div class="dialog-footer">
				<el-button type="primary" @click="submitFileForm">确 定</el-button>
				<el-button @click="upload.open = false">取 消</el-button>
			</div>
		</template>
	</el-dialog>
</template>
<script setup>

const upload = reactive({
     
	// 是否显示弹出层（用户导入）
	open: false,
	// 弹出层标题（用户导入）
	title: "标题",
	// 是否禁用上传
	isUploading: false,
	// 是否更新已经存在的用户数据
	updateSupport: 0,
	// 设置上传的请求头部
	headers: {
     Authorization: "Bearer " + getToken()},
	// 上传的地址
	url: import.meta.env.VITE_APP_BASE_API + "/yourControllerApi"
});

//数据上传
const updateData = () => {
     
	upload.title = "数据上传";
	upload.open = true;
}

//文件上传中处理
const handleFileUploadProgress = (event, file, fileList) => {
     
	upload.isUploading = true;
	console.log(upload.url)
};

//文件上传成功处理
const handleFileSuccess = (rp, file, fileList) => {
     
	//这里的rp就是后端controller的响应数据
	console.log(rp)
	upload.open = false;
	upload.isUploading = false;
	proxy.$refs["uploadRef"].handleRemove(file);
};
</script>

<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>4.1.2</version>
</dependency>

@PostMapping("/yourControllerApi")
public AjaxResult importData(@RequestBody MultipartFile file){
   
    return stockMgntService.importData(file);
}

@Service
public class StockMgntServiceImpl implements StockMgntService {
   
	@Override
    public AjaxResult importData(MultipartFile file) {
   
    	try(InputStream is = file.getInputStream();) {
   
            Workbook workbook = WorkbookFactory.create(is);
            int numberOfSheets = workbook.getNumberOfSheets();
            if (numberOfSheets != 1){
   
            	//要处理多个sheet，循环就可以
                System.out.println("只允许有1个Sheet");
                return null;
            }
            //取得第一个sheet
            Sheet sheet = workbook.getSheetAt(0);
            //获取最后一行的索引，但通常会比预想的要多出几行。
            int lastRowNum = sheet.getLastRowNum();
            //循环读取每一行
            for (int rowNum = 0; rowNum < lastRowNum; rowNum++) {
   
                Row rowData = sheet.getRow(rowNum);
                if (rowData != null){
   
                	//可以使用rowData.getLastCellNum()获取最后一列的索引，这里只有6行，是假设现在的excel模板是固定的6行
                    for(int cellNum = 0; cellNum < 6; ++cellNum){
   
                        Cell cell = rowData.getCell(cellNum);
                        if (cell == null){
   continue;}
                        cell.setCellType(CellType.STRING);
                        if (!cell.getStringCellValue().isEmpty()){
   
                            System.out.println(cell.getStringCellValue());
                        }
                        /*
                        利用这个方法可以更好的将所有数据以String获取到
						Cell cell = productCodeRow.getCell(cellNum , Row.MissingCellPolicy.RETURN_BLANK_AS_NULL);
                		String cellValue = dataFormatter.formatCellValue(cell );
						*/
                    }
                }
            }
        }catch (Exception e) {
   
        	System.out.println(e.getMessage());
            throw new RuntimeException();
        }
	}
}

<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>4.1.2</version>
</dependency>

@GetMapping("/yourControllerApi")
public AjaxResult exportData(@RequestParam String moveNo, HttpServletResponse response){
   
    System.out.println(moveNo);
    System.out.println(response);
    return stockMgntService.exportData(moveNo, response);
}

@Service
public class StockMgntServiceImpl implements StockMgntService {
   
@Override
    public AjaxResult exportData(String moveNo, HttpServletResponse response) {
   
    //这里是从后台resources文件夹下读取一个excel模板
	ClassPathResource resource = new ClassPathResource("template/模板.xlsx");
        try(InputStream fis = resource.getInputStream();
            Workbook workbook = WorkbookFactory.create(fis);
            ServletOutputStream os = response.getOutputStream()
        ){
   
        	//这块写入你的数据
        	//往第一个sheet的第一行的第2列和第5列写入数据
        	Sheet sheet = workbook.getSheetAt(0);
            sheet.getRow(0).getCell(1, Row.MissingCellPolicy.CREATE_NULL_AS_BLANK).setCellValue("test");
            sheet.getRow(0).getCell(5, Row.MissingCellPolicy.CREATE_NULL_AS_BLANK).setCellValue("test");
            /*......你的操作......*/
            //这块开始配置传输
			response.setCharacterEncoding("UTF-8");
            response.setContentType("application/vnd.ms-excel");
            response.setHeader("Content-disposition", "attachment;filename=template.xlsx");
            response.flushBuffer();
            workbook.write(os);
            os.flush();
            os.close();
        }catch (IOException e) {
   
			throw new RuntimeException(e);
		}
		return null;
	}
}

<template>
	<el-button type="primary" @click="downloadData" size="small" plain>模板下载</el-button>
</template>

<script setup>
const downloadData = () => {
     
	console.log(queryParams.moveNo)
	axios({
     
        url: '/yourControllerApi',
        method: 'get',
        params: {
     moveNo:'0000212132142'},
        responseType: "blob"
    }).then(rp=>{
     
		console.log(rp)
		const blob = new Blob([rp], {
     type: 'application/vnd.ms-excel'});
		let link = document.createElement('a');
		link.href = URL.createObjectURL(blob);
		link.setAttribute('download', '模板下载.xlsx');
		link.click();
		link = null;
	});
}
</script>