Thread: Java code to read an excel file and populate the data into oracle database

Hello everyone

New to Java. Got an assignment. Struck with it

Need some help

I have to read an excel file and populate the data into oracle database

The excel sheet is pre defined format where the user enters the data and uploads the file with data

The excel has the following columns

1) Name
2) Marks1
3) Marks2
4) Marks3

Immediately after the first row where these column names are displayed the user will enter the data

Now coming to database, I have 2 tables, one is NM_MSTR and other is CHL_DTL

NM_MSTR contains all the names along with a PK_ID

The child data contains the following

1) FK_NM_ID - this is link to PK_ID of NM_MSTR
2) MRKS1 - This corresponds to Marks1 in Excel
3) MRKS2 - This corresponds to Marks2 in Excel
4) MRKS3 - This corresponds to Marks3 in Excel

Now once i get the excel, I need to read data and upload into CHL_DTL. First i need to read row wise. When i read the first record, I need to check if the text entered in "NAME" column of excel exists in database i.e. the master table. If it does then I need to extract the id from the master and post the id along with the marks into CHL_TBL

I need to use string Tokenizer. Pls help