Registration Form using Servlet and Mysql

Posted on September 2, 2021

7 min read

1,016

The tutorial will teach you how to make a Registration Form using Servlet and Mysql step by step. those who interest to learn servlet this is right to learn from the beginning to advanced. i have attached the video below i explained the easy way to understand programming.

Registration Form

Create the file Index.html paste the following code.

Index.html

<html>
    <head>
        <title>TODO supply a title</title>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        
        <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/css/bootstrap.min.css" integrity="sha384-Vkoo8x4CGsO3+Hhxv8T/Q5PaXtkKtu6ug5TOeNV6gBiFeWPGFN9MuhOf23Q9Ifjh" crossorigin="anonymous">
        <script src="https://code.jquery.com/jquery-3.4.1.slim.min.js" integrity="sha384-J6qa4849blE2+poT4WnyKhv5vZF5SrPo0iEjwBvKU7imGFAV0wwj1yYfoRSJoZ+n" crossorigin="anonymous"></script>
        <script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.0/dist/umd/popper.min.js" integrity="sha384-Q6E9RHvbIyZFJoft+2mJbHaEWldlvI9IOYy5n3zV9zzTtmI3UksdQRVvoxMfooAo" crossorigin="anonymous"></script>
        <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/js/bootstrap.min.js" integrity="sha384-wfSDF2E50Y2D1uUdj0O3uMBJnjuUD4Ih7YwaYd1iqfktj0Uod8GCExl3Og8ifwB6" crossorigin="anonymous"></script>
    </head>
    <body>
        
        <div class="container">
            <div class="row">
                <div>
                    <form action="registation" method="POST">
                        
                        <div class="form-group">   
                            <h2>Registaion</h2>  
                        </div>
                        
                         <div class="form-group">   
                             <label>First Name</label>
                             <input type="text" class="form-control" id="fname" name="fname" placeholder="Firstname" required>
                        </div>
                        
                         <div class="form-group">   
                             <label>Last Name</label>
                             <input type="text" class="form-control" id="lname" name="lname" placeholder="Lastname" required>
                        </div>
                        
                         <div class="form-group">   
                             <label>Address</label>
                             <input type="text" class="form-control" id="address" name="address" placeholder="Address" required>
                        </div>
                      
                        <div class="form-group">   
                             <label>Phone No</label>
                             <input type="text" class="form-control" id="phone" name="phone" placeholder="Phone" required>
                        </div>
                        
                        
                        <div class="form-group">   
                           
                            <button type="submit" class="btn btn-success">Submit</button>
                        </div>
                    </form>
                </div>
            </div>
        </div>    
    </body>
</html>

<html>

<head>

<title>TODO supply a title</title>

</head>

<body>

<div>

<h2>Registaion</h2>

</div>

<label>First Name</label>

</div>

</div>

<label>Address</label>

</div>

<label>Phone No</label>

</div>

<button type="submit" class="btn btn-success">Submit</button>

</div>

</form>

</div>

</body>

</html>

registation.java

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

@WebServlet("/registation")
public class registation extends HttpServlet {

Connection con;
    PreparedStatement pst;
    PreparedStatement pst1;
    ResultSet rs;

@Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {

try 
        {
            response.setContentType("text/html");
            PrintWriter out = response.getWriter();
            
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql://localhost/ebank", "root", "");
            String fname = request.getParameter("fname");
            String lname = request.getParameter("lname");
            String address = request.getParameter("address");
            String phone = request.getParameter("phone");
            
            
            pst = con.prepareStatement("insert into registation(fname,lname,address,phone)values(?,?,?,?)");
            pst.setString(1, fname);
            pst.setString(2, lname); 
            pst.setString(3, address);
            pst.setString(4, phone);
            pst.executeUpdate();
            
            pst1 = con.prepareStatement("select max(id) from registation");
            rs = pst1.executeQuery();
            
            rs.next();
            
            int regno;
            
            regno = rs.getInt(1);
            
            out.println("Thank you for your Registation");
            out.println("Your Registaion No is :" + regno);
            
            
        } catch (ClassNotFoundException ex) {
           ex.printStackTrace();
        } catch (SQLException ex) {
           ex.printStackTrace();
        }
    }
}

import java.io.IOException;

import java.io.PrintWriter;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.logging.Level;

import java.util.logging.Logger;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

@WebServlet("/registation")

public class registation extends HttpServlet {

Connection con;

PreparedStatement pst;

PreparedStatement pst1;

ResultSet rs;

@Override

protected void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

try

{

response.setContentType("text/html");

PrintWriter out = response.getWriter();

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

con = DriverManager.getConnection("jdbc:mysql://localhost/ebank", "root", "");

String fname = request.getParameter("fname");

String lname = request.getParameter("lname");

String address = request.getParameter("address");

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

pst = con.prepareStatement("insert into registation(fname,lname,address,phone)values(?,?,?,?)");

pst.setString(1, fname);

pst.setString(2, lname);

pst.setString(3, address);

pst.setString(4, phone);

pst.executeUpdate();

pst1 = con.prepareStatement("select max(id) from registation");

rs = pst1.executeQuery();

rs.next();

int regno;

regno = rs.getInt(1);

out.println("Thank you for your Registation");

out.println("Your Registaion No is :" + regno);

} catch (ClassNotFoundException ex) {

ex.printStackTrace();

} catch (SQLException ex) {

ex.printStackTrace();

}

Node js React Mongodb Search Functionality

Node js Angular Mongodb Search Functionality

How to Search Records Node js Express Mongodb

Inventory Management Servlet Jsp with Ajax

Servlet CRUD tutorial Insert,Update,Delete

Leave a Reply Cancel reply

Check Also

Node js React Mongodb Search Functionality

Recent Posts

Registration Form

Index.html

registation.java

i have attached the video link below. which will do this tutorials step by step.

Leave a Reply Cancel reply

Check Also

Recent Posts