<%@page contentType="text/html"%> <%@page pageEncoding="UTF-8"%> <%@ include file="connectionDB.jsp" %> <%@ include file="header.jsp" %> <% ResultSet rs = null, rs1 = null; Statement st = null, st1 = null; String sql = ""; try { sql = "select TweetId from tweets"; st = con.createStatement(); rs = st.executeQuery(sql); int total = 0; while(rs.next()){ total++; } int pages = total/20; if(total%20 != 0) pages++; %>

Home

Public Timeline Total tweets : <%=total%>

<% } catch(Exception ex) { System.out.println("Error in search "+ex); } %> <%@ include file="footer.jsp" %>