用jsefa实现CSV转实体类

最新推荐文章于 2024-02-19 15:06:32 发布

原创最新推荐文章于 2024-02-19 15:06:32 发布 · 416 阅读

0 ·

CC 4.0 BY-SA版权

CSV 同时被 2 个专栏收录

3 篇文章

订阅专栏

jsefa

1 篇文章

订阅专栏

本文介绍如何利用Jsefa库读取并解析CSV文件，实现数据的快速导入。通过示例代码展示了如何配置CsvConfiguration，使用HeaderAndFooterFilter过滤表头和表尾，并通过Deserializer读取CSV数据到Java对象中。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

jsefa的maven

<dependency>
			<groupId>net.sf.jsefa</groupId>
			<artifactId>jsefa</artifactId>
			<version>1.1.0.RELEASE</version>
		</dependency>

实现代码

import lombok.Data;
import net.sf.jsefa.common.converter.BigDecimalConverter;
import net.sf.jsefa.csv.annotation.CsvDataType;
import net.sf.jsefa.csv.annotation.CsvField;

import java.io.Serializable;
import java.math.BigDecimal;

@Data
@CsvDataType
public class Radar implements Serializable{

	@CsvField(pos = 1)
	private String id;
	@CsvField(pos = 2)
	private String city;
	@CsvField(pos = 3)
	private String province;
	@CsvField(pos = 4)
	private String type;
	@CsvField(pos = 5)
	private BigDecimal lat;
	@CsvField(pos = 6)
	private BigDecimal lon;
	@CsvField(pos = 7)
	private BigDecimal radius;
	@CsvField(pos = 8)
	private BigDecimal shape;
	@CsvField(pos = 9)
	private BigDecimal step;
	@CsvField(pos = 10,converterType = BigDecimalConverter.class)
	private BigDecimal radius_nowcast;
	@CsvField(pos = 11)
	private BigDecimal shape_nowcast;
	@CsvField(pos = 12)
	private BigDecimal step_nowcast;
	@CsvField(pos = 13)
	private BigDecimal superrefraction;
	@CsvField(pos = 14)
	private BigDecimal ETtop;
	@CsvField(pos = 15)
	private BigDecimal grid_left;
	@CsvField(pos = 16)
	private BigDecimal grid_right;
	@CsvField(pos = 17)
	private BigDecimal grid_up;
	@CsvField(pos = 18)
	private BigDecimal grid_down;
}

@CsvField(pos = 7,converterType = BooleanConverter.class,format = {"1", "0"})
private Boolean tripped;

import lombok.extern.slf4j.Slf4j;
import net.sf.jsefa.Deserializer;
import net.sf.jsefa.common.lowlevel.filter.HeaderAndFooterFilter;
import net.sf.jsefa.csv.CsvIOFactory;
import net.sf.jsefa.csv.config.CsvConfiguration;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.core.io.Resource;
import org.springframework.stereotype.Component;

import java.io.*;
import java.util.*;
import java.util.stream.Collectors;

@Slf4j
@Component
public class RadarConfig {

	@Value(value = "classpath:radar_info_grid.csv")
	private Resource resource;

	public Map<String, Radar> initRadarStation() {
		List<Radar> radars = new ArrayList<>();
		try {
			BufferedReader br = new BufferedReader(new InputStreamReader(resource.getInputStream()));

			CsvConfiguration config = new CsvConfiguration();
			config.setLineFilter(new HeaderAndFooterFilter(1, false, true));//第一行为表头
			config.setFieldDelimiter(',');//csv用,分割
			Deserializer deserializer = CsvIOFactory.createFactory(config, Radar.class)
					.createDeserializer();
			deserializer.open(br);
			while (deserializer.hasNext()) {
				Radar ra = deserializer.next();
				radars.add(ra);
			}
			deserializer.close(true);
		} catch (Exception ex) {
			ex.printStackTrace();
		}
		return radars.stream().collect(Collectors.toMap(Radar::getId,r->r));
	}

}