Instead of Insert Command Select Command

I was able to insert records (with username and password) into database from excel file using the link
http://www.roseindia.net/tutorial/java/poi/insertExcelFileData.html

I need to enhance this program(instead of insert I need to use 'Select' command now in the enhanced program) to check if a particular set of usernames are there in database login table or not compared to the excel file records. If they are not there I would like to generate report of the missing usernames and email to user.
How can I modify the program. Please advise.Any ideas, suggestions, sample code, links, source code highly appreciated. Thanks in advance
File.xls
LVL 7
gudii9Asked:
Who is Participating?
 
ManishLeadCommented:
Check here
http://www.exampledepot.com/egs/java.sql/CreateResultSet.html,
Better you will save data from xls to some array or map and then iterate it,
0
 
CEHJCommented:
I was able to insert records (with username and password) into database from excel file using the link

I thought you said you couldn't HERE!?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.