## Попробуйте это ##
String email=request.getParameter("email");
String pass=request.getParameter("pass");
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/users_record","root","root");
Statement st1=con.createStatement();
ResultSet obj1=st1.executeQuery("select * from registration where email='" +email+ "'");
System.out.println(email);
while(obj1.next())
{
String p2=obj1.getString(5);
if(p2.equals(pass))
{
response.sendRedirect("home1.jsp?msg=YOU HAVE SUCCESSFULLY LOGGED IN ");
}
else
{
response.sendRedirect("login1.jsp?msg=Invalid password");
}
}