EN
Java - how to read CSV file into java object using Jackson CSV library - complex example with BigDecimal and enum
15 points
In this post we will read CSV file into java pojo object using Jackson CSV processor.
This example contains BigDecimal and enum as ComplexUserDto properties.
To use Jackson CSV library we need to add jackson-dataformat-csv dependency to pom.xml.
xxxxxxxxxx1
<dependency>2
<groupId>com.fasterxml.jackson.dataformat</groupId>3
<artifactId>jackson-dataformat-csv</artifactId>4
<version>2.9.9</version>5
</dependency>Below we have all classes we need to read csv file. Ensure to create csv file on your disc and set correct path in ComplexUserCsvReader class.
To run this example copy to your project those 3 files:
- ComplexUserCsvReader
- ComplexUserDto
- users.csv
2.1 Logic
Logic which reads CSV file into java ComplexUserDto pojo object with Jackson CSV library.
Usage of classes:
- CsvMapper + CsvSchema from jackson CSV library
- MappingIterator from jackson databind library
xxxxxxxxxx1
import com.fasterxml.jackson.databind.MappingIterator;2
import com.fasterxml.jackson.dataformat.csv.CsvMapper;3
import com.fasterxml.jackson.dataformat.csv.CsvSchema;4
5
import java.io.File;6
import java.io.IOException;7
import java.util.List;8
9
public class ComplexUserCsvReader {10
11
public static void main(String[] args) throws IOException {12
13
// set correct path to csv file on your disc14
File csvFile = new File("C:\\csv_tests\\complex_users.csv");15
16
CsvMapper csvMapper = new CsvMapper();17
18
CsvSchema csvSchema = csvMapper19
.typedSchemaFor(ComplexUserDto.class)20
.withHeader()21
.withColumnSeparator(',')22
.withComments();23
24
MappingIterator<ComplexUserDto> complexUsersIter = csvMapper25
.readerWithTypedSchemaFor(ComplexUserDto.class)26
.with(csvSchema)27
.readValues(csvFile);28
29
List<ComplexUserDto> complexUsers = complexUsersIter.readAll();30
31
complexUsers.forEach(System.out::println);32
}33
}Output:
xxxxxxxxxx1
ComplexUserDto{id=1, name='Ann', age=30, favouriteFruit=ORANGE, money=10001.222}2
ComplexUserDto{id=2, name='Seth', age=25, favouriteFruit=APPLE, money=5550.788}3
ComplexUserDto{id=3, name='Tom', age=27, favouriteFruit=BANANA, money=400.999}2.2 User Pojo object - ComplexUserDto
xxxxxxxxxx1
import com.fasterxml.jackson.annotation.JsonPropertyOrder;2
3
import java.math.BigDecimal;4
5
({"id", "name", "age", "favouriteFruit", "amount"})6
public class ComplexUserDto {7
8
enum Fruit {9
APPLE, BANANA, ORANGE10
}11
12
private Long id;13
private String name;14
private Integer age;15
private Fruit favouriteFruit;16
private BigDecimal money;17
18
public ComplexUserDto() {19
20
}21
22
public Long getId() {23
return id;24
}25
26
public void setId(Long id) {27
this.id = id;28
}29
30
public String getName() {31
return name;32
}33
34
public void setName(String name) {35
this.name = name;36
}37
38
public Integer getAge() {39
return age;40
}41
42
public void setAge(Integer age) {43
this.age = age;44
}45
46
public Fruit getFavouriteFruit() {47
return favouriteFruit;48
}49
50
public void setFavouriteFruit(Fruit favouriteFruit) {51
this.favouriteFruit = favouriteFruit;52
}53
54
public BigDecimal getMoney() {55
return money;56
}57
58
public void setMoney(BigDecimal money) {59
this.money = money;60
}61
62
63
public String toString() {64
return "ComplexUserDto{" +65
"id=" + id +66
", name='" + name + '\'' +67
", age=" + age +68
", favouriteFruit=" + favouriteFruit +69
", money=" + money +70
'}';71
}72
}2.3 Complex user CSV file
Save this file on disc as 'complex_users.csv' and change location in ComplexUserCsvReader class.
xxxxxxxxxx1
id,name,age,favouriteFruit,money2
1,Ann,30,ORANGE,10001.2223
2,Seth,25,APPLE,5550.7884
3,Tom,27,BANANA,400.999