📄 product_admin.asp

📁 本实例为一个完整的网上购物商城的完整例子程序,里面有所以的源代码.希望对大家学习有用.

💻 ASP

字号:

<!--#include file="conn.asp"-->
<%
if session("admin_name")="" then
        response.redirect "error.asp?error=001"
end if
%><%
sql = "select * from 56770_csort order by csort_id "
set rs=server.createobject("ADODB.Recordset")
rs.open sql, conn, 1, 1
%>
<script language = "JavaScript">
var onecount; 
onecount=0; 
subcat = new Array(); 
<%
count = 0
do while not rs.eof
%>
subcat[<%=count%>] = new Array("<%= trim(rs("csort_name"))%>", "<%= trim(rs("sort_name"))%>", "<%= trim(rs("csort_name"))%>"); 
<%
count = count + 1
rs.movenext
loop
rs.close
set rs=nothing
%>
onecount=<%=count%>; 
function changelocation(sort_name)
{ 
        document.cxsort_name.csort_name.length = 0;
        var sort=sort_name;
        var i;
        document.cxsort_name.csort_name.options[0] = new Option('请选择二级分类', '');
        for(i=0; i < onecount; i++)
        {
                if(subcat[i][1] == sort)
                {
                        document.cxsort_name.csort_name.options[document.cxsort_name.csort_name.length] = new Option(subcat[i][0], subcat[i][2]);
                }
        }
        
}
</script>
<link rel="stylesheet" href="css.css" type="text/css">
<body text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="0" cellspacing="1" cellpadding="2" bgcolor="#FFFFFF" vspace="0" hspace="0">
<tr>
<td height="27" background="images/admin_bg_1.gif">.:: 您可以在这里进行商品相关操作</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="50">&nbsp; </td>
</tr>
</table>
<table border="0" cellspacing="1" cellpadding="4" bgcolor="#FFFFFF" align="center" width="60%">
<tr bgcolor="#6699CC">
<td colspan="2">请选择您要批量浏览的商品的条件</td>
</tr>
<tr bgcolor="#D6DFF7">
<td colspan="2">由于查询全部商品过慢，所以至少请选择商品所在一级分类 </td>
</tr>
<form name="cxsort_name" method="post" action="product_list.asp">
<tr bgcolor="#B0CBE6">
<td align="right">一级分类:</td>
<td>
<select name="sort_name" onChange="changelocation(document.cxsort_name.sort_name.options[document.cxsort_name.sort_name.selectedIndex].value)">
<option value="" selected>请选择一级分类</option>
<%
sql="select * from 56770_sort"
set rs=server.createobject("ADODB.Recordset")
rs.open sql, conn, 1, 1
while not rs.eof
%>
<option value="<%=rs("sort_name")%>"><%=rs("sort_name")%></option>
<%
rs.movenext
wend
rs.Close()
%>
</select>
</td>
</tr>
<tr bgcolor="#B0CBE6">
<td align="right">二级分类:</td>
<td>
<select name="csort_name">
<option selected value="">请选择二级分类</option>
</select>
</td>
</tr>
<tr bgcolor="#B0CBE6">
<td colspan="2" align="center">
<input type="submit" name="Submit" value="确 定">
</td>
</tr>
</form>
</table>
<script LANGUAGE="javascript">
changelocation(document.cxsort_name.sort_name.options[document.cxsort_name.sort_name.selectedIndex].value);
</script>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -