<%@ page language ="java" errorPage="ExceptionHandler.jsp"%> <%@ page import ="java.sql.*" %> <%@ page import ="db.*" %> <%! ResultSet rs=null; ResultSet rs1=null; ResultSet rs2=null; String theam=""; String user_session=""; String question=null; String ans_option=null; String question_id=null; int contest_id=0; int answer=0; %> <% String contest_idd=request.getParameter("id"); int contest_id=Integer.valueOf(contest_idd).intValue(); //String user_name=(String)session.getAttribute("user_name"); %> <% 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(); %> Welcome to Smscontest.com
 
PLAY TO WIN    
<% Statement st1 = con.createStatement(); rs=st1.executeQuery("select * from contest_detail where V_CD_Flag='Y' order by Contest_Name desc"); while (rs.next()) {%> " class="categories"><%=rs.getString("Contest_Name")%>   |  <%} rs.close(); st1.close(); %>

<% theam=""; if(con!=null) { con.close(); } %>