Add Employee Record into database using JDBC with JSP and Servlet,JDBC Insert data into database

Add Employee Record into the database using JDBC with JSP and Servlet, JDBC Insert data into database

Step1st:-  Create Table using PHPMYADMIN

localhost/phpmyadmin  

step2nd:     create JSP using   JSP+WebForms

step3rd:-      Create Servlet and Write Database Connectivity code

Complete Code of JSP Web Forms:-

<%@include  file="header.jsp" %>

<section>
    <h1>Welcome in home page</h1>
   
    <hr>
    <center>
    <form action="EmpSer" method="post">
        <input type="text" name="txtempid" placeholder="Enter employee id" /> 
        <br>
        <br>
        <input type="text" name="txtemppass" placeholder="Enter employee password" /> 
        <br>
        <br>
        <input type="text" name="txtempname" placeholder="Enter employee name" /> 
        <br>
        <br>
        <input type="text" name="txtempjob" placeholder="Enter employee job" /> 
        <br>
        <br>
        <input type="text" name="txtempsalary" placeholder="Enter employee salary" /> 
        <br>
        <br>
        <input type="submit" name="btnsubmit" value="Insert" />
    </form>
    </center>
</section>

<%@include  file="footer.jsp" %>


Complete Code of Servlet:-

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.*;
/**
 *
 * @author Hp
 */
public class EmpSer extends HttpServlet {

    /**
     * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
     * methods.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        try  {
          Class.forName("com.mysql.jdbc.Driver");
          Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/javatest","root","");
          Statement st = con.createStatement();
          int x = st.executeUpdate("insert into emp (empid,password,empname,job,salary) values('"+request.getParameter("txtempid")+"','"+request.getParameter("txtemppass")+"','"+request.getParameter("txtempname")+"','"+request.getParameter("txtempjob")+"','"+request.getParameter("txtempsalary")+"')");
          if(x!=0)
              out.write("data inserted successfully");
             
         
        }
        catch(Exception ex)
        {
            out.write(ex.getMessage().toString());
        }
    }

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /**
     * Handles the HTTP <code>GET</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Handles the HTTP <code>POST</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Returns a short description of the servlet.
     *
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>

}