
<%@page import="java.sql.*"%>
<%@include file="LMHeader.jsp" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>welcome</title>
<style>
</style>
</head>
<body style="background-color: #f2f2f2">
    
<div class="row">
<% 
    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()){

%>
<form action="#" method="post">      
    
<div class="col-md-4">
                        <div class="column">
                            <div class="card">
                                <img src="images/<%=rs.getString(33)%>" alt="User" style="width: 100%; height: 300px;">
                                <div style="background-color: white;">
                                    <h1 style="background-color: #f2f2f2; padding-top:1rem; padding-left: 1rem; padding-right: 1rem; margin: 0px"><%=rs.getString(2)%> <%=rs.getString(4)%> </h1>
                                    <p class="price" style="background-color: #f2f2f2; padding: 10px; margin: 0px;"> <%=rs.getString(22)%> </p>
                                    <p style="background-color: #f2f2f2; margin: 0px; padding-bottom: 20px"><%=rs.getString(23)%></p>
                                              
                                </div>
                            </div>
                        </div>
                    </div>
   
</form>    
<%
        }
%>

</div>
<%
    } catch (Exception e) {
          out.println(e);
    }           
%>
</body>
</html>