Untitled

<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%@page contentType="text/html" pageEncoding="UTF-8"%>

<%!
    public String printButton(String dest, String label) {
        return "<form action=\"" + dest + "\"method=\"POST\"><input type=\"submit\" value=\"" + label + "\"/></form >";
    }
%>


<%
    boolean devMode = false; // set to true for messages
    Connection connection = null;
    Statement s1 = null;
    PreparedStatement pstatement = null;
    ResultSet resultSet = null;

    String server = "jdbc:mysql://localhost:3306/";
    String database = "dip_db_schm";
    String encoding = "?useUnicode=yes&characterEncoding=UTF-8";
    String user = "root";
    String pass = "vagooba1234d";

    try {
        Class.forName("com.mysql.jdbc.Driver");
        connection = DriverManager.getConnection(server + database + encoding, user, pass);
        if (!connection.isClosed());
        s1 = connection.createStatement();
%>
<html>
    <head></head>
    <style>
        .mySlides {display:none;}
    </style>

    <link rel="stylesheet" type="text/css" href="mystyle.css" />

    <body  bgcolor="#00ffff" ONLOAD = "startTimer();">
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

        <script type="text/javascript">
            var seconds = 0;

            function startTimer() {
                window.setInterval("updateTime()", 1000);
            }

            function updateTime() {
                seconds++;
                soFar.innerHTML = seconds;
            }

            var d = new Date();
            document.write(d.getDate());
            document.write(" / ");
            document.write(d.getMonth() + 1);
            document.write(" / ");
            document.write(d.getFullYear());

            document.write("  ");

            document.write(d.getHours());
            document.write(" : ");
            document.write(d.getMinutes());
            document.write(" : ");
            document.write(d.getSeconds());

        </script>


        <div id="wrap">

            <div id="header" style="max-width:900px">
                <img class="mySlides" src="awesome.jpg" style="height:100px;width:900px">
                <img class="mySlides" src="wallpaper.jpg" style="height:100px;width:900px">
                <img class="mySlides" src="1.jpg" style="height:100px;width:900px">
                <img class="mySlides" src="2.jpg" style="height:100px;width:900px">
                <img class="mySlides" src="3.jpg" style="height:100px;width:900px">
            </div>

            <script>
                var myIndex = 0;
                carousel();

                function carousel() {
                    var i;
                    var x = document.getElementsByClassName("mySlides");
                    for (i = 0; i < x.length; i++) {
                        x[i].style.display = "none";
                    }
                    myIndex++;
                    if (myIndex > x.length) {
                        myIndex = 1;
                    }
                    x[myIndex - 1].style.display = "block";
                    setTimeout(carousel, 1500); // Change image every 1.5 seconds
                }
            </script>


            <div id="nav">
                <p>You are watching this page for:
                    <SPAN ID = "soFar" STYLE = "font-weight : bold">0</SPAN> seconds</p>
            </div>

            <div id="sidebar">
                <center>
                    <p><%=printButton(request.getRequestURL().toString(), "refresh")%></p>
                    <p><%=printButton("index.jsp", "Αρχική")%></p>
                </center>
            </div>

            <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
            <script type="text/javascript">
                google.charts.load('current', {'packages': ['table']});

                google.charts.setOnLoadCallback(drawTable1);
                google.charts.setOnLoadCallback(drawTable2);
                google.charts.setOnLoadCallback(drawTable3);
                google.charts.setOnLoadCallback(drawTable4);
                google.charts.setOnLoadCallback(drawTable5);

                <%//num stats
                    resultSet = s1.executeQuery("select count() as count from "+database+".theses_available;");
                    resultSet.first();
                    int th_av = resultSet.getInt("count");
                    resultSet = s1.executeQuery("select count() as count from "+database+".theses_undertaken;");
                    resultSet.first();
                    int th_un = resultSet.getInt("count");
                    resultSet = s1.executeQuery("select count() as count from "+database+".theses_gradeable;");
                    resultSet.first();
                    int th_co = resultSet.getInt("count");
                    resultSet = s1.executeQuery("select count() as count from "+database+".theses_graded;");
                    resultSet.first();
                    int th_gr = resultSet.getInt("count");
                %>


                function drawTable1() {
                    var data = new google.visualization.DataTable();
                    data.addColumn('string', 'Statistic');
                    data.addColumn('number', 'Number of theses');
                    data.addRows([
                        ['Theses Available', <%out.print(th_av);%>],
                        ['Theses Undertaken', <%out.print(th_un);%>],
                        ['Theses Complete', <%out.print(th_co);%>],
                        ['Theses Graded', <%out.print(th_gr);%>]
                    ]);

                    var table1 = new google.visualization.Table(document.getElementById('table1_div'));

                    table1.draw(data, {showRowNumber: true, width: '100%', height: '100%'});
                }

                function drawTable2() {

                    var data = new google.visualization.DataTable();
                    data.addColumn('string', 'Professor');
                    data.addColumn('number', 'Student average grade');
                    data.addRows([
                    <%//prof avg stud grade
                        pstatement = connection.prepareStatement("Select * from " + database + ".prof_avg_stud_grade;");
                        pstatement.execute();
                        resultSet = pstatement.getResultSet();
                        if (resultSet.first()) {
                            do {
                                out.println("['" + resultSet.getString("lname") + " " + resultSet.getString("fname") + "'," + resultSet.getDouble("avg_grade") + "],");
                            } while (resultSet.next());
                        }
                        resultSet.close();
                        pstatement.close();
                    %>
                    ]);

                    var table2 = new google.visualization.Table(document.getElementById('table2_div'));

                    table2.draw(data, {showRowNumber: true, width: '30%', height: '20%'});
                }

                function drawTable3() {
                    //Όλες          title, lname, fname, date_pub
                    var data = new google.visualization.DataTable();
                    data.addColumn('string', 'Professor');
                    data.addColumn('number', 'Theses average grade');
                    data.addRows([
                    <%//prof avg dipl grade
                        pstatement = connection.prepareStatement("Select * from " + database + ".prof_avg_stud_grade;");
                        pstatement.execute();
                        resultSet = pstatement.getResultSet();
                        if (resultSet.first()) {
                            do {
                                out.println("['" + resultSet.getString("lname") + " " + resultSet.getString("fname") + "'," + resultSet.getDouble("avg_grade") + "],");
                            } while (resultSet.next());
                        }
                        resultSet.close();
                        pstatement.close();
                    %>

                    ]);

                    var table3 = new google.visualization.Table(document.getElementById('table3_div'));

                    table3.draw(data, {showRowNumber: true, width: '30%', height: '20%'});
                }

                function drawTable4() {
                    //Όλες          title, lname, fname, date_pub
                    var data = new google.visualization.DataTable();
                    data.addColumn('string', 'asf');
                    data.addColumn('number', 'Theses conducted');
                    data.addRows([
                         <%//prof dipl num
                            pstatement = connection.prepareStatement("Select * from " + database + ".prof_dipl_num;");
                            pstatement.execute();
                            resultSet = pstatement.getResultSet();
                            if (resultSet.first()) {
                                do {
                                    out.println("['" + resultSet.getString("lname") + " " + resultSet.getString("fname") + "'," + resultSet.getInt("num_dipl") + "],");
                                } while (resultSet.next());
                            }
                            resultSet.close();
                            pstatement.close();
                        %>
                    ]);

                    var table4 = new google.visualization.Table(document.getElementById('table4_div'));

                    table4.draw(data, {showRowNumber: true, width: '30%', height: '20%'});
                }

                function drawTable5() {
                    //Όλες          title, lname, fname, date_pub
                    var data = new google.visualization.DataTable();
                    data.addColumn('string', 'Professor');
                    data.addColumn('number', 'Average Completion time (weeks)');
                    data.addRows([
                    <%//prof avg dipl period
                        pstatement = connection.prepareStatement("Select * from " + database + ".prof_avg_dipl_per;");
                        pstatement.execute();
                        resultSet = pstatement.getResultSet();
                        if (resultSet.first()) {
                            do {
                                out.println("['" + resultSet.getString("lname") + " " + resultSet.getString("fname") + "'," + resultSet.getDouble("avg_per") + "],");
                            } while (resultSet.next());
                        }
                        resultSet.close();
                        pstatement.close();
                    %>

                    ]);

                    var table5 = new google.visualization.Table(document.getElementById('table5_div'));

                    table5.draw(data, {showRowNumber: true, width: '30%', height: '20%'});
                }

            </script>

            <%
                } catch (Exception ex) {
                    out.println("<br>---<br>Exception: <br>" + ex);
                } finally {//Release Resources
                    if (resultSet != null) {
                        try {
                            resultSet.close();
                        } catch (SQLException sqlEx) {
                        }
                        resultSet = null;
                    }

                    if (s1 != null) {
                        try {
                            s1.close();
                        } catch (SQLException sqlEx) {
                        }
                        s1 = null;
                    }

                    if (!connection.isClosed()) {
                        try {
                            connection.close();
                        } catch (SQLException sqlEx) {
                        }
                        connection = null;
                    }
                }
            %>
            <h1>Chart:Theses Stats</h1>

            <div id="table1_div" style="width:500px; height:200px;"></div>
            <div id="table2_div" style="width:500px; height:200px;"></div>
            <div id="table3_div" style="width:500px; height:200px;"></div>
            <div id="table4_div" style="width:500px; height:200px;"></div>
            <div id="table5_div" style="width:500px; height:200px;"></div>


            <div id="footer">
                <a href="https://www.facebook.com/theicsd/?fref=ts"><font class="menu">Facebook</font></a>
                <font class="menu-delimiter">|</font>
                <a href="http://www.icsd.aegean.gr/icsd/"><font class="menu">Official Site</font></a>
                <font class="menu-delimiter">|</font>
                <a href="https://webmail.aegean.gr/"><font class="menu">Web_Mail</font></a>
                <font class="menu-delimiter">|</font>
                <a href="https://eclass.icsd.aegean.gr/"><font class="menu">E-Class</font></a>
            </div>
        </div>
    </body>
</html>