<%@ page language ="java" %> <%@ page import ="java.sql.*" %> <%@ page import ="db.*" %> <%! ResultSet rs=null; ResultSet rs1=null; ResultSet rs2=null; String theam=""; int qrs=0; String arr1=""; String arr2=""; String category_ring=""; int limitePorPagina = 10; %> <% String qs=request.getQueryString(); String [] arr= qs.split("@"); arr1=arr[0]; arr2=arr[1]; qrs=Integer.valueOf(arr1).intValue(); %> <% Connection con=ConnectionFactory.getConnection(); Statement st1 = con.createStatement(); rs=st1.executeQuery("select * from theams where display='Y'"); while(rs.next()) { theam=rs.getString("color_pg"); } rs.close(); st1.close(); %> <% Statement stcatg = con.createStatement(); ResultSet rscat=stcatg.executeQuery("select Ring_catg from ring_catg where Pk_Ring_Catg_Id="+qrs); if(rscat.next()) { category_ring=rscat.getString("Ring_catg"); } // stcatg.close(); rscat.close(); %> Welcome to Smscontest.com
MONOPHONIC
KEYPRESS
 
  <%=category_ring%>
<% Statement st2 = con.createStatement(); rs2=st2.executeQuery("select * from ring_catg "); while (rs2.next()) {%> @1" class="categories"><%=rs2.getString("Ring_catg")%>   |   <%} rs2.close(); st2.close(); %>

<% String ring_type="Polyphonic"; Statement stn = con.createStatement(); Statement declaracao2 = con.createStatement(); rs1=stn.executeQuery("select * from ringtones where Ring_Type='"+ring_type+"' and Fk_ring_catg="+qrs+" LIMIT " + arr2 + "," + String.valueOf(limitePorPagina)); ResultSet rsnew = declaracao2.executeQuery("Select count(*) as c from ringtones where Ring_Type='"+ring_type+"' and Fk_ring_catg="+qrs); 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(rs1.next()) { int ring_id=rs1.getInt("Pk_ring_Id"); %> <%}} catch(SQLException e) { out.println("SQL Error" + e); }%>
    CODE     RINGTONE
LISTEN
    <%=rs1.getString("Ring_Code")%> <%=rs1.getString("Ring_Title")%>
 
<% if (pr > 10) { %> [First]  [Previous]  <% }//if (pr > 0) if (pr < (totalpgs * limitePorPagina) - limitePorPagina) { %> [Next]  [Last]  <% }//if (cont < totalpgs) %>
     
 
<% rs1.close(); st1.close(); category_ring=""; theam=""; con.close(); %>