Kotlin + Spring Boot + Apache Commons Export Data to CSV Example

 Hello everyone, today we will learn how to export and download the data as a CSV file in a Kotlin + Spring Boot project. CSV stands for Comma-Separated-Values and it's a common format for doing a bulk data transfer between systems. For creating and parsing CSV files, we will use Apache Commons' 3rd-party library. 


Project Directory:


Technologies used:

  • Kotlin
  • Spring Boot
  • Apache Commons
  • Spring Data JPA
  • H2DB
  • Maven

Maven[pom.xml]

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 
https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.3.7.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.knf.dev</groupId>
    <artifactId>kotlin_springboot_apachecommans_exportcsv</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>kotlin_springboot_apachecommans_exportcsv</name>
    <description>Demo project for Spring Boot</description>

    <properties>
        <java.version>1.8</java.version>
        <kotlin.version>1.3.72</kotlin.version>
    </properties>

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>com.fasterxml.jackson.module</groupId>
            <artifactId>jackson-module-kotlin</artifactId>
        </dependency>
        <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-csv</artifactId>
            <version>1.8</version>
        </dependency>
        <dependency>
            <groupId>org.jetbrains.kotlin</groupId>
            <artifactId>kotlin-reflect</artifactId>
        </dependency>
        <dependency>
            <groupId>org.jetbrains.kotlin</groupId>
            <artifactId>kotlin-stdlib-jdk8</artifactId>
        </dependency>

        <dependency>
            <groupId>com.h2database</groupId>
            <artifactId>h2</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
            <exclusions>
                <exclusion>
                    <groupId>org.junit.vintage</groupId>
                    <artifactId>junit-vintage-engine</artifactId>
                </exclusion>
            </exclusions>
        </dependency>
    </dependencies>

    <build>
        <sourceDirectory>${project.basedir}/src/main/kotlin</sourceDirectory>
        <testSourceDirectory>${project.basedir}/src/test/kotlin</testSourceDirectory>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
            <plugin>
                <groupId>org.jetbrains.kotlin</groupId>
                <artifactId>kotlin-maven-plugin</artifactId>
                <configuration>
                    <args>
                        <arg>-Xjsr305=strict</arg>
                    </args>
                    <compilerPlugins>
                        <plugin>spring</plugin>
                    </compilerPlugins>
                </configuration>
                <dependencies>
                    <dependency>
                        <groupId>org.jetbrains.kotlin</groupId>
                        <artifactId>kotlin-maven-allopen</artifactId>
                        <version>${kotlin.version}</version>
                    </dependency>
                </dependencies>
            </plugin>
        </plugins>
    </build>

</project>

Creating the Document

package com.knf.dev.entity

import javax.persistence.*

@Entity
@Table(name = "employee")
class Employee {
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    var id: Long = 0
    var name: String? = null
    var email: String? = null
    var country: String? = null
    var age = 0
    var role: String? = null

    constructor() : super() {}
    constructor(
        name: String?, email: String?, country: String?,
        age: Int, role: String?
    ) : super() {
        this.name = name
        this.email = email
        this.country = country
        this.age = age
        this.role = role
    }
}

Creating the Repository

package com.knf.dev.repository

import com.knf.dev.entity.Employee
import org.springframework.data.jpa.repository.JpaRepository
import org.springframework.stereotype.Repository

@Repository
interface EmployeeRepository : JpaRepository<Employee, Long>

Creating the Service

package com.knf.dev.service

import java.io.ByteArrayInputStream
import com.knf.dev.entity.Employee
import com.knf.dev.helper.CSVHelper
import com.knf.dev.helper.CSVHelper.employeesToCSV
import com.knf.dev.repository.EmployeeRepository
import org.springframework.beans.factory.annotation.Autowired
import org.springframework.stereotype.Service


@Service
class EmployeeService {
    @Autowired
    var employeeRepository: EmployeeRepository? = null
    fun fetchAll(): List<Employee> {
        return employeeRepository!!.findAll()
    }

    fun load(): ByteArrayInputStream {
        //save Dummy Data
        saveDummyEmployees()
        val employees = fetchAll()
        return CSVHelper.employeesToCSV(employees)
    }

    //save Dummy Data
    fun saveDummyEmployees() {

        val employees: MutableList<Employee> = ArrayList()

        // create dummy employees
        employees.add(
            Employee(
                "Dummy-1", "dummy1@example.com",
                "India", 35, "Lead Tester"
            )
        )
        employees.add(
            Employee(
                "Dummy-2", "dummy2@srovoki.me",
                "USA", 25, "Tester"
            )
        )
        employees.add(
            Employee(
                "Dummy-3", "dummy3@gmail.com",
                "Japan", 29, "Sr.Tester"
            )
        )
        employees.add(
            Employee(
                "Dummy-1", "dummy1@example.com",
                "India", 35, "Lead Tester"
            )
        )
        employees.add(
            Employee(
                "Dummy-2", "dummy2@srovoki.me",
                "USA", 25, "Tester"
            )
        )
        employees.add(
            Employee(
                "Dummy-3", "dummy3@gmail.com",
                "Japan", 29, "Sr.Tester"
            )
        )
        employees.add(
            Employee(
                "Dummy-1", "dummy1@example.com",
                "India", 35, "Lead Tester"
            )
        )
        employees.add(
            Employee(
                "Dummy-2", "dummy2@srovoki.me",
                "USA", 25, "Tester"
            )
        )
        employees.add(
            Employee(
                "Dummy-3", "dummy3@gmail.com",
                "Japan", 29, "Sr.Tester"
            )
        )
        employees.add(
            Employee(
                "Dummy-1", "dummy1@example.com",
                "India", 35, "Lead Tester"
            )
        )
        employees.add(
            Employee(
                "Dummy-2", "dummy2@srovoki.me",
                "USA", 25, "Tester"
            )
        )
        employees.add(
            Employee(
                "Dummy-3", "dummy3@gmail.com",
                "Japan", 29, "Sr.Tester"
            )
        )
        employees.add(
            Employee(
                "Dummy-1", "dummy1@example.com",
                "India", 35, "Lead Tester"
            )
        )
        employees.add(
            Employee(
                "Dummy-2", "dummy2@srovoki.me",
                "USA", 25, "Tester"
            )
        )
        employees.add(
            Employee(
                "Dummy-3", "dummy3@gmail.com",
                "Japan", 29, "Sr.Tester"
            )
        )
        employeeRepository?.saveAll(employees)
    }
}

Creating the Helper 

package com.knf.dev.helper

import java.io.IOException
import java.io.ByteArrayInputStream
import com.knf.dev.entity.Employee
import java.io.PrintWriter
import org.apache.commons.csv.CSVPrinter
import org.apache.commons.csv.CSVFormat
import java.io.ByteArrayOutputStream
import java.util.*


object CSVHelper {
    fun employeesToCSV(employees: List<Employee>): ByteArrayInputStream {
        val format = CSVFormat.DEFAULT.withHeader("ID", "Name", "Email", 
                  "Age", "Country", "Role")
        try {
            ByteArrayOutputStream().use({ out ->
                CSVPrinter(
                    PrintWriter(out),
                    format
                ).use { csvPrinter ->
                    for (emp in employees) {
                        val data: List<String?> = Arrays.asList(
                            emp.id.toString(),
                            emp.name, emp.email,
                            java.lang.String.valueOf(emp.age), emp.country,
                            emp.role
                        )
                        csvPrinter.printRecord(data)
                    }
                    csvPrinter.flush()
                    return ByteArrayInputStream(out.toByteArray())
                }
            })
        } catch (e: IOException) {
            throw RuntimeException(
                "fail to import data to CSV file: "
                        + e.message
            )
        }
    }
}

Creating the Controller

package com.knf.dev.controller

import org.springframework.http.HttpHeaders
import org.springframework.http.ResponseEntity
import org.springframework.core.io.InputStreamResource
import javax.servlet.http.HttpServletResponse
import org.springframework.web.bind.annotation.GetMapping
import com.knf.dev.service.EmployeeService
import org.springframework.beans.factory.annotation.Autowired
import org.springframework.http.MediaType
import org.springframework.stereotype.Controller


@Controller
class EmployeeController {
    @Autowired
    var employeeService: EmployeeService? = null
    @GetMapping("/export-employees")
    @Throws(Exception::class)
    fun exportCSV(response: HttpServletResponse?): 
              ResponseEntity<InputStreamResource> {
        val filename = "employees.csv"
        val file = InputStreamResource(employeeService!!.load())
        return ResponseEntity.ok().header(
            HttpHeaders.CONTENT_DISPOSITION,
            "attachment; filename=$filename"
        )
            .contentType(MediaType.parseMediaType("application/csv")).body(file)
    }
}

Driver

package com.knf.dev

import org.springframework.boot.autoconfigure.SpringBootApplication
import org.springframework.boot.runApplication

@SpringBootApplication
class KotlinSpringbootApachecommansExportcsvApplication

fun main(args: Array<String>) {
   runApplication<KotlinSpringbootApachecommansExportcsvApplication>(*args)
}

Run 

$ mvn spring-boot:run

Hit this URL in your local system, http://localhost:8080/export-employees

Open the downloaded CSV file


Download source code




Comments

Post a Comment

Popular posts from this blog

Learn Java 8 streams with an example - print odd/even numbers from Array and List

Example 1: Java 8 program to print odd numbers from a List   import java.util.Arrays; import java.util.List; import java.util.stream.Collectors; /*Java 8 Program to find Odd Numbers from a List*/ public class DriverClass { public static void main( String [] args) { List < Integer > numbers = Arrays. asList( 1 , 4 , 8 , 40 , 11 , 22 , 33 , 99 ); List < Integer > oddNumbers = numbers.stream(). filter(o -> o % 2 != 0 ). collect(Collectors.toList()); System.out.println(oddNumbers); } } 1. Initialize List using Arrays.asList() method. Java's built-in Arrays.asList() method converts an array into a list. This method takes an array as an argument and returns a List object. 2.  Java List interface provides stream() method which returns a sequential Stream with list of Integer as its source. 3. The Java stream filter() method allow
Read more

ReactJS - Bootstrap - Buttons

Image
Bootstrap is a free and open-source front-end development framework for the creation of websites and web apps. It is a free and open-source project, hosted on GitHub, and originally engendered by Twitter.  Let us create a new React app - click here After engendering the React app, the best way to install Bootstrap is via the npm package. To install Bootstrap, navigate to the React app folder, and run the following command. $ npm install react-bootstrap bootstrap --save Example import React from 'react' ; import Button from 'react-bootstrap/Button' ; import 'bootstrap/dist/css/bootstrap.min.css' ; class App extends React.Component { render() { return ( <div> <> <Button variant = "primary" > Primary </Button> { ' ' } <Button variant = "secondary" > Secondary </Button> { ' ' } <Butto
Read more

Spring Core | BeanFactoryPostProcessor | Example

Image
In Spring, the  BeanFactoryPostProcessor is a  functional interface that contains a abstract method postProcessBeanFactory .   It allows us to modify the Spring context’s bean definitions before any beans get created.  BeanFactoryPostProcessor can create new bean definitions or modify existing ones. Since  BeanFactoryPostProcessor  should be called before other bean types are formed, it must be registered as a static method level. BeanFactoryPostProcessor example We are creating a simple maven project. You could clone the code from our GitHub repo. Final Project Directory Complete pom.xml <? xml version ="1.0" encoding ="UTF-8" ?> < project xmlns ="http://maven.apache.org/POM/4.0.0" xmlns:xsi ="http://www.w3.org/2001/XMLSchema-instance" xsi :schemaLocation ="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd" > < modelVersion >4.0.0</ modelVersion > < gr
Read more

Spring Boot 3 + Spring Security 6 + Thymeleaf - Registration and Login Example

Image
In this section we will learn how to create user registration and login using Spring boot 3, Spring security 6, Thymeleaf, JPA, and PostgreSQL. The GitHub repository link is provided at the end of this tutorial. You can download the source code. What’s New in Spring Security 6? WebSecurityConfigurerAdapter Removed : The  WebSecurityConfigurerAdapter class was deprecated and then removed in Spring Security 6. Instead, you should now take a more component-based approach and create a bean of type  SecurityFilterChain . Here's an example: @Configuration @EnableWebSecurity public class SecurityConfiguration { @Bean public SecurityFilterChain securityFilterChain ( HttpSecurity http) throws Exception { http .authorizeHttpRequests((requests) -> requests .requestMatchers( "/registration**" ).permitAll() .anyRequest().authenticated() ) .formLogin((form) -> form
Read more

File Upload, Download, And Delete - Azure Blob Storage + Spring Boot Example

Image
In this section, you will learn how to create  a storage account on Microsoft Azure and create a simple spring boot application to perform different file operations such as upload, download, and delete files from the Azure blob storage. A little bit of Background Azure Blob Storage Azure Blob storage is Microsoft's object storage solution for the cloud. Blob storage is optimized for storing massive amounts of unstructured data. Unstructured data is data that doesn't adhere to a particular data model or definition, such as text or binary data. More Info -  https://docs.microsoft.com/en-us/azure/storage/blobs/storage-blobs-introduction Spring Boot Spring Boot makes it easy to create stand-alone, production-grade Spring-based Applications that you can "just run".  More Info -  https://spring.io/projects/spring-boot Create an Azure Storage Account and blob container using Azure Portal Sign in to Azure portal  https://portal.azure.com/#home  and search for " Storage a
Read more

Custom Exception Handling in Quarkus REST API

Image
In this section, we will learn how to handle exceptions in the Quarkus REST application using ExceptionMapper interface implementations. ExceptionMapper is a contract for a provider that will map a thrown application exception to a Response object. We will show you custom exception handling with the help of a simple application, Final  Project Directory: Complete pom.xml  <?xml version = "1.0" ?> <project     xsi:schemaLocation = "http://maven.apache.org/POM/4.0.0     https://maven.apache.org/xsd/maven-4.0.0.xsd"     xmlns = "http://maven.apache.org/POM/4.0.0"     xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance" >     <modelVersion> 4.0.0 </modelVersion>     <groupId> org.knf.dev.demo </groupId>     <artifactId> quarku-custom-exception-handling </artifactId>     <version> 1.0.0-SNAPSHOT </version>     <properties>         <compiler-plugin.version> 3.8.1 </compiler-
Read more

ReactJS, Spring Boot JWT Authentication Example

Image
In this tutorial, we’ll create a user registration & login example using ReactJS, Spring Boot, Spring Security, and JWT authentication. You could download the source code from our Github repository, the download link is provided at the end of this tutorial. Technologies used Backend Technologies: Java 17 Spring Boot 2.7.0 Spring Security Spring Data JPA JWT H2 Database Frontend Technologies: React 17.0.1 Axios 0.27.2 Redux 4.0.5 Bootstrap 4.5.2 ReactJS - SpringBoot - JWT - Flow Backend Project Directory: Frontend Project Directory: Following is the screenshot of our application - User Registration: User Signin: Profile View: Access Resource: We will build two projects:  1. Backend:   spring-boot-security-jwt 2. Frontend: react-redux-jwt Project 1: spring-boot-security-jwt Pom.xml <?xml version = "1.0" encoding = "UTF-8" ?> <project xmlns = "http://maven.apache.org/POM/4.0.0" xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance"
Read more

Java, Spring Boot Mini Project - Library Management System - Download

Image
Hello everyone, Hope you are doing well. Here, we provide a Library Management System mini-project for beginners, it's free for download. Maybe you can build more on top of this project and create your own product, that's all about you. The source code download link is provided at the end of this post. 1. Benefit of this project You could cover the following technologies and features by learning and debugging this mini project. Java 17 Java Stream Java Lamda Expressions Java Records Functional programming Object-oriented programming var Keyword in Java Generics in Java Java Switch Spring boot 2.6.4 Spring Security Thymeleaf template engine OpenCSV Spring Data JPA Server Side Pagination H2 Database  Bootstrap HTML CSS and more... 2. Objective Of Spring Boot On Library Management System The main objective of this project is to manage the details of the books, author, category, and publisher. Only Admin/Librarian will manage all these activities. Also, they can export the data in
Read more

Top 5 Java ORM tools - 2024

Image
  The term ORM refers to object-relational mapping, which uses objects to adapt programming languages to database systems while allowing them to function with SQL and object-oriented programming ideas. Any kind of database management system that can accomplish object mapping to the table in the virtual system is suitable for the implementation of ORM. Java has a wide variety of ORM tools, some of which are mentioned below: 1. Hibernate Hibernate is a lightweight, open-source, non-invasive Java ORM (Object-Relational Mapping) framework that allows developers to create objects that function independently of database software and create persistence logic in any Java or JavaEE application. It offers an abstraction layer, so developers don't have to bother about implementations; Hibernate handles these tasks internally, such as connecting to databases and creating queries to carry out CRUD operations, among other things. Persistence logic development is done with it. Persistence logic r
Read more

Java - DES Encryption and Decryption example

DES (Data Encryption Standard) algorithm is the most commonly used encryption  symmetric-key  algorithm in the world. For a long time, "cipher generation" was synonymous with DES in many people's minds. Although the Electronic Frontier Foundation recently called, it built a 220,000 machine to try to crack DES encrypted data. DES and its variant "triple data encryption algorithm" will still be widely used in government and banking. AES became the replacement for DES).   DES processes bits or binary numbers. We know that every four bits make up a hexadecimal number. DES encrypts a set of 64-bit information, which is represented by 16 hexadecimal numbers. DES also uses 64-bit long ciphers to provide encryption. However, every 8 bits in the key are ignored, resulting in a correct key length of 56 bits in DES. However, in any case, one 64-bit block is an eternal DES organization. Java DES Encryption and Decryption   import javax.crypto.Cipher; import javax.crypto.K
Read more