Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 795
  • Last Modified:

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
0
gudii9
Asked:
gudii9
1 Solution
 
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
 
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

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now