<%
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()){
%>
<%
}
%>
<%
} catch (Exception e) {
out.println(e);
}
%>