Forum:

Form Error Messages/Redirecting

Greenhorn

Posts: 1

posted 10 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi,

I graduated from college with a degree in Web Development, and for some reason I am drawing a complete blank with what I'm trying to do. I don't know why I am having this issue, but I have been trying to work on it for the past few days now and I tried everything I can. I DON'T want to use a Servlet, whether it'll be easier or not, I just want complete JSP pages. I will have the code snippets below for all the pages I have that deals with where I am having issues. And this project is NOT for school or work or anything like that. But I have a page called register.jsp where a user can fill out a form to sign up for an account. I have another page called newmember.jsp which will do the backend code for the registration form. If a user signing up for an account on register.jsp has a username that is already in use, it'll tell them that in an error message due to response.sendRedirect. If a member signs up for an account and is under the age of 13 years old, they'll be given an error message due to response.sendRedirect. I'm also going to add in the same thing with an email already in use, but don't have that in now because I want to get these two working first. If a combination of the above listed errors are entered in the form and submitted, it'll list the error messages associated with that response.sendRedirect. Currently, it is working, however, not correctly. If a user has a taken username and is above 13 years old, both messages display. And if the username is available, but the member is under 13 years old, both messages display as well. I don't know why I can't figure this out and I did have something similar in college years ago but can't remember what it was I did and I don't have the flash drive I had for class anymore. I know Servlets may be the best way to go, but I really just want this to be done using JSP, just how I am preferring this to be. Any help would be greatly appreciated. Below are the code snippets.

register.jsp

<%-- 
    Document   : index
    Created on : Jul 8, 2014, 4:24:52 PM
    Author     : Scotty
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>

<!DOCTYPE html>

<html>
    
<head>
    
    <title>Sign Up For TriviaWorld</title>
    <meta http-equiv="Content-Type" content="text/html; charset=windows-1250" />
    <link rel="stylesheet" href="template.css" type="text/css" />

</head>

<body>
    
    <div id="wrap">
    <div id="header">
        
        <img src="images/triviaworld_logo.gif" alt="TriviaWorld Logo" />
        <h2 id="slogan">A world full of trivia...</h2>
        
    <div id="menu">
       
        <%@include file="menubar.jsp"%>
        
    </div> 
    </div> 
        
    <div id="main">
    <div class="box">
        
            <%
                    // Getting the username of the admin if he/she has logged in.
                    
                    String admin = (String)session.getAttribute("adminusername");
                    
                    // If the admin is not null, then the user is logged in and
                    // it'll display the admin's username, as well as a link to
                    // logout if he/she doesn't want to stay logged into his/her
                    // account.
                    
                    // Checking if the member supplied the correct username and/or password
                    // combination.  If an incorrect username and/or password was entered,
                    // it'll display the below error message.

if (request.getParameter("error") != null)
                    {
                        out.println("<p><b>This username is not available.  Please select a different username.</b></p>");
                    }
                    
                    if (request.getParameter("error") != null)
                    {
                        out.println("<p><b>You must be at least 13 years old to create an account.</b></p>");
                    }
                    
                    if (admin != null)
                    {
                        out.println("<p>Welcome " + admin + ", <a href=\"adminlogout.jsp\" target=\"_self\">Logout</a></p>");
                    }
                %>
                
                <%
                    String member = (String)request.getSession().getAttribute("memberusername");
                    
                    if (member == null)
                    {
                %>
                
                <h2 align="center">Registration Form</h2>
                
                <p align="center">Fill out the form below and click submit to register as a member
                    of TriviaWorld.</p>
                
                <form method="post" action="newmember.jsp">
                    
                <p><input type="hidden" name="id"></p>
                                
                <p>* Username <input type="text" name="memberusername" maxlength="25" size="25" required></p>
                
                <p>* Password <input type="password" name="memberpassword" maxlength="25" size="25" required></p>
                
                <p>* First Name <input type="text" name="firstname" maxlength="25" size="25" required></p>
                
                <p>* Last Name <input type="text" name="lastname" maxlength="25" size="25" required></p>
                
                <p>* Age <input type="text" name="age" maxlength="3" size="5" required></p>
                
                <p>* Email <input type="text" name="email" maxlength="75" size="25" required></p>
                
                <p>* City <input type="text" name="city" maxlength="50" size="25" required>
                
                * State <select name="state" required>
                           <option name="empty" selected></option>
                           <option name="none">None</option>
                           <option name="alaska">AK</option>
                           <option name="alabama">AL</option>
                           <option name="arkansas">AR</option>
                           <option name="arizona">AZ</option>
                           <option name="california">CA</option>
                           <option name="colorado">CO</option>
                           <option name="connecticut">CT</option>
                           <option name="delaware">DE</option>
                           <option name="florida">FL</option>
                           <option name="georgia">GA</option>
                           <option name="hawaii">HI</option>
                           <option name="iowa">IA</option>
                           <option name="idaho">ID</option>
                           <option name="illinois">IL</option>
                           <option name="indiana">IN</option>
                           <option name="kansas">KS</option>
                           <option name="kentucky">KY</option>
                           <option name="louisiana">LA</option>
                           <option name="massachusetts">MA</option>
                           <option name="maryland">MD</option>
                           <option name="maine">ME</option>
                           <option name="michigan">MI</option>
                           <option name="minnesota">MN</option>
                           <option name="missouri">MO</option>
                           <option name="mississippi">MS</option>
                           <option name="montana">MT</option>
                           <option name="northcarolina">NC</option>
                           <option name="northdakota">ND</option>
                           <option name="nebraska">NE</option>
                           <option name="newhampshire">NH</option>
                           <option name="newjersey">NJ</option>
                           <option name="newmexico">NM</option>
                           <option name="nevada">NV</option>
                           <option name="newyork">NY</option>
                           <option name="ohio">OH</option>
                           <option name="oklahoma">OK</option>
                           <option name="oregon">OR</option>
                           <option name="pennsylvania">PA</option>
                           <option name="rhodeisland">RI</option>
                           <option name="southcarolina">SC</option>
                           <option name="southdakota">SD</option>
                           <option name="tennessee">TN</option>
                           <option name="texas">TX</option>
                           <option name="utah">UT</option>
                           <option name="virginia">VA</option>
                           <option name="vermont">VT</option>
                           <option name="washington">WA</option>
                           <option name="washingtondc">Washington DC</option>
                           <option name="wisconsin">WI</option>
                           <option name="westvirginia">WV</option>
                           <option name="wyoming">WY</option>
                   </select>
                    
                * Country <input type="text" name="country" maxlength="50" size="20" required>
                
                * Zip Code <input type="text" name="zipcode" maxlength="5" size="5" required></p>
                
                <p><input type="radio" name="touagree" required> I have read and agreed to TriviaWorld's
                   <a href="termsofuse.jsp" target="_blank">Terms of Use</a> and if I violate the Terms
                   of Use, I'll be subjected to legal action and/or permanently being banned from
                   accessing and participating in anything related to TriviaWorld.</p>
                
                <p><input type="radio" name="ppagree" required> I have read and agreed to TriviaWorld's
                   <a href="privacypolicy.jsp" target="_blank">Privacy Policy</a> legal agreement and
                   acknowledge that I understand how my privacy will be used and affected by signing up
                   for an account with TriviaWorld.</p>
                
                <p align="center"><input type="submit" name="register" value="Register">
                   <input type="reset" name="clear" value="Clear"></p>
                
                </form>
                
                <p><b>* Required</b></p>
                
                <%
                    }
                %>
      
    </div> 
    </div> 
    
    <br />
    
    </div> 
    </div> 
    
    <div id="footer-wrap">
    <div class="footer-left">
        
        <%@include file="leftfooter.html"%>
        
    </div> 
        
    <div class="footer-right">
      
        <%@include file="rightfooter.html"%>
  
    </div> 
    </div> 
    
</body>

</html>

newmember.jsp

<%-- 
    Document   : index
    Created on : Jul 8, 2014, 4:24:52 PM
    Author     : Scotty
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>

<!DOCTYPE html>

<html>
    
<head>
    
    <title>New Member Backend Code - Page Does Not Display</title>
    <meta http-equiv="Content-Type" content="text/html; charset=windows-1250" />
    <link rel="stylesheet" href="template.css" type="text/css" />

</head>

<body>
    
    <%
        // Defining the variables for the username and password for the
        // members located in the database and getting the information that
        // was inputted by the member into the text field.

String memberusername = request.getParameter("memberusername");
        String memberpassword = request.getParameter("memberpassword");
        String firstname = request.getParameter("firstname");
        String lastname = request.getParameter("lastname");
        int age = Integer.parseInt(request.getParameter("age"));
        String email = request.getParameter("email");
        String city = request.getParameter("city");
        String state = request.getParameter("state");
        String country = request.getParameter("country");
        String zipcode = request.getParameter("zipcode");
        String id = (String)(session.getAttribute("id"));

// Creating a Try/Catch Block to do the code and catch any errors that may occur.

try
        {
            // Creating the JDBC Class.

Class.forName("com.mysql.jdbc.Driver");

// Creating the database connection to access my database.

Connection database = DriverManager.getConnection(
                    "jdbc:mysql://localhost/sitename",
                    "username",
                    "password");

// Creating the Statement to make the database updatable.

Statement sql = database.createStatement(
                    ResultSet.TYPE_FORWARD_ONLY,
                    ResultSet.CONCUR_UPDATABLE);

// Creating the ResultSet to create an SQL Statement where
            // it'll be selecting all of the fields in the members table.

ResultSet newmembers = sql.executeQuery("SELECT * FROM members");

// Checking if the member information added have been left blank.

if (memberusername == memberusername)
            {        
                response.sendRedirect("register.jsp?error=1");
            }
            else if (age < 13)
            {
                response.sendRedirect("register.jsp?error=1&error=2");
            }
            else
            {
                // Inserting to the next row to create a new member account.

newmembers.moveToInsertRow();

// Updating the String so the new member is updated with the new
                // information for the member's information.

newmembers.updateString("id",id);
                newmembers.updateString("username",memberusername);
                newmembers.updateString("password",memberpassword);
                newmembers.updateString("firstname",firstname);
                newmembers.updateString("lastname",lastname);
                newmembers.updateInt("age",age);
                newmembers.updateString("email",email);
                newmembers.updateString("city",city);
                newmembers.updateString("state",state);
                newmembers.updateString("country",country);
                newmembers.updateString("zipcode",zipcode);

// Will insert the row in the members table, which will create
                // a new member account.

newmembers.insertRow();

// Closing the ResultSet, Statement, and Database.

newmembers.close();
                sql.close();
                database.close();

// Redirecting the user back to the Homepage.

response.sendRedirect("index.jsp");
            }
        }
        catch (ClassNotFoundException e) 
        {
            // Checking if the Class has not been found on the server.

e.printStackTrace();
        }
        catch (SQLException e)
        {
            // Checking if there is an SQL syntax error.

e.printStackTrace();
        }
    %>
    
</body>

</html>

Bear Bibeault

Sheriff

Posts: 67750

173

I like...

posted 10 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Welcome to the Ranch!

Scotty McCoy wrote:I DON'T want to use a Servlet, whether it'll be easier or not, I just want complete JSP pages.

Bad, bad, bad, bad, and did I say bad idea. Why the insistence on using the wrong tools for the job?

JSPs are meant for the view portion of the web app. Servlets should be used as the controllers. Using JSPs for anything other than view is like, well:

I also see that you are using obsolete and outdated Java scriptlets in your pages. JSP 2 threw those out with the bathwater in 2002. Twelve years ago. You should be using the JSTL and EL in any JSP page written after 2002.

I'm assuming that you're not a newcomer to JSP, but I'd recommend reading this article anyways. But certainly read this article to understand how to properly construct a modern Java web app.

[Asking smart questions] [About Bear] [Books by Bear]