⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 produce_jj.asp

📁 建造工业系统所需的SQL源代码
💻 ASP
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="conn/conn.asp"-->
<%
Set rs=Server.CreateObject("ADODB.RecordSet")
sql="Select ID,PName,Introduce From tb_products"
rs.Open sql,conn,1,3
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>产品介绍--产品简介!</title>
<link href="Css/style.css" rel="stylesheet">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>

<body>
<table width="871" border="0" align="center" cellpadding="-2" cellspacing="-2" class="tableBorder">
  <tr>
    <td valign="top"><table width="100%" height="54" border="0" cellpadding="-2" cellspacing="-2" background="Images/Top_01.gif">
      <tr>
        <!--网页头部-->
        <td valign="top"><!--#include file="top.asp"--></td>
      </tr>
    </table>
      <table width="100%"  border="0" cellspacing="-2" cellpadding="-2">
        <tr>
          <td height="238" valign="top"><table width="100%" height="507"  border="0" cellpadding="-2" cellspacing="-2">
            <tr>
              <td width="17" valign="top"><table width="100%" height="439"  border="0" cellpadding="-2" cellspacing="-2">
                <tr>
                  <td width="200" height="225" background="Images/welcome.gif">&nbsp;</td>
                </tr>
                <tr>
                  <td width="200" height="190" background="Images/left_bottom.gif"></td>
                </tr>
                <tr>
                  <td height="9" background="Images/left_line.gif"></td>
                </tr>
              </table></td>
              <td valign="top"><table width="100%" height="205"  border="0" cellpadding="-2" cellspacing="-2">
                <tr>
                  <td width="188" height="212" valign="top" background="Images/menu_son_01_cpzs2.gif"><table width="100%" height="206"  border="0" cellpadding="-2" cellspacing="-2" style="color:#BABECF">
                    <tr>
                      <td width="19%" height="62">&nbsp;</td>
                      <td width="81%">&nbsp;</td>
                    </tr>
                    <tr>
                      <td height="27">&nbsp;</td>
                      <td height="27" valign="bottom"><a href="produce_zs.asp">产品展示</a></td>
                    </tr>
                    <tr>
                      <td height="22">&nbsp;</td>
                      <td height="22" valign="bottom"><a href="index.asp">&nbsp;&nbsp;&nbsp;</a>产品简介</td>
                    </tr>
                    <tr>
                      <td>&nbsp;</td>
                      <td height="27" valign="bottom"><a href="produce_user.asp">使用条件</a></td>
                    </tr>
                    <tr>
                      <td>&nbsp;</td>
                      <td height="26" valign="bottom">&nbsp;</td>
                    </tr>
                    <tr>
                      <td>&nbsp;</td>
                      <td>&nbsp;</td>
                    </tr>
                  </table></td>
                </tr>
              </table>
                <table width="100%" height="239"  border="0" cellpadding="-2" cellspacing="-2">
                  <tr>
                    <td height="30" valign="top"><img src="Images/friend.gif" width="188" height="30"></td>
                  </tr>
                  <tr>
                    <td height="67" background="Images/friend_01.gif"><div align="center"><img src="Images/Link/KJXXLogo.gif" width="184" height="66"></div></td>
                  </tr>
                  <tr>
                    <td height="72" background="Images/friend_02.gif"><div align="center"><img src="Images/Link/MRLogo.gif" width="184" height="66"></div></td>
                  </tr>
                  <tr>
                    <td height="70" background="Images/friend_01.gif"><div align="center"><img src="Images/Link/ZQLogo.gif" width="184" height="66" border="0"></div></td>
                  </tr>
                </table>
                <img src="Images/friend_03.gif" width="188" height="27"></td>
              <td width="666" valign="top" background="Images/Top_05.gif"><table width="100%" height="135"  border="0" cellpadding="-2" cellspacing="-2" background="Images/Top_04_cpjj.gif">
                  <tr valign="top">
                    <td height="61" colspan="4"><table width="100%"  border="0" cellspacing="-2" cellpadding="-2">
                        <tr>
                          <td width="73%" height="24">&nbsp;</td>
                          <td width="27%" style="color:#313D99">&gt; 产品介绍 &gt; 产品简介 &gt;&gt; </td>
                        </tr>
                    </table></td>
                  </tr>
                  <tr>
                    <td width="24%" height="52">&nbsp;</td>
                    <td width="16%" valign="top" style="color:#5D5D5D">我公司主要产品:</td>
                    <td width="58%" style="color:#5D5D5D">
                      <%
					IF rs.eof and rs.bof Then
						Response.Write("暂无产品信息!")
					Else
						product=""
						For i=1 To rs.RecordCount
							product=product+rs("PName")+"  "
							rs.MoveNext
						Next
						If Len(product)>150 Then
							Response.Write(Left(product,150)&"...")
						Else
							Response.Write(product)
						End If
					End IF
					%></td>
                    <td width="2%" style="color:#5D5D5D">&nbsp;</td>
                  </tr>
                  <tr>
                    <td colspan="4">&nbsp;</td>
                  </tr>
              </table>
                
                <table width="98%" height="308"  border="0" cellpadding="-2" cellspacing="-2" style="margin:5pt">
                  <tr>
                    <td valign="top">
			  <%
			  If rs.eof And rs.bof Then
			  	Response.Write("暂时无产品信息!")
			  Else
			%>					<table width="100%" height="52"  border="1" cellpadding="-2" cellspacing="-2" bordercolor="#DFE1EB" bordercolordark="#9CA6C6" bordercolorlight="#DFE1EB">
                      <tr align="center">
                        <td width="16%">产品名称</td>
                        <td width="84%">产品简介</td>
                      </tr>
			<%'分页显示
			rs.pagesize=3
			page=CLng(Request("page"))
			if page<1 then page=1
			rs.absolutepage=page
			for i=1 to rs.pagesize	
			  %>  
                      <tr>
                        <td style="padding:5pt"><a href="#" onClick="window.open('produce_detail.asp?ID=<%=rs("ID")%>','','width=700,height=382')"><font color="#666666"><%=rs("PName")%></font></a></td>
                        <td style="padding:5pt"><%=Replace(Replace(rs("introduce"),chr(13),"<br>"),chr(32),"&nbsp;")%></td>
                      </tr>
			  <%
			  rs.MoveNext
			  If rs.Eof Then exit For 
			  Next%>	
                    </table>
			  <table width="95%" height="25"  border="0" align="center" cellpadding="-2" cellspacing="-2">
                <tr>
                  <td width="33%" height="26" valign="bottom"><% if page<>1 then %>
                    <a href=?page=1 class="white"><font color="#666666">第一页</font></a> <a href=?page=<%=(page-1)%> class="white"><font color="#666666">上一页</font></a>
                    <%end if 
			if page<>rs.pagecount then %>
                    <a href=?page=<%=(page+1)%> class="white"><font color="#666666">下一页</font></a> <a href=?page=<%=rs.pagecount%> class="white"><font color="#666666">最后页</font></a>
                    <%end if%></td>
                  <%If not(rs.Eof and rs.Bof) Then%>
                  <td width="35%" align="right" class="word_grey">[<%=page%>/<%=rs.PageCount%>]&nbsp;&nbsp;每页<%=rs.PageSize%>条&nbsp;&nbsp;共<%=rs.RecordCount%>条记录</td>
                  <%End If%>   
                </tr>
              </table>
			  <%End If%>					</td>
                  </tr>
                </table>                <table width="100%" height="56"  border="0" cellpadding="-2" cellspacing="-2">
                  <tr>
                    <td height="56" bgcolor="#FFFFFF"><!--#include file ="CopyRight.htm"--></td>
                    <td width="208"><img src="Images/re_top.gif" width="208" height="56" border="0" usemap="#Map"></td>
                  </tr>
                </table></td>
            </tr>
          </table></td>
        </tr>
      </table><table width="100%"  border="0" cellspacing="-2" cellpadding="-2">
  <tr>
    <td height="8" background="Images/bottom.gif"></td>
  </tr>
</table></td>
  </tr>
</table>

<script language="javascript">
	ourmove()
</script>
<map name="Map">
  <area shape="rect" coords="82,17,125,39" href="#">
  <area shape="circle" coords="48,28,14" href="index.asp" alt="返回首页">
</map>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -