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()
    {
         }   
 
 
  }