<%@page import="project.ConnectionProvider"%> <%@page import="java.sql.*"%> <%@include file="LMHeader.jsp" %> All Leave Requests
<% String msg = request.getParameter("msg"); if ("done".equals(msg)) { %>

Status Updated Successfully!

<%}%> <% if ("wrong".equals(msg)) { %>

Some thing went wrong! Try again!

<%}%>

Leave Requests

<% String vid = request.getParameter("req_id"); try { Class.forName("com.mysql.jdbc.Driver"); Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/CLINIHR", "root", "Clinica123"); Statement st = con.createStatement(); ResultSet rs = st.executeQuery("select * from leave_app where LMemail='"+email+"'"); while (rs.next()) { %>
<% } %> <% } catch (Exception e) { System.out.println(e); } %>
Employee ID Employee Name From Date To Date Mobile Number Leave Type View More
<%=rs.getString(1)%> <%=rs.getString(2)%> <%=rs.getString(6)%> <%=rs.getString(7)%> <%=rs.getString(10)%> <%=rs.getString(4)%>