title: Server using a table that I didn't even mention in my code
body: <p>Im using NetBeans 8.0 . I've created a table "full" in database "face" . Earlier , I created a table "student" in database "rishi" . Now , after deleting the table from database "rishi" &amp; also after changing the database to "full" , I get the following error :-</p>
  
  <blockquote>
    <p>java.sql.SQLException: Base table or view not found message from server: "Table 'face.student' doesn't exist".</p>
  </blockquote>
  
  <p>Here's my HTML code :-</p>
  
  <pre><code>&lt;html&gt;
  &lt;head&gt;
      &lt;title&gt;TODO supply a title&lt;/title&gt;
      &lt;meta charset="UTF-8"&gt;
      &lt;meta name="viewport" content="width=device-width, initial-scale=1.0"&gt;
  &lt;/head&gt;
  &lt;body&gt;
      &lt;center&gt;
          &lt;h1&gt;Login !&lt;/h1&gt;
          &lt;hr&gt;
          &lt;form action = "Check" method = "post"&gt;
              &lt;pre&gt;
                  Enter email :     &lt;input type = "text" name = "email"&gt;
                  Enter password :  &lt;input type = "password" name = "pass"&gt;
                  &lt;input type = "submit" value = "Login"&gt;
              &lt;/pre&gt;
          &lt;/form&gt;
          &lt;hr&gt;
          &lt;h3&gt;New ? Sign in today !&lt;/h3&gt;
          &lt;form action = "New" method = "post"&gt;
              &lt;pre&gt;
                  Enter name :        &lt;input type = "text" name = "user"&gt;
                  Enter email :       &lt;input type = "text" name = "newEmail"&gt;
                  Enter password :    &lt;input type="password" name = "newPass"&gt;
                  Re-enter password : &lt;input type="password" name = "repass"&gt;
                                      &lt;input type = "submit" value = "Sign Up"&gt;
              &lt;/pre&gt;
          &lt;/form&gt;
      &lt;/center&gt;
  &lt;/body&gt;
  &lt;/html&gt;
  </code></pre>
  
  <p>And here's my Servlet :-</p>
  
  <pre><code>public class New extends HttpServlet {
  
      @Override
      protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
          PrintWriter out = response.getWriter();
          String name = request.getParameter("user");
          String email = request.getParameter("newEmail");
          String pass = request.getParameter("newPass");
          String repass = request.getParameter("repass");
  
          try {
              Class.forName("com.mysql.jdbc.Driver");
              Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/face" , "root" , "root");
              Statement st = con.createStatement();
              ResultSet r = st.executeQuery("select * from full");
              int flag = 0;
  
          while(r.next()) {
              String s = r.getString(2);
              if(pass.equals(repass) || email.equals(s)) {
                  flag = 1;
              }
              else {
                  flag = 2;
              }
  
              if(flag == 2) {
                  response.sendRedirect("fail2.html");
              }
              else {
                  String qr = String.format("insert into student values('%s','%s','%s')" , name , email , pass);
                  st.executeUpdate(qr);
                  response.sendRedirect("home.html");
              }
          }
  
          catch (ClassNotFoundException ex) {
              out.println("Cannot load driver !");
          } catch (SQLException ex) {
              out.println(ex);
          }       
      }
  
      @Override
      protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
         doGet(request,response);
      } 
  }
  </code></pre>
  
  <p>What could possibly be going wrong ?</p>
  
  <p>Thank you in advance !</p>