Untitled

    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Reachable Results</title>
        <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
    </head>
    <body>


    <p>
        <button onclick="goBack()">Go Back To Selection</button>
        <script>
        function goBack() {
            window.history.back();
        }
        </script>
        </p>

    <table class="table table-striped">

    <thead>
        <th>Retweet Count</th>
        <th>Tweet Text</th>
        <th>Tweet Poster</th>
        <th>Category</th>
        <th>Subcategory</th>
        <th></th>
    </thead>
    <tbody>

    <%
    Connection connection = null;
    Statement statement = null;
    ResultSet rs = null;

    String dbName = "jdbc:mysql://cs363winservdb:3306/nsyens?allowPublicKeyRetrieval=true&useSSL=false";
    try{
        String dbUser = (String) session.getAttribute("username");
        String dbPassword = (String) session.getAttribute("password");
        String nodeSelection = request.getParameter("selection");
        String viewAmount = request.getParameter("viewSelection");
        String yearSelected = request.getParameter("yearSelection");
        String monthSelected = request.getParameter("monthSelection");
        connection = DriverManager.getConnection(dbName,dbUser,dbPassword);
        statement = connection.createStatement();
        String query = "SELECT t.retweet_count , t.tweet_text , t.posted_user , u.category, u.sub_category FROM tweets t, users u WHERE MONTH(t.created_at)='"+ monthSelected +"' AND YEAR(t.created_at)='" + yearSelected + "' AND t.posted_user=u.screen_name ORDER BY t.retweet_count DESC LIMIT " + viewAmount +";";
        ResultSetMetaData rsMetaData;
        String toShow;
        rs = statement.executeQuery(query);
        rsMetaData = rs.getMetaData();
        toShow = "";

        while (rs.next()) {
            out.println("<tr>");
            for (int i = 0; i < rsMetaData.getColumnCount(); i++) {
                out.println("<td>" + rs.getString(i + 1) + "</td>");
            }
            out.println("</tr>");
            }
        %>

        </tbody>
        </table>