<%@page import="java.util.Date"%> <%@page contentType="text/html" pageEncoding="UTF-8" import="java.sql.*" session="true"%> Search News
Sort By : <% request.setCharacterEncoding("UTF-8"); if (!(request.getParameter("searchCategoryopt") == null)){ out.println("News for "+request.getParameter("searchCategoryopt")); } else if(!(request.getParameter("searchDatetxt") == null)){ out.println("News of "+request.getParameter("searchDatetxt")); } else if(!(request.getParameter("searchHeadlinetxt") == null)){ out.println(""+request.getParameter("searchHeadlinetxt")); } %>
<% request.setCharacterEncoding("UTF-8"); try { Connection con = connect.getConnection(); Statement stmt = con.createStatement(); ResultSet rs = null; String search = null; String searchHeadlineText = request.getParameter("searchHeadlinetxt"); String searchDatetxt = request.getParameter("searchDatetxt"); String searchCategoryopt = request.getParameter("searchCategoryopt"); if((searchHeadlineText != null) ) { search = request.getParameter("searchHeadlinetxt"); rs = stmt.executeQuery("select * from t_news where headline Like '"+search+"%' order by date desc"); session.setAttribute("searchResult","Search Based on Headline"); } else if (searchDatetxt != null) { search = request.getParameter("searchDatetxt"); rs = stmt.executeQuery("select * from t_news where date='"+search+"' order by date desc "); session.setAttribute("searchResult","News of "+search+" "); } else if(searchCategoryopt != null ) { search = request.getParameter("searchCategoryopt"); rs = stmt.executeQuery("select * from t_news where category='"+search+"' and active='1' order by date desc"); session.setAttribute("searchResult","News of "+search+""); } else { rs = stmt.executeQuery("select * from t_news order by date desc"); session.setAttribute("searchResult",""); } int i = 0 ; String str1 = null ; // if(request.getParameter("category")!= null) // str1 = request.getParameter("category"); // else // str1 = (String)session.getAttribute("category"); String headline = null; String news = null; String sno= null; // session.setAttribute("category",str1); boolean toggle = true; out.println( "
"); out.println(""); while( rs.next()) { String str = rs.getString(3); if (str.length() >= 300 ) { str = str.substring(0, 300); } Date date = rs.getDate(6); if (toggle) { out.println(""); out.println(""); toggle= false; } else { out.println(""); toggle= true; } } out.println("
"); out.println(""+rs.getString(2)+"
"); out.println(date); //print date out.println("
"+rs.getString(2)+"
"); out.println(date); //print date out.println("
"); out.println("
"); out.println("

"); // String headline = rs.getString(2); } catch (Exception e) {out.println(e);} %>