Link to home
Start Free TrialLog in
Avatar of gudii9
gudii9Flag for United States of America

asked on

java program to read excel/text and checks oracle database and emails missing records

I am looking for a java sample example which reads excel or text file and
 iterate through the records by forming hash map or other object. Forms a query and queries againest oracle database
and generates excel report of any missing records compared to excel/ text file records.Emails the missingrecords report.

I saw this example

http://www.roseindia.net/tutorial/java/poi/insertExcelFileData.html

But it is not complete on what I was looking. It is inserting instead of 'select' to check missing records.

It mentioned like

int k=stat.executeUpdate("insert into login(username,password) value('"+username+"','"+password+"')");

>>login(username,password)
 is login is the name of the table with columns names username,password in the paranthesis?

 Any ideas, suggestions, sample code, links, source code highly appreciated. Thanks in advance
ASKER CERTIFIED SOLUTION
Avatar of Am P
Am P
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial