Registration Form in JSP

Introduction

In this article we define how to create a registration form in JSP. The NetBeans IDE is used to create the Registration Form.

Registration Form in JSP

There are many ways to create a registration form in JSP, such as using a separate Java class for the JDBC connection, using a servlet for the JDBC connection, using a DAO class for the database connection, etcetera but in this I use only two JSP classes.

We need to create the following class:

signuppage.html
processdata.jsp
reg.sql

1. signuppage.html

This file is used to create a form page. This form is used to get the user data from the user, after taking user information this page processes information to another page that we named "processdata.jsp".

2. processdata.jsp

This JSP page is used to set up the database connection and save user information in our database "reg".

3. reg.sql

This is an Oracle database table, used to save user records in the database.

Syntax

create table reg 
 (
   uname varchar2(20), umail varchar2(30), upass varchar2(20),
   udob varchar2(20), ugender varchar2(20), uphone varchar2(20),
   ucountry varchar2(20)
 );

Let's start creating Registration form in JSP

We need to follow several steps in the NetBeans IDE for creating this form.

Step 1

Open the NetBeans IDE.

Step 2

Choose "Java web" -> "Web application" as shown below.

Step 3

Type your project name as "RegistrationFormApp" as in the following.

Step 4

Now choose your Java version and server wizard as shown below.

Step 5

Now create a new HTML file named "signuppage.html" with the following.

signuppage.html

<!DOCTYPE html>

<html>

<head>

<title>User-SignUp</title>

</head>

<h1>Welcome User Please fill the detail below</h1>

<tr>

<td>

</td>

<td>

</td>

</tr>

<tr>

<td>

<b>Email-ID:</b>

</td>

<td>

<input type="email" name="uemail"

</td>

</tr>

<tr>

<td>

<b>Create Password:</b>

</td>

<td>

</td>

</tr>

<tr>

<td>

<b>Confirm Password:</b>

</td>

<td>

</td>

</tr>

<tr>

<td>

</td>

<td>

</td>

</tr>

<tr>

<td>

<b>Gender:</b>

</td>

<td>

</td></tr>

<tr>

<td>

<input type="radio" name="ugender" value="Male">Male

</td>

<td>

<input type="radio" name="ugender" value="Female">Female

</td>

</tr>

<tr>

<td>

<b>Phone No:</b>

</td>

<td>

</td>

</tr>

<tr>

<td>

<b>Country:</b>

</td>

<td>

</td>

</tr>

<tr>

<td>

</td>

<td>

</td>

</tr>

</table>

</form>

</body>

</html>

Step 6

Now create a JSP file named "processdata.jsp" with the following:

processdata.jsp

<%@ page language="java" import="java.sql.*"%>

String name = request.getParameter("uname");

String email = request.getParameter("uemail");

String pass = request.getParameter("upass");

String dob = request.getParameter("udob");

String gender = request.getParameter("ugender");

String phone = request.getParameter("uphone");

String country = request.getParameter("uloc");

String role = request.getParameter("urole");

try {

Class.forName("oracle.jdbc.driver.OracleDriver");

Connection con = DriverManager.getConnection("jdbc:oracle:thin:@mcndesktop07:1521:XE", "sandeep", "welcome");

PreparedStatement ps = con.prepareStatement("insert into reg values(?,?,?,?,?,?,?)");

ps.setString(1, name);

ps.setString(2, email);

ps.setString(3, pass);

ps.setString(4, dob);

ps.setString(5, gender);

ps.setString(6, phone);

ps.setString(7, country);

ps.executeUpdate();

out.println("Data saved successfully");

} catch (Exception e) {

out.println(e);

}

Step 7

Now our project is ready to run.

Right-click on the project menu, then select "Run". The following output is generated there.

Step 8

Fill in the given details there.

Step 9

Click on the "Submit" button. The following message is shown there.

Note

If you have the same message then that means you have done it successfully, else check your code.

Step 10

For confirmation of the saved data,

go to the Oracle database home page login with your username and password and then check that your data was saved there. As I do that I get the data in the database as in the following