Advance Java

aRpit April 03, 2021

 Design a form to input details of an employee and submit the data to a servlet. Write code for   servlet that will save the entered details as a new record in database table Employee with fields   (EmpId, EName, Email, Age).


  • Employee Servlet

import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
 
public class Employee extends HttpServlet {
 
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) {
        try {
            int id, age;
            String name, email;
           
            response.setContentType("text/html");
            PrintWriter out = response.getWriter();
           
            Class.forName("com.mysql.jdbc.Driver");
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/College", "root", "");
            PreparedStatement ps = conn.prepareStatement("insert into Employee(EmpId, EName, Email, Age) values(?, ?, ?, ?)");
           
            id = Integer.parseInt(request.getParameter("id"));
            name = request.getParameter("name");
            email = request.getParameter("email");
            age = Integer.parseInt(request.getParameter("age"));
           
            ps.setInt(1, id);
            ps.setString(2, name);
            ps.setString(3, email);
            ps.setInt(4, age);
           
            int i = ps.executeUpdate();
            out.print(" Employee registered successfully...!");   
            ps.close();
            conn.close();
        }
        catch(Exception ex) {
            ex.printStackTrace();
        }
    }
}

  • Employee html 

<!DOCTYPE html>
 <html>
    <head>
        <title> Employee </title>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
    </head>
    <body>
        <div>
            <form action="Employee" method="post">
                <p>ID: <input type="number" name="id" required> </p>
                <p>Name: <input type="text" name="name" required> </p>
                <p>Email: <input type="email" name="email" required> </p>
                <p>Age: <input type="number" name="age" required> </p>
                <input type="submit" value="Save">
            </form>
        </div>
    </body>

</html>

  • Web.xml 

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="3.1" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd">
    <servlet>
        <servlet-name>Employee</servlet-name>
        <servlet-class>Employee</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>Employee</servlet-name>
        <url-pattern>/Employee</url-pattern>
    </servlet-mapping>
    <session-config>
        <session-timeout>
            30
        </session-timeout>
    </session-config>

</web-app>

Post a Comment

0 Comments

Emoji
(y)
:)
:(
hihi
:-)
:D
=D
:-d
;(
;-(
@-)
:P
:o
:>)
(o)
:p
(p)
:-s
(m)
8-)
:-t
:-b
b-(
:-#
=p~
x-)
(k)