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

📄 index.asp

📁 oracle9i程序事例集
💻 ASP
字号:
<%@LANGUAGE="VBSCRIPT"%>
<%  
  dim conn
  dim connstr
  Set conn=Server.CreateObject("ADODB.Recordset")
  connstr="Driver={Microsoft ODBC for Oracle};server=mylink;uid=system;pwd=system;"
  %>
<html>
<head>
<title>欢迎来到本电子商务网站</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style>
<!--
a:link          { color: #4157F1; text-decoration: none }
a:visited       { color: #4157F1; text-decoration: none }
a:active        { color: #668DF4; text-decoration: none }
a:hover         { color: #668DF4; text-decoration: none; position: relative; right: 0px; top: 1px }
.style2 {font-size: x-small}
.style3 {font-size: 12px}
-->
</style>
</head>
<body>
<div align="center">
<center>
<div align="left"><!-- #include file="pagetop.asp" --></div>
<table width="98%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td height="5"></td>
  </tr>
</table>
<table width="95%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td valign="top">
	<table width="25%" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td><!-- #include file="userinfo.asp" --></td>
    </tr>
    <tr>
      <td><!-- #include file="companyinfo.asp" --></td>
    </tr>
    <tr>
      <td><!-- #include file="gonggaoinfo.asp" --></td>
    </tr>
    </table>
    </td>
    <td valign="top">
	<table border="0" cellspacing="0" cellpadding="0" width="100%">
	  <tr><td>
		<table width="95%" border="0" cellspacing="0" cellpadding="0" align="center">
        <tr><td height="5" colspan="2"></td></tr>
        <tr><td align="center" colspan="2"><font size="-1" color="#0000FF">最新上架商品</font></td></tr>
		  <%
			sql="select product_id, product_kindnum, product_price, product_picpath from GSCOTT.product_info_table where product_isdel='n' order by product_time desc"
			set rs=server.CreateObject("adodb.recordset")
			rs.open sql,connstr,1,1
			for i=1 to 3
		  %>
		<tr>
		  <% for j=1 to 2 %>
		  <td>
            <table width="95%"  border="0" cellspacing="0" cellpadding="0">
            <tr><td height="5"></td></tr>
			<tr>
              <td rowspan="3"><a href="shp_detail.asp?id=<%=rs("product_id")%>"><img src="../Admin/pic/<%=rs("product_picpath")%>" border="0"></a></td>
              <td><font size="-1">商品型号:<a href="shp_detail.asp?id=<%=rs("product_id")%>"><%=rs("product_kindnum")%></a></font></td>
            </tr>
			<tr>
              <td><font size="-1">价格:<%=rs("product_price")%></font></td>
            </tr>
            <tr>
              <td align="center"><a href="javascript:demo('gouwu.asp?id=<%=rs("product_id")%>&action=add');"><img border="0" src="../img/goumai.gif"></a></td>
            </tr>
            <tr><td height="5"></td></tr>
            <% rs.movenext %>
			</table>
		  </td>
		  <% next %>
        </tr>
		<% next %>
        </table>
		</td>
      </tr>
    </table>
	</td>
	<td valign="top">
    <table width="25%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td><!-- #include file="search_easy.asp" --></td>
      </tr>
      <tr>
        <td><!-- #include file="paihang_info.asp" --></td>
      </tr>
    </table>
	</td>
  </tr>
</table>
<!-- #include file="pagefooter.html" -->
</center>
</div>
</body>
</html>

⌨️ 快捷键说明

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