rs2.first(); id = rs2.getInt("id"); creation_date = rs2.getString("creation_date"); rating = rs2.getInt("rating"); access = rs2.getInt("access");
rs.first(); id = rs.getInt("id"); creation_date = rs.getString("creation_date"); rating = rs.getInt("rating"); access = rs.getInt("access");
  public void doGet(HttpServletRequest request, HttpServletResponse response)      throws IOException, ServletException  {    ServletPrinter    sp = null;    PreparedStatement stmt = null, stmt2 = null;    Connection        conn = null;    sp = new ServletPrinter(response, "RegisterUser");    String categoryName, nickname, firstname, lastname, email;    String password = null, creation_date = null;    int userId;    int access = 0, id = 0, rating = 0;    ResultSet rs = null, rs2 = null;    int updateResult;    firstname = request.getParameter("firstname");    lastname = request.getParameter("lastname");    nickname = request.getParameter("nickname");    email = request.getParameter("email");    password = request.getParameter("password");    if (firstname == null)    {      sp.printHTML("You must provide a story title!<br>");      return;    }    if (lastname == null)    {      sp.printHTML("<h3>You must provide a story body!<br></h3>");      return;    }    if (nickname == null)    {      sp.printHTML("<h3>You must provide a category!<br></h3>");      return;    }    if (email == null)    {      sp.printHTML("<h3>You must provide an email address!<br></h3>");      return;    }    if (password == null)    {      sp.printHTML("<h3>You must provide a password!<br></h3>");      return;    }    conn = getConnection();    //Authenticate the user    try    {      stmt = conn.prepareStatement("SELECT * FROM users WHERE nickname=\""          + nickname + "\"");      rs = stmt.executeQuery();    }    catch (Exception e)    {      sp.printHTML("ERROR: Nickname query failed" + e);      closeConnection(stmt, conn);      return;    }    try    {      if (rs.first())      {        sp            .printHTML("The nickname you have chosen is already taken by someone else. Please choose a new nickname.<br>\n");        closeConnection(stmt, conn);        return;      }      stmt = conn.prepareStatement("INSERT INTO users VALUES (NULL, \""          + firstname + "\", \"" + lastname + "\", \"" + nickname + "\", \""          + password + "\", \"" + email + "\", 0, 0, NOW())");      updateResult = stmt.executeUpdate();      stmt2 = conn.prepareStatement("SELECT * FROM users WHERE nickname=\""          + nickname + "\"");      rs2 = stmt2.executeQuery();      rs2.first();      id = rs2.getInt("id");      creation_date = rs2.getString("creation_date");      rating = rs2.getInt("rating");      access = rs2.getInt("access");    }    catch (Exception e)    {      sp.printHTML("Exception registering user " + e + "<br>");      closeConnection(stmt, conn);      return;    }    closeConnection(stmt, conn);    sp        .printHTML("<h2>Your registration has been processed successfully</h2><br>\n");    sp.printHTML("<h3>Welcome " + nickname + "</h3>\n");    sp        .printHTML("RUBBoS has stored the following information about you:<br>\n");    sp.printHTML("First Name : " + firstname + "<br>\n");    sp.printHTML("Last Name  : " + lastname + "<br>\n");    sp.printHTML("Nick Name  : " + nickname + "<br>\n");    sp.printHTML("Email      : " + email + "<br>\n");    sp.printHTML("Password   : " + password + "<br>\n");    sp        .printHTML("<br>The following information has been automatically generated by RUBBoS:<br>\n");    sp.printHTML("User id       :" + id + "<br>\n");    sp.printHTML("Creation date :" + creation_date + "<br>\n");    sp.printHTML("Rating        :" + rating + "<br>\n");    sp.printHTML("Access        :" + access + "<br>\n");    sp.printHTMLfooter();  }