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 Answer of Questions and ASK to Doubt