EmployeeLoginServlet.java

package com.danish;

import jakarta.servlet.;
import jakarta.servlet.http.;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class EmployeeLoginServlet extends HttpServlet {
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String employeeId = request.getParameter("employeeId");
String password = request.getParameter("password");

    try (Connection conn = DatabaseConnection.getConnection()) {
        String sql = "SELECT * FROM employee WHERE id = ? AND password = ?";
        PreparedStatement pstmt = conn.prepareStatement(sql);
        pstmt.setString(1, employeeId);
        pstmt.setString(2, password);

        ResultSet rs = pstmt.executeQuery();
        if (rs.next()) {
            HttpSession session = request.getSession();
            session.setAttribute("employeeName", rs.getString("name"));
            response.sendRedirect("employee/dashboard.jsp");
        } else {
            request.setAttribute("errorMessage", "Invalid login credentials!");
            request.getRequestDispatcher("employee/login.jsp").forward(request, response);
        }
    } catch (Exception e) {
        response.getWriter().println("Error: " + e.getMessage());
    }
}

}