Untitled

</head>
    <body>
        <h3 align="center">Associates by Manager</h3>
        <div class="container">
            <form action="retrieve.jsp" method="post">
            <div class="col-sm-5">
            <strong>List by Manager:</strong>
                <select class="form-control" name="mgrid" data-width="150px" onchange="this.form.submit()";>
                        <option value="0">Select Manager</option>
                <%
                 try
                {
                    Class.forName("com.mysql.jdbc.Driver").newInstance();
                    Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/newschema","root","root");
                    Statement stm=conn.createStatement();
                    ResultSet rs=stm.executeQuery("select * from manager");
                    while(rs.next())
                    {

                %>
                        <option id=mid value="<%=rs.getInt("id")%>"><%=rs.getString("id_manager")%></option>
                <%
                    }
                    conn.close();
                    rs.close();
                }
                 catch(Exception ex)
                {
                    ex.printStackTrace();
                    out.println("Error "+ex.getMessage());
                }
                %>

                </select>

            <br>
            </div>
            <table class="table table-bordered table-striped">
                <thead class="thead-dark">
                <tr>
                    <th class="text-center">User ID</th>
                    <th class="text-center">Name</th>
                    <th class="text-center">Shift</th>
                    <th class="text-center"colspan="3">Action</th>
                </tr>
                </thead>
                <%
                try
                {
                Class.forName("com.mysql.jdbc.Driver").newInstance();
                Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/newschema","root","root");
                Statement stm=conn.createStatement();
                String sql="select * from associate where id_mgr_fk="+Integer.parseInt(request.getParameter("mgrid"));
                ResultSet rs=stm.executeQuery(sql);
                while(rs.next())
                {
                %>
                    <tr>
                        <td><%=rs.getString("id_assc") %></td>
                        <td><%=rs.getString("name_assc") %></td>
                        <td class="text-center"><%=rs.getString("shift_assc") %></td>
                        <td class="text-center"><a href="update.jsp?id=<%=rs.getString("id")%>">Update</a></td>
                        <td class="text-center"><a href="delete.jsp?id=<%=rs.getString("id")%>">Delete</a></td>
                        <td class="text-center"><a href="mark_attndc.jsp?id=<%=rs.getString("id")%>">Change Leave status</a></td>
                    </tr>
                <%
                }
                rs.close();
                conn.close();

                }
                catch(Exception ex)
                {
                    ex.printStackTrace();
                }
                %>
            </table>
            </form>
        </div>
    </body>
</html>