Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

servlet example without using MVC pattern

 
Shanu Pandey
Greenhorn
Posts: 18
Java Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have written the following Servlet for Login Page without using MVC pattern:
Correct UserNames and Passwords are stored in MSAccess Database.



The problem is this ..when I enter wrong UserName and Password, it prints ‘Invalid UserName or Password’ many times.But I want it only once.How to overcome this problem.please help me to make correction in the code.
 
Ben Souther
Sheriff
Posts: 13411
Firefox Browser Redhat VI Editor
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You're selecting every name in the table and then comparing them in your Java code.
Why not build a select statement that looks for the exact username and password entered by the user.

If you have an empty resultSet, then you know there was no match.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic