Table of Contents
Mapping CSV to JavaBean
grammar
algorithm
method
Example: Employee.java
Example
Output
in conclusion
Home Java javaTutorial Mapping CSV to JavaBeans using OpenCSV

Mapping CSV to JavaBeans using OpenCSV

Sep 13, 2023 pm 09:29 PM

使用 OpenCSV 将 CSV 映射到 JavaBean

CSV files are basically plain text files that store data in comma-separated columns. OpenCSV is the library for parsing these CSV files, which are otherwise difficult to process. It is a very easy-to-use library that supports multiple functions such as reading and writing CSV files with headers.

In this article, we will discuss the process of mapping CSV files to JavaBeans through OpenCSV. Additionally, OpenCSV is a helpful tool in this process.

Mapping CSV to JavaBean

The OpenCSV library provides some classes and mapping strategies for mapping CSV files to Java Beans. One of the classes is CSVToBean, which is used to map CSV files to JavaBeans. To parse these CSV files, the CSVToBean class needs a mapping strategy defined and passed to the CSVToBean class. One of the popular mapping strategies is HeaderColumnNameTranslateMappingStrategy, which maps column IDs to Java Bean properties.

grammar

The mapping of CSV files to Beans is completed through a series of steps. However, the syntax for creating a HashMap with a mapping between column IDs and beam properties is as follows -

HashMap map = new HashMap();
map.put("column_id", "bean_property");
Copy after login

First, we create a hashmap, and then use the put() function of HashMap to map the column id with the corresponding Java bean property.

algorithm

  • Step One - First add OpenCSV to your Java project using the following dependencies.

For Maven projects, add the following dependencies to the java project -

<dependency>
   <groupId>com.opencsv</groupId>
   <artifactId>opencsv</artifactId>
   <version>4.1</version>
</dependency>
Copy after login

For a Gradle project, you need to add the following dependencies -

compile group: 'com.opencsv', name: 'opencsv', version: '4.1'
Copy after login
  • Step 2 - Now, let’s start the basic steps of mapping csv file to Java Bean.

  • Step 3 - Create a HashMap with a mapping between column IDs and bean properties.

  • Step 4 - Add all the column ids of the csv file corresponding to the bean properties.

  • Step 5 − Create HeaderColumnNameTranslateMappingStrategy object.

  • Step 6 - Now, pass the mapped hashmap to the setColumnMapping() method.

  • Step 7 - Call objects of CSVToBean and CSVReader classes.

  • Step 8 - Now, we will call the parse method of the CSVToBean class and pass it the HeaderColumnNameTranslateMappingStrategy and CSVReader objects.

  • Step 9 - Print the details of the Bean object.

method

Now, let us use OpenCSV to map the contents of the Employee.csv file to JavaBeans. The Employee.csv file contains data such as employee name, department, and salary.

The contents of the Employee.csv file are as follows:

Employee_Name, Department, Salary
Naman, Human Resource, 45000
Nikita, Sales, 35000
Rocky, IT, 50000
Raman, Human Resource, 42000
Copy after login

Now, let us first create the Employee class and then create the main method that maps the contents of that csv file to JavaBeans.

Example: Employee.java

public class Employee {
   private static final long serialVersionUID = 1L;
 
   public String emp_name, department, salary;
 
    public String getName() {
      return emp_name;
   }
 
   public void setName(String n) {
      emp_name  = n;
   }
 
   public String getSalary() {
      return salary;
   }
 
   public void setSalary(String s) {
      salary = s;
   }
 
   public String getDepartment() {
      return department;
   }
 
   public void setDepartment(String d) {
      d = department;
   }
   public String toString() {
      return "Employee [Name=" + emp_name + ", Department= " + department +",
         Salary = " + salary+ "]";
   }
}
Copy after login

The following is the program code of the CsvToBean.java file.

Example

import java.util.*;
import com.opencsv.CSVReader;
import com.opencsv.bean.CsvToBean;
import com.opencsv.bean.HeaderColumnNameTranslateMappingStrategy;

public class csvtobean {
   public static void main(String[] args) {
      Map<String, String> map = new HashMap<>();
      map.put("Employee_Name", "emp_name");
      map.put("Department", "department");
      map.put("Salary", "salary");
      HeaderColumnNameTranslateMappingStrategy<Employee> s =
         new HeaderColumnNameTranslateMappingStrategy<>();
      s.setType(Employee.class);
      s.setColumnMapping(map);
      CSVReader csvReader = null;
      try {
         csvReader = new CSVReader(new FileReader
         ("D:\CSVFiles\Employee.csv"));
      }
      catch (FileNotFoundException e) {
         e.printStackTrace();
      }
      CsvToBean csvToBean = new CsvToBean();
      List<Employee> l = csvToBean.parse(s, csvReader);
      for (Employee x : l) {
         System.out.println(x);
      }
   }
}
Copy after login

Output

Employee [Name=Naman, Department=Human Resource, Salary=45000]
Employee [Name=Nikita, Department=Sales, Salary=35000]
Employee [Name=Rocky, Department=IT, Salary=50000]
Employee [Name=Raman, Department=Human Resource, Salary=42000]
Copy after login

As you can see in the above program code, we first create a hash map that maps column IDs to corresponding bean properties. We then implemented the HeaderColumnNameTranslateMappingStrategy strategy for the Employee class and passed it to the parse method of the CsvToBean class to map the CSV to JavaBean using OpenCSV.

in conclusion

In this article, we looked at how to map CSV files to JavaBeans using OpenCSV. The simple technique discussed to do this is to use the CsvToBean class and a mapping strategy for the objects passed to the CsvToBean class. We discussed the steps and program code to parse employee data in csv format into JavaBeans using OpenCSV.

The above is the detailed content of Mapping CSV to JavaBeans using OpenCSV. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Top 4 JavaScript Frameworks in 2025: React, Angular, Vue, Svelte Top 4 JavaScript Frameworks in 2025: React, Angular, Vue, Svelte Mar 07, 2025 pm 06:09 PM

This article analyzes the top four JavaScript frameworks (React, Angular, Vue, Svelte) in 2025, comparing their performance, scalability, and future prospects. While all remain dominant due to strong communities and ecosystems, their relative popul

How do I implement multi-level caching in Java applications using libraries like Caffeine or Guava Cache? How do I implement multi-level caching in Java applications using libraries like Caffeine or Guava Cache? Mar 17, 2025 pm 05:44 PM

The article discusses implementing multi-level caching in Java using Caffeine and Guava Cache to enhance application performance. It covers setup, integration, and performance benefits, along with configuration and eviction policy management best pra

Node.js 20: Key Performance Boosts and New Features Node.js 20: Key Performance Boosts and New Features Mar 07, 2025 pm 06:12 PM

Node.js 20 significantly enhances performance via V8 engine improvements, notably faster garbage collection and I/O. New features include better WebAssembly support and refined debugging tools, boosting developer productivity and application speed.

How does Java's classloading mechanism work, including different classloaders and their delegation models? How does Java's classloading mechanism work, including different classloaders and their delegation models? Mar 17, 2025 pm 05:35 PM

Java's classloading involves loading, linking, and initializing classes using a hierarchical system with Bootstrap, Extension, and Application classloaders. The parent delegation model ensures core classes are loaded first, affecting custom class loa

Iceberg: The Future of Data Lake Tables Iceberg: The Future of Data Lake Tables Mar 07, 2025 pm 06:31 PM

Iceberg, an open table format for large analytical datasets, improves data lake performance and scalability. It addresses limitations of Parquet/ORC through internal metadata management, enabling efficient schema evolution, time travel, concurrent w

Spring Boot SnakeYAML 2.0 CVE-2022-1471 Issue Fixed Spring Boot SnakeYAML 2.0 CVE-2022-1471 Issue Fixed Mar 07, 2025 pm 05:52 PM

This article addresses the CVE-2022-1471 vulnerability in SnakeYAML, a critical flaw allowing remote code execution. It details how upgrading Spring Boot applications to SnakeYAML 1.33 or later mitigates this risk, emphasizing that dependency updat

How can I implement functional programming techniques in Java? How can I implement functional programming techniques in Java? Mar 11, 2025 pm 05:51 PM

This article explores integrating functional programming into Java using lambda expressions, Streams API, method references, and Optional. It highlights benefits like improved code readability and maintainability through conciseness and immutability

How do I use Maven or Gradle for advanced Java project management, build automation, and dependency resolution? How do I use Maven or Gradle for advanced Java project management, build automation, and dependency resolution? Mar 17, 2025 pm 05:46 PM

The article discusses using Maven and Gradle for Java project management, build automation, and dependency resolution, comparing their approaches and optimization strategies.

See all articles