gudii9
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("inse rt into login(username,password) value('"+username+"','"+pa ssword+"') ");
>>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
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("inse
>>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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.