Instead of Insert Command Select Command

Posted on 2012-08-29
Last Modified: 2012-08-31
I was able to insert records (with username and password) into database from excel file using the link

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
Question by:gudii9
    LVL 86

    Expert Comment

    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!?
    LVL 11

    Accepted Solution

    Check here,
    Better you will save data from xls to some array or map and then iterate it,

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL ( several years ago, it seemed like now was a good time to updat…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
    Viewers will learn one way to get user input in Java. Introduce the Scanner object: Declare the variable that stores the user input: An example prompting the user for input: Methods you need to invoke in order to properly get  user input:

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now