Importing Excel Data into Database with Spring Framework

Question

I am developing a website that stores data in a mysql database. One of the user of the website wishes to record data for the website in an excel spreadsheet. I intend to develop a solution that consist of three parts:

A controller class that saves the uploaded excel spreadsheet into a directory in the server.
A service layer that read the saved excel spreadsheet from the directory using apache POI. 3. JPA to record data in the excel spreadsheet into the mysql database.

Is this a good pattern for the intended solution ? Has anyone implemented a similar solution ?

I dont really understand your requirements. Is the excel spreadhseet meant to be another way to get data into the database? Or is it meant to be a replacement for the database? — Solubris
– Solubris, Commented Jan 20, 2013 at 5:15
@Solubris the excel spreadsheet is meant to be another way to get data into the database. Thank you — zfranciscus
– zfranciscus, Commented Jan 20, 2013 at 9:46

Solubris · Accepted Answer · 2013-01-20 13:04:48Z

1

Sounds reasonable.

See if the user would upload a csv file instead of xls file, as this will be easier to handle.
try to stream upload directly to disk. If you store it in memory, then large uploads will cause out of memory error for jvm.

edited Jan 20, 2013 at 13:04

answered Jan 20, 2013 at 12:32

Solubris

3,8212 gold badges25 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Importing Excel Data into Database with Spring Framework

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related