show.asp

基于C#语言的一个物流信息网数据库系统开发案例的源代码 ,很实用

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<!-- #include file="../Conn/conn.asp" -->
<% 
	tb=request.Form("select") 
 	meg=request.Form("meg") 
 	sql="select * from "&tb
   	rs.open sql,conn
   	leng=rs.fields.count
   	redim arrays(leng)
   	for i=1 to rs.fields.count-1
        arrays(i)=rs(i).name
	next
	for i=1 to rs.fields.count-2
	   str=arrays(i)&" like '%"&meg&"%' or "	 
	   sum=sum+str
	next
	   str=arrays(leng-1)&" like '%"&meg&"%'"
	   sum=sum+str
	set rs=nothing 
	conn.close
	set conn=nothing
%>	
<% 	select case tb %>
	<% case "tb_GoodsMeg" %>
		<!-- #include file="Goods/Goods_top.asp" -->
	<% case "tb_CarMessage" %>
	<!--#include file="Cars/Cars_top.asp" -->
		<% case "tb_EnterpriseMeg" %>
	<!-- #include file="Enterprise/Enterprise_top.asp" -->
		<% case "tb_KnowledgeMeg" %>
	<!-- #include file="Knowledge/knowledge_top.asp" -->
		<% case "tb_NewMeg" %>
	<!-- #include file="New/New_top.asp" -->
<% 	end select %>
<!-- #include file="../Conn/conn.asp" -->
<%	   
	sql="select * from "&tb&" where "&sum  	
	rs.pagesize=24
    page=request.QueryString("pages")
    if page="" then page=1 end if 
    rs.open sql,conn,1,3
    if not rs.eof or not rs.bof then 
    	rs.absolutepage=cint(page)
    	i=0
   		while not rs.eof and i<rs.pagesize
   			i=i+1
   			formname="form"&i           
%>           
<% select case tb %>
	<% case "tb_GoodsMeg" %>
		<!-- #include file="Goods/Goods_bottom.asp" -->
	<% case "tb_CarMessage" %>
		<!--#include file="Cars/Cars_bottom.asp" -->
	<% case "tb_EnterpriseMeg" %>
		<!-- #include file="Enterprise/Enterprise_bottom.asp" -->
	<% case "tb_KnowledgeMeg" %>
		<!-- #include file="Knowledge/knowledge_bottom.asp" -->
	<% case "tb_NewMeg" %>
		<!-- #include file="New/New_bottom.asp" -->
<% end select %>
<% 
   	rs.movenext()
   	wend 
%>
		</table>
	</td>
</tr>
<tr>
	<td height="12"></td>
</tr>
<tr>
	<td height="12" align=right>
<% 	
	if page=1 then
      	if page<>rs.pagecount then 
%>
	  	<a href="index.asp?action=search&pages=<%=page+1%>">下一页</a>
	  	<a href="index.asp?action=search&pages=<%=rs.pagecount%>">最后一页</a>
	  <%end if %>
<% else %>
      <%if page<rs.pagecount then %>
   	  	<a href="index.asp?action=search&pages=1">第一页</a>
	  	<a href="index.asp?action=search&pages=<%=page-1%>">上一页</a>
	  	<a href="index.asp?action=search&pages=<%=page+1%>">下一页</a>
	  	<a href="index.asp?action=search&pages=<%=rs.pagecount%>">最后一页</a>
	  <%else %>
	    <a href="index.asp?action=search&pages=1">第一页</a>
	  	<a href="index.asp?action=search&pages=<%=page-1%>">上一页</a>
	  <%end if %>
<% end if %>	  
	</td>
<% else %>
</table>
	</td>
</tr>
<tr>
	<td height="12"><div align="center"><span style="color: #FF0000">没有您要查找的信息</span></div></td>
<% end if%> 
</tr>
</table>
</td>
</tr>
</table>