Untitled

<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>LOGIN PAGE</title>
</head>
<body>
<h1 style="color: red" align="center">ADMIN LOGIN HERE</h1>
<form action="servlet1" method="post" align="center" style="color: #ff3399">
USER NAME:<input type="text" name="name"><br><br>
PASSWORD:<input type="password"name="password"><br><br>

<input type="submit" value="LOGIN">
</form>
</body>
</html>

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * Servlet implementation class Validate
 */
@WebServlet("/Validate")
public class Validate extends HttpServlet {
    private static final long serialVersionUID = 1L;

    /**
     * @see HttpServlet#HttpServlet()
     */
 /*   public Validate() {
        super();
        // TODO Auto-generated constructor stub
    }

    *//**
     * @see Servlet#init(ServletConfig)
     *//*
    public void init(ServletConfig config) throws ServletException {
        // TODO Auto-generated method stub
    }

    *//**
     * @see Servlet#destroy()
     *//*
    public void destroy() {
        // TODO Auto-generated method stub
    }

    *//**
     * @see Servlet#getServletConfig()
     *//*
    public ServletConfig getServletConfig() {
        // TODO Auto-generated method stub
        return null;
    }

    *//**
     * @see Servlet#getServletInfo()
     *//*
    public String getServletInfo() {
        // TODO Auto-generated method stub
        return null;
    }

    *//**
     * @see HttpServlet#service(HttpServletRequest request, HttpServletResponse response)
     *//*
    protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
    }
*/
    /**
     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        response.getWriter().append("Served at: ").append(request.getContextPath());
    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        doGet(request, response);
        try{
            response.setContentType("Text/Html");
            PrintWriter out=response.getWriter();
            String n=request.getParameter("name");
            String p=request.getParameter("password");

            if(n.equals("suresh") || p.equals("gopineni")){
                System.out.println("user login success:");
                RequestDispatcher rd=request.getRequestDispatcher("Success.html");
                rd.forward(request, response);
            }
            else{
                System.out.println("user login failed:");
                out.println("<html><body><h3 align='center'>Please enter valid username & Password:</h3></body></html>");

                RequestDispatcher rd=request.getRequestDispatcher("UserLogin.html");
                rd.include(request, response);
            }

        }catch(Exception e){
            System.out.println(e);
        }
    }


}

<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<h1 style="color:orange">WELCOME TO SURESH GOPINENI</h1>
<form action="servlet2" method="post" align="center" style="color: #ff3399">
USER NAME:<input type="text" name="fname"><br><br>
LAST NAME:<input type="text"name="lname"><br><br>

<input type="submit" value="ADD USER">
</body>
</html>

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.Statement;

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;

/**
 * Servlet implementation class StoreInDatabase
 */
@WebServlet("/StoreInDatabase")
public class StoreInDatabase extends HttpServlet {
    private static final long serialVersionUID = 1L;

    /**
     * @see HttpServlet#HttpServlet()
     */
    public StoreInDatabase() {
        super();
        // TODO Auto-generated constructor stub
    }

    /**
     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        response.getWriter().append("Served at: ").append(request.getContextPath());
    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        doGet(request, response);
        response.setContentType("text/html");
        PrintWriter out=response.getWriter();
        String fn=request.getParameter("fname");
        String ln=request.getParameter("lname");
        try{
            Class.forName("com.mysql.jdbc.Driver");
            Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/realtime","root","root");
            PreparedStatement pp=con.prepareStatement(" insert into fullnametb(fname,lname) values(?,?)");
            pp.setString(1, fn);
            pp.setString(2, ln);
            int i=pp.executeUpdate();
            out.println("<html><head>welcome</head><body>");
            if(i!=0){
                out.println("<h1>two record inserted</h1></body></html>");
            }
            else{
                RequestDispatcher rd=request.getRequestDispatcher("Success.html");
                rd.include(request, response);
            }
            con.close();
        }catch(Exception e){
            System.out.println(e);
        }
    }

}