i have a jsp it has two fileds..mobileno and password..when i enterd values its storing in DB.But when iam retriving its retriving and comparing only with newly inserted values only.. it is comparing only last inserted values in Db only ..here is my code..


package com;
import java.io.*;
import java.util.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class SearchServlet extends HttpServlet
{

private ServletConfig config;

public void init(ServletConfig config)
throws ServletException{
this.config=config;
}
public void service(HttpServletRequest request, HttpServletResponse response)
throws ServletException,IOException{

PrintWriter out = response.getWriter();
String connectionURL = "jdbc:mysql://localhost/test";
Connection connection=null;
ResultSet rs;
String mobileno=request.getParameter("mobileno");
String password=request.getParameter("password");
response.setContentType("text/html");
HttpSession ses=request.getSession(true);
try {
// Load the database driver
Class.forName("com.mysql.jdbc.Driver");
// Get a Connection to the database
connection = DriverManager.getConnection(connectionURL, "root", "password");
//Add the data into the database
String sql = "select mobileno,password from newuser";
Statement s = connection.createStatement();
s.executeQuery (sql);
rs = s.getResultSet();
while (rs.next ()){
mobileno=rs.getString("mobileno");
password=rs.getString("password");
}
rs.close ();
s.close ();
}catch(Exception e){
System.out.println("Exception is ;"+e);
}

if(mobileno.equals(request.getParameter("mobileno"))
&& password.equals(request.getParameter("password")))
{

// ses.setAttribute("MOBILENO",mobileno);
// ses.setAttribute("PASSWORD",password);

// mobileno = (String)ses.getAttribute("MOBILENO");
out.print("<h1>You are Already Registerd </h1>");
}

else
{

out.println("<h1>You are not a Valid User Please Register</h1>");
out.println("<a href='newregister.jsp'><br>Register Here!!</a>");

}}

public void destroy()
{
}


}

This is your post No: 10 and still you are either too lazy or are just plain ignorant to read the rules I do not know. But please read this on how to use [code] tags.


As far as your problem goes you need to put a where clause in you select query like this:-

So your while will be entered only if the mobile no is valid (and if valid give you the password of only that "mobileno" )and you just have to check whether the "password" is valid in your if condition.

Also I can see that you are overwriting the value in the variables "mobileno" and "password", first you are storing in the value you get from the request here:-

And then you overwrite them if the corresponding values you get from the database here:-


Also another suggestion do not user mysql "root" login to do such trivial tasks. Use root only when you have to perform administrative tasks on your database, for normal use create another user account.

Same question asked here http://www.daniweb.com/forums/thread159180.html
Forum flooding is not welcomed, please read the rules!
Hopefully this will be moved and merge soon in JSP section

but i want to compare dynamically ..if i give particular number then it displays those results.. but if i give another number then i have to change that in servlet also...i want dynamically if mobilenumber enterd in jsp then it should be checked with db and comapres with enterd value.. if its there dispaly already existed if not register..how i should i do this?

If you would just merge my query with your code wouldn't it do the same or you need me to spoon feed you the exact java syntax, then here it is :-

... there is no spoon, Neo

as for mahaboob Basha:
Stephen84s already told you how to compare it dynamically. read the answers before disagreeing with them.

i tried evry thing possibly i can... still its not working.. plz dont get angry .. iam a student we r doing a project for this i have to do this..plz help me in this...iam sending my total code..
SearchServlet:
____________

package com;
import java.io.*;
import java.util.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class SearchServlet extends HttpServlet
{

private ServletConfig config;

public void init(ServletConfig config)
throws ServletException{
this.config=config;
}
public void service(HttpServletRequest request, HttpServletResponse response)
throws ServletException,IOException{

PrintWriter out = response.getWriter();
String connectionURL = "jdbc:mysql://localhost/basha";
Connection connection=null;
ResultSet rs;

String mobileno=request.getParameter("mno");
String password=request.getParameter("pwd");
response.setContentType("text/html");
HttpSession ses=request.getSession(true);

try {
// Load the database driver
Class.forName("com.mysql.jdbc.Driver");
// Get a Connection to the database
connection = DriverManager.getConnection(connectionURL, "root", "3ptec");
//Add the data into the database
String sql = "select mobileno,password from newuser where mobileno='"+ mobileno + "'and password='"+ password + "' " ;


Statement s = connection.createStatement();
rs=s.executeQuery (sql);
rs = s.getResultSet();


while (rs.next ())
{
mobileno=rs.getString("mobileno");
password=rs.getString("password");
out.println("MOBILENO=" +mobileno );
out.println("PASSWORD=" +password );


}

rs.close ();
s.close ();


}

catch(Exception e)
{
System.out.println("Exception is ;"+e);
}


if(mobileno.equals(request.getParameter("mno")) && password.equals(request.getParameter("pwd")))
{

out.print("<h1>You are Already Registerd </h1>");
}


else
{

out.println("<h1>You are not a Valid User Please Register</h1>");
out.println("<a href='newregister.jsp'><br>Register Here!!</a>");
}



}

}

search.jsp
----------------
<%@ page language="java" %>
<h2><font color="#0000FF"><b>Login&nbsp;</b></font>

<br>
<br>
Please enter MobileNumber and password</h2>
<form name="frm" action="/SearchServlet" method="Get" >
<b>
MobileNo :&nbsp;</b><input type="text" name="mno" value=""/><br>
<b>
Password :&nbsp; </b><input type="password" name="pwd" value=""/>
&nbsp;
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;<input type="submit" value="Check" />
<H1>Newuser </H1>
<P><A href="newregister.jsp">Signup</A><BR>
</p>
</form>

table
---------

mysql> create table newuser(mobileno char(20),password char(20));
Query OK, 0 rows affected (0.08 sec)

mysql> insert into newuser values('9999999999','Peter');
Query OK, 1 row affected (0.03 sec)


where iam doing the mistake?.......................

Am not looking at that post until you start using [code] tags to wrap your code. I already mentioned it to you in my first post, but you just wish to keep ignoring it and please start writing your posts in English. The SMS speech and the "..."s you are using are irritating, I guess that would not be too much to ask.

Iam ..sorry.. really i dont know how to use [code] tags .. plz i will go through those code tags it now...from next time i will follow code tags definately... plz check that this time...

No I am not, I gave you the link in my first post, if you cant find it then see this :-
http://www.daniweb.com/forums/announcement9-3.html

Edit your post and add the code tags to it, it should not take more than a few minutes.
And PLEASE write the full words why do you eat up sentences with the "..." and the SMS language(used with Mobile handsets) when you have a complete keyboard in front of you.

And you have not even mentioned what is going wrong now, after you changed your query.