How to search a user-id in the mySQL database table using JAVA (JDBC and JSP)
Posted on 2004-10-20
I have a form (JSP) which displays a text box.If i enter a user id in the text box and submit the form ,my JSP should search that user id in the mysql database table and should display a message whether the user id is already in the table or not.In case if the user id is not there then it should display a message as it is not there,if it is there it should display a message as it is there in the database.
In my case i could search the user id in the table but the message is displaying many times if the id is not there.It should be displayed only once if the id is not there.
Snippest of code would be helpful.