<%
                     ArrayList list = new ArrayList();
                     ArrayList sublist = new ArrayList();
                     try {
                         Class.forName("org.postgresql.Driver");
                         Connection con = DriverManager.getConnection("jdbc:postgresql://sigma.pwsz.krosno.pl:5432/buk", "postgres", "26!D$196eF85");
                 %>

                 <%
                     String query1 = "select * from Dyscyplina";
                     Statement st1 = con.createStatement();
                     ResultSet rs1 = st1.executeQuery(query1);

                     while (rs1.next()) {


                 %>

                 <button class="list-group-item"   style="background-color: #343a40; color:#fff200; text-align: left; list-style-type: none;">
                     <li><%= rs1.getString("nazwa")%>
                         <span class="glyphicon glyphicon-chevron-down" aria-hidden="false"></span>
                 </button>

                 <ul class="list-group-item" style="background-color: #fff200; border: 0px; color:#343a40; border-color:#343a40; list-style-type: none;">
                     <%
                         String query2 = "select nazwa from Region";
                         Statement st2 = con.createStatement();
                         ResultSet rs2 = st2.executeQuery(query2);
                         while (rs2.next()) {
                     %>


                     <li>
                         <a href="#" class="list-group-item" style="background-color: #fff200; color: #343a40; ">
                             <%= rs2.getString("nazwa")%>
                         </a>
                     </li>
                     <%
                         }
                     %>
                 </ul>
                </li>


                <%
                    }
                %>
</ul>

<%
    } catch (Exception e1) {
    }
%>