search.asp

设计考虑校园电子商务模式

<%
'****************************************************
' 多多校园                      Power by ddtaobao.com
' Email:[e-mail]               OICQ:136465584 
' Web: http://www.ddtaobao.com              作者:多多
' 校园、企业、医院、公司程序定做，系统开发，网站制作!
' Copyright (C) 2007 ddtaobao.com All Rights Reserved
'****************************************************
%>
<!--#include file="top.asp"-->
<TABLE width=778 border=0 align=center cellSpacing=0 cellPadding=0>
  <TBODY>
    <TR> 
   

      <TD vAlign=top>
<%
if request.form("keyword")="" then
response.write "<script language='javascript'>" & VbCRlf
response.write "alert('请输入您要搜索的关键字!');" & VbCrlf
response.write "history.go(-1);" & vbCrlf
response.write "</script>" & VbCRLF
else
keyword =HTMLEncode(request.form("keyword"))
Set rs= conn.execute("select * from dd_goods where goods_name like '%"&keyword&"%'  order by goods_id desc" ) 
if rs.eof or rs.bof then
%>
        <div align="center">
        <TABLE cellSpacing=1 cellPadding=0 width="100%" border=0>
          <TBODY>
            <TR> 
              <TD class=th> 对不起！</TD>
            </TR>
            <TR> 
              <TD align="center" class="tablebody1">没有找到任何商品！</TD>
            </TR>
          </TBODY>
        </TABLE>
</div>
<%else%>
        <div align="center">
  <TABLE cellpadding="3" cellspacing="1" align="center" class="tableborder1">                    <tr> 
          <TBODY>
            <TR> 
              <TD class=th>                  

						<img border="0" src="images/news.gif" width="15" height="15">
                      商品搜索                   </TD>
            </TR>
            <TR> 
              <TD align="center">
              <table width="100%" border="0" cellpadding="0" style="border-collapse: collapse">
<% do while not rs.eof%>
                  <tr> 
                    <td height=18 class="tablebody1" >&nbsp; ·<a href="goods_info.asp?goods_id=<%=rs("goods_id")%>" target="_blank"><%=rs("goods_name")%></a></td>
                    <td align="right" class="tablebody1" ><font color="#999999">(<%=rs("goods_date")%>)</font></td>
                    <% 
rs.movenext 
loop 
rs.close 
set rs=nothing 
%>
                  </tr>
                </table></TD>
            </TR>
          </TBODY>
        </TABLE>
</div>
<%end if%>
<%end if%>
        </TD>
    </TR>
  </TBODY>
</TABLE>
<!--#include file="bottom.asp"-->