Verify/deny a new user to MySQL via Servlet

The user is correctly denied if user enters the first "dbemails" value.

However, if it is a new user, the users are "squarely compounded/added" into MySQL.

Eg: user2, user3,user3, (user4, user4, user4, user4), (user5x8), (user6x16)
etc.
I have no clue what is going on here, thank you.

The pastebins are better formatted, but posted code here anyway.
Thank you
http://pastebin.ca/23893
http://pastebin.ca/23892

Here is the jsp, also viewable at:
http://pastebin.ca/23893
*********************************************

**********************************end JSP

and the SERVLET, also viewable at:
http://pastebin.ca/23892
*******************************

import java.io.*;
import java.net.*;
 
import javax.servlet.*;
import javax.servlet.http.*;
 
import java.sql.*;
 
 
public class mysql_input_verify extends HttpServlet {
 
  public void doPost(HttpServletRequest inRequest, 
    HttpServletResponse outResponse)                                                                        
    throws ServletException, IOException {
 
    PrintWriter out = null;
    Connection connection = null;
    Statement statement;
    Statement statementP;
    ResultSet rs;
    InetAddress remoteInetAddress;
    //String connectionURL = "jdbc:mysql://nothere/securityEDIT";
    String connectionURL = "jdbc:mysql://nothere/security";
    try {
      Class.forName("com.mysql.jdbc.Driver");
 
      connection = DriverManager.getConnection(connectionURL);
      statement = connection.createStatement();
 
      outResponse.setContentType("text/html");
      out = outResponse.getWriter(); 
 
      String emailgrabber = inRequest.getParameter("emailadd");
      String hiddenValue = inRequest.getParameter("ipsuck");
 
      rs = statement.executeQuery("SELECT id, email, password FROM acc");
 
 
      
      while (rs.next()) {
          
          String dbemails = rs.getString(2);
          
          if (emailgrabber.equals(dbemails) )
          {
              outResponse.sendRedirect( "http://localhost:8084/JSP_Learn/userexists.jsp" );
          }
          
          else {
              
////////////////////////START Insert Code START Insert Code/ I *think this is the problem area****////////////////////////////////////////////      
  
        PreparedStatement prepareUpdatePrice = connection.prepareStatement( 
      "INSERT INTO acc VALUES('',?,?,now()); ");
 
      prepareUpdatePrice.setString(1,emailgrabber);
      prepareUpdatePrice.setString(2, hiddenValue);
            
      int n = prepareUpdatePrice.executeUpdate() ;
    
////////////////////////END Insert Code END Insert Code/////////////////////////////////////////////
        
      out.println("<HTML><HEAD><TITLE>Products</TITLE></HEAD>");
      out.println("<BODY>");
      out.println("<UL>");
              
    
        out.println("<LI>" + rs.getString("ID") + " " 
          + rs.getString("email") + " " 
          + rs.getString("password"));
          
        
        out.println("</p> hardy hard MySQL verify");
      out.println("</UL>");
      out.println("</BODY></HTML>");
        
                }
      }
 
      
    }//end try
    catch(ClassNotFoundException e) {  
      out.println("Driver Error"); }
    catch(SQLException e) { 
      out.println("SQLException: " + e.getMessage());
    }
  }
  
  /*
  public void doPost(HttpServletRequest inRequest, 
    HttpServletResponse outResponse)                                                                        
    throws ServletException, IOException {
    doGet(inRequest, outResponse);
  }
*/
}

**********************

[Edit by Dave - code tags added]
[ September 25, 2005: Message edited by: David O'Meara ]

1, 2, 4, 8, 16

It looks like each time you read the values from the database, you are reading everything and re-inserting. Hence you double the number of times each user exists.

Have a look at the way you use your while(rs.next()), consider adding a 'where' clause to the query and using an 'if(rs.next())' instead.

I have to admit I just browsed the code and didn't read it all, it's a bit too much to digest.

Dave