search.jsp

来自「jsp的技术教程」· JSP 代码 · 共 155 行

<%@ include file="head.inc"%>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="workM" scope="page" class="test.faq" />
<jsp:useBean id='clock' scope='page' class='dates.JspCalendar' type="dates.JspCalendar" />      
<%!
public String getStr(String str)
{
	try
	{
		String temp_p=str;
		byte[] temp_t=temp_p.getBytes("GBK");
		String temp=new String(temp_t,"ISO8859_1");
		return temp;
	}
	catch(Exception e)
	{
	 
	}
	return "null";
}
%>       
<%!
public static String category(int id)
{
	try
	{
		switch(id)
		{
			case 1:
				return "计算机类";
				//break;
			case 2:
				return "英语类";
				//break;
			default:
				return "其他类";
				//break;
		}
	}
	catch(Exception e)
	{
	
	}
	return "null";
}
%>                   
<TABLE border=0 cellPadding=0 cellSpacing=0 width=760 align="center">
  <TBODY>
  <tr><td align="left" height=25>当前位置：<a href="../index.jsp">首页</a> -&gt; 查询商品   </td>
 <%@ include file="../member/date.inc"%>
  </tr>
  <TR bgColor=#3399ff>
    <TD height=1 colspan="2"><IMG height=1 src="images/spacer.gif" 
  width=16></TD></TR>
  <tr><td height=10 colspan="2"><IMG height=1 src="images/spacer.gif" 
  width=16></td></tr>
  </TBODY></TABLE>

  <table align="center" border="0" width="760" cellspacing="0" cellpadding="0" height="355">                  
	<tr>                  
	             
		<td width="10" height="100%"></td>
		<td width="1" height="100%" bgcolor="#3399ff"></td>
		<td width="10" height="100%"></td>
		<td width="589" height="331" valign="top" background="images/bg1.gif">                       
        <table border="0" width="100%" cellspacing="0" cellpadding="0">                  
          <tr>                  
            <td colspan="3" width="100%" height="20" bgcolor="#3399ff">&nbsp;<font color="#ffffff">站内搜索 -> 关键字:<b><font color="Red"><%=request.getParameter("keyword")%></font></b></font>
			</td>
		  </tr>
		   <table border="0" width="100%" cellspacing="0" cellpadding="0">                  
          <tr>                  
            <td width="42%" height="20" bgcolor="#3399ff">&nbsp;<font color="Red">标题</font>       
			</td>
            <td width="15%" height="20" bgcolor="#3399ff">&nbsp;<font color="Red">作者</font>       
			</td>
            <td width="15%" height="20" bgcolor="#3399ff">&nbsp;<font color="Red">类别</font>       
			</td>
            <td width="28%" height="20" bgcolor="#3399ff">&nbsp;<font color="Red">详细资料</font>       
			</td>
		  </tr>
		  <ul>
		
		 
				
 	<%
		String keyword,way;
		String strSQL;
		keyword=request.getParameter("keyword");
		keyword=(keyword);
		way=request.getParameter("way");
		strSQL="";
  
		//////////////书名********************
		if(way.trim().equals("1")){
			strSQL="SELECT * FROM book where";
			strSQL=strSQL+" name like '%"+keyword+"%'";
			
		}
		
		//////////////作者********************
		if(way.trim().equals("2")){
			strSQL="SELECT * FROM book where";
			strSQL=strSQL+" author like '%"+keyword+"%'";
		}
		
		//////////////出版社********************
		if(way.trim().equals("3")){
			strSQL="SELECT * FROM book where";
			strSQL=strSQL+" publish_name like '%"+keyword+"%'";
		}
		//out.println(strSQL);

//		out.println("<ul>");
		ResultSet RSa = workM.executeQuery(strSQL);
		int searchnum;
		searchnum=0;
		while (RSa.next()) {
			String srch_title,author;
			int id,cate;
			id=RSa.getInt("id");
			srch_title=getStr(RSa.getString("name"));
			author=getStr(RSa.getString("author"));
			cate=RSa.getInt("category");
			out.println("<tr height='23'><td>");
			out.println("<li><a href=javascript:show('../book_store/book.jsp?id="+id+"','详细资料',480,500)>"+srch_title+"</a>");
			out.println("</td>");
			out.println("<td>"+author+"&nbsp;</td>");
			out.println("<td>"+category(cate)+"</td>");
			out.println("<td><a href=javascript:show('../book_store/book.jsp?id="+id+"','详细资料',480,500)>[详细资料]</a></td>");
			out.println("</tr>");
			
			searchnum=searchnum+1;
		}
		RSa.close();
		out.println("</ul>");
  		out.println("共搜索到<b><font color=Red>"+searchnum+"</font></b>条纪录");
	%>
	
		<p align="right"><a href="javascript:history.go(-1)">返 回</a></p>


			
			</td>
			 <td width="5%"></td>
		  </tr>
        </table>                  

        </td>
    </tr>
  </table>


<%@ include file="../member/footer.inc"%>