Java Technology Hub: Registration form using jsp with servlet

 This code is developed by using NetBeans. Here I include CSS styles also in JSP page

Code for jsp:

<html>

    <head>

        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

        <title>user registration</title>

        <style type="text/css">

            body{

                margin-top: 100px;

            #tf,select{

             border: solid 1px darkcyan;

h2{

                color:  cornflowerblue;

                font-family: cursive;

            #button{

                color: white;

                background-color:blue;

                border: sloid 1px #aaaaaa;

                cursor: pointer;

                width: 100px;

                height: 30px;

        </style>

    </head>

    <body>

    <center>

        <h2>Register Here</h2>

        <form action="RegServlet" method="post">

            <table>

                <tr>

                    <td>Name </td><td><input type="text" name="name" value="" id="tf" /></td>

                </tr>

                <tr>

                    <td>Email id </td><td><input type="text" name="mailid" value=""id="tf" /></td>

                </tr>

                <tr>

                    <td>Password </td><td><input type="password" name="psw" value="" id="tf"/>

                 </td>

                </tr>

                <tr>

                <td>Security Question </td>

                <td><select name="sq">

                        <option value="your best friend name">your best friend name</option>

                          <option value="your favorite movie">your favorite movie</option>

                           <option value="your favorite subject">your favorite subject</option>

                    </select></td></tr>

                <tr><td>Security Answer </td><td><input type="text" name="sa" value=""id="tf" />

           </td>

                </tr>

                <tr><td></td><td><input type="submit" name=""value="Register me" id="button"/>

            </td></tr>

            </table>

        </form>

    </center>

    </body>

</html>

Servlet code:

import java.io.IOException;

import java.io.PrintWriter;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.logging.Level;

import java.util.logging.Logger;

import javax.servlet.RequestDispatcher;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

public class RegServlet extends HttpServlet {

    protected void processRequest(HttpServletRequest request, HttpServletResponse response)

            throws ServletException, IOException, ClassNotFoundException, SQLException {

        response.setContentType("text/html;charset=UTF-8");

        PrintWriter out = response.getWriter();

        try {

            String name,mid,psw,sq,sa;

           name=request.getParameter("name");

           mid=request.getParameter("mailid");

           psw=request.getParameter("psw");

           sq=request.getParameter("sq");

           sa=request.getParameter("sa");

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

           Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/myblog",

           "narendar_blog","12345");

           String q=" insert into account_info values('"+name+"','"+mid+"','"+psw+"','"+sq+"',

           '"+sa+"')";

           Statement st=con.createStatement();

           int i=st.executeUpdate(q);

           if(i>0)

            RequestDispatcher rd=request.getRequestDispatcher("account_login.jsp");

              rd.forward(request, response);

        catch(Exception e)

            out.println(e);

        }finally {

            out.close();

Java Technology Hub