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>

}



Post a Comment

If you have any doubt in programming or join online classes then you can contact us by comment .

Previous Post Next Post