Login Query

how to login with usertype in jsp page and redirect then whith user tyep

here is my code

<% Connection con=null; Statement stmt=null; ResultSet rst=null;

String email=request.getParameter("username"); String password=request.getParameter("password"); String user=request.getParameter("usertype"); try { Class.forName("com.mysql.jdbc.Driver"); } catch(Exception e) { out.print("driver error"); } try { Class.forName("com.mysql.jdbc.Driver"); con=DriverManager.getConnection("jdbc:mysql://localhost:3306/internship","root",""); stmt=con.createStatement(); String str="Select * from login where email='"+email+"' and password='"+password+"' and user='"+user+"'"; rst=stmt.executeQuery(str);

if(rst.next()) { if(email.equals(rst.getString(2)) && password.equals(rst.getString(3)) && user.equals(rst.getString(4))) { response.sendRedirect("/student");
} else if(user.equals(rst.getString(4))) { response.sendRedirect("/employer"); } }
else { session.setAttribute("error","login"); response.sendRedirect("index.jsp"); } }

      catch(SQLException se)
       {
            out.print("driver error"+se);
       }         


            %>

please help me i want to redirect page with its login