title: No suitable driver found for jdbc:mysql://localhost:3306/finalproject
body: <p>this is my test.jsp code</p>
  
  <pre><code>&lt;%@ page language="java" contentType="text/html; charset=ISO-8859-1"
  pageEncoding="ISO-8859-1"
  import="java.sql.*"
  import="java.io.*"
  %&gt;
  
  &lt;!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"      "http://www.w3.org/TR/html4/loose.dtd"&gt;
  &lt;html&gt;
   &lt;head&gt;
      &lt;meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"&gt;
      &lt;title&gt;Final Project&lt;/title&gt;
  &lt;/head&gt;
  &lt;body&gt;
      &lt;center&gt;&lt;h1&gt;New Registration Page&lt;/h1&gt;&lt;/center&gt;
      &lt;table border="1" align="center"&gt;
          &lt;tr&gt;
              &lt;td&gt;
                  &lt;table border="0" align="center" cellpadding="1" cellspacing="1"&gt;
                      &lt;tr&gt;
                          &lt;form action=Profile.jsp method="get"&gt;
                          &lt;td&gt;First Name*:&lt;/td&gt; &lt;!-- we need a button that says show profile then link it here --&gt;
                          &lt;td&gt;&lt;input type="text" name="firstname"&gt;&lt;/td&gt;
                      &lt;/tr&gt;
                      &lt;tr&gt;
                          &lt;td colspan="3"&gt;&lt;center&gt;&lt;input type="submit" value="Submit!"&gt;&lt;/center&gt;&lt;/td&gt;
                          &lt;/form&gt;
                      &lt;/tr&gt; 
                  &lt;/table&gt;
              &lt;/td&gt;
          &lt;/tr&gt;
      &lt;/table&gt;
  &lt;/body&gt;
  </code></pre>
  
  <p></p>
  
  <p>This file is connected with the profile.jsp. 
  When i submit the test.jsp,No suitable driver found for jdbc:mysql://localhost:3306/finalproject error comes up from </p>
  
  <pre><code>&lt;% 
  Class.forName("java.sql.Connection");
  Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/finalproject", "root", "vietforlife");
  String firstname=request.getParameter("firstname");
  
          Statement statement = connection.createStatement();
          ResultSet resultset = statement.executeQuery("SELECT FirstName, LastName, Username, Password1, Password2, Email FROM userid WHERE FirstName = '"+firstname+"'"); 
  %&gt;
  </code></pre>
  
  <p>I think my database is not connected with the jsp file. 
  I followed the instructions from similar question, but that was not work. 
  can you guys help me?</p>