<%@page import="project.ConnectionProvider"%> <%@page import="java.sql.*"%> View Leave Details
<% String msg = request.getParameter("msg"); if ("done".equals(msg)) { %>

Leave Application Submitted Successfully!

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

Some thing went wrong! Try again!

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

Leave Application status is updated

<%}%>

Back

<% 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 inner join users where leave_app.emp_code=users.emp_code and leave_app.req_id='" + vid + "'"); while (rs.next()) { %>

Leave Details

Employee Name

Employee Code

Nature Of Leave

Days Applied

From date

To Date

If half Day

Reason For Taking Leave

Contact Number During Leave

Contact Address

Allocated Person

Status
<% } } catch (Exception e) { out.println(e); } %>