Excel to SQL Java Project

This is a small Java project I created to demonstrate how to import data from an excel file, map it to dto's, convert it into entities, and save it to a SQL database.

I used JavaSE, java 8, using MySQL. I used workbench as the gui to create the table.

Project Workflow

1. read data from excel (.xlsx)
2. Map rows to dto's
3. Transform dto's into JPA entities
4. Persist entities into a SQL database.

Technologies USed

• Java 8
• Apache POI
• JavaSE
• JDBC
• SQL Database (MySQL)
• Junit

How To Run

1. Place your excel file in the projects src/ folder(Or wherever your code expects it).
2. Open project in eclipse
3. Run the main method (Main.java)
4. Check the database for the imported data

Author

Created by myself, Peter Ruggles.