package forgotPassword;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.DriverManager;
import java.sql.ResultSet;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;

/**
 * Servlet implementation class FP
 */
@WebServlet("/FP")
public class FP extends HttpServlet {
	
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		
			String s1 = request.getParameter("txt1");
			String s2 = request.getParameter("txt2");
			String s3 = request.getParameter("txt3");
		
				PrintWriter out = response.getWriter();
				
				try {
					
					Class.forName("com.mysql.jdbc.Driver");
					
					Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/BookStore" , "root" , "sqlsewebsite@2");
					
					Statement st = (Statement) con.createStatement();
					
					ResultSet rs = (ResultSet) st.executeQuery("select * from  usertable where pincode = "+s1+" and email = "+s2+" and mobno = "+s3 );
					while(rs.next()) {
						
						
						out.println(rs.getString(1) + "    " + rs.getString(3) + "   " + rs.getInt(7));
						
					}
					
					con.close();	
				}
				
				catch(Exception e) {
					
					System.out.println(e);
					
					
					
				}
	        }
        }
