This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

servlet example without using MVC pattern

 
Shanu Pandey
Greenhorn
Posts: 18
Java Tomcat Server
  • 0
  • 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
  • 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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic