Kotlin Spring Boot RestAPIs – Download CSV File example – Apache Commons CSV + MySQL

Kotlin

87

springboot

136

Mysql

85

csv

9

apachecommons

1

loveprogramming viết ngày 17/04/2021

https://grokonez.com/spring-framework/spring-boot/kotlin-spring-boot/kotlin-spring-boot-restapis-download-csv-file-example-apache-commons-csv-mysql

Kotlin Spring Boot RestAPIs – Download CSV File example – Apache Commons CSV + MySQL

In the tutorial, we show you how to create a Kotlin SpringBoot RestAPIs application that uses Spring JPA to get data from MySQL records and uses Apache Commons CSV library to write data to a CSV file.

Related posts:

• Kotlin – How to read/write CSV file with Apache Commons CSV
• Kotlin Spring JPA + Postgresql | Spring Boot Example
• Kotlin SpringBoot Upload/Download File – MultipartFile + Thymeleaf + Bootstrap 4 example

Technologies

– Kotlin Spring Boot – 2.0.6.RELEASE
– Spring JPA
– MySQL
– Apache Commons CSV

Practice

Project Structure ->

Create Kotlin SpringBoot project

Use SpringToolSuite to create a Kotlin SpringBoot project with below dependencies:

<dependency>
    <groupId>org.jetbrains.kotlin</groupId>
    <artifactId>kotlin-stdlib-jdk8</artifactId>
</dependency>
<dependency>
    <groupId>org.jetbrains.kotlin</groupId>
    <artifactId>kotlin-reflect</artifactId>
</dependency>
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-web</artifactId>
</dependency>      
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>   
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>
<dependency>
    <groupId>org.apache.commons</groupId>
    <artifactId>commons-csv</artifactId>
    <version>1.5</version>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
    <groupId>javax.xml.bind</groupId>
    <artifactId>jaxb-api</artifactId>
    <version>2.3.0</version>
</dependency>

Customer Model

• Customer.kt ->

More at:

https://grokonez.com/spring-framework/spring-boot/kotlin-spring-boot/kotlin-spring-boot-restapis-download-csv-file-example-apache-commons-csv-mysql

Kotlin Spring Boot RestAPIs – Download CSV File example – Apache Commons CSV + MySQL