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

Product Successfully Updated!

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

Some thing went wrong! Try again!

<%}%>
<% //String line_manager = request.getParameter("first_name" + "last_name"); 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_timesheet where line_manager='Mr. Sachin Pawar'"); while(rs.next()){ %>
<% } %> <% }catch (Exception e) { System.out.println(e); } %>
Sr. no Date Total Worked Hours Overtime View More
<%=rs.getString(1)%> <%=rs.getString(6)%> <%=rs.getString(3)%> <%=rs.getString(5)%>