Spring boot - upload CSV file and store records in database.

Spring boot - upload CSV file and store records in database.

Kirankumar Garaddi Kirankumar Garaddi

Kirankumar Garaddi

Full Stack Developer at Hewlett Packard Enterprise

发布日期: 2018年1月9日
+ 关注

Every morning, I always feel to Learn new and Implement.

Today, I worked on Csv file upload and store records in SQL Database.

Requirement is:

  • Upload Student CSV files which contains multiple properties.
  • Consider mandatory fields are phoneNumber and firstName - If either of property is null ignore that record and return as failed records.
  • primary key is studentId
  • Use opencsv parser to convert CsvToBean
  • return failed student list as Json.

Project exist in GitHub use below link to download or clone repository

Link: Spring boot - csv to sql repository

Run the project using below command:

mvn spring-boot:run


Requirement:

Requirement Video Link


要查看或添加评论，请登录

Kirankumar Garaddi的更多文章

  • Tracing System using Zipkin server
    2020年2月6日

    Tracing System using Zipkin server

    How to do latency analysis for microservice-based applications. Zipkin is a distributed tracing system.

  • All about git and git commands
    2019年12月19日

    All about git and git commands

    Questions: How to create a new repository or existing source code as repository? Answer: 1.?Create remote…

  • Host React Application in AWS S3 Bucket
    2018年12月26日

    Host React Application in AWS S3 Bucket

    Basic question arise to my mind, why we need to run EC2 instance to Host React Application? Now a days every single…

  • Spring Boot - Crud Operation with pagination using JpaRepository(15 minutes)
    2018年1月17日

    Spring Boot - Crud Operation with pagination using JpaRepository(15 minutes)

    Spring Boot - Implemented Post, Get, Delete, Update and Read with pagination Web services(model Student). Time to…

  • Spring boot - Upload Images to S3 Bucket
    2018年1月8日

    Spring boot - Upload Images to S3 Bucket

    Today I worked on Small task, uploading to S3 buckets. Please follow the below steps to easily implement Spring boot…

  • Spring boot - JpaRepository parent & child record insert at once.
    2018年1月5日

    Spring boot - JpaRepository parent & child record insert at once.

    Spring Boot - Basic Crud Operation. How to insert Parent and child entity at the same time in mySQL using spring boot…

    1 条评论
  • AWS Serverless Architecture and example
    2017年6月7日

    AWS Serverless Architecture and example

    Abstract: Abstract microservices are an architectural and organizational approach to software development to speed up…

  • FCM Push Notification Java Server
    2016年10月10日

    FCM Push Notification Java Server

    Firebase Cloud Messaging (FCM) is a cross-platform messaging solution that lets you reliably deliver messages at no…

    10 条评论
  • TimeZone Conversion
    2016年9月1日

    TimeZone Conversion

    Hi Guys let’s have a session on new important concept in Programming world. A time zone is a region of the globe that…

  • Comparator in Java
    2016年8月10日

    Comparator in Java

    Introduction: Comparator is one of the most heavily used interface in java Application. Mainly used for sorting any…

社区洞察

其他会员也浏览了