Insert Excel/CSV data into MySql database || JDBC batch to insert csv file into database using Java

In this video i have shown how to insert excel or csv data into mysql database using java jdbc. We will be using jdbc batch to insert the csv fiel into the database using java.

➡️:Java Playlist ArjunCodes :

………………………………………………………………………………………………………………..

➡️:SpringBoot Playlist ArjunCodes :

……………………………………………………………………………………………………………….

➡️:Web Playlist ArjunCodes :

……………………………………………………………………………………………………………..

➡️:Github Playlist ArjunCodes :

……………………………………………………………………………………………………………...

Follow me on :

#JavaProgramming #CsvDataJava #Java #Arjuncodes

[kunalsingh]

Thanks for this tutorial. It helped a lot!

[Riuk]

what if some of the blocks are empty? can this thing still be done putting null or something there?

[denisr.]

hi great video but your count doesnt do anything everytime it goes to .excecuteBatch and it doesnt go to addBatch and then excetue them all

[wuwvwtr]

Why batchsize should be set to 20
i am a java newbie

[SchallCF]

close of db connection should happen in finally? if exception happens, db connection will never be closed

[riyasaha]

Hi Arjun, what if in the same code you are passing a input CSV file where columns are shuffled...

[anujtiwari]

hey can you guide me i want to send csv file in database using ajax call in java jsp servlet

[anmolrane]

Should u not increment the count to count ++?

[lutansahu]

I have 5 lack records in my excel how can insert

[icodex]

Hello Arjun, Thanks for this effort, but can help me in the same example where i need to delete all existing records and insert new records from a csv file.
Note: My application need to query database to delete the existing records before inserting a new one EVERYTIME.
Appriciate if you can assist here with better performance and time saving applicaton code using java

[amitshrivastava]

Bhai itne add rakoge to Kon dekhega vedio