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

📄 produce_user.asp

📁 建造工业系统所需的SQL源代码
💻 ASP
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="conn/conn.asp"-->
<%
Set rs=Server.CreateObject("ADODB.RecordSet")
sql="Select ID,PName,Temperature,pressure 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_cpzs3.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="produce_jj.asp">产品简介</a></td>
                    </tr>
                    <tr>
                      <td>&nbsp;</td>
                      <td height="27" valign="bottom"><a href="index.asp">&nbsp;&nbsp;&nbsp;</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 align="center" valign="top" style="color:#666666;font-size:14px"><b>明日产品使用条件</b><br>
                      <br>
			  <%
			  If rs.eof And rs.bof Then
			  	Response.Write("暂时无产品信息!")
			  Else
			%>		
                      <table width="92%"  border="0" cellSpacing="1px" cellPadding="0px" bgColor="#6D78A7">
                        <tr align="center" bgcolor="#6D78A7">
                          <td width="63%" height="27"><font color="#FFFFFF">产品名称</font></td>
                          <td width="18%"><font color="#FFFFFF">适用温度(℃)</font></td>
                          <td width="19%"><font color="#FFFFFF">工作压力(MPa)</font></td>
                        </tr>
			<%'分页显示
			rs.pagesize=6
			page=CLng(Request("page"))
			if page<1 then page=1
			rs.absolutepage=page
			for i=1 to rs.pagesize	
				If i mod 2 <>0 Then
			  %>  
                        <tr bgcolor="#FFFFFF">
                          <td style="padding:5pt"><%=rs("PName")%></td>
                          <td style="padding:5pt">≤ <%=rs("Temperature")%>&nbsp;℃</td>
                          <td style="padding:5pt">≤&nbsp;<%= FormatNumber(rs("Pressure"),1,-1)%>&nbsp;MPa</td>
                        </tr>
			<%Else%>
                        <tr bgcolor="#B1B7D0">
                          <td style="padding:5pt"><%=rs("PName")%></td>
                          <td style="padding:5pt">≤ <%=rs("Temperature")%>&nbsp;℃</td>
                          <td style="padding:5pt">≤&nbsp;<%= FormatNumber(rs("Pressure"),1,-1)%>&nbsp;MPa</td>
                        </tr>
			  <%
			  End If
			  rs.MoveNext
			  If rs.Eof Then exit For 
			  Next%>	
                      </table>
					  <table width="92%" 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="50,28,14" href="index.asp" alt="返回首页">
</map>
</body>
</html>

⌨️ 快捷键说明

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