资 源 简 介
<%@ LANGUAGE="VBSCRIPT" %>
<%
ProductClass_2=request("ProductClass_2")
set rs=server.createobject("adodb.recordset")
sqltext="select * from Product"
if request("Product_Name")<>"" then
sqltext=sqltext &" where Product_Name like %"& request("Product_Name") &"% "
else
sqltext=sqltext &" where Product_Name like %"& "" &"% "
end if
if request("Product_Class")<>"" then
sqltext=sqltext &" and Class_1 like %"& request("Product_Class") &"% "
end if