import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class Check
{
	String Url = "jdbc:mysql://localhost:3306/FlatDetails";
	String User = "root";
	String Pass = "root";

	public boolean CheckUser(String username, String passwordSignIn)
	{
		System.out.println("InCheck CLass");
		try
		{
			Class.forName("com.mysql.jdbc.Driver");
			Connection con=DriverManager.getConnection(Url,User ,Pass);
			PreparedStatement stmt = con.prepareStatement("select Email, Password from SignUp where Email = ? and Password = ?");
			stmt.setString(1, username);
			stmt.setString(2, passwordSignIn);

			ResultSet rs = stmt.executeQuery();
			while(rs.next())
			{
				String OneUser = rs.getString(1);
				String TwoPass = rs.getString(2);
				System.out.println("Username --> " +OneUser+ " Password --->    "+TwoPass);
				return true;
			}

		}catch(Exception e)
		{
			System.out.println(e);
		}
		return false;
	}
}