<%@page import="project.ConnectionProvider"%> <%@page import="java.sql.*"%> <%@include file="employeeHeader.jsp" %> Home
<% String msg=request.getParameter("msg"); if("login".equals(msg)){ %>
Login to Buy Products
<%}%> <% if("exist".equals(msg)){ %>
Product already exist in you cart! Quantity increased!
<%}%> <% if("added".equals(msg)){ %>
Product Added To Your Cart
<%}%> <% if("invalid".equals(msg)){ %>
Something Went Wrong!!! Try Again
<%}%>

My 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 LeaveCount"); while (rs.next()) { %>
<% } %> <% } catch (Exception e) { System.out.println(e); } %>
Emp # Leave Type Leave Balance Last Updated On
<%=rs.getString(1)%> <%=rs.getString(2)%> <%=rs.getString(3)%> <%=rs.getString(4)%> <%=rs.getString(5)%>