污染网站代码_辽宁省建设工程信息网网_引擎优化是什么意思_长沙企业seo优化

以下代码集成spring-data-jpa进行数据库操作，只需关注easyexcel部分即可。

1.引入依赖

<dependencies><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-web</artifactId><version>3.2.5</version></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-data-jpa</artifactId><version>3.2.5</version></dependency><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>8.0.33</version></dependency><!--引入easyexcel依赖包--><dependency><groupId>com.alibaba</groupId><artifactId>easyexcel</artifactId><version>3.1.1</version></dependency></dependencies>

2.application.yml

server:port: 18072spring:application:name: easy-poidatasource:driver-class-name: com.mysql.cj.jdbc.Driverurl: jdbc:mysql://127.0.0.1:3306/java_study?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8&usessL=trueusername: rootpassword: rootjpa:database: MYSQLhibernate:ddl-auto: updateshow-sql: falseopen-in-view: trueproperties:hibernate:format_sql: true

3.创建类型转换类

用于空值转整型，文本转整型等类型异常问题

BigDecimal类型转换

package org.office.easypoi.converter;import cn.hutool.core.util.StrUtil;
import com.alibaba.excel.converters.Converter;
import com.alibaba.excel.enums.CellDataTypeEnum;
import com.alibaba.excel.metadata.GlobalConfiguration;
import com.alibaba.excel.metadata.data.ReadCellData;
import com.alibaba.excel.metadata.data.WriteCellData;
import com.alibaba.excel.metadata.property.ExcelContentProperty;import java.math.BigDecimal;public class BigDecimalConverter implements Converter<BigDecimal> {@Overridepublic Class supportJavaTypeKey() {return BigDecimal.class;}// 读入文件数据转为Java实体类@Overridepublic BigDecimal convertToJavaData(ReadCellData<?> cellData