https://grokonez.com/spring-framework/spring-boot/download-csv-file-from-springboot-restapi-mysql-using-apache-commons-csv-spring-jpa

Download CSV File from SpringBoot RestAPI + MySQL – using Apache Commons CSV + Spring JPA

In the tutorial, we show you how to create a 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:

• Java – How to read/write CSV file with Apache Commons CSV
  – How to use Spring JPA MySQL | Spring Boot
• SpringBoot – Upload/Download MultipartFile to FileSystem – Bootstrap 4 + JQuery Ajax

Technologies

- Spring Boot - 2.0.6.RELEASE - Spring JPA - MySQL - Apache Commons CSV - 1.5

Practice

Project Structure ->

Create SpringBoot project

Use SpringToolSuite to create a SpringBoot project with below dependencies:

<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>

Customer Model

- Customer.java ->

More at:

https://grokonez.com/spring-framework/spring-boot/download-csv-file-from-springboot-restapi-mysql-using-apache-commons-csv-spring-jpa

Download CSV File from SpringBoot RestAPI + MySQL – using Apache Commons CSV + Spring JPA

#springboot #restapi #mysql #apache-common