|
|
Search Results 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
<%@ page import="java.io.*" %>
<%@ page import="javax.servlet.*" %>
<%@ page import="javax.servlet.http.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.lang.reflect.Array" %>
<%
String title;
String webaddress;
String category =request.getParameter("category");
String finalSql ="";
String sql1 = "SELECT * FROM search WHERE (search.category='"+category+"')";
String sql2 =" ORDER BY title ";
//add order by
finalSql =sql1 +sql2;
//System.out.println("finalSQL="+finalSql);
Connection con = null;
Statement stmt=null;;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:searchDSN";
con = DriverManager.getConnection(url, "searchbingo", "searchbingo");
stmt = con.createStatement();
}
catch(Exception e)
{
System.out.println("Error in creating connection object. " +e);
}
try
{
//System.out.println("before execute");
System.out.println("***Category ="+category+" search in Trimurti Search Engine. ***");
ResultSet rs;
rs = stmt.executeQuery(finalSql);
int i=0;
long noOfRows =0;
while (rs.next())
{
noOfRows = noOfRows +1;
}
//System.out.println("No. of Rows="+noOfRows);
%>
<%out.println("");
out.println("");
out.println("| ");
out.println("Category : "+category+" ");
out.println(" | ");
out.println(" ");
out.println(" ");
%>
|
Web Site Matches Found :
<%=noOfRows%>
|
<%
rs = stmt.executeQuery(finalSql);
while (rs.next())
{
%>
<%
// Title and webaddress and description
webaddress =rs.getString("webaddress");
out.println("");
//System.out.println("In loop");
out.println("");
out.println("");
out.println("
 " +""+rs.getString("title")+" " +"");
out.println("
"+ rs.getString("description")+"....");
out.println("
"+ webaddress);
out.println(" | ");
out.println(" ");
out.println(" ");
continue;
}//ends rs.next
}//ends try
catch(Exception e)
{
out.println("Error in processing SQL. "+ e);
}
finally
{
try
{
con.close();
stmt.close();
}
catch (Exception e)
{
}
}
%>
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 Copyright © 2002 Trimurti Solutions. All rights reserved.
Contact us at:
webmaster@trimurtisolutions.com
Fax number: 509 695 6957
|
