Hi i created one jsp form with 2 fields..now in the first servlet i want check whether those 2 fields values are presented in the Database or not..if not then i want move those values to another servlet .. how can i do this?how to get the values (parameter values of jsp in second servlet.. .ie; in first servlet those values will be comapred with database and bcoz of send redirect in else the values will be stored if they not present in DB here is my code plz check it once..
1st Servlet..
_____________
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("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", "password");
//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();
if(rs.next ())
{
mobileno=rs.getString("mobileno");
password=rs.getString("password");
out.println("MOBILENO=" +mobileno );
out.println("PASSWORD=" +password );
if(mobileno.equals(request.getParameter("mno")) && password.equals(request.getParameter("pwd")))
{
out.print("<h1>You are Already Registerd </h1>");
}
}
else
{
request.setAttribute("MOBILENO",mobileno);
request.setAttribute("PASSWORD",password);
RequestDispatcher dispatcher =
getServletConfig ( ) .getServletContext ().getRequestDispatcher("/LoginServlet");
dispatcher.forward (request, response) ;
}
rs.close ();
s.close ();
}
catch(Exception e)
{
System.out.println("Exception is ;"+e);
}
}
}
2nd servlet
------------------
package com;
import java.io.*;
import java.util.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class LoginServlet extends HttpServlet{
private ServletConfig config;
public void init(ServletConfig config)
throws ServletException{
this.config=config;
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException,IOException{
PrintWriter out = response.getWriter();
String connectionURL = "jdbc:mysql://localhost/test";
Connection connection=null;
String mno=null;
String pwd=null;
String mobileno = (String)request.getAttribute(MOBILENO);
String password = request.getAttribute(PASSWORD);
response.setContentType("text/html");
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 = "insert into newuser values(" + mobileno + ",'" + password + "')";
Statement s = connection.createStatement();
HttpSession ses=request.getSession();
int x = s.executeUpdate(sql);
if(x==1)
{
out.println("<h1> Thanks For the Registration</h1>");
out.println("<br><h1> Welcome to 3P Technologies</h1></br>");
}
else{
out.println("<h1>+Your Registration is failed..Plase try again+</h1>");
out.println("<a href='newregister.jsp'><br>Register Here!!</a>");
}
s.close();
}
catch(Exception e){
System.out.println("Exception is ;"+e);
}
}
}