<%@page import="java.sql.*"%> <%@include file="LMHeader.jsp" %> welcome
<% 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 users where line_manager='Sachin Pawar'"); while(rs.next()){ %>
User

<%=rs.getString(2)%> <%=rs.getString(4)%>

<%=rs.getString(22)%>

<%=rs.getString(23)%>

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