<div>
<blockquote>
I was able to insert records (with username and password) into database from excel file using the link
</blockquote>
<br />
I thought you said you couldn't <a href="https://www.experts-exchange.com/questions/27846624/MySql-insert-Data-issue.html" rel="ugc">HERE</a>!?
</div>


> 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 [https://www.experts-exchange.com/questions/27846624/MySql-insert-Data-issue.html]!?

<div>
<div class="content wysiwyg-content">
I was able to insert records (with username and password) into database from excel file using the link<br />
<a href="http://www.roseindia.net/tutorial/java/poi/insertExcelFileData.html" rel="ugc">http://www.roseindia.net/tutorial/java/poi/insertExcelFileData.html</a><br />
<br />
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.<br />
How can I modify the program. Please advise.Any ideas, suggestions, sample code, links, source code highly appreciated. Thanks in advance<br />
<a href="https://filedb.experts-exchange.com/incoming/2012/08_w35/599820/File.xls" target="_blank" class="file-inline" title="xls (16 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>File.xls</a>
</div>
</div>


File.xls

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

Instead of Insert Command Select Command

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Java Enterprise Edition (Java EE) is a specification defining a collection of Java-based server and client technologies and how they interoperate. Java EE specifies server and client architectures and uses profiles to define technology sets targeted at specific classes of applications. All Java EE profiles share a set of common features, such as naming and resource injection, packaging rules and security requirements.

Java EE

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.