Untitled

<%@page import="com.mysql.jdbc.Connection"%>
 <%@page import="com.mysql.jdbc.Statement"%>
 <%@page import="java.sql.ResultSet"%>
 <%@page import="java.sql.DriverManager"%>
 <%@page contentType="text/html" pageEncoding="UTF-8"%>
 <!DOCTYPE html>
  <html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>JSP Page</title>
  </head>
   <body>
    <h1>Hello World!</h1>
   <%@ page import ="java.sql.*" %>
    <%
     Connection c1 = null;
     Statement st = null;
     ResultSet rs = null;

     Class.forName("com.mysql.jdbc.Driver");
     c1 = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/teacher","root", "abcde");
        {
         System.out.println("Couldn't find the driver!");
         System.out.println("Couldn't connect: print out a stack trace and exit.");
      System.out.println("We got an exception while creating a statement:" + "that probably means we're no longer connected.");

      st = (Statement) c1.createStatement();
          System.out.println("Statement Created Successfully");
             {
          System.out.println("We got an exception while creating a statement:" + "that probably means we're no longer connected.");  }

           if (c1!= null) {
               System. out.println("Hooray! We connected to the database!");
            } else {
                System.out.println("We should never get here.");
            }}
            %>
              <%
       try{

        String name=request.getParameter("username");
        String abc=request.getParameter("password");
        String Sql="select * from login where username='"+name+"' AND password='"+abc+"'";

      while(rs.next())  {
      out.println("aa");}
       catch(SQLException ex)
         {
         out.println(ex);
         }
         %>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
      <!DOCTYPE html>
      <html>
      <%@include file="db conn.jsp" %>
      <head>
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
       <title>JSP Page</title>
      </head>
      <body>
      <form  method="GET " action="reg.jsp" autocomplete="on">
      <h1>Log in</h1>
        <p>
     <label for="username" class="uname" data-icon="u" >Username:</label>
     <input id="username" name="username" required="required" type="text" placeholder="Username"/>
     </p>
     <p>
     <label for="password" class="youpasswd" data-icon="p">Password:</label>
     <input id="password" name="password" required="required" type="password" placeholder="Password" />
     </p>
     <p class="keeplogin">
     <input type="checkbox" name="loginkeeping" id="loginkeeping" value="loginkeeping" />
     <label for="loginkeeping">Keep me logged in</label>
     </p>
     <p class="login button">
     <input type="submit" value="Login" />
     <input type="button" onclick="location.href='reg.jsp';" value="Sign Up"/>
     </p>

    <input type="radio" name="gender" value="Teach" checked/> Teacher
    <input type="radio" name="gender" value="Student"/>Student
     </form>
     </body>
 </html>

HTTP Status 500 -
    type Exception report

    message

    description The server encountered an internal error () that prevented it from fulfilling this request.

    exception

    org.apache.jasper.JasperException: Exception in JSP: /db conn.jsp:62

    62:             while(rs.next())  {}