<%@ page language ="java" errorPage="ExceptionHandler.jsp"%> <%@ page import ="java.sql.*" %> <%@ page import ="db.*" %> <%! ResultSet rs=null; ResultSet rs1=null; ResultSet rs2=null; ResultSet rs9=null; String theam=""; int k=0; int j=0; int row_cou=0; String qs=""; String user_session=""; String category=""; String arr1=""; String arr2=""; int catg=0; int limitePorPagina = 10; %> <% qs=request.getQueryString(); String [] arr= qs.split("@"); arr1=arr[0]; arr2=arr[1]; k=Integer.valueOf(arr1).intValue(); %> <% Connection con=ConnectionFactory.getConnection(); Statement sttheam = con.createStatement(); rs=sttheam.executeQuery("select * from theams where display='Y'"); while(rs.next()) { theam=rs.getString("color_pg"); } rs.close(); sttheam.close(); %> <% Statement stcatg = con.createStatement(); ResultSet rscatg=stcatg.executeQuery("select Jokes_catg from jokes_catg where j_catg_id="+k); if(rscatg.next()) { category=rscatg.getString("Jokes_catg"); } rscatg.close(); stcatg.close(); %> <%Statement stn = con.createStatement(); ResultSet rsn=stn.executeQuery("select * from jokes_catg where j_catg_id="+k); while (rsn.next()) { category=rsn.getString("Jokes_catg"); } %> Welcome to Smscontest.com
 
  <%=category%>
<% Statement stcat = con.createStatement(); ResultSet rscat=stcat.executeQuery("select * from jokes_catg order by Jokes_catg"); while (rscat.next()) {%> @1" class="categories"><%=rscat.getString("Jokes_catg")%>   |   <%} rscat.close(); stcat.close(); %>

<% Statement stmt = con.createStatement(); Statement declaracao2 = con.createStatement(); ResultSet rtst=stmt.executeQuery("select * from jokes where joke_show='Y' and Fk_joke_catg="+k+" LIMIT " + arr2 + "," + String.valueOf(limitePorPagina)); ResultSet rsnew = declaracao2.executeQuery("Select count(*) as c from jokes where joke_show='Y' and Fk_joke_catg="+k); rsnew.next(); int totalregs = Integer.parseInt(rsnew.getString("c")); int totalpgs = Math.round(totalregs / limitePorPagina); if ((totalregs % limitePorPagina) > 0) totalpgs++; int pr = Integer.valueOf(arr2).intValue(); try{ while (rtst.next()) { row_cou=0; %> <% } } catch(SQLException e) { out.println("SQL Error" + e); } %> <% if(row_cou<1) { %> <%}%>
    TITLE
READ BY
RANK
    @1" class="tdbgrt"><%=rtst.getString("joke_brief")%>
<%=rtst.getString("jokes_hit")%>
<%=rtst.getString("joke_rank")%>
<% if (pr > 10) { row_cou=1; %>  [First]  [Previous]  <% }//if (pr > 0) if (pr < (totalpgs * limitePorPagina) - limitePorPagina) { row_cou=1; %> [Next]  [Last]  <% } %>
 
 
 
<% j=0; %> <% //rs2.close(); //st2.close(); rtst.close(); con.close(); %> <% theam=""; if(con!=null) { con.close(); } %>