<%@page contentType="text/html" pageEncoding="UTF-8" import="java.sql.*" session="true"%> News In Detail
<% int i = 0 ; String str1 = null ; if(request.getParameter("newsNumber")!= null) str1 = request.getParameter("newsNumber"); else str1 = (String)session.getAttribute("newsNumber"); String headline = null; String news = null; String sno= null; session.setAttribute("newsNumber",str1); try { Connection con = connect.getConnection(); Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery("select * from t_news where sno = '"+str1+"'"); rs.next(); headline = rs.getString(2); news = rs.getString(3); sno = rs.getString(1); // String headline = rs.getString(2); } catch (Exception e) {out.println(e);} %>

<%out.println(headline); %>

<%=news %>

Comments

    <% try { Connection con1 = connect.getConnection(); Statement stmt1 = con1.createStatement(); ResultSet rs3 = stmt1.executeQuery("select * from t_userreview where headline ='"+headline+"' and valid=1" ); boolean comment_odd = true; while (rs3.next()) { if(comment_odd) { out.println("
  • "); comment_odd = false; } else{ out.println("
  • "); comment_odd= true; } out.println("
    "+rs3.getString(5)+" wrote:
    "); out.println("
    August 4, 2009 at 8:35 am
    "); out.println("

    "+rs3.getString(3)+"

    "); out.println("
    • "); } } catch (Exception e) { } %>

Write A Comment