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

Salary Slip Uploaded Successfully!

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

Some thing went wrong! Try again!

<%}%>






<% // Create SimpleDateFormat object java.text.SimpleDateFormat formatter = new java.text.SimpleDateFormat("yyyy-MM-dd"); // Format current date and time String currentDateAndTime = formatter.format(new java.util.Date()); %>

<% // Array to map month numbers to month names String[] monthNames = {"January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"}; // Get the current month (Note: Month is zero-based in Java Calendar) java.util.Calendar cal = java.util.Calendar.getInstance(); int currentMonth = cal.get(java.util.Calendar.MONTH); String currentMonthName = monthNames[currentMonth]; %>

<% // Get the current year //java.util.Calendar cal = java.util.Calendar.getInstance(); int currentYear = cal.get(java.util.Calendar.YEAR); %>

All Salary Slips

<% 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 emp_payroll"); while (rs.next()) { %>
<% } %> <% } catch (Exception e) { System.out.println(e); } %>
Emp # Email Date Month Year File Name Open
<%=rs.getString(2)%> <%=rs.getString(3)%> <%=rs.getString(4)%> <%=rs.getString(5)%> <%=rs.getString(6)%> <%=rs.getString(7)%>