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");
		
				
				
				try {
					
					Class.forName("com.mysql.jdbc.Driver");
					
					Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/BookStore" , "root" , "sqlsewebsite@2");
					System.out.println("Database...");
					java.sql.PreparedStatement pst = null;
					String sql = "SELECT password FROM usertable where email=? and mobno=? ";
					pst = con.prepareStatement(sql);
					pst.setString(1, s1);
					pst.setString(2, s2);
					pst.setString(3, s3);
					
					
					ResultSet rs = pst.executeQuery();
					PrintWriter out = response.getWriter();
					while(rs.next()) {
						
						
						out.println(rs.getString(1) + "    " + rs.getString(3) + "   " + rs.getInt(7));
						
					}
					
					con.close();	
				}
				
				catch(Exception e) {
					
					System.out.println(e);
					
					
					
				}
	        }
        }
