Actually, my goal is to use the Confluence's instance web server functionality to call a user defines JSP which will be located http://Confluence Apps/admin/xxxxxx.jsp to access a table and to display the content on screen:
I have created the following:
<html> <head><title>Space/Page Statistics</title></head> <body> <%@ page import="java.util.*" %> <%@ page import="javax.sql.*;" %> <%
java.sql.Connection con; java.sql.Statement s; java.sql.ResultSet rs; java.sql.PreparedStatement pst;
con=null; s=null; pst=null; rs=null;
// Remember to change the next line with your own environment String url= "jdbc:mysql://mysql-wiki-1.test.internal/wiki"; String id= ""; String pass = "";
try{
Class.forName("com.mysql.jdbc.Driver"); con = java.sql.DriverManager.getConnection(url, id, pass);
}catch(ClassNotFoundException cnfex){ cnfex.printStackTrace();
} String sql = "SELECT PageAccessedURL, COUNT(PageAccessedURL) `HitCount` FROM confluence_access_logs WHERE EntryDate >= '2015-01-06 18:46:50' AND EntryDate <= '2015-01-07 00:20:21' GROUP BY PageAccessedURL ORDER BY HitCount DESC limit 10 ";
try{ s = con.createStatement(); rs = s.executeQuery(sql); %> <table border="1"> <tr> <th>Space/Page Name</th> <th>Hit Count </th> </tr> <% while( rs.next() ){ %><tr> <td><%= rs.getString("PageAccessedURL") %></td> <td><b><%= rs.getString("HitCount") %></b></td> </tr> <% } %>
<%
}
catch(Exception e){e.printStackTrace();} finally{ if(rs!=null) rs.close(); if(s!=null) s.close(); if(con!=null) con.close(); }
%> </table> </body> </html>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.